Transaction for warehouse stocks per material

[Former Member]

Hi

I am wondering if anyone knows of a transaction that gives you the current 'GOOD' stock you have per material and per warehouse, ideally it would look something like the below:

Part number	Factory warehouse	External warehouse 1	External warehouse 2
1	25	5	12
2	50	0	45
3	100	0	67
4	125	2	0
5	150	10	2
6	200	250	32

Any help would be much appreciated.

Thanks.

[JL23 · Accepted solution]

There is no such report in WM, in WM you always only look into 1 warehouse at a time.

You can of course something similar with MB52 report, you only need to enter the plant and the storage locations that are connected to the warehouses (table T320) in your selection.

You can then filter on unrestricted use stock when the result appears.

However, the values are listed beneath each other columns and not in rows as in your table above.