Report needed to conbine stock movement and corresponding balance

[Former Member]

Hi Friends,

End user need a report to show stock movement trasaction and it's coresponding stock balance.

In MB51, we can see all the stock movements against one material, is there any way a report could show stocks' corresponding iventory balance under diffierent invenotory category (unrestriced,QC, Return and block) for each movement trasaction ?

Report needed like below

SLoc , MoveType , Material document, posting date, qty, unrestic bal, QC balance, return Balance, Blked Bal.

Thanks,

L

[former_member183879]

Hi Linda,

We are presently preparing a report similar to what you are asking for. It is tedious, complicated report.

You can refer to the tables MBEWH, MBEW, MSEG, MKPF, MARDH etc to create a report for ur purpose. You have to understand how MBEWH and MBEW works.

[bcrao]

Check MMBE-

Shift+F7

or MMBE-> menu>environment and choose your options here

Thanks

Chidambaram

[Former Member]

Hi,

Kindly take the help of abaper and create a customized report or also you can have query created in SQ01.

Hope this will help you !!!

Regards,

Krishna O