06-28-2005 2:19 PM
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
06-28-2005 4:18 PM
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
06-28-2005 4:18 PM
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
06-28-2005 4:37 PM
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
06-28-2005 4:51 PM
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
06-28-2005 7:18 PM
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
06-28-2005 8:30 PM
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
06-29-2005 11:21 AM
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
10-23-2005 11:40 AM
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