User Lock Status In Sap



In this post, we will detail how to retrieve SAP user Login History from SAP log system using different Methods.

How to Monitor a SAP Lock Entries: In SM12 check any lock entry older than 2 days, if any outdated entry check the corresponding User and check the user online or offline in AL08 and contact that User (you can get the User info from su01) and inform about the lock else if the user is offline release the table from lock by deleting the lock. We have a SAP System 4.6C running on PSeries + AIX 5.2; Sometimes, after a long period without a restart on the system, the amount of free memory on ST06 decreases a lot. Looking on the operation system and the processes, there’s no process as a “”memory killer””. So, we descovered that if we select some WPs in.

How to retrieve the login history for any SAP user and the list of SAP transaction codes executed by a SAP user.

User Lock Status In Sap

In the last part, we will explain how to custom tracking the SAP login action.

ST03N : SAP User Login History

The most used method to retrieve SAP User login history is using the standard SAP Transaction Code ST03N.

Go to ST03N → Switch to Expert mode in the upper left corner → Expand the node Total and select the time period (day, week, month) → Expand the node User and Settlement Statistics and select User Profile → DoubleClick the user you want and you get a list with transactions

SM19 & SM20 : User Login History using SAP Log

The second method is to use SAP Audit System.
First you need to activate the SAP audit. Use the SAP Tcode SM19 for Security Audit Configuration.

Then use SM20 for all the SAP user history including:

  • Login
  • Reports he ran
  • Password Change
  • Lock and Unlocked User
  • Authorization Change …

List of SAP SM* Transaction Codes

Here the main SAP SM* Tcodes used for User, System Administration … :

SM01Lock Transactions
SM02System Messages
SM04Logons to an AS Instance
SM05HTTP Session Management: Monitoring
SM12Display and Delete Locks
SM13Administrate Update Records
SM14Update Program Administration
SM18Reorganize Security Audit Log
SM19Security Audit Configuration
SM20Analysis of Security Audit Log
SM20NAnalysis of Security Audit Log
SM21system log
SM28Installation Check
SM29Model Transfer for Tables
SM30Call View Maintenance
SM31Call View Maintenance Like SM30
SM32Maintain Table Parameter ID TAB
SM33Display Table Parameter ID TAB
SM34Viewcluster maintenance call
SM35Batch Input Monitoring
SM36Schedule Background Job
SM37Overview of job selection
SM37BSimple version of job selection
SM37CFlexible version of job selection
SM38Queue Maintenance Transaction
SM39Job Analysis
SM49Execute external OS commands
SM50Work Processes of AS Instance
SM51Started AS Instances
SM52Virtual Machine Overview
SM53VMC Monitoring and Administration
SM54TXCOM Maintenance
SM55THOST Maintenance
SM56Number Range Buffer
SM58Asynchronous RFC Error Log
SM580Transaction for Drag & Relate
SM59RFC Destinations (Display/Maintain)
SM5ARFC Chain Analysis
SM5BMaintenance of DPTIMETAB
SM61Backgroup control objects monitor
SM61BNew control object management
SM62Event History and Background Events
SM63Display/Maintain Operating Mode Sets
SM64Manage Background Processing Events
SM65Background Processing Analysis Tool

Check also SAP Tcodes Workbench: ABAP Workbench Tcodes

Sap Security Trace

RSUSR200 Report for SAP User Login History

Another way to retrieve the list of User history for login in SAP System is to run the standard SAP report RSUSR200.

The RSUSR200 is for List of Users According to Logon Date and Password Change.

You want really get all the login history. But you can see the last login information and the last user’s password change.

STAD: SAP transaction Codes used by user

STAD is the SAP standard transaction for Statistics display for all systems.
You can select the User ID and you will have all the detail about the login, transactions and Reports that this particular user has launched.

SAP Login History Tables

User Lock Status In Sap Query

The SAP Login history tables used to track user login are:

  • USR02: Logon Data (Kernel-Side Use)
    • TRDAT: SAP Last Logon Date
    • LTIME: SAP Last Logon Time
  • WCR_USERSTAT: login log for Portal

Custom/Exit SAP Login History Track

If you want to track more actions or you need a specific report for User Login History in SAP, you can develop your own ABAP code using the user-exit SUSR0001.

The function-exit is EXIT_SAPLSUSF_001.

Note that used is triggered only for SAPGUI type “DIAG” logon. It is executed After successful SAPGUI logon. Check SAP Note 37724 for more information

If you are not familiar with CMOD, here a good article on Implementation of SAP logon user exit SUSR0001