topic Re: Track changes in Database Entries in Application Development and Automation Discussions

Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 07:55:06 GMT

Hi All,

How am I going to track all the changes in the data for a custom table?

Thanks,

Jim

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 07:57:23 GMT

Hi,

Tables CDHDR and CDPOS stores all the changes related to a field in all the tables. check in them.

reward if useful

regards,

Anji

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 07:59:35 GMT

Hi Jim,

Transaction SCU3 tracks changes in the data for standard or custom objects. For that, that object should be logged.

How to log a table for changes:

1) Go to SE11

2) Go to the technical settings of the table ( Menu item GoTO->Technical settings)

3) Set the checkbox 'Log Data changes'

Regards,

Vishnu Priya

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 08:01:02 GMT

Hi Anji,

But how will I make the changes appear on CDHDR and CDPOS?

Thanks,

Jim

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 08:18:09 GMT

Hi Vishnu,

I try this one but it didn't work. Can you explain it more?

Thanks,

Jim

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 08:20:59 GMT

At the data element level for the fields in the table, you have to check the Change Document Checkbox.

Regards,

Ravi

Re: Track changes in Database Entries

Former Member — Fri, 23 Mar 2007 08:33:45 GMT

Hi Jim,

Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged. So, please check if that parameter is set or not. And also as suggested by Ravi, at data element level for the fields, check the option, 'Change Document'.

The existing logs can be displayed with Transaction Table history (SCU3).

Regards,

Vishnu Priya

Re: Track changes in Database Entries

Juwin — Sun, 25 Mar 2007 01:07:20 GMT

If the "Log data changes" is checked for the table, you want to check the data changes, then try transaction AUT10.

Re: Track changes in Database Entries

Former Member — Tue, 27 Mar 2007 04:41:43 GMT

Hi Vishnu,

How can I check on this "Logging only takes place if parameter rec/client in the system profile is set correctly"? I've already checked the 'Changed Document' at the data element and at the technical settings of the table. But when i change an existing entry in the table, it is still not reflecting in CDHDR the changes in the table.

Jim

Re: Track changes in Database Entries

Juwin — Tue, 27 Mar 2007 20:29:39 GMT

Goto transaction RZ10. Do an F4 on the profile. You should get an profile name which starts with your system ID. For example, if you system ID is DV1 and the message server name is abcd1, then the profile name could be DV1_DVEBMGS00_ABCD1. Now, select extended maintenance radio button and click display. It will show you the list of parameters set on the system. Now you may find for rec/client.

Message was edited by:

Juwin Thomas