AGR_USERS
Assignment of roles to users
AGR_USERS is an SAP database table in S/4HANA. Assignment of roles to users. It contains 11 fields. 17 CDS views read from this table.
CDS Views using this table (17)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /AGIL/LUR_I_RoleNumberOfUsers | view | from | Number of Users in Role | |
| /AGIL/LUR_I_RoleUserObjAccess | view | inner | Role/User Auth Object Access | |
| /dmbe/I_User_Roles | view | from | Assignment of roles to users | |
| Agr_Users_Usrefus | view | inner | User-Role Assignment for ref. User | |
| C_SuplrActyPotntlEmplRespVH | view | inner | CONSUMPTION | Potential resp.employees for an activity |
| FCLM_BAM_SHLP_REVIEWER | view | left_outer | Search help for reviewer | |
| I_ACMRoleAssignmentForUser | view | from | BASIC | Interface layer for role assigned to the user |
| I_PPM_AuthznByUserRoleH | view | inner | BASIC | Project Authorizations by User Role |
| P_PPM_AuthorizationByUserRole | view | inner | BASIC | |
| P_PPM_LocalAuthorizations | view | inner | BASIC | |
| P_USER_ROLE | view | inner | Get roles for users with reference user | |
| P_USR_AUTH_ROLE | view | inner | User with Roles or Authorizations | |
| Pfcg_Role_To_User | view | from | Assigmnt:PFCGRoleName-User(incl.RefUser) | |
| 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 |