USR02 - Logon Data (Kernel-Side Use)

Logon Data (Kernel-Side Use) information is stored in SAP table USR02.
It is part of development package SUSR_KRN in software component BC-SEC-LGN. This development package consists of objects that can be grouped under "User Administration Tables Used Kernel-Side".

Fields for table USR02

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT3*
BNAMEUser Name in User Master RecordXXUBNAMECHAR12
BCODEPassword Hash KeyXUCODERAW8
GLTGVUser valid fromXUGLTGVDATS8
GLTGBUser valid toXUGLTGBDATS8
USTYPUser TypeXUUSTYPCHAR1
CLASSUser group in user master maintenanceXUCLASSCHAR12USGRP
LOCNTNumber of failed logon attemptsXULOCNTINT11
UFLAGUser Lock StatusXUUFLAGINT11
ACCNTAccount IDXUACCNTCHAR12
ANAMECreator of the User Master RecordXUANAMECHAR12
ERDATCreation Date of the User Master RecordXUERDATDATS8
TRDATLast Logon DateXULDATEDATS8
LTIMELast Logon TimeXULTIMETIMS6
OCOD1Password Hash KeyXUCODERAW8
BCDA1Date of Last Password ChangeXUBCDATDATS8
CODV1Code Version of Password Hash Algorithm (Old Systems)XUCODEVERSCHAR1
OCOD2Password Hash KeyXUCODERAW8
BCDA2Date of Last Password ChangeXUBCDATDATS8
CODV2Code Version of Password Hash Algorithm (Old Systems)XUCODEVERSCHAR1
OCOD3Password Hash KeyXUCODERAW8
BCDA3Date of Last Password ChangeXUBCDATDATS8
CODV3Code Version of Password Hash Algorithm (Old Systems)XUCODEVERSCHAR1
OCOD4Password Hash KeyXUCODERAW8
BCDA4Date of Last Password ChangeXUBCDATDATS8
CODV4Code Version of Password Hash Algorithm (Old Systems)XUCODEVERSCHAR1
OCOD5Password Hash KeyXUCODERAW8
BCDA5Date of Last Password ChangeXUBCDATDATS8
CODV5Code Version of Password Hash Algorithm (Old Systems)XUCODEVERSCHAR1
VERSNUser master record versionXUVERSIONCHAR3
CODVNCode Version of Password Hash Algorithm (New Systems)XUCODEVER2CHAR1
TZONETime ZoneTZNZONECHAR6TTZZ
PASSCODEPassword Hash Value (SHA1, 160 Bit)PWD_SHA1RAW20
PWDCHGDATEDate of Last Password ChangeXUBCDATDATS8
PWDSTATEPassword Change: Required / Allowed / Not PossiblePWDCHGSTATEINT11
RESERVEDCUA Control InformationXUCUACNTLINT11
PWDHISTORYIndicator: Password History Stored in Table USRPWDHISTORYXUPWDHISTINT11
PWDLGNDATEDate of Last Password LogonXULPDATDATS8
PWDSETDATEDate: Password Reset by AdministratorXUSPDATDATS8
PWDINITIALIndicator: Password Is Initial (= Set by Administrator)XUPWDINITINT11
PWDLOCKDATEDate: Setting of Password LockXUPLDATDATS8
PWDSALTEDHASHPassword Hash Value (Various Algorithms and Codings)PWD_HASH_STRINGCHAR255
SECURITY_POLICYSecurity Policy NameSECURITY_POLICY_NAMECHAR40SEC_POLICY_CUST
Privacy Policy