P_PROF_PAR_REF

DDL: P_PROF_PAR_REF SQL: PPROFPARREF Type: view

Profiles with Parameter for ref.users

P_PROF_PAR_REF is a CDS View that provides data about "Profiles with Parameter for ref.users" in SAP S/4HANA. It reads from 2 data sources (usrefus, ust04) and exposes 4 fields.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
usrefus usrefus inner
ust04 ust04 inner

Parameters (1)

NameTypeDefault
prof xuprofile

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPROFPARREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Profiles with Parameter for ref.users view

Fields (4)

KeyFieldSource TableSource FieldDescription
bname usr02 bname
class usr02 class
refuser usrefus refuser
profile ust04 profile 
@AbapCatalog.sqlViewName: 'PPROFPARREF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Profiles with Parameter for ref.users'
define view P_PROF_PAR_REF
  with parameters
    prof : xuprofile
  as select distinct from usr02
    inner join            usrefus on usr02.bname = usrefus.bname
  inner join  ust04 on ust04.bname = usrefus.refuser
{
  usr02.bname,
@Consumption.hidden: true
  usr02.class, // Do not export usergroup!  

  usrefus.refuser,
  ust04.profile
}
where
  ust04.profile = $parameters.prof

Learn More