Agr_Users_Usrefus

DDL: AGR_USERS_USREFUS SQL: AGR_USREFUS_V Type: view

User-Role Assignment for ref. User

Agr_Users_Usrefus is a CDS View that provides data about "User-Role Assignment for ref. User" in SAP S/4HANA. It reads from 2 data sources (usrefus, agr_users) and exposes 4 fields with key fields user_name, role_name, valid_from, valid_to.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
usrefus ref_user from
agr_users role_to_user inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName AGR_USREFUS_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label User-Role Assignment for ref. User view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY user_name usrefus bname
KEY role_name agr_users agr_name
KEY valid_from agr_users from_dat
KEY valid_to agr_users to_dat 
@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 = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AGR_USERS",
"USREFUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More