Pfcg_Role_To_User

DDL: PFCG_ROLE_TO_USER SQL: PFCGROLE2USER_V Type: view
9 Fields 2 Data Sources 1 Associations

Assigmnt:PFCGRoleName-User(incl.RefUser)

Pfcg_Role_To_User is a CDS View that provides data about "Assigmnt:PFCGRoleName-User(incl.RefUser)" in SAP S/4HANA. It reads from 2 data sources (Agr_Users_Usrefus, agr_users) and exposes 9 fields with key fields user_name, role_name, valid_from, valid_to, role_name. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
Agr_Users_Usrefus ref_user union
agr_users user from

Associations (1)

CardinalityTargetAliasCondition
[1] Usr02_Class _usrclass $projection.user_name = _usrclass.bname

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PFCGROLE2USER_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assigmnt:PFCGRoleName-User(incl.RefUser) view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY user_name agr_users uname User Name
KEY role_name agr_users agr_name Role Name
KEY valid_from agr_users from_dat Validity Start Time
KEY valid_to agr_users to_dat Validity End Time
user_name User Name
KEY role_name Agr_Users_Usrefus role_name Role Name
KEY valid_from Agr_Users_Usrefus valid_from Validity Start Time
KEY valid_to Agr_Users_Usrefus valid_to Validity End Time
_usrclassAssociation

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 Pfcg_Role_To_User.
-- 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: PFCGROLE2USER_V

CREATE VIEW Pfcg_Role_To_User AS
SELECT
  user.uname AS user_name,
  user.agr_name AS role_name,
  user.from_dat AS valid_from,
  user.to_dat AS valid_to
FROM agr_users AS user
LEFT OUTER JOIN Usr02_Class AS _usrclass ON user_name = _usrclass.bname  -- association [1]
-- UNION with additional select branch(es): Agr_Users_Usrefus
;

Learn More