SAP Knowledge Base Article - Public

3390831 - Error "Sales Order &1 contains inconsistent header data" occurs in the "Import Sales Orders" app

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

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions