SAP Knowledge Base Article - Public

2789827 - Error: "Material ID 'XXXXXX' already exists" While Importing Products With Material Description in Other Languages

Symptom

Your requirement is to import a Product XXXXX with Material Description in other languages. Upon trying to import Product using Data Workbench object: Product, you see that the first record from the file is imported in the system. But the other records has the Processing Error

Material ID 'XXXXX' already exists
(where XXXXX represents the Product ID)

Environment

SAP Cloud for Customer

Reproducing the Issue

1. Go to Data Workbench workcenter
2. Go to Import view
3. Select the radio button for Individual Object
4. Go to Insert tab
5. Go to Standard Object tab
6. Search for the Data Workbench object Product
7. Select Download
8. Fill data in the fields
 
Example:
External_Key: YYYYY (where YYYYY represents the External Key for the Product)
Product_ID: XXXXX
Language: DE
Material_Description: Beispiel
 
Example:
External_Key: ZZZZZ (where ZZZZZ represents the External Key for the Product)
Product_ID: XXXXX
Language: FR
Material_Description: Exemple
 
9. Save the file
10. Select Next and Browse for the file
11. Select Upload
12. Choose Next
13. Select Import
14. In the Monitor view, check for the respective Task ID
The first record from the file is imported in the system. But the second record has the Processing Error.

Cause

The Data Workbench object: Product is used to import a Product in system in any one language. It is not possible to use the Data Workbench object: Product to maintain the respective Product with Material Description in multiple languages.

Resolution

To upload the Product with its Material Description in other languages, the Product should exist in your system. Therefore, you have to first upload the Product in the Insert mode using the Data Workbench object: Product. In this case you may choose to import in any one language.

Thereafter, for the same Product ID, if you want to maintain the Material Description in different languages, use the Data Workbench object: Product Other Language in the Insert mode. Ensure that the External ID for each needs to be different from the External Key of the original Product that you uploaded and further, the External ID needs to be different from the External Key of the Other Language as well.

Keywords

Material Description, Other Languages, Product Other Languages, Product , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer add-ins all versions