Moving avarage price report

[Former Member]

Hi

can somebody pls tell me how can I get report for the Moving average

price on a particular date & value of the stock accordingly on that day.

Thanks & regards..

pravin

[Former Member · Accepted solution]

the transaction code CKM3

or u can build sap query

You can build such a report from MSEG & MBEW tables.

I remember that MSEG has fields for 'Stock qty & value prior to posting a material document'. So, you have to develop a report from this info.

MBEW has current MAP info

Hope ths help

Please reward points

Sunil

[Former Member]

Hello Praveen,

CKM3 / CKM3N will work only if material ledger is active for your valuation area.

Table MBEW will give the material price and value for current and previous period, not for particualr date and the same is for MBEWH will give the price and value for past periods.

Table MSEG contains Material value and Stock before posting that material document, but does not contain document date, so you need to take it from MKPF table.

Also you need to give logic that if material document is not available for that particular date it should consider the posting period and pick the material price and value from MBEW / MBEWH table.

I think it will be some challenging report to get material price for particular date, instead if you convience business abou the getting price for that posting period it will be more easy. In that case you need to consider only MBEW and MBEWH table.

Hope this helps.

Regards

Arif Mansuri

[Former Member]

Hi,

For My Knowledge you can get Moving Average price today date,Current period and previous period only.

If you want Moving Average price for Perticular day Means today date 30.03.2007 but you want MAP for 01.03.2007.This is not Possible,I am Talking about List MAP of all mtrls.

If i am wrong pls Correct Me,

Thanks,

Raghu

[dipak_kumar3]

Hi,

Doing bit research on MSEG table may lead to what you are looking for .

Thanks

Dipak

[Former Member]

Hi,

Transaction MB5B is worth looking at, this is the closest report to what you want.

Steve B