topic Re: diffrence between select endselect and select. in Application Development and Automation Discussions

diffrence between select endselect and select.

Former Member — Mon, 12 Nov 2012 17:50:10 GMT

Hi all,

Could you tell me please that what is the difference between select and endselect.

1- select a b c from table xy into itab where a = 1.

2 select a b c from table xy into itab where a = 2.

endselect.

Moderator message: FAQ, please search for information before posting.

Message was edited by: Thomas Zloch

Re: diffrence between select endselect and select.

former_member206439 — Mon, 12 Nov 2012 18:26:27 GMT

Select

Endselect

it work's like a Loop and Endloop.

Where as Select will retrive all the values at once.

Re: diffrence between select endselect and select.

alex_campbell — Mon, 12 Nov 2012 19:32:17 GMT

As Naresh stated, SELECT ... ENDSELECT works like LOOP ... ENDLOOP, whereas SELECT retrieves all values at once. There are some important considerations though.

- In your examples, statement 1 will not compile. When using the Select statement without EndSelect, you need to either specify SELECT SINGLE ... INTO ... (meaning that only one record from the database will be returned, and it will be populated into the structure you provide) or, you need to specify SELECT ... INTO TABLE ... (meaning that all records are returned, and populated into the internal table you provide.) You can also use APPENDING TABLE instead of INTO TABLE if you don't want to overwrite the internal table.

- SELECT ... ENDSELECT uses a database cursor to interate through the rows that match your query. Because of this, you cannot use the COMMIT WORK or ROLLBACK WORK statements, because they would close the database cursor.

In general I think using the SELECT without the ENDSELECT is the better practice. I never use SELECT ... ENDSELECT in my code.

Re: diffrence between select endselect and select.

Former Member — Tue, 13 Nov 2012 03:54:02 GMT

Select * into ITAB is faster. Select Endselect is slower.

Also, Select Endselect locks table for the entire processing time. Hence, it is better to use Select Into ITAB.

You can go to SE30 -> Utilities -> Tips and Tricks for more details.