3596962 - Issue with Uploading SAP Sales Order Template from SharePoint in SAP S/4HANA Cloud Public Edition

• When attempting to upload the SAP Sales Order template from SharePoint, a required field error is encountered, preventing the billing process.
• The same file, however, is successfully uploaded when using Google format.
• The error message displayed is vague and does not provide a clear cause for the issue: "At least one required field is missing in your file. Your file must contain valid field names, which you can find in the template."

SAP S/4HANA Cloud Public Edition

1. Navigate to Import Sales Order
2. Attempt to upload the file
3. Observe the error message displayed

The issue occurs when a decimal-based custom (e.g., ITEM.YY1_ABC_SDI) or standard field is formatted as text instead of numeric. This is often seen with decimal fields created via In-App Extensibility or downloaded via external tools (e.g., SharePoint).

To correct this and proceed with the upload:

1. Open the Excel file.
2. Navigate to column: ITEM.YY1_ABC_SDI.
3. For each cell with a decimal value:
   • Either retype the value manually, or
   • Double-click the cell to re-activate the value, prompting Excel to recognize it as a number.
4. A green triangle may appear in the top-left corner of the cell — this confirms Excel has re-interpreted the content correctly.
5. Save the file and attempt the upload again.

After retyping or reformatting, the file should upload successfully without triggering the required field error.

SAP S/4HANA Cloud Public Edition, Public Cloud, SAP Sales Order, SharePoint, Upload, Required field error, File Headers, Billing Block, Google format,  Upload Error, Excel Template, Required Field Missing, Decimal Field, Green Triangle, Contract Percentage, Import Sales Orders,  , KBA , SD-SLS-IMP-SPR-2CL , Sales Document Import from Spreadsheet (Public Cloud) , Problem