topic Re: Storage Bin in Application Development and Automation Discussions

Storage Bin

Former Member — Tue, 27 Feb 2007 10:15:34 GMT

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..

Re: Storage Bin

sreeramkumar_madisetty — Tue, 27 Feb 2007 10:16:58 GMT

Search the relation using the Transaction code : spro.

You can findout the tables.

Regards,

kumar

Re: Storage Bin

Former Member — Tue, 27 Feb 2007 10:25:48 GMT

Hi,

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

Even it is linked with Handling Unit Number also.

Regards,

Anji

Re: Storage Bin

Former Member — Tue, 27 Feb 2007 11:26:12 GMT

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