topic Re: Updating time - cdhdr table in Application Development and Automation Discussions

Updating time - cdhdr table

Former Member — Thu, 05 Sep 2013 11:34:02 GMT

Hello all,

I have a job which checks the cdhdr table with several objectsclass like anla, banf and einkbeleg. I'm trying to get all the modifications of the objects with those classes.

The situation is, I think, the table cdhdr is not updated online (when a change is done on any of the requested objects). I tryed to find something on SDN and Google but I don't see anything interesting.

So, here my question: has anybody any idea about the updating process of the cdhdr table? is it updated online (at the same time than the change is done)? is there any job which stars this process?

Thanks for all!,

Joaquín.

Re: Updating time - cdhdr table

Former Member — Thu, 05 Sep 2013 14:31:36 GMT

Hi,

I think this table is updated whenever something happens. controlled by settings in SCDO.

If you want to make something really specific I will advise you to use SWEC for customer specific event triggering and use a workflow as a receiver.

What is the functional requirement which prompted you to ask this question?

Kind regards, Rob Dielemans

Re: Updating time - cdhdr table

Former Member — Fri, 06 Sep 2013 07:34:28 GMT

Hi,

Thanks for your reply.

I have a big (a really big process) which checks the not real-costs reading many tables related with SP, PO, employee expenses and assets. This process read all the information and calculates the differences between the real cost and not real-costs sending the information (by PI) with the amount pending to pay to our employees, providers...

The new functionality includes to check the objects were changed the day before the one-day-process runs, so we try to look for only the SP, PO.... which had any change yesterday, this is why I read the cdhdr table.

I found an inconsistence between the big process and the one-day-process. One of the assets was processed properly by the big process but not by the one day process.

The day of the process was the 04/09, so (the program and) I checked the cdhdr table looking for changes on 03/09, but nothing was there, however on 05/09 I checked again the cdhdr table and the asset was there with the date of 03/09... this is why I asked for a possible delay on the updating time...

Kr,

Joaquín.

Re: Updating time - cdhdr table

Former Member — Fri, 06 Sep 2013 10:29:54 GMT

Hi Joaquín,

If there is an inconsistency then in all probability you shouldn't use it to narrow down on relative data. If the only way to really know what has happened in one day is to select all the data from the various tables then you should probably do that.
Unless someone has a better idea on this forum of course.

Kind regards, Rob Dielemans

Re: Updating time - cdhdr table

RaymondGiuseppi — Fri, 06 Sep 2013 11:18:40 GMT

Change document are executed like update of data in the "update task", this background task is triggered by the COMMIT of the original transaction. They are usually executed just after the update of main database (V2 after V1) after the lock release. You can find information at Updates in the SAP System (BC-CST-UP), The SAP Lock Concept and Update Techniques.

There can be some delay between end of V1 (the end of the WAIT options of COMMIT-WORK) and actual posting of change document (there is no urgency as those are not required by most application)

Regards,

Raymond