topic select endselect. in Application Development and Automation Discussions

select endselect.

Former Member — Tue, 21 Aug 2007 06:13:06 GMT

can we use select endselect syntax in newer versions

FredericGirod — Tue, 21 Aug 2007 06:17:52 GMT

You can, but if you read any performance documentation, you will read that it's the worst code you could made.

Fred

Former Member — Tue, 21 Aug 2007 06:19:30 GMT

Hi Pavan,

It is not suggestable to use select endselect. Instead we have to use select into table and then loop on the itab afterwards.

Former Member — Tue, 21 Aug 2007 06:21:10 GMT

HI Pavan

chk this one

SELECT * FROM T006 INTO X006.

APPEND X006.

ENDSELECT

instead of above one u can use this one

SELECT * FROM T006 INTO TABLE X006.

reward points to all helpful answers

kiran.M

Former Member — Tue, 21 Aug 2007 06:21:51 GMT

HI pavan,

Yes you can use SELECT -ENDSELECT in newer version.

Regards

Sourabh Verma

Former Member — Tue, 21 Aug 2007 06:31:57 GMT

hi pavan

ya we can use select endselect in newer versions too...unless and until you use

internal table.

for eg...

select single * from table into table itab where <condition>.

if not use end select like

select single * from table where <condition>.

reward if useful...

cheers

asha

end select.