SAP Knowledge Base Article - Public

2489750 - Error Message: "Material ID XXXXX Already Exists" When Trying to Update Materials on Migration Tool

Symptom

You are trying to update Materials through the BC activity Migration of Materials. Even though your migration template is correct the system is throwing the error message Material ID XXXXX already exists.

Reproducing the Issue

  1. Go to the Business Configuration work center and access the view Overview;
  2. Search for the activity Migration of Materials;
  3. Open the activity Migration of Materials and select the option Migrate Materials using the Migration Tool;
  4. Select the option Upload data from Migration Template;
  5. After uploading the template click on Execute Migration Step by Step;
  6. After reaching the step Simulation you will get an error message.

Cause

By default the Migration Tool will have the Migration Method set as Add New Records.

Resolution

Change the Migration Method of the file to Enhance Already existing records by following the steps below.

  1. In the Migration Tool select the file which you need to change the migration method and click on Properties;
  2. Select the migration method Enhance already existing records.

Alternatively, Materials can be updated through the Mass Data Maintenance work center.

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions