topic Select Query in Application Development and Automation Discussions

Select Query

sudhir_uppalapati — Tue, 20 May 2008 13:25:00 GMT

Hi All,

I have to retrieve MATNR LFIMG VRKME ARKTX from LIPS where LIPS-VBELN = VFSI-VBELN.

Here i have a value 71 for VBELN which is in both LIPS & VFSI and i am able to retrieve all the fields but i have two 71's in LIPS. so i am gettng the values for the first 71 and i am not getting the values of second 71.

How to get the values of Second 71.

Regards,

Sudhir

Re: Select Query

Former Member — Tue, 20 May 2008 13:54:13 GMT

pass the POSNR als into the LIPS table.....

can you show the code for the select

then some one can help

Re: Select Query

Former Member — Tue, 20 May 2008 13:58:23 GMT

Hi,

Are you retreiving the data from lips into a internal table ?

if yes then it should get all the lips records for order 71.

If not then you need to pass the posnr also.

regards,

Advait

Re: Select Query

Former Member — Tue, 20 May 2008 14:04:19 GMT

Hi Sudhir,

use the following code.

data:begin of itab occurs o,

MATNR type matnr,

LFIMG type lfimg,

VRKME type vrkme,

ARKTX type arktx,

end of itab.

select lips_{matnr lips}lfimg lips_{vrkme lips}arktx into table itab

from lips inner join vfsi

on LIPS_{VBELN = VFSI}VBELN.

check the table itab.you will get all the entries.

reward points if helpful.