P_USER_ROLE

DDL: P_USER_ROLE SQL: PUSERROLE Type: view Package: SUSR
17 Fields 5 Data Sources

Get roles for users with reference user

P_USER_ROLE is a CDS View that provides data about "Get roles for users with reference user" in SAP S/4HANA. It reads from 5 data sources (agr_texts, agr_texts, agr_users, agr_users, usrefus) and exposes 17 fields with key field bname. Part of development package SUSR.

Data Sources (5)

SourceAliasJoin Type
agr_texts agr_texts left_outer
agr_texts agr_texts left_outer
agr_users agr_users inner
agr_users agr_users inner
usrefus usrefus inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSERROLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get roles for users with reference user view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY bname usr02 bname User name
class usr02 class User Group
agr_name agr_users agr_name Role
refuser Reference user
from_dat agr_users from_dat Start date
to_dat agr_users to_dat End date
col_flag agr_users col_flag Assgmt Comes From Composite Role
org_flag agr_users org_flag HR Org Mgt
bname User name
class usr02 class User Group
agr_name agr_users agr_name Role
refuser usrefus refuser Reference user
from_dat agr_users from_dat Start date
to_dat agr_users to_dat End date
col_flag agr_users col_flag Assgmt Comes From Composite Role
org_flag agr_users org_flag HR Org Mgt
text agr_texts text User Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_USER_ROLE.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PUSERROLE

CREATE VIEW P_USER_ROLE AS
SELECT
  usr02.bname AS bname,
  usr02.class AS class,
  agr_users.agr_name AS agr_name,
  cast( '' as us_refus ) AS refuser,
  agr_users.from_dat AS from_dat,
  agr_users.to_dat AS to_dat,
  agr_users.col_flag AS col_flag,
  agr_users.org_flag AS org_flag,
  agr_texts.text AS text
INNER JOIN agr_users ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN agr_texts ON /* join condition not captured in parsed metadata */
INNER JOIN usrefus ON /* join condition not captured in parsed metadata */
;

Learn More