Storage Bin

[Former Member]

Hi,

i need to find out the bin location for particular warehouse number. But in the table LAGP each warehouse no(LGNUM) is having different bin locations. how can i find it out exact bin location for a particular material. Is there any other tables related with VEPO and VEKP.

Thanks..

[sreeramkumar_madisetty]

Hi

Search the relation using the Transaction code : spro.

You can findout the tables.

Regards,

kumar

[Former Member]

Hi,

Table <b>LTHU</b> will give you the Location for WH Number.

Even it is linked with Handling Unit Number also.

Regards,

Anji

[Former Member]

Table LQUA (quants) will show you all of the places where a material is stored, by wwarehouse number. Ther shuld be an index by material and warehouse, so the search is quite fast.

For VEKP and VEPO, in WM the handling unit is treated as a storage unit. If you take the handling unit ID and look in table LEIN, this will show you where int he warehouse the storeage unit (HU) is stored. The HE/SU information is also in LQUA.

HTH. If so, award points.

Dave