AGR_USERS_USREFUS

CDS View

User-Role Assignment for ref. User

AGR_USERS_USREFUS is a CDS View in S/4HANA. User-Role Assignment for ref. User. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Pfcg_Role_To_User view union Assigmnt:PFCGRoleName-User(incl.RefUser)

Fields (3)

KeyField CDS FieldsUsed in Views
KEY role_name role_name 1
KEY valid_from valid_from 1
KEY valid_to valid_to 1 
@AbapCatalog.sqlViewName: 'AGR_USREFUS_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'User-Role Assignment for ref. User'
--do not use within BASIC developement
--only usable for application development
define view Agr_Users_Usrefus
  as select from usrefus   as ref_user
    inner join   agr_users as role_to_user on ref_user.refuser = role_to_user.uname
{
  key ref_user.bname        as user_name,
  key role_to_user.agr_name as role_name,
  key role_to_user.from_dat as valid_from,
  key role_to_user.to_dat   as valid_to
}
where role_to_user.exclude = ''

Learn More