Hi, in SAP how do I find out the last 5 users who modified a certain table?

Answer 1

Check the SAP Help portal:

sing the logging flag you can define whether changes to the data records of a table should be logged. If logging is switched on, each change to an existing data record (with UPDATE, DELETE) by the user or application program is recorded in the database in a log table (DBTABPRT).

This graphic is explained in the accompanying text

To switch on logging, the SAP System must be started with a profile containing parameter rec/client. This parameter defines whether all clients or only selected clients should be logged.

The parameter can have the following values:

rec/client = ALL


Log all clients.

rec/client = 000[,...]


Log the specified clients.

rec/client = OFF


Do not log.

Caution

If logging is switched on, it will slow down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, a number of users access this log table in parallel. This can cause lock situations although the users are working with different application tables.

Logging is independent of the update.

The existing logs can be displayed with Transaction Table History (SCU3).

Answer 2

Are you trying to do view table history, I think you need to use SCU3.

Hope this helps.