Hi Mahehsha,
I don't think that's possible by looking directly at tables.
The tables you might need are /SCWM/QUAN and /SCWM/AQUA, also the LIME tables.
But then, as the storage bin is unique inside an EWM warehouse number, they do not contain the storage section as this would be redundant information. Therefore, you'd have to select first all storage bins for a specific storage type + section combination and then the stock for all these storage bins.
However, that's nothing I would recommend.
If your requirement is "check" in terms of monitoring, use the warehouse management monitor for the selection - you have all options there that you need and more.
If your requirement is to check in terms of a development, use function module /SCWM/SELECT_STOCK or the class /SCWM/CL_MON_STOCK which both offer the option to select by storage section. Actually, the class is a bit better as you can choose between physical and available stock.
All the best,
Jonas
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.