How MBEWH Table Get Updated

ERP SAP ==> SAP MM Module

Would like to know the MBEWH table updation logic.

MBEWH table is updated whenever there is change in Moving Average Price.

MBEWH is basically the History table for MBEW - Material Valuation table.

As MBEW is supposed to contain current values, when it has to be changed (like when updating material current price, etc.), the current value gets written to MBEWH and the new value gets written to MBEW.

The current standard is always in MBEW. When the first activity in a ‘period’ takes place valuation or quantity update; a record is written to MBEWH to document the balance, std, price control, that existed BEFORE the "first activity 

The number that represents the previous period record being written into the MBEWH table is represented in the ‘current period’ LFMON field. 

EXAMPLE: when the first activity occurs in period 3 (i.e., a goods receipt), an entry is written into the MBEWH table with a ‘current period’ number of 2. The quant and value updated to the ‘total stock’ and ‘total value’ fields are equal to the data that represents these fields PRIOR to the activity quant and value occurring in period 3.

If there is no activity for several periods, you will not have entries for every period in the MBEWH table.

What is difference between MBEWH & MCHBH table?
Why are stock in these table different?
I have two reports one is for Stock at PLANT level and one BATCH level . They used table for quantity MBEWH for PLANT level and MCHBH for BATCH level and whenever displaying quantity is different in both reports ?

MBEWH table is referring to total valuated stock
MCHBH table is referring to valuated stock with unrestricted

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Other Logistics Modules

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.