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

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







USR02 is a standard SAP Table which is used to store Logon Data (Kernel-Side Use) data and 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 SAP USR02 Table and the data within it using relevant 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


SAP USR02 Table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BNAMEXUBNAMECHAR12User Name in User Master Record
BCODEXUCODERAW8Password Hash Key
GLTGVXUGLTGVDATS8User valid from
GLTGBXUGLTGBDATS8User valid to
USTYPXUUSTYPCHAR1User TypeUSTYP
CLASSXUCLASSCHAR12USGRPUser group in user master maintenance
LOCNTXULOCNTINT13Number of failed logon attempts
UFLAGXUUFLAGINT13User Lock Status
ACCNTXUACCNTCHAR12Account ID
ANAMEXUANAMECHAR12Creator of the User Master Record
ERDATXUERDATDATS8Creation Date of the User Master Record
TRDATXULDATEDATS8Last Logon Date
LTIMEXULTIMETIMS6Last Logon Time
OCOD1XUCODERAW8Password Hash Key
BCDA1XUBCDATDATS8Date of Last Password Change
CODV1XUCODEVERSCHAR1Code Version of Password Hash Algorithm (Old Systems)
OCOD2XUCODERAW8Password Hash Key
BCDA2XUBCDATDATS8Date of Last Password Change
CODV2XUCODEVERSCHAR1Code Version of Password Hash Algorithm (Old Systems)
OCOD3XUCODERAW8Password Hash Key
BCDA3XUBCDATDATS8Date of Last Password Change
CODV3XUCODEVERSCHAR1Code Version of Password Hash Algorithm (Old Systems)
OCOD4XUCODERAW8Password Hash Key
BCDA4XUBCDATDATS8Date of Last Password Change
CODV4XUCODEVERSCHAR1Code Version of Password Hash Algorithm (Old Systems)
OCOD5XUCODERAW8Password Hash Key
BCDA5XUBCDATDATS8Date of Last Password Change
CODV5XUCODEVERSCHAR1Code Version of Password Hash Algorithm (Old Systems)
VERSNXUVERSIONCHAR3User master record version
CODVNXUCODEVER2CHAR1Code Version of Password Hash Algorithm (New Systems)
TZONETZNZONECHAR6TTZZTime Zone
ZBVMASTERXUZBVFLAGCHAR1CUA User Template: Logon Not Possible Here
PASSCODEPWD_SHA1RAW20Password Hash Value (SHA1, 160 Bit)
PWDCHGDATEXUBCDATDATS8Date of Last Password Change
PWDSTATEPWDCHGSTATEINT13Password Change: Required / Allowed / Not Possible
RESERVEDXUCUACNTLINT13CUA Control Information
PWDHISTORYXUPWDHISTINT13Indicator: Password History Stored in Table USRPWDHISTORY
PWDLGNDATEXULPDATDATS8Date of Last Password Logon
PWDSETDATEXUSPDATDATS8Date: Password Reset by Administrator

PWDINITIALXUPWDINITINT13Indicator: Password Is Initial (= Set by Administrator)
PWDLOCKDATEXUPLDATDATS8Date: Setting of Password Lock
PWDSALTEDHASHPWD_HASH_STRINGCHAR255Password Hash Value (Various Algorithms and Codings)
SECURITY_POLICYSECURITY_POLICY_NAMECHAR40SEC_POLICY_CUSTSecurity Policy Name



Key field
Non-key field