dynamic table select
i am creating bdocs and send them to CRM. To select the Data, i was trying to use the CURSOR-Statement. Well i figured out, that curser gets reseted in the process and so i cant use it.
Now im looking for a dynamic possibility to select data from tables similar to the cursor.
is there a fm i can give a tablename and blocksize so it is returning me small blocks of data each call? (without using intern cursor statement ). the data tables can also be very large ( > 20 mio entries) so FMs like RFC_READ_TABLE have too bad performance.
If there is no FM / Method like this. how to do a dynamic select, with dynamic table and where clause so i can get small blocks of any table, sending them and then selecting the next block. Like saving the last row's key fields and putting them into the where clause of next select in loop. so i get only the new values.
can you help me out with this?
I hoping there are some FMs... because im looking for an easy solution