SAP Note 26653 - Performance improvement SD document update

Symptom:

Long validity periods when updating large documents.

Cause and prerequisites

Database operations with an effort for the update of indexes.

Solution

In programs LV05IFxI (x = 0, 1, 2, 3, ... , 8) in which sales and distribution document indexes are updated, you can activate the array insert for the insert mode. The corrections required to do this are described in the attachment.

In the following overview you can see which programs in your system can be used for a performance improvement:

Program Table Contents of the index table

LV05IF0I VAKPA Orders by partner function
LV05IF1I VAPMA Order items by material
LV05IF2I VAKGU Quotation validity
LV05IF3I VEPVG Delivery due index
LV05IF4I VLKPA Deliveries by partner functions
LV05IF5I VKDFS Billing initiator
LV05IF6I VLPMA Delivery items by material
LV05IF7I VRKPA Bills by partner functions
LV05IF8I VRPMA Billing items for each material

The highest performance improvement is achieved for programs LV05IF1I, LV05IF6I and LV05IF8I because here an item index is written.

This note will not be included in a Hot Package. Check whether you require the correction described in your system. When you apply a Hot Package, the system may overwrite parts of this correction. Therefore, when applying a Hot Package, make sure that you retain this correction (SPAM/SPAU) unchanged in your system.

Additional key words

Performance, VA01, VL01, VF01, VA02, VL02, VF02, VL04, VF04, index, indexes, validity period, update, update program, sales order, delivery, billing document