SAP table USER02 (User Data for Logon)

Field Description Data Type Length Decimals Checktable Data Element
BCODE Password Hash Key RAW 8 0 XUCODE
GLTGV User valid from DATS 8 0 XUGLTGV
GLTGB User valid to DATS 8 0 XUGLTGB
USTYP User Type CHAR 1 0 XUUSTYP
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance CHAR 12 0 USGRP XUCLASS
LOCNT Number of failed logon attempts INT1 3 0 XULOCNT
UFLAG User Lock Status INT1 3 0 XUUFLAG
0 Not Locked
128 Locked Due To Incorrect Logons (Limited Term)
32 Locked Globally By Administrator
64 Locked Locally By Administrator
ACCNT Account ID CHAR 12 0 XUACCNT
ANAME Creator of the User Master Record CHAR 12 0 XUANAME
ERDAT Creation Date of the User Master Record DATS 8 0 XUERDAT
TRDAT Last Logon Date DATS 8 0 XULDATE
LTIME Last Logon Time TIMS 6 0 XULTIME
OCOD1 Password Hash Key RAW 8 0 XUCODE
BCDA1 Date of Last Password Change DATS 8 0 XUBCDAT
CODV1 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD2 Password Hash Key RAW 8 0 XUCODE
BCDA2 Date of Last Password Change DATS 8 0 XUBCDAT
CODV2 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD3 Password Hash Key RAW 8 0 XUCODE
BCDA3 Date of Last Password Change DATS 8 0 XUBCDAT
CODV3 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD4 Password Hash Key RAW 8 0 XUCODE
BCDA4 Date of Last Password Change DATS 8 0 XUBCDAT
CODV4 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD5 Password Hash Key RAW 8 0 XUCODE
BCDA5 Date of Last Password Change DATS 8 0 XUBCDAT
CODV5 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
VERSN User master record version CHAR 3 0 XUVERSION
CODVN Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated

USER02 foreign key relationships

Table Field Check Table Check Field
0 USER02 CLASS USGRP User Groups MANDT
0 USER02 CLASS USGRP User Groups USERGROUP