Reporting.

[Former Member]

Hi Experts,

SAP only provides moving average value for current, previous period, and previous year. SAP does not provide transactions/reports that will provide moving average value for a given date.

How can I report moving average price for material number 10000000 at plant 0001 on Feb, 28 2010?

Thanxs,

- Ganesh

[Former Member · Accepted solution]

Try any of these solutions: 

1. Change the updating level of the structure (S031) to "daily". In LIS the total value and the total stock are available. Divide value by the stock. It is possible to calculate this dynamically when the analysis is run and to display the result. 

2. Create your own structure in LIS and populate it by copying the Moving Average Price from the material master every time there is a transaction. You will have data on those days when there was a transaction.

[Former Member]

check this report

S_P00_07000139

[Former Member]

In My knowledge SAP stores MAP in table MBEWH period wise

You can get period wise not date wise