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

Regarding RESB table changes

Former Member — Thu, 12 Jul 2007 06:03:52 GMT

Hi..

I m working on one interface, in which i hav RESB 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 04:55:41 GMT

Hi CS ,

U have to look at Transaction-->document changes , not the table changes , as u knw that RESB contains Purchase Data , so u have to look at that Tcodes .

Regards

Peram

Re: Regarding RESB table changes

Former Member — Fri, 13 Jul 2007 05:05:25 GMT

Hi Cynthia,

In the runtime we can check for the changes that are made in a table by using the mirror tables. there would be XRESB and YRESB tables in runtime which would hold the mirror images of the table contents before change and after change. so we have to perform a check of the fields from both the table at runtime. If there is a change perform the required action accordingly.

<b>

Reward points if this helps,</b>

Kiran