Profit Margin Issue

[Former Member]

We would Like to see all the Sales orders which are Having 100% Profit/Contribution Margin from Sales order ,I tried KOMV Table But it is a Structure.

Thank you ,

Sandhya A

[Lakshmipathi]

I am sure, your sale order will have both PR00 and VPRS and as you are aware VPRS fetch the cost of the material you are invoicing and PR00 is the selling price to that customer.

In sale order these two condition types will show the value to the extent of the quantity invoiced and you can very well take the same from the table KONV. You can also try from tables A303 or A305

thanks

G. Lakshmipathi

[Former Member]

I tried A303/5 but shows nothing.and KONV Table I am Unable to understand it, I thought it would show Order Amount,Sale Price and the Profit Margin either in % or amount .

Like 100 Net Price

40 Mat Price

Margin 100-40=60 or 60% as the Margin . We would like to see this kind of Analysis.

Thank you ,

Sandhya.A

[Former Member]

Hi,

First you have to define the condition type in V/06 for the profit and assign the require routines to get the profit.

Then assign this condition type in the pricing procedure.

Then you can see the profit in sales order itself,

If you want to see the profit at table level, you can get it from the KONV table