Data Migration Cockpit Error : instance already exists in the table

[SAPSupport]

How can the Data Migration Cockpit be configured or utilized to perform a mass upload of material master data for multiple company codes and valuation types in a single file? Currently, attempting to combine records for multiple company codes and valuation types in one upload file leads to staging table errors indicating duplicate key fields, even when no duplicates exist within the file. Is there a way to simplify this process and avoid the need to create separate files for each combination of company code and valuation type?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

The tool was designed for initial data load specifically, not daily operation. For that, updating entries is not allowed. For objects such as "Product - extend existing record by new org levels", the field "Run ID can" be used to iterate over pre-existing entries but, even so, it has to be done on subsequent runs (please see the attached documentation). In the end, if another entry with the same key fields exist, it will be considered a duplicate and will be skipped.

[Caio · Accepted solution]

Dear experts,

As an addition, the KBA below explains exactly this concept, that the Migration Cockpit should be used for initial data load, not mass data upload:

• 2650201 - Migration Cockpit: How to create/update data records

Also, since the documentation was mentioned in the answer above but wasn't attached, I'm linking it here for reference:

• Product - extend existing record by new org levels | SAP Help Portal

Best regards,
Caio