topic Re: Problem with select query in Application Development and Automation Discussions

Problem with select query

Former Member — Mon, 14 May 2007 05:04:43 GMT

SELECT kunnr vgbel posnr vbeln

matnr lgort kdmat vrkme kunag lfimg erdat vstel

INTO TABLE it_likp_lips

FROM zvsvs01

WHERE kunnr IN s_kunnr

AND vbeln IN s_vbeln

AND vstel IN s_vstel

I have written a select query like this,the problem is I want to comapre the selection screen fields with table SHP_IDX_GDSI fields Instead of View(zvsvs01),How can i do it.

Re: Problem with select query

Former Member — Mon, 14 May 2007 05:08:53 GMT

You can join the View and the table SHP_IDX_GDSI

usiong the field VBELn and can write the code.

SELECT a_{kunnr a}vgbel a_{posnr a}vbeln

a_{matnr a}lgort a_{kdmat a}vrkme a_{kunag a}lfimg a_{erdat a}vstel

INTO TABLE it_likp_lips

FROM zvsvs01 as a join SHP_IDX_GDSI as b on

a_{vbeln = b}vbeln

WHERE b~kunnr IN s_kunnr

AND b~vbeln IN s_vbeln

AND b~vstel IN s_vstel.

Reward points if useful

Regards

Anji

Re: Problem with select query

Former Member — Mon, 14 May 2007 05:10:23 GMT

use for all entries

SELECT kunnr vgbel posnr vbeln

matnr lgort kdmat vrkme kunag lfimg erdat vstel

INTO TABLE it_likp_lips1

FROM SHP_IDX_GDSI

WHERE kunnr IN s_kunnr

AND vbeln IN s_vbeln

AND vstel IN s_vstel.

if it_likp_lips1[] is not initial.

SELECT kunnr vgbel posnr vbeln

matnr lgort kdmat vrkme kunag lfimg erdat vstel

INTO TABLE it_likp_lips

FROM zvsvs01

for all entries in it_likp_lips1

WHERE kunnr eq it_likp_lips1-kunnr

AND vbeln eq it_likp_lips1-vbeln

AND vstel eq it_likp_lips1-vstel.

endif.

if helpful, reward

Sathish. R

Re: Problem with select query

Former Member — Mon, 14 May 2007 05:10:38 GMT

Your question is not very clear..Upto my understanding you can do this while declaring select-option...I mean while declaring just put,

select-option: s_kunnr for SHP_IDX_GDSI-kunnr.

Like that for other fields also...Now proceed with your same select query...

Reward all helpfull answers..........

Re: Problem with select query

Former Member — Mon, 14 May 2007 05:13:09 GMT

Hi Prasad,

write a select query to Join table and view .

SELECT a_{kunnr a}vgbel a_{posnr a}vbeln

a_{matnr a}lgort a_{kdmat a}vrkme a_{kunag a}lfimg a_{erdat a}vstel

b~vbeln

INTO TABLE it_likp_lips

FROM zvsvs01 as a inner join SHP_IDX_GDSI as b

on a_{vbeln = b}vbeln

WHERE b~kunnr IN s_kunnr

AND b~vbeln IN s_vbeln

AND b~vstel IN s_vstel.

Regards,

Hemant