Maximum quantity limit for line items in sales orders

[omega-ou]

Hi SAP expert ,

Business scenario: The customer's main business is selling building materials and accessories, and its ultimate customer is villa owners. In a sales order, it is necessary to record the detailed list of building materials and accessories for each villa in the sales order. A villa has approximately 3000 building materials and accessories, and there will be a demand for 10 villas in one sales order. Therefore, one sales order will have 30000 lines of project details.

I tried to use the Sales and Distribution Bom feature, the header of the bom is each villa . the items of the bom is the detailed list of building materials and accessories , but I found that the sales orders still display the detailed materials of the BOM, so that the number of line items of each sales order will be greater than 20000 .

I need to confirm the maximum number of line items for a sales order in the system, and how many detailed line items can the system support for a single sales order ?

[Fancy_Zou]

Hi, One more question regarding your request: Are the detailed line items expected to be billed in the invoice, or just the main items?

[Fancy_Zou · Accepted solution]

Hi,

To directly address your question, the maximum number of items in a single sales order primarily depends on the digit limitations of the line item number. If the "Item Number Increment" is set to 1, the system can accommodate up to 999,999 items.

Updated: In SAP S/4HANA Cloud Public Edition, the limitations associated with financial documents in SAP ECC, which stemmed from the table BSEG, no longer apply. This is due to the introduction of the table ACDOCA for financial accounting, along with the default compression of BSEG. You may refer to the blog 999 – The Number of the BSEG .

Best Regards,
Fancy

[omega-ou · Accepted solution]

hi Fancy, Thanks.

[Fancy_Zou · Accepted solution]

Hi @omega-ou , 

Correct one info: If the "Item Number Increment" is set to 1, the system can accommodate up to 999,999 items. It is because the digit of item number is 6.

Best Regards,
Fancy

[omega-ou · Accepted solution]

OK, Thanks.

[Fancy_Zou · Accepted solution]

Hi @omega-ou 

I have updated the financial limitation section of the answer with a confirmation from the SAP development team.

Best Regards,
Fancy

[omega-ou · Accepted solution]

hi Fancy, Thanks.

[omega-ou]

hi, the detailed line items .