The Moving Average Price of a Material in a Plant suffers strong variances that you cannot explain.
Not only goods movements change the Moving Average Price of a material. Invoices, Credit memos, Price changes, Order settlements can also change the Stock Value without changing the stock quantity, and, therefore, result in changes in the Moving Average Price.
NEW Analysis Report MBMAPCHANGES:
We used to follow the solution explained in the SAP Note 1506200 to explain the changes suffered by the Moving Average Price of a material.
This process, however, involves plenty of manual steps and checking data directly in database tables for which most users will not have authorization in SAP systems. For this reason, SAP support has developed a report which can query the list of documents which have changed moving average price of a certain material.
The report is named MBMAPCHANGES and it is available with the Note 2198317 - Analysis report for moving average price changes: MBMAPCHANGES
About the tool:
Based on the selection criteria entered on the main screen of the report the system assembles an ALV list of documents which changed the moving average price. Each line contains the reference documents' key fields, the quantity and amount posted by the document, the total stock and total stock value before posting and the moving average price before and after the posting. V-Price changes over the 'Highlight threshold %" will be highlighted for easier analysis. Double-clicking lines will open the reference documents in their corresponding display-transaction.
Selection screen example: