USR02

Logon Data (Kernel-Side Use) | #masterdata | Component: Authentication and SSO
Column Name Description
MANDT Client
BNAME User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
GLTGV User valid from
GLTGB User valid to
ERDAT Creation Date of the User Master Record
TRDAT Last Logon Date
LTIME Last Logon Time
BCDA1 Date of Last Password Change
BCDA2 Date of Last Password Change
BCDA3 Date of Last Password Change
BCDA4 Date of Last Password Change
BCDA5 Date of Last Password Change
PWDCHGDATE Date of Last Password Change
PWDLGNDATE Date of Last Password Logon
PWDSETDATE Date: Password Reset by Administrator
PWDLOCKDATE Date: Setting of Password Lock
Column Name Description
USTYP User Type Show values
UFLAG User Lock Status Show values
CODV1 Code Version of Password Hash Algorithm (Old Systems) Show values
CODV2 Code Version of Password Hash Algorithm (Old Systems) Show values
CODV3 Code Version of Password Hash Algorithm (Old Systems) Show values
CODV4 Code Version of Password Hash Algorithm (Old Systems) Show values
CODV5 Code Version of Password Hash Algorithm (Old Systems) Show values
CODVN Code Version of Password Hash Algorithm (New Systems) Show values
ZBVMASTER CUA User Template: Logon Not Possible Here Show values
PWDSTATE Password Change: Required / Allowed / Not Possible Show values
RESERVED CUA Control Information Show values
PWDHISTORY Indicator: Password History Stored in Table USRPWDHISTORY Show values
PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) Show values
Column Name Description Domain name
BCODE Password Hash Key XUCODE
LOCNT Number of failed logon attempts XULOCNT
ACCNT Account ID XUACCNT
ANAME Creator of the User Master Record BNAME
OCOD1 Password Hash Key XUCODE
OCOD2 Password Hash Key XUCODE
OCOD3 Password Hash Key XUCODE
OCOD4 Password Hash Key XUCODE
OCOD5 Password Hash Key XUCODE
VERSN User master record version XUVERSION
PASSCODE Password Hash Value (SHA1, 160 Bit) SHA1_HASH
PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings) PWD_HASH_STRING
Master Data Relations Join Conditions
User group
  • USR02.MANDT == USGRP.MANDT
  • USR02.CLASS == USGRP.USERGROUP
Security Policy Name
Time Zone
  • USR02.MANDT == TTZZ.CLIENT
  • USR02.TZONE == TTZZ.TZONE