USR02
Anmeldedaten (kernelseitige Verwendung !!!)
USR02 is an SAP database table in S/4HANA. Anmeldedaten (kernelseitige Verwendung !!!). It contains 44 fields. 35 CDS views read from this table.
CDS Views using this table (35)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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_EXC_GET | view | inner | Get latest execution timestamp per job and bname tupel | |
| SAIS_JOB_LIST_SHD | view | inner | Get list of sheduled job steps with user data | |
| SUIM_GET_US_AUTH_S_TABU_DIS | view_entity | from | Get S_TABU_DIS Auth. for User | |
| SUIM_GET_US_AUTH_S_TABU_NAM | view_entity | from | Get S_TABU_NAM Auth. for User | |
| SUIM_IS_AUTH_TABU_ACT_X | view_entity | inner | User with generic table authorizations | |
| SUIM_SECPOL_ATTR | view_entity | from | Attributs of SecPol | |
| SUIM_SECPOL_VIEW | view_entity | left_outer | Get Profil Parameter for Users | |
| 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 |