USR02 table in SAP ERP or S/4HANA stores Logon Data (Kernel-Side Use) data. There are total 44 fields in USR02 table. The Logon Data (Kernel-Side Use) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of USR02 table. It is in User Administration Tables Used Kernel-Side (SUSR_KRN) ABAP package and is part of the Authentication and SSO (BC-SEC-LGN) module.
SAP USR02 Table Fields
Following is the list of fields that are available in SAP USR02 table. The primary key fields of Logon Data (Kernel-Side Use) table in SAP are MANDT (Client), BNAME (User Name in User Master Record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| 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 | USGRP | CHAR(12) |
| 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 | TTZZ | CHAR(6) |
| 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 | SEC_POLICY_CUST | CHAR(40) |
