Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Help: Urgent!!!!!!!

Vijay
Active Contributor
0 Kudos

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.

points guaranted

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi vijay

After selecting data from ltak and ltap, you can use query on lqua as shown below

Select * from LQUA

Where lgnum = ltap-lgnum

And lqnum = ltap-vlqnr “ it’s a quant in any transfer order

It will give you desired value of available stock.

regards

asha

6 REPLIES 6

Former Member
0 Kudos

Hi ,

Try with matnr field in both LQUA and LTAP

<b>Regards,

Azhar</b>

Former Member
0 Kudos

Hi,

This query already seems to exist..

check the suggestion in that thread

Regards

Aparna

Former Member
0 Kudos

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

rEGARDS

Former Member
0 Kudos

LTAP -> chk this table value or initial. if table is null as funcation people.

do this steps.

LQUA

LGNUM

LQNUM

LTAK

LGNUM

TANUM

LTAP

LGNUM

TANUM

TAPOS

using inner join two table LQUA LTAK -> store result it_first.

uing for all entries it_first where LTAP ->it_first LGNUM

Former Member
0 Kudos

Hi

Link the table LTAP and LQUA with the following fields

LGNUM

LQUA-LQNUM = LTAP-VLQNR (quant)

and if you want use the other common fields like

MATNR,WERKS,CHARG and

LQUA-LGTYP = LTAp-VLTYP and

LQUA-LGPLA = LTAP-VLPLA

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member
0 Kudos

hi vijay

After selecting data from ltak and ltap, you can use query on lqua as shown below

Select * from LQUA

Where lgnum = ltap-lgnum

And lqnum = ltap-vlqnr “ it’s a quant in any transfer order

It will give you desired value of available stock.

regards

asha