Dear experts,
I have a table having the data mentioned below
and the field in the table NUM_OF_DAYS is having data
15
30
45
but it actually means a range i.e.
0 to 15
16 to 30
31 to 45
46 to 50
now in my enhancement I am getting a variable value which can be any number that can fall between the above mentioned range. i.e.
var can be.. VAR = 14 or VAR = 36
now in my case if VAR will fall between 0 to 15 then first record should be fetched in my internal table
and if VAR falls between 16 to 30 then first two records should be fetched into my internal table
and if VAR falls between 31 to 45 then first three records should be fetched into my internal table and so on.
Kindly help me how to fetch such tricky record