Skip to Content

Need Report Like MC.9 that includes Storage Type

Hello gurus,

We have plants that are IM only, and others that are WM. The IM plants have storage locations specific to production staging. The WM plants have storage types specific to production staging. I have searched unsuccessfully for a transaction or report that is like MC.9, that also includes storage type. We currently use MC.9 to run a report that highlights inventory in production staging that has not moved in 7 days or longer. I could run MC.9 for the IM locations, and LX02 for the WM locations, then merge the two, but I'd prefer to run only one report if a means to run only one exists. Or are there some tables I could link into a new query that I can create to serve this purpose?

Thanks in advance for thoughts everyone.

George

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 14, 2020 at 06:43 AM

    Hello George Kaszas

    First of all, kudos for using MC.9!!! MC.9 is a turnkey solution for inventory reporting and optimization, still I can see it hardly used.

    MC.9 is purely MM-IM analysis. Thus it doesn't cover LE-WM organizational structures, e.g. storage types. In general storage locations and storage types are independent i.e. stock in one storage location can be placed in several storage types and vice versa stock in several storage locations can be put in a single storage type. MC.9 is updated by IM-MM material movements not by LE-WM transfer orders.

    Therefore you need to use separate LE-WM reports e.g. LX02 to report stock on LE-WM level.

    You could however use LE-WM storage location control to have your stock automatically posted to a separate storage location (still managed in WM) during material staging for production - see SAP Help: Posting Changes Between Storage Locations - Material Staging for Production

    Sure, that would mean a change to your current business process and certainly update to master data, however that would allow to implement your requirement i.e. to use MC.9 to monitor slow moving stock in production staging.

    Best regards

    Dominik Tylczynski

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.