Change log for work center data

[Former Member]

Hi,

I was looking for the table where the change header document for the work center is stored.I was able to find a transation CR10 which shows the changes and also the database table CDHRD.

When I am trying to view the changes that were made to the work center I find that the data does not exist in the tables.

I was curious to know this as for some transaction the data is being logged in their respective change table but not for Work Center changes.

Can anyone tell me as to why this is happening.

What I think is that some changes to the configuration are required in order to log the changes in the database.

Kindly help.

Regards

Varun

[Former Member]

Hi,

I was looking for the table where the change header document for the work center is stored.I was able to find a transation CR10 which shows the changes and also the database table CDHRD.

When I am trying to view the changes that were made to the work center I find that the data does not exist in the tables.

I was curious to know this as for some transaction the data is being logged in their respective change table but not for Work Center changes.

Can anyone tell me as to why this is happening.

What I think is that some changes to the configuration are required in order to log the changes in the database.

Kindly help.

Regards

Varun

[Former Member]

Hello,

changedocuments are generally stored in the tables CDHDR and CDPOS. The Objectclass ( key in CDHDR) for workcenter is 'RESSOURCE'.

You could read a entire changedocument with the function 'CHANGEDOCUMENT_READ'.

Regards

Wolfgang

[Former Member]

Hi Wolfgang,

Thanks for the information.

However i have another question.

The change table will have data only when it is activated in the configuration menu.

However is there any other way by which we can capture the previous data for the work center e.g. the changed by field. I want that the names of the users who has changed the wrok center currently and the name of the person who previously made changes to it.

See if you can help me on that.

Regards

Varun

[Former Member]

Hello Varun,

I think you need the log information when the 'Log Data Changes' in the 'Technical Settings' w.r.t a Transparent Table. You will be able to see these log details by Tx. SCU3.

However, for tables CRHD, CRTX this 'log Data changes indicator' is not checked.

Hope this helps you.

Best Regards, Murugesh AS

[Former Member]

Varun - have you tried going to the transaction that maintains work centers and display change documents there?

I think you have to have "change documents" turned on for a specific object (cost center, work center, etc). If it's not turned on there, if you press F1 in the "display change documents" screen, it should tell you how to turn it on.

Rob

[Former Member]

OK - I figured out that you can't show change documents from the work order change screen (CR02). But the documentation for CR10 says that change documents are configurable for work centers. So, my advice is to turn this over to a functional person.

Rob

[Former Member]

Hi all,

The issue was resolved. All that I had to do was to ask the basis to activate the change log for work center changes and after that the table CDHDR is getting updated with all the details.

Thanks for your help.

Varun

[Former Member]

Hi Varun,

I have a similar requirnment....

I want capture changes made in Tcode CR02 in HR assignments.

I want to know which tables are updated when there is changes made ,if we add a person or delete a person in HR assignment for work centre.

Thanks in Advance

Vijju