Need pricing data for invoice

[Former Member]

Hi Experts,

I want to do some processing on pricing data for an invoice. I have invoice and item level data but am not able to get the pricing data from database tables. Please let me know the link to get pricing data from database tables for invoice.

Regards,

Dileep.

[former_member193284 · Accepted solution]

Hi Dileep,

The pricing data can be retrived from the condition tables.

Please refer Invoice tables VBRK & VBRP and look for condition record field KNUMV. take this field and go to the condition tables KNOV. This table will hold pricing data based on the condition types.

Check for condition record number in VBRK if you done find one. you can get the order number of the invoice from VBFA and pick then retrieve VBAK-KNUMV and get pricing data as shown below.

Sample code

**-->Get condition records

SELECT knumv

kposn

stunr

zaehk

kappl

kschl

krech

kawrt

kbetr

waers

kwert

kstat

kinak

koaid FROM konv INTO TABLE t_konv

WHERE knumv = w_es_bil_invoice-hd_gen-kond_numb "vbak-knumv

AND kappl IN (c_kappl,c_taxes).

Thanks

[Former Member · Accepted solution]

Thank you Sumit.

Dileep.