Skip to Content
0
Former Member
May 03, 2007 at 08:30 AM

select statement with package size

1868 Views

Hi,

is there any way where i can loop the package size within select statement, say for ex.

select * from tstc into table itab package size 1000.

write : sy-dbcnt.

loop into ipackage

do processing

endloop.

endselect.

the output will be 1000 2000 3000 .... 10000

here can i loop the above data in chunk of 1000 till the last record of table i.e. output first 1000 records than next 1000 and so on...

& this i want to complete in single select statement.please let me

is this possible on the ECC 6.0 system.

Thanks,

John.