Symptom
Unable to import sales orders with more than 1000 rows using the "Import Sales Orders" app (or any other apps within the "Import Sales Documents" app). Receive the error "File must be smaller than 10 MB, with no more than 1000 rows of data".
Environment
SAP S/4HANA Cloud Public Edition
Cause
To ensure optimal system performance and usability, apps within the "Import Sales Documents" app are designed to process imported Excel files with a maximum size of 10 MB and no more than 1000 rows. This limitation aligns with the core Sales and Distribution functionality, as SAP recommends keeping sales documents under 1000 line items. Exceeding this threshold may lead to performance challenges and increased processing times due to the complexity of linking each line item to multiple tables, such as scheduling lines, costing, variant configuration, document flow, and status.
Resolution
Based on the current design as per explained in the "Cause" section, the suggestion is to reduce the rows to lower than 1000 in the imported Excel file (keeping it smaller than 10 MB) and create multiple sales orders via multiple Excel files.
Keywords
1000 rows, Import Sales Orders, Import Sales Documents, File, Smaller than, 10 MB, No more than, SAP S/4HANA Cloud Public Edition, Performance, Usability, Sales and Distribution functionality, Time out, Excel , KBA , SD-SLS-IMP-SPR-2CL , Sales Document Import from Spreadsheet (Public Cloud) , Problem
SAP Knowledge Base Article - Public