CDS Views for AGR_USERS table
Overview
AGR_USERS is a standard SAP S/4HANA table that stores Assignment of roles to users data. The following is a list of CDS Views for AGR_USERS table.
A CDS view is a CDS entity that implements a view and is defined in a CDS data definition. They are defined for existing database tables, views, or other non-abstract CDS entities.
Using CDS views, you can rearrange and rename table fields to meet application-specific requirements. They are used to define rich semantic data models.
AGR_USERS CDS Views
The following table gives you an overview of the released standard CDS views for AGR_USERS table in S/4HANA 2020.
| CDS View Name | SQL View Name | Description |
|---|---|---|
| AGR_USERS_USREFUS | AGR_USREFUS_V | User to Role Assignment (based on role name) |
| I_ACMROLEASSIGNMENTFORUSER | IACMUSRROLASGNT | Interface layer for role assigned to the user |
| I_PPM_AUTHZNBYUSERROLEH | IPPMAUTHZNUSRRLH | Project Authorizations by User Role |
| PFCG_ROLE_TO_USER | PFCGROLE2USER_V | Assigment of PFCG Role to User (incl. Ref.User) |
| P_PPM_AUTHORIZATIONBYUSERROLE | PPPMAUTHUSRROLE | PPM Object Authorization for a user by role assignment |
| P_PPM_LOCALAUTHORIZATIONS | PPPMLOCALAUTH | Local Authorizations (Activities not yet resolved) |
| P_USER_ROLE | PUSERROLE | Get Roles for Users with Reference User |
| P_USR_AUTH_ROLE | PUSRAUTHROLE | User with Profiles or Authorizations |
| FCLM_BAM_SHLP_REVIEWER | V_FCLMREVIEWER | Search help for reviewer |