1. Home
  2. Resources
  3. SAP Tables
  4. USER02 - User Data for Logon

SAP Table USER02

User Data for Logon

USER02 (User Data for Logon) 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 USER02 to other SAP tables.

USER02 table fields

Field Data element Checktable Datatype Length Decimals
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 (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

USER02 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
USER02 CLASS USR02 MANDT USGRP User Groups MANDT
USER02 CLASS USER02 CLASS USGRP User Groups USERGROUP