SAP Table USR02
Logon Data (Kernel-Side Use)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table USR02 (Logon Data (Kernel-Side Use)) is a standard table in SAP ERP. It belongs to the package SUSR.
Technical Information
| Table | USR02 |
| Short Text | Logon Data (Kernel-Side Use) |
| Package | SUSR |
| Table Type | Transparent Table |
Fields for Table USR02
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| BNAME | ✔ | User Name in User Master Record | 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 | 3 | ||
| UFLAG | User Lock Status | XUUFLAG | INT1 | 3 | ||
| 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 | |
| ZBVMASTER | CUA User Template: Logon Not Possible Here | XUZBVFLAG | CHAR | 1 | ||
| 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 | 3 | ||
| RESERVED | CUA Control Information | XUCUACNTL | INT1 | 3 | ||
| PWDHISTORY | Indicator: Password History Stored in Table USRPWDHISTORY | XUPWDHIST | INT1 | 3 | ||
| 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 | 3 | ||
| 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 |