USR02
Logon Data (Kernel-Side Use)
USR02 is an SAP database table in S/4HANA. Logon Data (Kernel-Side Use). It contains 44 fields. 30 CDS views read from this table.
CDS Views using this table (30)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /AGIL/LUR_I_User | view | from | Relevant Users | |
| /dmbe/i_User_Description | view | inner | Deal User Description | |
| I_Acmusr02 | view | from | BASIC | View of user-table: USR02, used by ACM |
| I_DFS_MaintUserDetailsBasic | view | from | BASIC | User Details Basic View |
| I_FrcElmntOrgUserDetails | view | from | BASIC | Basic view to read the user details |
| I_PrepaymentAgrmtUserNameText | view | from | BASIC | Prepayment Agreement User Name Text |
| I_PrepaymentAgrmtUserNameVH | view | from | BASIC | Prepayment Agrmt User Name VH |
| I_RSAU_UGROUP | view | from | Cross Client User Group Assignments | |
| I_SWI_WIIinvUsers | view_entity | inner | Work Items with Invalid Users | |
| I_SWI_WIIinvUsers | view_entity | left_outer | Work Items with Invalid Users | |
| I_SystemUser | view | from | BASIC | System Benutzer |
| P_BPUsrAssignment | view | from | BASIC | Business User - User Assignment |
| P_BPUsrDetail | view | inner | BASIC | Business User - User Detail |
| P_BPUsrEEWASmtpSrch | view | inner | BASIC | Business User Workplace Address Smtp Srch |
| P_DDMRPController | view | left_outer | BASIC | |
| P_USER_ADDR | view | from | BASIC | F4 Suchhilfe für Benutzer |
| P_USER_LOGON | view | from | BASIC | Suche nach Logondaten |
| P_UserAddress | view | from | BASIC | Allegmeine CDS View für Adresse |
| P_USR_BY_GLOBALUID | view | inner | BASIC | User UUID |
| P_USR_EXTUID | view | inner | BASIC | Externe UID |
| P_USR_TO_GLOBALUID | view | inner | BASIC | User UUID |
| P_USR02 | view | from | BASIC | F4 Suchhilfe für Benutzer |
| P_USR02_USR21 | view | from | User from USR02 and USR21 | |
| s_sclt_customeruser_ddl | view | from | Customer User | |
| SAIS_JOB_LIST_EXA | view | inner | Get list of sheduled job steps with user data | |
| SAIS_JOB_LIST_SHD | view | inner | Get list of sheduled job steps with user data | |
| SUIM_US_DOCU | view_entity | from | SUIM | Get User Documentation List | |
| usr_attr_id_assign_w_default | view_entity | from | Zuordnung Benutzerattribute mit Default | |
| Usr02_Class | view | from | User with user group | |
| VFCLM_BAM_DDL_USERFULLNAME | view | from | User full name view |
Fields (44)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | MANDT | |
| KEY | bname | XUBNAME | |
| bcode | XUCODE | ||
| gltgv | XUGLTGV | ||
| gltgb | XUGLTGB | ||
| ustyp | XUUSTYP | ||
| class | XUCLASS | ||
| locnt | XULOCNT | ||
| uflag | XUUFLAG | ||
| accnt | XUACCNT | ||
| aname | XUANAME | ||
| erdat | XUERDAT | ||
| trdat | XULDATE | ||
| ltime | XULTIME | ||
| ocod1 | XUCODE | ||
| bcda1 | XUBCDAT | ||
| codv1 | XUCODEVERS | ||
| ocod2 | XUCODE | ||
| bcda2 | XUBCDAT | ||
| codv2 | XUCODEVERS | ||
| ocod3 | XUCODE | ||
| bcda3 | XUBCDAT | ||
| codv3 | XUCODEVERS | ||
| ocod4 | XUCODE | ||
| bcda4 | XUBCDAT | ||
| codv4 | XUCODEVERS | ||
| ocod5 | XUCODE | ||
| bcda5 | XUBCDAT | ||
| codv5 | XUCODEVERS | ||
| versn | XUVERSION | ||
| codvn | XUCODEVER2 | ||
| tzone | TZNZONE | ||
| zbvmaster | XUZBVFLAG | ||
| passcode | PWD_SHA1 | ||
| pwdchgdate | XUBCDAT | ||
| pwdstate | PWDCHGSTATE | ||
| reserved | XUCUACNTL | ||
| pwdhistory | XUPWDHIST | ||
| pwdlgndate | XULPDAT | ||
| pwdsetdate | XUSPDAT | ||
| pwdinitial | XUPWDINIT | ||
| pwdlockdate | XUPLDAT | ||
| pwdsaltedhash | PWD_HASH_STRING | ||
| security_policy | SECURITY_POLICY_NAME |