topic Re: Regarding RESB table changes in Application Development and Automation Discussions

Regarding RESB table changes

Former Member — Thu, 12 Jul 2007 06:08:01 GMT

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?

Re: Regarding RESB table changes

Former Member — Fri, 13 Jul 2007 05:43:00 GMT

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.

Re: Regarding RESB table changes

Former Member — Fri, 07 Sep 2007 17:41:01 GMT

Hello Cynthia,

Did you find the trigger ??

thanks

Re: Regarding RESB table changes

Former Member — Mon, 10 Sep 2007 04:48:16 GMT

yes.. solved the problem