topic Re: Help: Urgent!!!!!!! in Application Development and Automation Discussions

Help: Urgent!!!!!!!

Vijay — Tue, 31 Jul 2007 06:34:54 GMT

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

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:39:30 GMT

Hi ,

Try with matnr field in both LQUA and LTAP

<b>Regards,

Azhar</b>

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:41:36 GMT

Hi,

This query already seems to exist..

check the suggestion in that thread

Regards

Aparna

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:44:29 GMT

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

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:44:29 GMT

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

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:52:32 GMT

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

Re: Help: Urgent!!!!!!!

Former Member — Tue, 31 Jul 2007 06:58:07 GMT

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