How i can link the sale line price to invoice line item price

[Former Member]

I want to write an query to link the Sale order line item condition type PR00 to Invoice line item condition type PR00.

The purposed is to compare the sale order Price PR00 vs Invoice PR00 to check user had made any manual changes in SAP.

[Lakshmipathi · Accepted solution]

First you need to pass KNUMV from both VBAK and VBRK to KONV so that you will get the PR00 values from sale order and billing.  Further, since your requirement is to generate a report only wherever there is a difference, validate the following two fields from KONV table

• Condition type (KSCHL)
• Cond.base value (KAWRT)

Tell this logic to your ABAP team who can build the required logic

G. Lakshmipathi