Material standard and variable price

[Former Member]

Hi all,

I've been ask to create a report that shows the variable and standard price of the material for the current month and compare this with the price of a month that they get to choose, and if they don't choose a month to compare it with then I should show the price of that material for every month of the year.

My question is, where can I find this info in SAP. I know that in MM03 I see the standard and variable price of the month and the previous month, but that's about it.

where can I find this historical info of prices for material?

thanks in advanced,

Fidel Gregorio Peralta.

[Former Member]

Hi Gregorio,

have a look at table mbew. I think it will be at least of some help.

regards

Siggi

[christian_wohlfahrt]

Hi!

You can find current prices in table MBEW. Field VPRSV says, if you find moving avg. in column VERPR or the standard price in STPRS. Currency is company code currency.

In table MBEWH you find historical values - which are only inserted in case of price changes - so missing periods have same value as last entry before.

Regards,

Christian

[Former Member]

Thank you so much Christian and Siggi. I'm not in the client at the moment, but when I get there I will try it out.

Regards,

Fidel