topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Sun, 24 Sep 2006 16:51:10 GMT

Hello friends,

I have to select data from data base based on a where condition from an internal table.

In It_BSID the field Vbeln is sometimes blank. So i have to select data into IT_KNVP where IT_BSID-vbeln is blank.

Below is the code that i ahve used and has errors.

SELECT kunnr

parvw

kunn2

INTO TABLE it_knvp

FROM knvp

FOR ALL ENTRIES IN it_bsid

WHERE it_bsid-vbeln is initial

and kunn2 EQ it_bsid-kunnr

and parvw EQ 'RE'.

Any suggestions.

Shejal Shetty.

Re: Select statement

Former Member — Sun, 24 Sep 2006 16:58:12 GMT

What do you need to extract?

You can't use FOR ALL ENTRIES option in this situation

You have to split the record with VBELN and without VBELN

LOOP AT IT_BSID WHERE VBELN = ' '.

APPEND IT_BSID TO IT_BSID_2.

ENDLOOP.

SELECT kunnr

parvw

kunn2

INTO TABLE it_knvp

FROM knvp

FOR ALL ENTRIES IN it_bsid_2

WHERE kunn2 EQ it_bsid-kunnr

and parvw EQ 'RE'.

Max

Re: Select statement

Former Member — Sun, 24 Sep 2006 17:00:53 GMT

Thanks MAX,

So I have to use another Internal table. IS there no way that i can do this without using another internal table.

However i dont want to loop it_bsid.

Shejal.

Re: Select statement

Former Member — Sun, 24 Sep 2006 17:03:29 GMT

Can i do it in this way,

LOOP AT IT_BSID WHERE VBELN = ' '.

SELECT kunnr

parvw

kunn2

INTO it_knvp

FROM knvp

WHERE kunn2 EQ it_bsid-kunnr

and parvw EQ 'RE'.

endselect.

endloop.

Shejal Shetty.

Re: Select statement

suresh_datti — Sun, 24 Sep 2006 17:05:31 GMT

Max is right.. you don't have an option but loop at it_bsid once & use another itab with the FOR ALL ENTRIES option..

delete it_bsid where vbeln is initial

and parvw EQ 'RE'.

and then use yor select

~Suresh

Re: Select statement

Former Member — Sun, 24 Sep 2006 17:07:31 GMT

Yes of course, but in this way u don't use FOR ALL ENTRIES option:

LOOP AT IT_BSID WHERE VBELN = ' '.

SELECT kunnr

parvw

kunn2

INTO it_knvp

FROM knvp

WHERE kunn2 EQ it_bsid-kunnr

and parvw EQ 'RE'.

<b>APPEND IT_KNVP.</b>

endselect.

endloop.

LOOP AT IT_BSID WHERE VBELN = ' '.

SELECT kunnr

parvw

kunn2

<b>APPENDING TABLE IT_KNVP</b>

FROM knvp

WHERE kunn2 EQ it_bsid-kunnr

and parvw EQ 'RE'.

endloop.

Max

Re: Select statement

Former Member — Sun, 24 Sep 2006 17:07:43 GMT

Hi,

writing a select statement in a loop will cause a performance issue.

You can use the code suggested by MAX.

Regards,

Azaz Ali.

Re: Select statement

Former Member — Sun, 24 Sep 2006 17:07:45 GMT

Thanks for all youe help guys,

Shejal Shetty...