Symptom
Transfer of data to staging table failed and error message "Cannot insert XXX into table /1LT/XXX (<SAP Structure>); instance already exists in the table" is displayed in the app Migrate Your Data.
Environment
SAP S/4HANA Cloud Public Edition
Cause
There is an existing record with the same key fields in the staging table.
Resolution
- Identify the record in the staging table that faces the mentioned error.
- Remove the old file and delete the corresponding instances from the staging table.
- Upload the new template file again and transfer the data again to the staging table.
See Also
KBA 3004732 - Cannot insert XXXXXXXXXXX into table /XXX/XXXXXXX (S_SUPPL_COMPANY); instance already exists in the table
Keywords
Duplicated, instance, Staging Tables, duplicated entry, duplicated entries, duplicate entry, duplicate entries, delete, update , KBA , CA-LT-MC , S/4HANA Migration Cockpit , CA-GTF-MIG , SAP S/4HANA Data Migration Cockpit Content , Problem
SAP Knowledge Base Article - Public