3536723 - [On-Premise ] Error "Your file contains missing, invalid, or duplicate data" occurs when using the "Import Sales Orders" app

Symptom

When creating sales orders from a file using the "Import Sales Orders" app, the system displays an error message: "Your file contains missing, invalid, or duplicate data".

In the Preview (Item Data / Order Data) page, more detailed messages are displayed. For example:

for the Requested Quantity field: Invalid Length.
for the Product or the Sold-to Party field: Required field.
for the Requested Delivery Date field: Invalid Format.

*Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Sales And Distribution (SD)
Fiori
SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

Requested Quantity, Quantity, Amount, Date, Time, Date/Time, Invalid Length, Sales Order, Import Sales Orders, Template, Text, General, Excel, Cell, Format, Missing, Invalid, Duplicate data, Required Field, invalid format, date, request delivery date, F4293 , KBA , SD-SLS-IMP-SPR , Sales Document Import from Spreadsheet , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.