INTERVIEW QUESTIONS
SAP R/3
SAP MM
DETAILS
Question: 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?
Answer: 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.
|