SAP ECC database help

[Former Member]

Hi Experts,

May we please seek your help regarding the corresponding database tables for KONV.

Currently were developing a reporting program that directly connects to SAP ECC Database.

One of our requirement is getting the Billing pricing conditions like Gross Price, Discounts and Taxes which in SAP is at KONV clustered table. Unfortunately were not able to locate the corresponding database tables of KONV.

Your help and inputs will be greatly appreciated. Thanks.

[Lakshmipathi · Accepted solution]

To get pricing conditions from billing document, first you need to execute VBRK, copy the data from field KNUMV and pass those values in KONV where also you can see the same field.  Before that, first check in VBRP table whether the required values are stored in Subtotal1 to Subtotal6 so that straightaway, you can take from VBRP.

G. Lakshmipathi

[Former Member · Accepted solution]

Hi Lakshmipathi,

Thank you for your valuable input. The columns you've mentioned contains the values that we need.

Again, Thank you.