Pfcg_Role_To_User

DDL: PFCG_ROLE_TO_USER SQL: PFCGROLE2USER_V Type: view Package: S_PROFGEN_CDS

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. Part of development package S_PROFGEN_CDS.

2 data source(s) 9 fields

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
KEY role_name agr_users agr_name
KEY valid_from agr_users from_dat
KEY valid_to agr_users to_dat
user_name
KEY role_name Agr_Users_Usrefus role_name
KEY valid_from Agr_Users_Usrefus valid_from
KEY valid_to Agr_Users_Usrefus valid_to
_usrclassAssociation 
@AbapCatalog.sqlViewName: 'PFCGROLE2USER_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Assigmnt:PFCGRoleName-User(incl.RefUser)'
--do not use within BASIC developement
--only usable for application development
define view Pfcg_Role_To_User
  as select from agr_users as user
  association [1] to Usr02_Class as _usrclass on $projection.user_name = _usrclass.bname
{
  key user.uname    as user_name,
  key user.agr_name as role_name,
  key user.from_dat as valid_from,
  key user.to_dat   as valid_to,
      _usrclass       --Association

}
where user.exclude = ''
union select from Agr_Users_Usrefus as ref_user
association [1] to Usr02_Class as _usrclass on $projection.user_name = _usrclass.bname
{
  key ref_user.user_name,
  key ref_user.role_name,
  key ref_user.valid_from,
  key ref_user.valid_to,
      _usrclass       --Association
}

Learn More