09-20-2011 9:19 PM
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
09-20-2011 9:29 PM
Hi
I think there is no need to enhance the table, you can directly check the changes done between yesterday and today.
like Current date minus 1 or some function module to get the previous date.
If you have a decent data update everyday then you can use it.
CDHDR and CDPOS will have impact on performance issue.
Please check with your ABAPER also.
Shiva
09-20-2011 9:29 PM
Hi
I think there is no need to enhance the table, you can directly check the changes done between yesterday and today.
like Current date minus 1 or some function module to get the previous date.
If you have a decent data update everyday then you can use it.
CDHDR and CDPOS will have impact on performance issue.
Please check with your ABAPER also.
Shiva
09-20-2011 9:59 PM
Thanks Shiva,
My requirement is to send delta extracts multiple times a day, so I think the current date - 1 logic would not work.
If at all I have to enhance the table, what is the volume of work I am looking at? is enhancing a table a very big task to add a field.
Appreciate your response.
Regards,
09-20-2011 10:03 PM
Hi
It will not be a big task, but the developer has to append the field to table and he has to find the user exit or BADI to generate the field and save it.
Overall it doesn't require a big effort
Shiva
09-20-2011 10:34 PM