USR02
Anmeldedaten (kernelseitige Verwendung !!!)
USR02 is an SAP database table in S/4HANA. Anmeldedaten (kernelseitige Verwendung !!!). It contains 45 fields. 45 CDS views read from this table.
CDS Views using this table (45)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_COM_CU_A4C_ODATA_RT | view_entity | from | Communication Users | |
| APS_COM_CU_A4C_QUERY | view_entity | from | Query Comm. User | |
| aps_iam_customeruser_ddl | view | from | Customer User | |
| APS_IAM_REP_COSTS | view | inner | IAM Key Figures App Costs | |
| APS_IAM_TUSR_CAT_VH | view | left_outer | Available Technical User Categories | |
| aps_iam_tusr_ddl | view | from | Technical User | |
| CUAN_ME_ME_QR_AUTH_USER_SEARCH | view | inner | CUAN_ME_ME_QR_AUTH_USER_SEARCH | |
| I_APS_IAM_USERS_CORE | view | from | Business Users assigned to Group Core | |
| I_MKT_UserAuthority | view | inner | BASIC | User Authority |
| 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 |
| I_UserBasic | view_entity | from | BASIC | Benutzer |
| P_BPUsrAssignment | view_entity | from | BASIC | Business User - User Assignment |
| P_BPUsrDetail | view_entity | inner | BASIC | Business User - User Detail |
| P_BPUsrEEWASmtpSrch | view_entity | inner | BASIC | Workplace Address Smtp Srch (BUM) |
| P_DDMRPController | view_entity | left_outer | BASIC | MRP Controller Details |
| 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 | Allgemeiner CDS View für Adresse |
| P_USERCREATIONTIMESTAMPS | view_entity | inner | Retrieve user creation timestamps from change documents | |
| 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_GAF_USER_F4_X | view_entity | inner | GAF Value Help for Users (Helper) | |
| SAIS_USER_F4_X | view_entity | inner | BC-SEC Value Help for Users (Helper) | |
| SAIS_USER_VALID_STATE | view_entity | from | SUIM | Get User Valid Status | |
| SUIM__USR_VAL_4_FLD_X | view_entity | from | SUIM | Get Authorization Values | |
| SUIM_GET_CR_USR_ATTRIB | view_entity | from | SUIM|User Attr. for Crit.-Auth. | |
| 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_S_USER_GRP | view_entity | from | SUIM|List granted User Ids for ACTVT 03 | |
| SUIM_SECPOL_ATTR | view_entity | from | Attributs of SecPol | |
| SUIM_SECPOL_VIEW | view_entity | left_outer | Get Profil Parameter for Users | |
| SUIM_START_CHECK_FOR_TCD | view_entity | inner | Authority Check for TCODE Start | |
| SUIM_US_DOCU | view_entity | from | SUIM | Get User Documentation List | |
| SUIM_USER_VALID_STATE | view_entity | from | SUIM | Get User Valid Status | |
| 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 (45)
| 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 | ||
| usr_created_on_datetime | susr_creation_timestamp |