Symptom
Error "Sales Order &1 contains inconsistent header data (Sheet &2, rows &3 and &4)" occurs when importing data using the "Import Sales Orders" app.
Environment
SAP S/4HANA Cloud
Cause
Only one sales order is created but it has multiple items. However, the values filled in the header-level "Delivery Date" field in the Excel are different for each item. This causes the "data inconsistency" error.
Resolution
The issue can be resolved by setting the header-level "Delivery Date" in the Excel to a same date. Having different delivery dates for the items can be realized by setting different delivery dates for each item at the item-level in the Excel ("ITEM.REQUESTEDDELIVERYDATE"). More details can be get from the field list in the template.
Keywords
Error, Sales order, Inconsistent header data, Sheet, Rows, Import sales orders, Delivery date, ITEM.REQUESTEDDELIVERYDATE , KBA , SD-SLS-IMP-SPR-2CL , Sales Document Import from Spreadsheet (Public Cloud) , Problem