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".
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 |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| BNAME | User Name in User Master Record | X | XUBNAME | CHAR | 12 | |
| BCODE | Password Hash Key | XUCODE | RAW | 8 | ||
| GLTGV | User valid from | XUGLTGV | DATS | 8 | ||
| GLTGB | User valid to | XUGLTGB | DATS | 8 | ||
| USTYP | User Type | XUUSTYP | CHAR | 1 | ||
| CLASS | User group in user master maintenance | XUCLASS | CHAR | 12 | USGRP | |
| LOCNT | Number of failed logon attempts | XULOCNT | INT1 | 1 | ||
| UFLAG | User Lock Status | XUUFLAG | INT1 | 1 | ||
| ACCNT | Account ID | XUACCNT | CHAR | 12 | ||
| ANAME | Creator of the User Master Record | XUANAME | CHAR | 12 | ||
| ERDAT | Creation Date of the User Master Record | XUERDAT | DATS | 8 | ||
| TRDAT | Last Logon Date | XULDATE | DATS | 8 | ||
| LTIME | Last Logon Time | XULTIME | TIMS | 6 | ||
| OCOD1 | Password Hash Key | XUCODE | RAW | 8 | ||
| BCDA1 | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| CODV1 | Code Version of Password Hash Algorithm (Old Systems) | XUCODEVERS | CHAR | 1 | ||
| OCOD2 | Password Hash Key | XUCODE | RAW | 8 | ||
| BCDA2 | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| CODV2 | Code Version of Password Hash Algorithm (Old Systems) | XUCODEVERS | CHAR | 1 | ||
| OCOD3 | Password Hash Key | XUCODE | RAW | 8 | ||
| BCDA3 | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| CODV3 | Code Version of Password Hash Algorithm (Old Systems) | XUCODEVERS | CHAR | 1 | ||
| OCOD4 | Password Hash Key | XUCODE | RAW | 8 | ||
| BCDA4 | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| CODV4 | Code Version of Password Hash Algorithm (Old Systems) | XUCODEVERS | CHAR | 1 | ||
| OCOD5 | Password Hash Key | XUCODE | RAW | 8 | ||
| BCDA5 | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| CODV5 | Code Version of Password Hash Algorithm (Old Systems) | XUCODEVERS | CHAR | 1 | ||
| VERSN | User master record version | XUVERSION | CHAR | 3 | ||
| CODVN | Code Version of Password Hash Algorithm (New Systems) | XUCODEVER2 | CHAR | 1 | ||
| TZONE | Time Zone | TZNZONE | CHAR | 6 | TTZZ | |
| PASSCODE | Password Hash Value (SHA1, 160 Bit) | PWD_SHA1 | RAW | 20 | ||
| PWDCHGDATE | Date of Last Password Change | XUBCDAT | DATS | 8 | ||
| PWDSTATE | Password Change: Required / Allowed / Not Possible | PWDCHGSTATE | INT1 | 1 | ||
| RESERVED | CUA Control Information | XUCUACNTL | INT1 | 1 | ||
| PWDHISTORY | Indicator: Password History Stored in Table USRPWDHISTORY | XUPWDHIST | INT1 | 1 | ||
| PWDLGNDATE | Date of Last Password Logon | XULPDAT | DATS | 8 | ||
| PWDSETDATE | Date: Password Reset by Administrator | XUSPDAT | DATS | 8 | ||
| PWDINITIAL | Indicator: Password Is Initial (= Set by Administrator) | XUPWDINIT | INT1 | 1 | ||
| PWDLOCKDATE | Date: Setting of Password Lock | XUPLDAT | DATS | 8 | ||
| PWDSALTEDHASH | Password Hash Value (Various Algorithms and Codings) | PWD_HASH_STRING | CHAR | 255 | ||
| SECURITY_POLICY | Security Policy Name | SECURITY_POLICY_NAME | CHAR | 40 | SEC_POLICY_CUST |