Need Report Like MC.9 that includes Storage Type

[former_member1043981]

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

[DominikTylczyn]

Hello geokas

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