Stock in previous periods can be a useful indicator in analyzing your stock positions through time per material or material group. Standard SAP report MC.9 offers this functionality:
MC.9 can present you with multiple historical stock levels and values at the end of each period. Important tables for this report are S031 – Statistics: Movements for current stocks, S032 – Statistics: Current Stock and Grouping Terms and S034 – Statistics: Movements for current stocks.
The stock level and value of the previous period is also displayed in the material master’s Accounting 1 tab:
Important tables here are MBEW and MBEWH, MARD and MARDH or MCHB and MCHBH. The ‘H’-tables represent historical records. If there is not a historical record in the H table, but there is one in the ‘current’ table, the historical value is the same as the current value.
Comparison of stock levels between MC.9 and the material master is rather straightforward. These should match. Comparison of stock value is more complicated. MC.9 offers four valuation methods to choose from. Material master offers another. As a rule of thumb: on plant level the standard value in MC.9 can be compared with the stock value in the material master, accounting view. SAP note 506077 provides some background on stock controlling valuation.
If the values in the material master and MC.9 don’t match, then check the update rules (e.g. for infostructure S031 and S034). How are your periods defined there? This can be found at IMG > Logistics General > LIS > Logistics Data Warehouse > Updating > Updating Control > Activate Update. This is just a pointer, there may be other reasons.
Update week 7/09
The total of LIS structures and its valuation methods for Inventory Controlling is rather complex. I recommend the following SAP notes if you really need to get acquainted with the workings and get guidance on how to update the structures
SAP Note 64636 – Procedure for statistical data setup in LIS : here
SAP Note 79083 – Setup of statistical data in BCO: Additional information : here
SAP Note 111691 -Material related statistical setup Inventory Controlling : here
SAP Note 456106 – Standard analyses : Display of values : here
SAP Note 512416 – LIS Stock in the past : here
SAP Note 551630 – FAQ : Questions on Inventory Controlling: here