MC44 – Inventory Turnover (2)

In MC44 – Inventory Turnover (1) I explained the concept of Inventory Turnover and how it can be used. In this post I will explain the transaction itself. The transaction is mostly self-explanatory, but there is one option of particular importance.

When you go to transaction MC44 you will see the below screen:

MC44

Transaction MC44 - Inventory Turnover

Like I said, most settings are easy to understand since they mostly concern filters on organisational unit (Sales Organisation, Purchasing Organisation, etc.) or filters on materials (material group, material type, etc). Of specifc importance is the setting “Daily usage” in the section Analysis period.

Daily usage unchecked: the report will use consumption quantitiesper period as registered in the material master. This means that if you use period Month for a material you can not analyze in shorter period intervals than Month. This should be no issue since Inventory Turover should be calculated over longer periods of time (minimum 6 – 12 months).

Daily usage checked: instead of the consumption values in the previous option the daily consumption values are used as you see them in report MB51 – Material Documents. I recommend this setting if you want to analyze the calculation of SAP  and to find out what movement type are included. The runtime of the report is increased.

So what movement types are included? You can find the included movement types in the movement type configuration in MBJJ. Here you can toggle the consumption parameter. This is a fundamental setting that also influences forecasting. Forecasting will use consumption values of a material. When you decide you do want to use goods issue to production order for forecasting, but not for calculation of inventory turnover, you have a problem. This cannot be done. You should calculate either value manually.

Conclusion: calculate Inventory Turnover over a longer period of time 6 to 12 months. Daily values are not relevant, unless you want to analyze results for your understanding.

Advertisements

4 thoughts on “MC44 – Inventory Turnover (2)

  1. Prabhakar

    Hello Eddai
    Happy New Year.
    I want to know how to get the Inventory Turnover as a whole instead of Material wise, for a particular plant for last 12 months. MC44 gives the Material wise, Inventory Turnover.
    Thanks
    S.Prabhakar

    Reply
  2. Paul

    Thanks for this! One quick comment: I believe the transaction you refer to for changing material type configuration is OMJJ, not MBJJ.

    Reply
  3. Petr

    Thank you for this article. However, I cant find the parameter you mentioned in the movement type customizing (which is ofc OMJJ). If anyone knows what is the exact name of this parameter it would help me much.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s