![all material master tables in sap all material master tables in sap](http://www.saptraininghq.com/wp-content/uploads/2012/11/Article-19-Image-5.png)
The movement type 301K (marked yellow) did not trigger any update in MBEWH table, because consignment stock has no value, hence no change to valuation, which means MBEW table is not affected.įinally we have movements in May 2011, and the first movement caused the creation of year end records of 20 and for the previous month 04 2011.
![all material master tables in sap all material master tables in sap](https://www.sap-tables.org/table/maw1/sap-table-MAW1-erd.png)
The movement from Aptriggered the creation of 2 history records: for period 003 2008, and because there was a year change in between a record for period 12 2007 The next month with movements was December 2007, which caused a history record for November 2007 The history record tells you that the stock and value for this material was zero at the end of April 2007 This event triggered the creation of the history record for period 004 2007. You can see that the first movement to this material happened on May 22, 2007. Many would expect to see 60 records for 5 years, but we had only 8 months with changes in those 5 years, hence only 8 history records were created.Īnd as proof a screen shot from MB51 Material Document list for the same material and plant: Here we see 8 history records for the valuation data MBEW of one material in one plant, created over a time span of 5 years: SAP writes only a history record for the month preceding a change in stock or value.Īll the periods between 2 records in a history table had the same stock/value all the time, hence you can take the value for those periods from the record following these missing periods. If there is no movement for several months, then you will not see any history record for all those months that have past. The History tables are updated with first movement after a period closure. SAP does not update the history table when you execute MMPV to close the MM period. SAP explains the logic in Note 193554 – Stock/valuation data of previous periods still we can see in many discussions that this note was not fully understood. This was implemented to speed up the period closing.īut how these tables are updated is for many users cumbersome, they expect to see a record for each month in those history tables, but SAP does it differently. All those tables have the same name as the standard tables, but with a H at the end. All stock and valuation tables in SAP have as well history tables since release 45.