10000 Line Items to be uploaded in Single Sales Order

[Former Member]

Hi

Need to upload more than 10000 Line items in the Single Sales Order. What could be the best way of uploading it. is LSMW helpful?

Response awaited. thanks

Moni

[Former Member]

More than 10000 Line items in a single sales order?

IMHO you should revise the requirements because I can't think or any situation where there should be so many lines in a sales document.

More than 1000 items is already strange, more than 10.000 is insane.

My 2 cents.

[Former Member]

It completely depends on you. I always do this by using eCATT. simple steps and easy to do, But LSMW is also a good option

Thanks,

Raja

[Former Member]

Hi,

Try using LSMW (legacy system migration work bench) for VA01. It will be helpful

regards,

santosh

[Former Member]

Can u advise the steps involved in LSMW?

I believe it is not necessary to go for VA01.

we can go for VA02 itself, as the Header data is going to be one and same. If we create a Sales Order with Header data alone and then using VA02 with that particular Sales Order number in LSMW...

but will the total line items can be taken by Sales Order item level.

this is what the clarification needed.

rgds,

[aramsum]

Hi Monisha,

Hi,

999,999 line items can be entered in a Sales order, but:

1. FI document has a restriction of 999 line items per document. So, depending on the account settings, there will be a lower limit. E.g. if each Sales order line item results in 2 line items in the accounting document, then the max. no. of SO line items is limited to 499.

2. If FI summarization is active, then the system summarizes the account postings, thus reducing the no. of FI line items. Hence, a SO can accomodate more than 999 line items. However, this means that certain line item level details will not be available to the Finance guys (which they may not like).

3. As the number of line items in a Sales order increases, the system performance suffers greatly. There are performance fixes available, but in general, it is painful to load a SO with large no. of line times through BDC's. 10 Sales orders with 100 lines each consume less system resources than 1 Sales order with 1000 lines.

Regards

Ram Pedarla

[Former Member]

Hi Ram,

Let us say, 10 Sales Orders each with 1000 Line Items. What could be the possibility??

is there any solution for uploading like this? As i informed before, in LSMW for VA02 transcation, takes only the first 7 Line items in Sales Order from the Flat File with more the 1000 line items. That is, it takes only upto the line items which we can see in the VA02 screen and i feel the scroll down functionality is not working to upload above 7 line items. Something has to be done on this.

Any pointer on this.

Moni.

[Former Member]

Hi

In such cases the best way to go is BAPI. Coz LSMW will go through all the screens and will take a lot of time. But BAPI would be faster any day.

But I do have the same concerns as Ram has regarding the FI document posting.

Regards

Yatin Thakkar