Skip to content
ERP Preflight

Data migration load files · Migration Template Intelligence

Referenced record is missing on the parent sheet

Default severity
Critical
Finding code:
MIG_TEMPLATE_CROSS_SHEET_REFERENCE_MISSING
Engine version:
1.0.0
Cite:r/SAPINXHN

What this finding means

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

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

How to fix it

Add the referenced records to the parent sheet of the template (or verify that they already exist in the target system); rows that reference a missing parent record cannot be created.

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.

Referenced record is missing on the parent sheet | ERP Preflight