SAP Table USR02 - Logon Data (Kernel-Side Use)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BNAME X XUBNAME CHAR 3 12 0 USR02 User Name in User Master Record
BCODE XUCODE RAW 15 8 0 Password Hash Key
GLTGV XUGLTGV DATS 23 8 0 User valid from
GLTGB XUGLTGB DATS 31 8 0 User valid to
USTYP XUUSTYP CHAR 39 1 0 User Type
CLASS XUCLASS CHAR 40 12 0 User group in user master maintenance
LOCNT XULOCNT INT1 52 3 0 Number of failed logon attempts
UFLAG XUUFLAG INT1 53 3 0 User Lock Status
ACCNT XUACCNT CHAR 54 12 0 Account ID
ANAME XUANAME CHAR 66 12 0 Creator of the User Master Record
ERDAT XUERDAT DATS 78 8 0 Creation Date of the User Master Record
TRDAT XULDATE DATS 86 8 0 Last Logon Date
LTIME XULTIME TIMS 94 6 0 Last Logon Time
OCOD1 XUCODE RAW 100 8 0 Password Hash Key
BCDA1 XUBCDAT DATS 108 8 0 Date of Last Password Change
CODV1 XUCODEVERS CHAR 116 1 0 Code Version of Password Hash Algorithm (Old Systems)
OCOD2 XUCODE RAW 117 8 0 Password Hash Key
BCDA2 XUBCDAT DATS 125 8 0 Date of Last Password Change
CODV2 XUCODEVERS CHAR 133 1 0 Code Version of Password Hash Algorithm (Old Systems)
OCOD3 XUCODE RAW 134 8 0 Password Hash Key
BCDA3 XUBCDAT DATS 142 8 0 Date of Last Password Change
CODV3 XUCODEVERS CHAR 150 1 0 Code Version of Password Hash Algorithm (Old Systems)
OCOD4 XUCODE RAW 151 8 0 Password Hash Key
BCDA4 XUBCDAT DATS 159 8 0 Date of Last Password Change
CODV4 XUCODEVERS CHAR 167 1 0 Code Version of Password Hash Algorithm (Old Systems)
OCOD5 XUCODE RAW 168 8 0 Password Hash Key
BCDA5 XUBCDAT DATS 176 8 0 Date of Last Password Change
CODV5 XUCODEVERS CHAR 184 1 0 Code Version of Password Hash Algorithm (Old Systems)
VERSN XUVERSION CHAR 185 3 0 User master record version
CODVN XUCODEVER2 CHAR 188 1 0 Code Version of Password Hash Algorithm (New Systems)
TZONE TZNZONE CHAR 189 6 0 TTZZ Time Zone
ZBVMASTER CHAR 195 1 0 'X'/'': Parallel Processing On/Off
PASSCODE PWD_SHA1 RAW 196 20 0 Password Hash Value (SHA1, 160 Bit)
PWDCHGDATE XUBCDAT DATS 216 8 0 Date of Last Password Change
PWDSTATE CHAR 224 1 0 'X'/'': Parallel Processing On/Off
RESERVED CHAR 225 1 0 'X'/'': Parallel Processing On/Off
PWDHISTORY XUPWDHIST INT1 226 3 0 Indicator: Password History Stored in Table USRPWDHISTORY
PWDLGNDATE XULPDAT DATS 227 8 0 Date of Last Password Logon
PWDSETDATE XUSPDAT DATS 235 8 0 Date: Password Reset by Administrator
PWDINITIAL XUPWDINIT INT1 243 3 0 Indicator: Password Is Initial (= Set by Administrator)
PWDLOCKDATE XUPLDAT DATS 244 8 0 Date: Setting of Password Lock
PWDSALTEDHASH PWD_HASH_STRING CHAR 252 255 0 Password Hash Value (Various Algorithms and Codings)

545211FAQ: Material master Customizing
1295042Error while trying to run User Synchronization job in RAR
1398802Various problems if nametab buffer is too small
1301479BAPI_USER_CREATE1/-CHANGE: Downward-compatible passwords