SAP TABLES | Basis Components | Security | Authentication and SSO(BC-SEC-LGN) SAP BC

USR02 SAP Logon Data (Kernel-Side Use) Table








USR02 is a standard SAP Table which is used to store Logon Data (Kernel-Side Use) information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table USR02 and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories

Text table = GRFNMWCNAPPRT


Dictionary fields for SAP Table USR02




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BNAMEXUBNAMECHAR12 User Name in User Master Record
BCODEXUCODERAW8 Password Hash Key
GLTGVXUGLTGVDATS8 User valid from
GLTGBXUGLTGBDATS8 User valid to
USTYPXUUSTYPCHAR1 User TypeUSTYP
CLASSXUCLASSCHAR12 USGRPUser group in user master maintenance
LOCNTXULOCNTINT13 Number of failed logon attempts
UFLAGXUUFLAGINT13 User Lock Status
ACCNTXUACCNTCHAR12 Account ID
ANAMEXUANAMECHAR12 Creator of the User Master Record
ERDATXUERDATDATS8 Creation Date of the User Master Record
TRDATXULDATEDATS8 Last Logon Date
LTIMEXULTIMETIMS6 Last Logon Time
OCOD1XUCODERAW8 Password Hash Key
BCDA1XUBCDATDATS8 Date of Last Password Change
CODV1XUCODEVERSCHAR1 Code Version of Password Hash Algorithm (Old Systems)
OCOD2XUCODERAW8 Password Hash Key
BCDA2XUBCDATDATS8 Date of Last Password Change
CODV2XUCODEVERSCHAR1 Code Version of Password Hash Algorithm (Old Systems)
OCOD3XUCODERAW8 Password Hash Key
BCDA3XUBCDATDATS8 Date of Last Password Change
CODV3XUCODEVERSCHAR1 Code Version of Password Hash Algorithm (Old Systems)
OCOD4XUCODERAW8 Password Hash Key
BCDA4XUBCDATDATS8 Date of Last Password Change
CODV4XUCODEVERSCHAR1 Code Version of Password Hash Algorithm (Old Systems)
OCOD5XUCODERAW8 Password Hash Key
BCDA5XUBCDATDATS8 Date of Last Password Change
CODV5XUCODEVERSCHAR1 Code Version of Password Hash Algorithm (Old Systems)
VERSNXUVERSIONCHAR3 User master record version
CODVNXUCODEVER2CHAR1 Code Version of Password Hash Algorithm (New Systems)
TZONETZNZONECHAR6 TTZZTime Zone
ZBVMASTERXUZBVFLAGCHAR1 CUA User Template: Logon Not Possible Here
PASSCODEPWD_SHA1RAW20 Password Hash Value (SHA1, 160 Bit)
PWDCHGDATEXUBCDATDATS8 Date of Last Password Change
PWDSTATEPWDCHGSTATEINT13 Password Change: Required / Allowed / Not Possible
RESERVEDXUCUACNTLINT13 CUA Control Information
PWDHISTORYXUPWDHISTINT13 Indicator: Password History Stored in Table USRPWDHISTORY
PWDLGNDATEXULPDATDATS8 Date of Last Password Logon
PWDSETDATEXUSPDATDATS8 Date: Password Reset by Administrator

PWDINITIALXUPWDINITINT13 Indicator: Password Is Initial (= Set by Administrator)
PWDLOCKDATEXUPLDATDATS8 Date: Setting of Password Lock
PWDSALTEDHASHPWD_HASH_STRINGCHAR255 Password Hash Value (Various Algorithms and Codings)
SECURITY_POLICYSECURITY_POLICY_NAMECHAR40 SEC_POLICY_CUSTSecurity Policy Name


Key field
Non-key field