SAP Knowledge Base Article - Public

3433079 - The requested delivery date is same for all the items although different requested delivery dates have been filled in for different items when using the "Import Sales Orders" app

Symptom

Although different requested delivery dates have been filled in the Excel for different items when using the "Import Sales Orders" app, in the created sales order, the delivery date is the same for all the items. It is the date of the creation of the sales order.

Environment

SAP S/4HANA Cloud

Cause

New columns are added into the Excel, e.g. "Item-level Requested Delivery Date" but the fourth row of the Excel is hidden. As a result, the "Field Name (Technical Name)" of this newly added column is not filled in.

Resolution

The issue can be resolved by unhiding the fourth row of the Excel and filling the technical name "ITEM.REQUESTEDDELIVERYDATE" for the newly added column "Item-level Requested Delivery Date". The technical name can be found from the Excel template which can be downloaded from the "Import Sales Orders" app.

Keywords

Requested, Delivery date, Sales order, Item, Import sales orders, Item-level requested delivery date, Field name, Technical name, 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