Log to track Z table changes

[Former Member]

Hi All,

We have to develop a program to see the log of Custom table changes.THis Custom table will undergo changes by various users, so we want to know who made the changes , when and what.

can you please explain how can I develop a program for such requirement?

Tx

Saurabh

[Former Member]

Hi All,

We have to develop a program to see the log of Custom table changes.THis Custom table will undergo changes by various users, so we want to know who made the changes , when and what.

can you please explain how can I develop a program for such requirement?

Tx

Saurabh

[Sandeep_Panghal]

Best way to achive this will be create a maintenance veiw for this table and record the changes in transport request.

[Former Member]

Hi

In your custom table, goto technical settings. You will find an option as LOG DATA CHANGES. This would have the log for various users who had changed data and so on.

Regards

Vinodh

This would actually store the log in the log table.

Edited by: Vinodh_AN on Nov 1, 2010 11:49 AM

[Former Member]

Hi Saurabh Joshi,

If I have understood correctly, you want to record the changes of entries in a Z table? if it is then check the check box in Technical Settings-->Log data changes. Then all the changes will get recorded and you can read them in SCU3.

Thanks & Regards,

Faheem.

[nabheetscn]

To add to above mentioned reply changes for only those fields will be recorded for which we have change document field checkbox checked.

Nabheet

[ThomasZloch]

The "log data changes" option (table DBTABLOG) is independent of this checkbox in the data element. The checkbox toggles writing of change documents in CDHDR/CDPOS.

Thomas

[SuhaSaha]

To add to what has already being mentioned in the replies, to log the changes to the table via "Log Data Changes" option you should turn "ON" the profile param "rec/client".

Without this the table data changes won't get recorded!

[Former Member]

Hi Saurabh,

you can setup the change documents for your Z table.

Then all the changes will be logged.

Please check the URL below to get to know how to use change documents.

[http://help.sap.com/erp2005_ehp_04/helpdata/EN/2a/fa015b493111d182b70000e829fbfe/frameset.htm|http://help.sap.com/erp2005_ehp_04/helpdata/EN/2a/fa015b493111d182b70000e829fbfe/frameset.htm]

These sections would be helpful to you:

[Creating change documents|http://help.sap.com/erp2005_ehp_04/helpdata/EN/2a/fa01d0493111d182b70000e829fbfe/content.htm]

[Read and format change documents|http://help.sap.com/erp2005_ehp_04/helpdata/EN/2a/fa01dd493111d182b70000e829fbfe/content.htm]

Cheers,

[Former Member]

This message was moderated.