From which SAP table(s) I should pull the inventory to show the units by Storage Bins?

[former_member704729]

Hello,

I need to pull the current inventory for a specific group of products, Storage Locations, and Storage Bins. Table MARD shows the total inventory by, Storage location and Material Number. I am still missing the Storage Bin.

Do you know from which SAP table(s) I should pull the inventory to show the units by Storage Bins?

The following images show:

* My Current SQL Query

* The Results of the Query without the Storage Bin

* The Correct Results displayed in SAP for a specific Storage Bin

Thank you very much for your support.

Juan Cisneros

.

[lenastodal]

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) and share screenshots of what you've seen/done. 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 as it encourages readers to respond to you. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS.

Best,
Lena
SAP Community Moderator

[Dominik_Tylczynski · Accepted solution]

Stock in WM managed storage locations is maintained in LQUA table.

Best regards

Dominik Tylczynski

[former_member704729 · Accepted solution]

Hello Dominik,

Thank you very much for your prompt reply.

Table LQUA is exactly what I needed.

Regards,
Juan Cisneros