Customizing of Material Type and MM Inconsistency Prevention

Let us first see an example how stock inconsistency will occur because of the customizing change on quantity/value updating flag for the material type.

In transaction MMBE, the current stock of the material TESTMAT_1 in plant 1000 is zero (material type is ROH):

Since the material type is ROH (Raw Material), normally the accounting view is available for the material. Check in MM03, accounting view, the stock valuation data is consistent to the stock quantity in MMBE as zero:

At the moment, the customizing of quantity/value updating flag for the material type ROH could be checked in transaction OMS2:

Since at the moment, the quantity and value updating indicators are ticked for the material type ROH, we expect any goods movement for material TESTMAT_1 in plant 1000 will cause update on stock quantity and valuation data. So firstly we will do a test goods receipt to check out the result:

In transaction MIGO, a test GR is done for the material TESTMAT_1 in plant 1000 for 10 PC:

The result in MMBE and MM03 is consistent to each other as below:

Now let us change the customizing of quantity/value updating flag for the material type ROH:

Now we do a test goods movement again to check out the result. It is a goods issue for 5 PC:

The result shows now the inconsistency between the stock quantity in MMBE and the stock valuation data in MM03:

If now you change back the customizing of quantity/value updating flag for the material type ROH in OMS2, so that the quantity and value updating indicators are ticked for the material type ROH, the inconsistency could be reported by inconsistency check report MB5K:

To prevent such inconsistency, if you want to change the value and/or quantity update of the material types, you have to book out the existing stocks in advance. Ensure that you book out existing stocks in your productive system before you transport the Customizing changes. After the customizing change, book back the stocks.

However this best practice is not aware of by everyone when doing customizing change on value and/or quantity update of the material types. So note 1396442 was introduced to provide reminder message when doing the customizing change. After the note implementation, there will be such warning message:

Thus, hopefully we can avoid this kind of inconsistency in the future.