SAP Knowledge Base Article - Public

2464094 - Is it Possible to Migrate Account Related Data in SAP Cloud for Customer System Using the Account ID in the ERP system?

Symptom

Your requirement is to migrate Account related Tax data using Migration of Customers for exiting accounts. In the migration template, you want the Account ID to refer to the External ID, which is the ID of the of the Account in the ERP system. But the system accepts the internal Account IDs which is available in the SAP Cloud for Customer system.

Reproducing the Issue

  1. Go to Business Configuration work center
  2. Select Implementation Projects view or Overview
  3. Search and Open the activity Migration of Customers
  4. Select Migrate customers using the migration tool
  5. Upload the Migration File
  6. Execute Migration for the respective Migration File with Migration Mode Modify already existing records
  7. You receive the error message mentioned in the Validation step:
  8. Business partner XXXXX doesn't exist in the system

Resolution

Migration is a onetime activity used to migrate data from Legacy system to SAP Cloud for Customer system. We do not support External IDs as part of the migration process. This is an integration scenario.

In future Migration Workbench would be replaced with Data Workbench and we will not support External Account ID as Account IDs for the data upload process in SAP Cloud for Customer system.

Keywords

KBA , external account id , LOD-CRM-EMP , Employee , How To

Product

SAP Cloud for Customer all versions