topic Re: Select - endselect in Application Development and Automation Discussions

Select - endselect

Former Member — Tue, 14 Oct 2008 17:15:58 GMT

I would like to create select -endselect construction and print every processed record

select HASH

from UPS_HASH

INTO table t2.

write t2-hash.

Endselect.

But the system generates the following error :

For the statement Endselect , there is no open structure introduced by select.

Can somebody help me

Re: Select - endselect

Former Member — Tue, 14 Oct 2008 17:18:11 GMT

my advise is avoid select and endselect. select all records and loop the table and write.

Below is what you want.

select HASH
from UPS_HASH
INTO t2.       "remove table
*
write t2-hash.
*
Endselect.

Re: Select - endselect

Former Member — Tue, 14 Oct 2008 17:19:54 GMT

select HASH

from UPS_HASH

INTO table t2.

write t2-hash.

Endselect.

remove your table statement from above, it is causing it to become an array fetch which doesnt need End Select.

On another note, array fetch is much better. if you use that, do a loop on your table T2, and write t2-hash within the loop.

Re: Select - endselect

BH2408 — Tue, 14 Oct 2008 17:20:07 GMT

Hi ,

i think there should be into table only into....

Check it out...

Regards,

bharani

Re: Select - endselect

Former Member — Tue, 14 Oct 2008 17:20:16 GMT

try something like this...

data: begin of ti_ups_hash occurs 0,
            hash like ups_hash-hash,
        end of ti_ups_hash.

select HASH
into corresponding fields of table ti_ups_hash
from UPS_HASH.

loop at ti_ups_hash.
write ti_ups_hash-hash

endloop.

Re: Select - endselect

Former Member — Tue, 14 Oct 2008 18:19:59 GMT

Hi Comandante,

You have not written the correct syntax. Please see the below correct syntax Table should not be used there.


select HASH
from UPS_HASH
INTO  t2.
*
write t2-hash.
*
Endselect.

Instead of this why dont you try with the internal table like below.


select HASH
from UPS_HASH
INTO table t2.
loop at t2.
write t2-hash.
  
endloop.

This will increase the performance aswell.

Thanks,

Chidanand