Show Inventory Movement Throughout the Month

[former_member1287140]

I would like to run a something in SAP that will give me the starting stock at certain period, then show any movements of that stock out to the customer. Similar to the MB5B but I need it to also show storage location and when a part actually moves out and on what day. For example, part in a specific plant and storage location comes in on 9/12/22 and then leaves on 9/16/22. I want to see those days it moves out so i can tell how long that specific part was in the warehouse for. I would also want to see if the part still had stock left. So if they only took 5 out of 10 pieces of that part that were in stock during that 9/12/22 to 9/16/22 i would still want to see the remaining 5. They could still be there at the end of the month or they could have moved out at another time, i would want to see that as well. I would assume we need batch number as well to make sure you are truly tracking the movement of the part correctly.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[Neeraj_Jain]

Hello sdnumber6,

Somehow, your expectation can be meet by running transaction MB51, in which, Material/storage location/date/time/movement/ batch and etc. your can see and analyze your inventory.

For ALV view run the report with option "Flat List" and in this view you can also export the report and analyze as per your requirement. After running the report you can also add the columns as per your requirement and save the layout for future display.

Regards,

Neeraj Jain