AGR_USERS
Zuordnung Rollen zu Benutzern
AGR_USERS is an SAP database table in S/4HANA. Zuordnung Rollen zu Benutzern. It contains 11 fields. 16 CDS views read from this table.
CDS Views using this table (16)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Agr_Users_Usrefus | view | inner | User-Role Assignment for ref. User | |
| aps_iam_brole_user_pfcg_pub | view_entity | inner | IAM: Business Role - User - PFCG | |
| aps_iam_cusr_asc_ddl | view | from | IAM Communication Scenarios of Users | |
| C_SuplrActyPotntlEmplRespVH | view | inner | CONSUMPTION | Potential resp.employees for an activity |
| FCLM_BAM_SHLP_REVIEWER | view | left_outer | Search help for reviewer | |
| I_PPM_AuthznByUserRoleH | view | inner | BASIC | Project Authorizations by User Role |
| P_PPM_LocalAuthorizations | view | inner | BASIC | Local Authorizations (Activities not yet resolved) |
| P_USER_ROLE | view | inner | Get roles for users with reference user | |
| P_UserRoles | view_entity | from | User role assignments | |
| P_USR_AUTH_ROLE | view | inner | User with Roles or Authorizations | |
| Pfcg_Role_To_User | view | from | Assigmnt:PFCGRoleName-User(incl.RefUser) | |
| SUIM_ACGR_SUPO_INFO_X | view_entity | left_outer | SUIM | help view for view entity SUIM_ACHR_SUPO_INFO | |
| SUIM_AGR_USR_CNT | view_entity | from | SUIM | Count of Assigned Users per Role | |
| SUIM_AGR_VALID_USER_CNT | view_entity | from | SUIM | Count of valid user in role | |
| SUIM_AGR_WITH_TCD | view | from | SUIM - Get (assigned) roles with tcode | |
| SUIM_PFCG_HEAD_WUSR | view_entity | inner | SUIM | Role Header with Assigned User |
Fields (11)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | symandt | |
| KEY | agr_name | agr_name | |
| KEY | uname | xubname | |
| KEY | from_dat | agr_fdate | |
| KEY | to_dat | agr_tdate | |
| exclude | agr_excl | ||
| change_dat | menu_date | ||
| change_tim | menu_time | ||
| change_tst | rstimestmp | ||
| org_flag | agr_org | ||
| col_flag | agr_col |