How to improve performance on SD document with over 1000 line items

[Former Member]

Dear experts,

A lot of our SD document contains 1500 to 5000 line items. Saving a simple change of one line item description would take 5 minutes (with or without pricing considerations). We are on ECC 5.0. Does anyone know of an existing snote or ways that would help to improve performance?

A related question on performance tracing. I have done some tracing and notice that the time to access SQL/buffer/enqueue/RFC only amount to less than 50% (sometimes 5%) of the total processing time. What has the system been doing for the "unrecorded" time?

Thank you and appreciate!

-cynthia

[Former Member]

I would check which modules or which parts of code take the most of the processing time. You can use SE30 to check one order save.

If it's not SQL - then it may be internal processing like inefficient loops and so on. For example runtime of nested loops with big tables have grows exponentially.

It may be caused by SAP code - search OSS notes for based on the module names which consume most time.

OR it can be caused by the code in your userexits - then developers have to fix it and redesign using more efficient technique.