ECC Source for Selling Price & Cost of production per unit which I can extract to BW server

[dipesh_mokani]

Hi Experts,

I want to know the source from where I can extract selling price per unit and Cost of production per unit of finished goods which I can extract to BW server. I want to use this selling price per unit in BPC Sales Plan and to find Contribution margin to sales.

Thanks

[eduardo_hinojosa]

Hi

For cost, consider table MBEW, fields STPRS and VERPR depending of value of field VPRSV. After consider how to link BWKEY with WERKS (if you are running PP BWKEY have to be WERKS, no BUKRS).

For sales, taking in account you can use different pricing procedures, I'd suggest you table VBRP field NETWR. But you have also the cost in VBRP or in pricing procedure (usually condition VPRS), do a research on field WAVWR in table VBPR (after a product costing the cost could be modified, or if the material is MAP).

Other possibility is if you are running COPA do a research on your operation concern.

I hope it helps you

Regards

Eduardo