10-10-2007 8:10 AM
For a database table, <b>Change history has to be enabled to track who changed what entry to what value.</b>
Can anyone let me know how to go about it?
A step by step procedure (code) would be preferrable.
Thanks in advance.
10-10-2007 8:27 AM
Hi Alka,
if it is a small (customizing) table, ´just switch on table logging for the table in dictionary, SE11, technical settings, Log data changes.
This is only advisable for small tables which are changed from time to time, not on a regular base.
If this is not the case, the way is more complex.
Please spend 5 to 10 minutes to read my recent thread:
Just one more hint: It is better to write single change documents for every changed line because trhen you have unique change objects if you want to retrieve the changes. Because the processing takes it's time, all database updates together with change doument handling should be done in background.
Conclusion: For me it was much easier than expected.
Regards,
Clemens
10-10-2007 8:33 AM
in se11, go to technical settings and click on "log data changes". u can enable.
for standard tables, u need basis help for access key.
u can see the change history in the transaction scu3.