Problem with ENDSELECT

[Former Member]

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.

[former_member188827]

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

[Former Member]

Hi,

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

rgds,

bharat.

[dhruv_shah3]

Hi,

For First its perfectly ok.

For second you may try out and see...

HTH

Regards,

Dhruv Shah

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[JozsefSzikszai]

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

ec