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.