Select 1000 rows each time program starts
I need to write a report that every time it is run by user it selects 1000 records from DB table, let's say BKPF.
|Run no.||First record no.||Last record no.|
What is the best way to achieve this? Should I store last selected record in Z db table and select next 1000 records with fields greater than that record?
//Edit: I need to select records like they had indexes, not some random 1000 records each time, but following 1000 records.
I'd be greatful for any help,