04-18-2009 7:43 AM
How can i find transaction last access date and username.
is there any table for the solution.
Moderator message - this question has been asked and answered many times before. Please search before asking. Thread locked
Edited by: Rob Burbank on Apr 19, 2009 4:16 PM
04-18-2009 7:48 AM
Try the transaction STAT. You will get a log containing the date and time of access.
04-18-2009 7:49 AM
Hi
use the trascations STAD,ST03 and STAT
you will get the details
Thanks!
04-18-2009 1:42 PM
You can find this on transaction ST03.
The table which stores this data is MONI
You can fetch the data from this table also.
Note: The data in this table is in raw data format you need to first convert it and then store in internal table.
Regards,
Lalit Mohan Gupta.
04-19-2009 6:38 PM
02-11-2022 9:51 AM
Hi,
To see when a certain t-code is used and who uses it based on program execution, see the following steps:
- T-code: se16n
- In “General Table View”
Table → ZUSRTC > enter
Transaction → fill in the t-code you want to view
- Press the execute button
Sort the data by date for easy viewing of the data.
Hope it helps~
03-04-2022 8:25 AM
Dear Rob,
From the CCMS monitoring side I can suggest to please check the following KBA:
##2349134 - Check what Transactions were Run by which Users
If you want to get the detailed data from the user, you should check the audit log SM20 only if you have activated the SM20 in SM19.
Since SM20 is for the security audit log. ST03 is for the performance analysis.
Best regards,
Norbert
SAP Product Support