How to Get Backdate Bin Stock Report

[Former Member]

Hi,

Appreciated it if anyone can give me an idea of which table I can combine / T-code for me to get the bin stock report for a certain time frame? I knew MB5B can give the opening balance and closing balance on the given date, but I which to get similar data, but was in bin level. Temporary I just find out Table-LQUA able to have the last mvt, last GR date. However if I specific on the date of mvt, the date will not be accurate. Any idea to solve the issues? I wish to get as of 31 Oct 2020 by bin level inventory.

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia

SAP Community Moderator

[Dominik_Tylczynski]

Hello wendyng

SAP standard LE-WM doesn't provide a report of historical stock levels per storage bin. You'd need to implement a custom report here. Table LQUA holds the current stock per storage bin. Tables LTAK (header) and LTAP (items) hold transfer order i.e. movement to and from a bin. So you could get current stock from LQUA and all the movements from LTAP and count back the stock level to any past date. Just keep in mind that the performance might be an issue if you have a lot of storage bins and movements and need to go far into the past.

Best regards

Dominik Tylczynski