KOMV Structure - Pricing Conditions for Billing Items

[Former Member]

Hello,

I am trying to extract the billing historical for the last year in order to use this data for a complex sales analisis. For this analysis I need all price conditions types and values for every billing item.

But I didn't find yet a solution for extracting the condition types, the amount, and the value for every billing item.

In VKRP table I don't have all the data. In KONP table I have some data but I don't know how to link this table to the VKRP table.

I saw that the data that I need are stored in KOMV structura, but I don't know how can I access this structure.

Does someone have a solution for this issue?

Thank you!

Daniela

[Former Member · Accepted solution]

Hello,

I found a very helpfull answer here : http://sap.ittoolbox.com/groups/technical-functional/sap-log-sd/komv-structure-pricing-conditions-fo...

Thank you for your support.

Daniela.

[Lakshmipathi]

In VKRP table I don't have all the data

I presume, this would have been typographical error as I dont find VKRP table.  In fact, getting condition types and its corresponding billing document have been discussed many times in the past.  The link between VBRK and KONV is KNUMV

G. Lakshmipathi

[Former Member]

G Lakshmipathi,

My mistake. Is table VBRK.

I found some answers here: http://sap.ittoolbox.com/groups/technical-functional/sap-log-sd/relationship-between-tables-vbrp-and...

But maybe exist a easier solution. We use ECC 6.0.

There are about 800.000 billing items.