‎2007 Jul 12 7:08 AM
Hi..
I m working on one interface, in which i hav RESB (reservation table) extraction process. For the initial run of this interface all the records should be downloaded .But on subsequent execution i need only the changed records. The problem is there is no means for me to keep track of the changes in RESB, as these are not getting reflected in change tables CDHDR and CDPOS. Also there is no CREATED/CHANGED date fields in RESB table. Does anyone know any alternative for fetching the changed or newly records from RESB table based on date?
‎2007 Jul 13 6:43 AM
Hello,
By looking into the table RESB record it seems difficult to determine the newly created or changed record on time stamp.
Here I am sharing my opinion.
You can implement a bussiness logic to determine for your requirement.
1. First determine all the standard SAP transactions that can change the records in this table. I
2. Look for a BADI/user exits triggered on data save on those t-codes.
3. Create your own table(I mean custom table) with the key fields of RESB + a time stamp field.
3. when BADI/USER-EXITS triggered, save the records of RESB (newly created/changed) in your custom table. Now this table should serve your purpose. Instead of creating new records in your custom table for each changed records in RESB just update the custom table with the timestamp.
Hope this way you can reach your goal. This usually is one of the practice that followed in such scenario.
‎2007 Sep 07 6:41 PM
‎2007 Sep 10 5:48 AM