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

Procedure

1. Go to Data Workbench work center.
2. Select Export view.
3. Select object as Object Identifier Mapping .
4. Filter the mapping.
5. Click Next.
6. Click Export Data.
7. Download the file from Monitor.
8. Open the file.
9. Add a column "ToBeDeleted" to the end of the row.
10. Enter value "TRUE" to the column "ToBeDeleted".
11. Now perform an update by going to Import view.
12. Select Individual Object and Update.
13. Select object as Object Identifier Mapping .
14. Upload the edited file and then update.

 ID Mapping Help Document

Object Identifier Mapping, Delete ID mapping, Delete External ID , KBA , LOD-CRM-INT-ERP , Integration of C4C with ERP , How To