i have a problem of how to select records(for only one field)from DB table based on user's input on the selection screen,the detail is given below:
scenario 1: the spawn program will only select several key fields from VBREVK according to the user input. Every time select around x entries and kick off the batch job for these x entries. Then next x entries I think this could be done by retrieve first x entries and keep track of the largest document number. Next time when retrieving data from VBREVK, add this document number to the selection criteria to find next x entries
scenario 2: select by index number in the table. If only selecting say 4 million records then selecting the records at index 1 and index 4 million based on the criteria would return our range. i only want to select 1 record for low value and 1 record for high value rather than selecting a whole tables worth of data.
usually we often select records into a internal table and the range is whole, i donn't know how to implement this using index, can anybody help me? thanks in advance.