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,
- Filter the mappings which needs to be deleted from the data file which was prepared during ID Mapping.
- Add another column in the CSV file with the header ToBeDeleted.
- To all the records in this column, add True
Procedure
- From Data Workbench, go to Import.
- Select ID Mapping.
- Select the object for which you want to import data. (Note:Only root nodes are listed.)
- Click Next.
- Browse and select the data file (CSV) of the ID mapping template.
- Click Upload.
- Click Next.
- Review and click Import.
See Also
Keywords
KBA , LOD-CRM-INT-ERP , Integration of C4C with ERP , How To
Product
SAP Cloud for Customer add-ins all versions