Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Change log for work center data

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

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

7 REPLIES 7

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

0 Kudos

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

0 Kudos

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
0 Kudos

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
0 Kudos

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

0 Kudos

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

0 Kudos

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