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