Skip to Content
Author's profile photo Jimmy Zhang

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):

image 

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:

image

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

image

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:

image

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

image

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

image

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

image

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

image

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:

image

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:

image

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sachin Jain
      Sachin Jain

      Seriously , this document clears most of my doubts ..

      Thanks a Lot for sharing !! 🙂

      Author's profile photo Former Member
      Former Member

      This information will be really useful for many consultants.

      Many thanks for sharing the info !

      Author's profile photo Sunil Panigrahi
      Sunil Panigrahi

      Very Nice document..Thanks for sharing this..

      Author's profile photo David Rodríguez de Francisco
      David Rodríguez de Francisco

      Thanks very much for this very very clear example !

      Author's profile photo Ashish Kumar
      Ashish Kumar

      Crystal clear explanation with snapshot comparisons which makes it easier to understand even for beginner like me....thank you Jimmy Zhang 🙂

      Author's profile photo Former Member
      Former Member

      Hi Jimmy,

       

      I have a scenario wherein we have this obsolete material that needs to be zero out on our stock on hand. However upon processing the cancellation/return to vendor (t-code MIGO) I have encountered this error message " Deficit of VC Unrestricted-use 5 UN"

       

      Appreciate if you can help on resolving my issue.

       

      Thank you