topic Re: table entries change in Application Development and Automation Discussions

table entries change

Former Member — Mon, 02 Apr 2007 08:36:27 GMT

Hi,

how we will see who is the lastchanged in table entries.

Re: table entries change

Former Member — Mon, 02 Apr 2007 08:52:56 GMT

Hi Kumarraju,

Sorry, got your question a wrong way. The following is the information on table log:

You must start the SAP system with the <b>rec/client</b> parameter. This parameter specifies whether the SAP system logs changes to table data in all clients or only in specific clients. The parameter can have

the following values:

- rec/client = ALL logs all clients

- rec/client = 000 [,...] logs the specified clients

- rec/client = OFF turns logging off

In the technical settings (use transaction SE13), set the Log data changes flag for those tables that you want to have logged.

If both of these conditions are met, the database logs table changes in the <b>DBTABPRT</b> table.

Use the RSTBHIST report to obtain a list of those tables that are currently set to be logged.

Hope it helps.

Thanks & Regards,

Santosh

Message was edited by:

NAVABOTHU SANTOSH KUMAR

Re: table entries change

Former Member — Mon, 02 Apr 2007 11:55:52 GMT

Hi,

Changed documents in SUIM shows information relating to Users,Roles,Profiles,Authorizations only.

Regards

Re: table entries change

Former Member — Mon, 02 Apr 2007 12:31:37 GMT

Hi,

in order to see table changes you need to have the profile parameter (RZ10) rec/client set. In the parameter you specify which clients should have logging on.

In addition to that each table you want to log needs to have logging switched on. You find this flag in the technical settings of a table (with SE13).

The logs can then be evaluated with transaction SCU3. In there you can also get a list of all logged tables.

Be aware that in order to evaluate logs the users need to have access to the table they want to view the logs for. This is because they will be able to view the data that has been changed (new and old values). Tables which do not belong to an authorisation group can't be evaluated.

Hope this helps.

Kind regards

Petra Merkel

Re: table entries change

Former Member — Tue, 03 Apr 2007 06:51:47 GMT

In suim no option for to see who changed the tableentries.

Re: table entries change

Former Member — Tue, 03 Apr 2007 06:59:04 GMT

Yes,

SUIM shows information relating to user,roles,authorizations,profiles etc only.

SCU3 shows data relating to customizing tables.

Regards

Re: table entries change

Former Member — Tue, 03 Apr 2007 08:06:05 GMT

hi,

Goto transaction SPDD. give * for selection type 'user' and execute.

now under 'without modification assistant --> tables' u can find the information.

regards,

yatindra