Table for stocks from storage types with level of available quantity 1

[prabhub]

In EWM, We have a scenario where the HU's which are in storage types with the level of available quantity as "1" [Bin level] - not visible in AQUA / QUAN table.

[prabhub]

It will be helpfull, if any one can help with the table for the above

[MohdRKhan]

Hi 

As per my knowledge,As we select available stock at bin level in a storage type. After that we dont find bin in /scwm/AQUA table.

As I dont know a direct table to link it but by logic we can find data

We have /SCWM/QUAN (Quant Attributes) this table is linked to available stock and Handling unit tables. It is linked via GUID_HU, GUID_Parent and GUID_Stock.

Handling Units (HUs) tracked by /SCWM/HUHDR are also connected through the Quant Attributes table through GUID_HU

Use  /SCWM/QUAN and /SCWM/HUHDR and you will find hu details. 

now indirectly, you can fetch hu details. 

Hope it may give some idea.

Regards

Rashid Khan