Skip to Content
0
Former Member
Sep 20, 2011 at 08:19 PM

WLK1 time stamp field

215 Views

Hello developers,

I am a functional consultant and wanted to know how difficult it is to do the following and what is the procedure. I want to know this for my understanding.

I have a requirement to extract deltas frequently from WLK1 table ( IS- Retail).

In WLK1 i do not have the time stamp field, I just have a last change date.

I have two ideas- Please let me know which one would be better in terms of simplicity and performance.

1) I want to add a time stamp field to WLK1 by telling my developer to enhance the table and considering all the programs associated with the table when the table is updated. in this way I will have a reference time stamp field directly and i can extract the deltas.

2) without any development, I can consider the change document tables- CDHDR, CDPOS for the changes(for object class) and based on that i can define the extract logic of deltas. The problem i see with this method is CDHDR is taking lot of time to get the records with in a time frame, so it will certainly affect the performance of the extract program.

My inclination is towards option 1, but I am not sure, how big of a task is that and what is the procedure that is normally adopted.

Any advice would be appreciated <removed by moderator>.

Thanks & Regards,

Edited by: Thomas Zloch on Sep 20, 2011 11:59 PM