SAP Knowledge Base Article - Public

2921918 - You Want to Remove the External ID Mapping for Business Partner

Symptom

In case you have multiple Business Partners (such as: Accounts, Business Partner, Contact, etc.) and you want to remove or update them in the External ID references, however it is a cumbersome taks in case you have a big amount of data to be changed manually (one by one).

Environment

SAP Cloud for Customer

Cause

Currently there is no automatic way to remove the entries, it requires a manual change.

Resolution

To proceed with the Deletion of a mass amount of ID Mappings you can make use of Data Workbench in order to remove the desire entries.

From Data Workbench,

  1. Filter the mappings which needs to be deleted from the data file which was prepared during ID Mapping.
  2. Add another column in the CSV file with the header ToBeDeleted.
  3. To all the records in this column, add True

Procedure

  1. From Data Workbench, go to Import.
  2. Select ID Mapping.
  3. Select the object for which you want to import data. (Note:Only root nodes are listed.)
  4. Click Next.
  5. Browse and select the data file (CSV) of the ID mapping template.
  6. Click Upload.
  7. Click Next.
  8. Review and click Import.

See Also

 ID Mapping Help Document

Keywords

KBA , LOD-CRM-INT-ERP , Integration of C4C with ERP , How To

Product

SAP Cloud for Customer add-ins all versions