topic Re: select in Application Development and Automation Discussions

select

Former Member — Wed, 15 Nov 2006 15:50:25 GMT

when we will use

select

end select

Re: select

Former Member — Wed, 15 Nov 2006 15:57:28 GMT

Hi,

I think generally if you don't have the full primary value to use SELECT SINGLE..You will be SELECT UP TO 1 ROWS with an ENDSELECT..Can be used for existence check..

Example..

SELECT MATNR UP TO 1 ROWS

INTO V_MATNR

FROM VBAP

WHERE VBELN = '1234567'.

ENDSELECT.

Thanks,

Naren

Re: select

Former Member — Wed, 15 Nov 2006 19:39:51 GMT

when you want process some thing( calculating or writing to list ) while fetching the date ,

Regards

Siva

Re: select

Former Member — Wed, 15 Nov 2006 19:43:14 GMT

You should use:

SELECT... INTO TABLE it_table

LOOP at it_table

ENDLOOP.

instead !!!

Select...Endselect creates a loop within the select statement BUT... it performs multiple DB reads to achieve it.

The INTO TABLE above performs one and only one DB read... which is much faster and efficient for the App server and DB server.

Re: select

former_member69765 — Thu, 16 Nov 2006 04:02:54 GMT

SELECT * from <Table>

All Processing Logic

END SELECT

SELECT - END SELECT works like a loop. A single record is read and the processing is done.

This causes multiple hits on Data base server... which increases your execution time.

Instead.. it is good programming practice to select all the required data into an internal table and then loop on the internal table. this reduces the run time to a great extent.

the conclusion is that in general you must avaoid using SELECT ENDSELECT.

Re: select

Former Member — Thu, 16 Nov 2006 13:31:46 GMT

Ratna,

Please reward points accordingly and close the thread.

Re: select

Former Member — Wed, 22 Nov 2006 06:06:00 GMT

i would suggest never to use select-end select .

u shopuld always prefer

select (field-list) into table (conditions) .

u can always avoid using select-end select .

also i would tell not to use nested select statements .

a better idea would be to use 'for all entries ' option of select statement .

if helpful plz reward points

Re: select

Former Member — Fri, 01 Dec 2006 07:21:28 GMT

Hi,

SELECT ENDSELECT is usually used when we need to select a range of values. Values which are just needed from the IT are selected using this.

SELECT is not concluded by ENDSELECT :

if it is a SELECT SINGLE command,

if only aggregate functions appear in the SELECT clause and there is no GROUP BY clause, or

if the INTO clause INTO TABLE itab or APPENDING TABLE itab does not include the addition PACKAGE SIZE.

Thanks and regards,

Priyanka.