topic Re: Problem with ENDSELECT in Application Development and Automation Discussions

Problem with ENDSELECT

Former Member — Mon, 10 Mar 2008 10:07:22 GMT

Hi,

Is it possible not to put an Endselect to the below 2 examples. Thanks a lot!

1. SELECT matnr

werks

lgort

labst

FROM mard INTO i_mard

FOR ALL ENTRIES IN i_stpo

WHERE matnr = i_stpo-idnrk

AND werks = i_stpo-pswrk

AND lgort = i_stpo-lgort.

2. SELECT stko~bmeng

stpo~idnrk

stpo~menge

stpo~lgort

FROM stko INNER JOIN stpo

ON stko_{stlnr = stpo}stlnr

INTO i_stpo

WHERE stko~stlnr = v_stlnr

AND stpo~pswrk = p_werks

AND stpo~stlnr = c_1.

Re: Problem with ENDSELECT

former_member188827 — Mon, 10 Mar 2008 10:10:06 GMT

in 1) u cant write endselect but for 2) u hav to

Re: Problem with ENDSELECT

Former Member — Mon, 10 Mar 2008 10:10:58 GMT

Hi,

if u use INTO CORREESPONDING FIELDS OF TABLE itab u can avoid the endselect.

rgds,

bharat.

Re: Problem with ENDSELECT

dhruv_shah3 — Mon, 10 Mar 2008 10:12:56 GMT

Hi,

For First its perfectly ok.

For second you may try out and see...

HTH

Regards,

Dhruv Shah

Re: Problem with ENDSELECT

Former Member — Mon, 10 Mar 2008 10:14:05 GMT

Hi,

In the first statement there is no need for an ENDSELECT.

In the second one you need to have ENDSELECT. You can avoid this , if you put SELECT SINGLE, but this will fetch only one record for you.

Just check which one is appropriate for your requirement.

Reward if helpful.

Regards.

Re: Problem with ENDSELECT

Former Member — Mon, 10 Mar 2008 10:14:15 GMT

Hi,

IF NOT i_stpo[] IS INITIAL.

SELECT matnr

werks

lgort

labst

FROM mard INTO TABLE i_mard

FOR ALL ENTRIES IN i_stpo

WHERE matnr = i_stpo-idnrk

AND werks = i_stpo-pswrk

AND lgort = i_stpo-lgort.

2. SELECT stko~bmeng

stpo~idnrk

stpo~menge

stpo~lgort

FROM stko INNER JOIN stpo

ON stko_{stlnr = stpo}stlnr

INTO *TABLE * i_stpo

WHERE stko~stlnr = v_stlnr

AND stpo~pswrk = p_werks

AND stpo~stlnr = c_1.

ENDIF.

When you are using FOR ALL ENTRIES it is compulsory to check initial or not

IF NOT i_stpo[] IS INITIAL.

Re: Problem with ENDSELECT

Former Member — Mon, 10 Mar 2008 10:14:43 GMT

Hi Mark

In first its not possible to write endselect

when we use

select

endselect.

It means we are executing a loop which retrieves records one by one but in (1) you are using caluse "for all entries" which is used to avoid looping. So here all the records come from database at a single time.

In second you can use endselect but for performance point of view no one recommend to use endselect because it is costlier as it retrives all records one by one from database.

regards

Aditya

Re: Problem with ENDSELECT

JozsefSzikszai — Mon, 10 Mar 2008 10:24:53 GMT

hi Mark,

in both cases, instead of INTO itab you have to use like: INTO TABLE itab. Than you don't need ENDSELECT. (INTO puts the selected lines one by one into a structure, INTO TABLE puts the selected lines into an internal table in one go.)

hope this helps