Skip to content
ERP Preflight

Data migration load files · Migration Template Intelligence

Duplicate record key

Default severity
Blocker
Finding code:
MIG_TEMPLATE_DUPLICATE_KEY
Engine version:
1.0.0
Cite:r/SAPINXHN

What this finding means

Migration Template Intelligence reports this finding with the default severity “Blocker”.

About the engine: Migration Cockpit load files (templates) validated against their declared schema: mandatory fields, lengths, types, keys, hierarchy

How to fix it

Keep exactly one row per key (all key-group fields together); merge or remove the duplicates. The migration processes one source record per key, so duplicates are rejected or overwrite each other.

How ERP Preflight detects it

The analysis is deterministic: the same exported files and the same knowledge snapshot always produce the same findings. No SAP system connection is required — you upload exports.

Engine
Migration Template Intelligence
Accepted formats
XML, CSV, TEXT
What to export

SAP data migration template (Migration Cockpit 'Migrate Your Data' load file): the Excel 2003 XML spreadsheet as downloaded from SAP (all sheets, document properties OBJECT_NAME / VERSION / LANGUAGE, field list) or the CSV of one data sheet including its header rows (as converted from an XLSX by the upload): title row, SAP structure names, SAP field names, the type-specification row ('ETE;80;0;C;80;0'), group names ('Schlüssel' / 'Key') and field descriptions ('*' = mandatory), then the data rows. EN and DE templates.

Required input
  • A migration template data sheet with its type-specification row (XML spreadsheet or CSV)
Evidence
Each finding points to the artifact path, line and column, the code snippet and the SHA-256 of the uploaded file. Findings without such a pointer are demoted to confidence UNKNOWN.
Confidence
The verdict rests on your artifacts only. Each finding carries a confidence class (VERIFIED, RULE_DERIVED, INFERRED or UNKNOWN) that shows how strong the evidence is.
Target releases of the engine
S4H_2022, S4H_2023, S4HANA_CLOUD_2402, S4HANA_CLOUD_2408
All problems: Data migration load files

Source: rule catalog of Migration Template Intelligence 1.0.0 in the ERP Preflight analysis service.

ERP Preflight is independent and not affiliated with SAP SE. SAP, ABAP, Fiori and S/4HANA are trademarks of SAP SE.

Duplicate record key | Data migration load files | ERP Preflight