Link between LQUA and LTAP

[Former Member]

Hi All,

Hi All,

Our requirement is to display available stock details corresponding to warehouse No,, transfer order no, material no ,etc..

We are retrieving data from LTAP AND LTAK join and then we want available stock (VERME) data from LQUA,

We want to know how do we retrieve data from LQUA based on LGNUM & LQNUM.

We were able to get LGNUM from LTAP but we tried LTAP- VLQNR,/LTAP-NLQNR,/LTAP- RLQNR and compared the same with LQUA-LQNUM.

But the values were different and hence the query didn’t return any result.

Could anyone please help me to get the unique record from LQUA for each record retrieved from LTAK and LTAP join. Please let me know any link between the above tables.

[Former Member]

Hi,

Use LGNUM on both tables

and LQUA-LGTYP = LTAP-VLTYP and LQUA-LGPLA = LTAP-VLPLA

and get the records from LQUA

If needed use MATNR,WERKS, CHARG and VBELN fields also. for joining the two tables

reward if sueful

regards,

Anji

[Former Member]

This message was moderated.