topic END SELECT in Application Development and Automation Discussions

END SELECT

Former Member — Thu, 19 Jul 2007 04:48:24 GMT

Hi,

when after SELECT clause ENDSELECT is used?

Re: END SELECT

former_member189059 — Thu, 19 Jul 2007 04:50:42 GMT

ENDSELECT is used when the selection involves more than one row and the output is into a single structure

eg:

select * from mara into corresponding fields of mara_wa.

append mara_wa to it_mara.

endselect.

cases where endselect is not used would be where you enter data directly into the table such as

select * from mara into corresponding fields of <b>table</b> it_mara.

or selecting a single record

select <b>single </b>* from mara into corresponding fields of mara_wa.

or selecting a count

select count(*) from mara into i_number.

Re: END SELECT

Former Member — Thu, 19 Jul 2007 04:51:05 GMT

HI,

in case of 1)select single ..... 2)select.......into [corresponding-fields of] table itab.

we should not use endselect.

in all other cases we have to use endselect.

rgds,

bharat.

Re: END SELECT

Former Member — Thu, 19 Jul 2007 04:52:08 GMT

Hi Debarshi..

If you are using select statement you need to use either one of the following statement..

1. select..... into tablename

2. select.... endselect

Thanks

Gowrishankar

Re: END SELECT

Former Member — Thu, 19 Jul 2007 04:52:51 GMT

hi,

endselect statements has to be used when u write select statements for retieving data from database.but if u use a syntax like below

select lifnr land1 name1 ort01 sortl from lfa1

UP TO 50 ROWS into corresponding FIELDS OF TABLE itab.

there is no need of using endselect.

ie..if u use select single * or select * from <table> into table <itab>

there is no need of using endselect.otherwise u have to use it.

Prajith

Re: END SELECT

Former Member — Thu, 19 Jul 2007 04:52:59 GMT

Hi,

A SELECT command for which the INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab is inserted into an internal table, must be followed by ENDSELECT .

For all other SELECT commands, ENDSELECT must be used unless a single line above the addition SINGLE is read after SELECT and unless the columns of the result set are statically specified and contain only aggregate functions without the specification of the addition GROUP BY.

Regards,

Himanshu

Re: END SELECT

Former Member — Thu, 19 Jul 2007 04:53:06 GMT

ENDSELECT.

Effect

The ENDSELECT statement closes a loop started with SELECT.

A SELECT command for which the INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab is inserted into an internal table, must be followed by ENDSELECT if the addition PACKAGE SIZE is used.

regards

dinesh