Track changes in Database Entries

[Former Member]

Hi All,

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

Thanks,

Jim

[Former Member]

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

[Former Member]

Hi Anji,

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

Thanks,

Jim

[Former Member]

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

[Former Member]

Hi Vishnu,

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

Thanks,

Jim

[Former Member]

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

Regards,

Ravi

[Former Member]

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

[Former Member]

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

[Juwin]

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 <b>DV1</b> and the message server name is <b>abcd1</b>, then the profile name could be <b>DV1_DVEBMGS00_ABCD1</b>. Now, select <b>extended maintenance</b> 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

[Juwin]

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