SAP Knowledge Base Article - Public

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


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).


SAP Cloud for Customer


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


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


  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


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


SAP Cloud for Customer add-ins all versions