04-19-2007 7:38 AM
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 didnt 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.
04-19-2007 7:45 AM
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
08-06-2011 5:05 AM