How to trace the table change history by a user

[Former Member]

Hi Gurus ,

In one of our cusotmizing table user deleted few data .

Is there any way to find out the user details for the same .

Below the steps i followed but no luck .

1. scu3 checked no luckj log for this peroid .

2. DBTABLOG checked in this table also .

Kindly  please help me .

Thanks,

Pradeep .

[Former Member · Accepted solution]

Hi Gurus ,

I am not able to find out this parameter Rec/Client in RZ10 .

Also is there any way to find out the trace .

Thanks for your support .

Thanks,

Pradeep.

[Former Member · Accepted solution]

Hi Pradeep.

Here you have the link for the Table Change Logging:

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/4d/b6d15036311dcee10000000a42189c/content.htm?frame...

Two important points here:

- It only applies for new changes, so if you haven't activated yet it will be useless.

- It will activate the logging of all the customizing tables chenges done in the client that you set in the parameter. so the number can be huge. t can impact in performance. In SCU3 you can evaluate the logs and see the list of logged tables.

Thanks

[former_member185447 · Accepted solution]

In RZ10 select the profile, go to extended maintanence, click on new paramter, go to the list and try to find Rec/ Client as its a default parameter provided by SAP and you will surely find it out.

If you still don't find it let me know. Also, Please read the link provided by Jose Manuel to get a understanding of table log concept.

Regards

Deepak M

[Former Member · Accepted solution]

Hi Guru's ,

Thanks for all your valuable info.

Thanks,

Pradeep.

[former_member45419]

Hi Pradeep,

Pls refer this link

http://help.sap.com/saphelp_nw04s/helpdata/en/1f/0be73ac6e7ec28e10000000a114084/frameset.htm

http://www.scribd.com/word/removal/11546901?query=how

http://scn.sap.com/message/14394796

Regards

Nayeem

[naveegarg]

Hi Pradeep,

If you ahve not activated table logging then you cannot see the changes from SCU3, however if you know the user name then probably you can start the trace of activities from SM21.

Regards

Naveen Garg

[Former Member]

Hi,

If you don't have activated the table audit neather the security audit, you can try in the Shared Cursor Cache (Oracle) of DB02. Filtering by the table, may be you find the responsible.

thanks

[former_member185447]

Hello Pradeep,

Please let me know what values are maintained for these settings.

1. Parameter Rec/Client in RZ10
2. Log data changes is checked or not for the customized table in SE13

Regards

Deepak M

[Reagan]

Hello

You need to enable logging for the table changes.

Check this link and notes

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/c7/69bcd2f36611d3a6510000e835363f/content.htm

1916  - Logging table changes in R/3

112388  - Tables are subject to logging

Regards

RB

[Former Member]

check with sm20 or stad