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
Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
MANDT | MANDT | CLNT | 3 |
* | Client | |
BNAME | XUBNAME | CHAR | 12 | User Name in User Master Record | ||
BCODE | XUCODE | RAW | 8 | Password Hash Key | ||
GLTGV | XUGLTGV | DATS | 8 | User valid from | ||
GLTGB | XUGLTGB | DATS | 8 | User valid to | ||
USTYP | XUUSTYP | CHAR | 1 | User Type | USTYP | |
CLASS | XUCLASS | CHAR | 12 | USGRP | User group in user master maintenance | |
LOCNT | XULOCNT | INT1 | 3 | Number of failed logon attempts | ||
UFLAG | XUUFLAG | INT1 | 3 | User Lock Status | ||
ACCNT | XUACCNT | CHAR | 12 | Account ID | ||
ANAME | XUANAME | CHAR | 12 | Creator of the User Master Record | ||
ERDAT | XUERDAT | DATS | 8 | Creation Date of the User Master Record | ||
TRDAT | XULDATE | DATS | 8 | Last Logon Date | ||
LTIME | XULTIME | TIMS | 6 | Last Logon Time | ||
OCOD1 | XUCODE | RAW | 8 | Password Hash Key | ||
BCDA1 | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
CODV1 | XUCODEVERS | CHAR | 1 | Code Version of Password Hash Algorithm (Old Systems) | ||
OCOD2 | XUCODE | RAW | 8 | Password Hash Key | ||
BCDA2 | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
CODV2 | XUCODEVERS | CHAR | 1 | Code Version of Password Hash Algorithm (Old Systems) | ||
OCOD3 | XUCODE | RAW | 8 | Password Hash Key | ||
BCDA3 | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
CODV3 | XUCODEVERS | CHAR | 1 | Code Version of Password Hash Algorithm (Old Systems) | ||
OCOD4 | XUCODE | RAW | 8 | Password Hash Key | ||
BCDA4 | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
CODV4 | XUCODEVERS | CHAR | 1 | Code Version of Password Hash Algorithm (Old Systems) | ||
OCOD5 | XUCODE | RAW | 8 | Password Hash Key | ||
BCDA5 | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
CODV5 | XUCODEVERS | CHAR | 1 | Code Version of Password Hash Algorithm (Old Systems) | ||
VERSN | XUVERSION | CHAR | 3 | User master record version | ||
CODVN | XUCODEVER2 | CHAR | 1 | Code Version of Password Hash Algorithm (New Systems) | ||
TZONE | TZNZONE | CHAR | 6 | TTZZ | Time Zone | |
ZBVMASTER | XUZBVFLAG | CHAR | 1 | CUA User Template: Logon Not Possible Here | ||
PASSCODE | PWD_SHA1 | RAW | 20 | Password Hash Value (SHA1, 160 Bit) | ||
PWDCHGDATE | XUBCDAT | DATS | 8 | Date of Last Password Change | ||
PWDSTATE | PWDCHGSTATE | INT1 | 3 | Password Change: Required / Allowed / Not Possible | ||
RESERVED | XUCUACNTL | INT1 | 3 | CUA Control Information | ||
PWDHISTORY | XUPWDHIST | INT1 | 3 | Indicator: Password History Stored in Table USRPWDHISTORY | ||
PWDLGNDATE | XULPDAT | DATS | 8 | Date of Last Password Logon | ||
PWDSETDATE | XUSPDAT | DATS | 8 | Date: Password Reset by Administrator | ||
PWDINITIAL | XUPWDINIT | INT1 | 3 | Indicator: Password Is Initial (= Set by Administrator) | ||
PWDLOCKDATE | XUPLDAT | DATS | 8 | Date: Setting of Password Lock | ||
PWDSALTEDHASH | PWD_HASH_STRING | CHAR | 255 | Password Hash Value (Various Algorithms and Codings) | ||
SECURITY_POLICY | SECURITY_POLICY_NAME | CHAR | 40 | SEC_POLICY_CUST | Security Policy Name |
Key field | |
Non-key field |
USR02 - Logon Data (Kernel-Side Use) USR01 - User master record (runtime data) USP_SELECTION_CONDITIONS - Structure for the Where-Condition of a Selection USP_FIELDS_SELECTION - Selected Fields for XML File USPROFLST - Transfer Structure for Profile Data for Lists USPROFLANG - Transfer Structure for Profile Data for Lists