table entries change

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

Hi,

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

Regards

[Former Member]

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

[Former Member]

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

[Former Member]

Yes,

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

SCU3 shows data relating to customizing tables.

Regards

[Former Member]

hi,

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

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

regards,

yatindra