USR02 is a standard Authentication and SSO Transparent Table in SAP Basis application, which stores Logon Data (Kernel-Side Use) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for USR02. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

USR02 — Meta Data

Description: Logon Data (Kernel-Side Use)
Main Category: Basis
Sub Category: Authentication and SSO
Table type: Transparent Table (TRANSP)

USR02 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 *
    2 BNAME Template name X CHAR 12
    3 BCODE Numeric RAW 8
    4 GLTGV User valid from DATS 8
    5 GLTGB User valid to DATS 8
    6 USTYP User Type CHAR 1
    7 CLASS Class Name CHAR 12 USGRP
    8 LOCNT Number of failed logon attempts INT1 3
    9 UFLAG Icon and Text for USR02-UFLAG INT1 3
    10 ACCNT Account Number (GUID) CHAR 12
    11 ANAME Application Name CHAR 12
    12 ERDAT Created on DATS 8
    13 TRDAT Date of Last Data Transfer DATS 8
    14 LTIME Time TIMS 6
    15 OCOD1 Password Hash Key RAW 8
    16 BCDA1 Date of Last Password Change DATS 8
    17 CODV1 Code Version of Password Hash Algorithm (Old Systems) CHAR 1
    18 OCOD2 Password Hash Key RAW 8
    19 BCDA2 Date of Last Password Change DATS 8
    20 CODV2 Code Version of Password Hash Algorithm (Old Systems) CHAR 1
    21 OCOD3 Password Hash Key RAW 8
    22 BCDA3 Date of Last Password Change DATS 8
    23 CODV3 Code Version of Password Hash Algorithm (Old Systems) CHAR 1
    24 OCOD4 Password Hash Key RAW 8
    25 BCDA4 Date of Last Password Change DATS 8
    26 CODV4 Code Version of Password Hash Algorithm (Old Systems) CHAR 1
    27 OCOD5 Password Hash Key RAW 8
    28 BCDA5 Date of Last Password Change DATS 8
    29 CODV5 Code Version of Password Hash Algorithm (Old Systems) CHAR 1
    30 VERSN Version CHAR 3
    31 CODVN Code Version of Password Hash Algorithm (New Systems) CHAR 1
    32 TZONE Time Zone for Date and Time Fields of Procurement Document CHAR 6 TTZZ
    33 ZBVMASTER CUA User Template: Logon Not Possible Here CHAR 1
    34 PASSCODE Password Hash Value (SHA1 RAW 20
    35 PWDCHGDATE Date of Last Password Change DATS 8
    36 PWDSTATE Password Change: Required / Allowed / Not Possible INT1 3
    37 RESERVED For Future Enhancements INT1 3
    38 PWDHISTORY Indicator: Password History Stored in Table USRPWDHISTORY INT1 3
    39 PWDLGNDATE Date of Last Password Logon DATS 8
    40 PWDSETDATE Date: Password Reset by Administrator DATS 8
    41 PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) INT1 3
    42 PWDLOCKDATE Date: Setting of Password Lock DATS 8
    43 PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings) CHAR 255
    44 SECURITY_POLICY Security Policy Name CHAR 40 SEC_POLICY_CUST

SAP Help, Wiki Resources, and Forum Discussions on USR02

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
USR01 User master record (runtime data) Basis - Authentication and SSO
USR03 User address data Basis - User and Authorization Management
USR21 Assign user name address key Basis - User and Authorization Management
USR04 User master authorizations Basis - User and Authorization Management
MARA General Material Data Logistics - Material Master
USR40 Table for illegal passwords Basis - Authentication and SSO
USR12 User Master Authorization Values Basis - User and Authorization Management

Transaction Codes for SAP Table USR02

TCODE Description Functional Area
SU01 User Maintenance Basis - User and Authorization Management
SE16 Data Browser Basis - Workbench Utilities
SUIM User Information System Basis - User Information System
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE38 ABAP Editor Basis - ABAP Editor
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SU10 User Mass Maintenance Basis - User and Authorization Management
RZ10 Maintain Profile Parameters Basis - Profile Maintenance

FMs for SAP Table USR02

FM Description Functional Area
BAPI_USER_GET_DETAIL Read User Details Basis - User and Authorization Management
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
RFC_READ_TABLE External access to R/3 tables via RFC Basis - See Note 539477
F4IF_INT_TABLE_VALUE_REQUEST F4 help also returning the value to be displayed in internal table Basis - F4 Help
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
BAPI_USER_UNLOCK Unlock User Basis - User and Authorization Management

ABAP Reports for SAP Table USR02

ABAP REPORT Description Functional Area
RSUSR200 List of Users According to Logon Date and Password Change Basis - System Audit Information System
RSUSR100 Change Documents for Users Basis - User Information System
RSUSR002 Users by Complex Selection Criteria Basis - User Information System
SPRSL TEXT 630 - Workbench Tools: Editors
RSPARAM Display SAP Profile Parameters Basis - Workbench Tools: Editors, Painters, Modelers
RSUSR003 Check the Passwords of Standard Users in All Clients Basis - System Audit Information System
RSUSR006 Locked Users and Users with Incorrect Logons Basis - User Information System
CL_ABAP_TYPEDESCR=============CP Include LDMEE1_ABACIH

BW Datasources for SAP Table USR02

BW DATASOURCE Description Functional Area
0TCTUSERNM BW Metadata: User -
0CO_OM_OPA_6 Orders: Actual Costs Using Delta Extraction CO - Overhead Cost Orders
0CO_OM_OPA_7 Orders: Commitment Line Items CO - Overhead Cost Orders
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
0CO_OM_WBS_2 WBS elements: Budget CO - Overhead Projects
0CO_OM_NWA_1 Network Activity: Costs CO - Overhead Projects
0CO_OM_WBS_1 WBS elements: Costs CO - Overhead Projects

Authorization Objects for SAP Table USR02

AUTHORIZATION OBJECT Description Functional Area
S_TCODE Transaction Code Check at Transaction Start
S_USER_GRP User Master Maintenance: User Groups
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
S_PROGRAM ABAP: Program Flow Checks
S_ADMI_FCD System Authorizations
S_DATASET Authorization for file access
S_RFC Authorization Check for RFC Access
S_DEVELOP ABAP Workbench