Correction Report For Sales Order

Once in a while, we are likely to encounter some issues related to sales order and this information will be useful for you to repair the data.

Take note to test in always in your Test environment first.

Sales Document Status Update

Sometimes a Sales Document may be updated incorrectly and the status may be out of sync with the attributes in the document.

For example the sales order has been fully delivered then also status is showing open or In-processing.

Solution is to Run SA38 or SE38 with report SDVBUK00 which will determine the status again for the document.
 

Billing Document Update - VF04

If a document is not displayed at all or incorrectly in the billing-due list, check the following points one after the other:

The relevance for billing (table TVAP) of the document: if this was changed, consider Note 127514.

The billing status of the document (tables VBUK or VBUP). If you can neither bill a document with Transaction VF01 or VF21 nor with Transaction VF04 or VF24, check whether the billing status of the document to be billed is correct.If required, run report SDVBUK00 for sales orders (Note 67742, 88511, 207875) or report ZZDELSTA for deliveries (Note 137011).

For billing documents, you can achieve a redetermination of the status by means of a change of a header field in the billing document (Note 142368).
 

Billing Index (table VKDFS)

If a document is not displayed in the billing-due list, but you can still bill it in Transaction VF01/VF21, the statuses of the document to be billed are correct. However, incorrectly, the system did not create an entry in the billing index. For the resetup of the index table, call up report RVV05IVB for the affected documents. This report is described in Note 128947.

Remarks:

The index update (VKDFS) occurs during the update of the statuses in program SAPLV05I that is, during a possible debugging, the update debugging has to be active. Function group V05I ('Index update') is maintained by component LE-SHP.

- You can find an analysis report for the billing-due list in the related Note 386370.

The statuses (VBUK, VBUP) are determined in programs SAPLV45P or SAPLV50P.
 

Correcting Incorrect SD Document Indexes

Report RVV05IVB is available in your system for reorganizing or correcting incorrect SD document indexes. The report can correct the following index tables:

Select only what is appropriate as the running time can be quite long.

For example, I fill in the Sales document number with issue and only Tick Billing index (Sales Documents)
 
Table Contents Usage
VEPVG Delivery Due Index  Delivery Due List (VL04)
VKDFS Billing Initiator  Billing Due List (VF04, VF24)
VTRDI Shipment Planning Index Shipment processing (VT01/VT04)
VRSLI Receipt of Material from Deliveries SC Stock Monitoring (ME2O)
VAKGU Sales Index: Quotation Validity List of Quotations (VA25)
VAKPA Orders by Partner Function List of Sales Orders (VA05)
VAPMA Order Items by Material  List of Sales Orders (VA05)
VLPKM Sched. Agrmnts by Cust Mat.  List of Scheduling Agreements (VA25)
VLKPA Delivery by Partner Function  List of Deliveries (VL05/VL06)
VLPMA Delivery Items by Material List of Deliveries (VL05/VL06)
VRKPA Bills by Partner Functions  List of Billing Docs (VF05)
VRPMA Billing Items per Material  List of Billing Docs (VF05)

If you use the RVV05IVB report to obtain a correct result for the SDRQCR21 correction report (Requirements), select "Material index" in the 'Sales documents' area and in the 'Deliveries' area. If you do not have much time to run the report, restrict the document numbers further (for example, the documents corrected in the last run of the SDRQCR21 correction report). If you have enough time, you do not need to restrict the documents any further.

The SDRQCR21 report works incorrectly if the material indexes of VAPMA (Sales and distribution documents) or VLPMA (Deliveries) are incorrect.

See also; MD04 - Inconsistencies after PGI - SDRQCR21

SAP SD Tips

See Also
VOV8 Sales Document Type Description of Fields

Get help for your SAP SD problems
SAP SD Forums - Do you have a SAP SD Question?

SAP Sales and Distribution Books
SAP SD Books  - Certification, Interview Questions and Configuration

Delivery Hints
SAP Logistics Execution

SAP Sales and Distribution Tips
SAP SD Discussion Forum and Sales/Distribution Tips

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.