Skip to content
Top Menu
  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets

SAP4TECH

SAP and ABAP Free Tutorials

  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy Policy
    • Cookie Policy
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
    • SAP BW
  • SAP Functional
    • SAP SRM
    • SAP CRM
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP S/4 HANA
  • SAP4TECH
Main Menu
ABAP Tutorials

SAP User Login History Tables (different methods) and Logon User-exit

June 12, 2017November 7, 2020
SAP User Login History Tables and Tips e1497262198742

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

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

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

Table of Contents

  • ST03N : SAP User Login History
  • SM19 & SM20 : User Login History using SAP Log
    • List of SAP SM* Transaction Codes
  • RSUSR200 Report for SAP User Login History
  • STAD: SAP transaction Codes used by user
  • SAP Login History Tables
  • Custom/Exit SAP Login History Track

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 … :

SM01 Lock Transactions
SM02 System Messages
SM04 Logons to an AS Instance
SM05 HTTP Session Management: Monitoring
SM12 Display and Delete Locks
SM13 Administrate Update Records
SM14 Update Program Administration
SM18 Reorganize Security Audit Log
SM19 Security Audit Configuration
SM20 Analysis of Security Audit Log
SM20N Analysis of Security Audit Log
SM21 system log
SM28 Installation Check
SM29 Model Transfer for Tables
SM30 Call View Maintenance
SM31 Call View Maintenance Like SM30
SM32 Maintain Table Parameter ID TAB
SM33 Display Table Parameter ID TAB
SM34 Viewcluster maintenance call
SM35 Batch Input Monitoring
SM36 Schedule Background Job
SM37 Overview of job selection
SM37B Simple version of job selection
SM37C Flexible version of job selection
SM38 Queue Maintenance Transaction
SM39 Job Analysis
SM49 Execute external OS commands
SM50 Work Processes of AS Instance
SM51 Started AS Instances
SM52 Virtual Machine Overview
SM53 VMC Monitoring and Administration
SM54 TXCOM Maintenance
SM55 THOST Maintenance
SM56 Number Range Buffer
SM58 Asynchronous RFC Error Log
SM580 Transaction for Drag & Relate
SM59 RFC Destinations (Display/Maintain)
SM5A RFC Chain Analysis
SM5B Maintenance of DPTIMETAB
SM61 Backgroup control objects monitor
SM61B New control object management
SM62 Event History and Background Events
SM63 Display/Maintain Operating Mode Sets
SM64 Manage Background Processing Events
SM65 Background Processing Analysis Tool

Check also SAP Tcodes Workbench: ABAP Workbench Tcodes

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

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

TaggedHistoryLoginSAP TablesUser

Related Posts

SAP Workflow Tables SAP Workflow Tcodes

SAP Workflow Tcodes and SAP Workflow Tables

July 12, 2018January 21, 2020

SAP OTR, Online Text Repository OTR Tcodes Tables Function and Translation

SAP OTR Tcodes, Tables, Function and Translation

December 21, 2017January 21, 2022

JSON and ABAP

List of The most important JSON ABAP Classes in SAP

December 19, 2017January 21, 2020

Post navigation

Previous Article What the 3 different Types of Tables in SAP ? (Transparent, Pool and Cluster)
Next Article A Short Introduction and Overview to SAP UI Theme Designer

Recent Posts

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)
  • The most Important SAP Work Center Tables in SAP PP

Quick Navigation

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets

Search …

SAP4TECH

  • Home
  • Privacy and Cookie Policy
  • Contact Us
  • About Me
  • Sitemaps
SAP and SAP logo are registered trademarks of SAP AG. sap4tech.net is not associated with SAP AG. We have made every effort to make sure provide relevant search results, use the content on this site at your own risk.
Powered by WordPress and HitMag.