1. Home
  2. Resources
  3. SAP Tables
  4. USR02 - Logon Data (Kernel-Side Use)

SAP Table USR02

Logon Data (Kernel-Side Use)

USR02 (Logon Data (Kernel-Side Use)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link USR02 to other SAP tables.

USR02 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BNAME User Name in User Master Record XUBNAME CHAR 12 0
BCODE Password Hash Key XUCODE RAW 8 0
GLTGV User valid from XUGLTGV DATS 8 0
GLTGB User valid to XUGLTGB DATS 8 0
USTYP User Type XUUSTYP CHAR 1 0
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance XUCLASS USGRP CHAR 12 0
LOCNT Number of failed logon attempts XULOCNT INT1 3 0
UFLAG User Lock Status XUUFLAG INT1 3 0
0 Not Locked
32 Locked Globally By Administrator
64 Locked Locally By Administrator
128 Locked Due To Incorrect Logons (Limited Term)
ACCNT Account ID XUACCNT CHAR 12 0
ANAME Creator of the User Master Record XUANAME CHAR 12 0
ERDAT Creation Date of the User Master Record XUERDAT DATS 8 0
TRDAT Last Logon Date XULDATE DATS 8 0
LTIME Last Logon Time XULTIME TIMS 6 0
OCOD1 Password Hash Key XUCODE RAW 8 0
BCDA1 Date of Last Password Change XUBCDAT DATS 8 0
CODV1 Code Version of Password Hash Algorithm (Old Systems) XUCODEVERS CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
X Password Deactivated
OCOD2 Password Hash Key XUCODE RAW 8 0
BCDA2 Date of Last Password Change XUBCDAT DATS 8 0
CODV2 Code Version of Password Hash Algorithm (Old Systems) XUCODEVERS CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
X Password Deactivated
OCOD3 Password Hash Key XUCODE RAW 8 0
BCDA3 Date of Last Password Change XUBCDAT DATS 8 0
CODV3 Code Version of Password Hash Algorithm (Old Systems) XUCODEVERS CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
X Password Deactivated
OCOD4 Password Hash Key XUCODE RAW 8 0
BCDA4 Date of Last Password Change XUBCDAT DATS 8 0
CODV4 Code Version of Password Hash Algorithm (Old Systems) XUCODEVERS CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
X Password Deactivated
OCOD5 Password Hash Key XUCODE RAW 8 0
BCDA5 Date of Last Password Change XUBCDAT DATS 8 0
CODV5 Code Version of Password Hash Algorithm (Old Systems) XUCODEVERS CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
X Password Deactivated
VERSN User master record version XUVERSION CHAR 3 0
CODVN Code Version of Password Hash Algorithm (New Systems) XUCODEVER2 CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8)
E Code Version E (Corrected Code Version D)
F Code Version F (SHA1, 40 Characters, Case-Sensitive, UTF-8)
G Code Version G = Code Vers. F + Code Vers. B (2 Hash Values)
H Code Version H (Generic Hash Procedure)
I Code Version I = Code Versions H + F + B (Three Hash Values)
X Password Deactivated
TZONE Time Zone TZNZONE TTZZ CHAR 6 0
ZBVMASTER CUA User Template: Logon Not Possible Here XUZBVFLAG CHAR 1 0
NULL False
X Correct
PASSCODE Password Hash Value (SHA1, 160 Bit) PWD_SHA1 RAW 20 0
PWDCHGDATE Date of Last Password Change XUBCDAT DATS 8 0
PWDSTATE Password Change: Required / Allowed / Not Possible PWDCHGSTATE INT1 3 0
254 Password cannot be changed in principle
255 Password cannot be changed until the end of the wait time
0 Password can be changed but does not need to be changed
1 Password is initial and must be changed
2 Password has expired and must be changed
3 Password must be changed due to tightened rules
RESERVED CUA Control Information XUCUACNTL INT1 3 0
0 Normal User (Can be distributed using CUA)
11 Local User (Is not distributed using CUA)
PWDHISTORY Indicator: Password History Stored in Table USRPWDHISTORY XUPWDHIST INT1 3 0
0 False
1 True
PWDLGNDATE Date of Last Password Logon XULPDAT DATS 8 0
PWDSETDATE Date: Password Reset by Administrator XUSPDAT DATS 8 0
PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) XUPWDINIT INT1 3 0
0 Undetermined (Initial)
1 True
2 False
PWDLOCKDATE Date: Setting of Password Lock XUPLDAT DATS 8 0
PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings) PWD_HASH_STRING CHAR 255 0
SECURITY_POLICY Security Policy Name SECURITY_POLICY_NAME SEC_POLICY_CUST CHAR 40 0

USR02 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
USR02 CLASS USR02 MANDT USGRP User Groups MANDT
USR02 CLASS USR02 CLASS USGRP User Groups USERGROUP
USR02 SECURITY_POLICY USR02 MANDT SEC_POLICY_CUST Configuration of Security Policies CLIENT
USR02 SECURITY_POLICY USR02 SECURITY_POLICY SEC_POLICY_CUST Configuration of Security Policies NAME
USR02 TZONE USR02 TZONE TTZZ Time zones TZONE
USR02 TZONE USR02 MANDT TTZZ Time zones CLIENT