Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

select endselect.

Former Member
0 Likes
634

can we use select endselect syntax in newer versions

5 REPLIES 5
Read only

FredericGirod
Active Contributor
0 Likes
614

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

Fred

Read only

Former Member
0 Likes
614

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.

Read only

Former Member
0 Likes
614

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

Read only

Former Member
0 Likes
614

HI pavan,

Yes you can use SELECT -ENDSELECT in newer version.

Regards

Sourabh Verma

Read only

Former Member
0 Likes
614

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.