How to fetch pricing condition for a invoice.

[senthil_kumar29]

Hi Guys,

I have a requirement to fetch pricing condition and its value for a invoice and print it in a form. From which table I could get this value. Since pricing condition tables are not standard one.

Cheers

Senthil

[former_member217082 · Accepted solution]

hi senthil

KONV , KONP,KONH all are pricing related tables

Regards

Srinath

[senthil_kumar29]

Thanx Guys

[former_member204513]

Dear Senthil,

Try with VBRK and VBRP tables

I hope it will help you

Regards,

Murali.

[Former Member]

Dear Senthil,

See u r prices in billing is stored in KONV.

But Billing Tables are VBRK & VBRP

VBRK is Header Table

VBRP is Detail table

Now enter billing document number in VBELN field of VBRK & extract KNUMV i.e Document Condition.

Also enter billing document number in VBELN field and material number in field of MATNR & extract Item Number POSNR,

So now u are having Document condition & item number

Put this two things in KNUMV & KPOSN fields of KONV & u will get all values in KWERT according to Condition Type.

I hope this will help u.

Regards

SWAPNIL

[Former Member]

Hi,

The condition relevent tables are :

KONV-Conditions for Transaction Data

KONP-Conditions for Items

KONH-Condition Header

VBRK-Billing Header

Prase