Inventory report in SAP (Unrestricted use & scheduled for delivery)

[Former Member]

Hi All,

Hope you are all ok and you can help me.

I am trying to find a report in SAP where I can see the items codes, lot numbers, quantity in unrestricted use and quantity scheduled for delivery so I can have a clue on how much stock left I have in my warehouse for all the codes and pull out the data into excel.

thanks for your help

[Former Member]

Dear Ant

Here you go...

Please check with MMBE it will give you every requirement which you willing to see. But the limitation is that at a time you can see only one material and you can't take the details in Excel from here.

Another TCODE is MB52 which will give you lot of information please click Non-Hierarchical Representation , So that you get in proper column.

If you are willing to see Stock in Hand Please Use MB5B.

Other useful TCODES

MC.9   - Stock with Value

MB53

MC.48 - Current stock.

MC50 - Dead stock also.

and last but not the least use Transaction "SAP1".This is menant for Reporting.You will find out all types of reports.

Thanking you!

Ashish Mishra

[Lakshmipathi]

Have you not checked in MMBE or MB52 ??

G. Lakshmipathi