P_PROF_PAR

DDL: P_PROF_PAR SQL: PPROFPAR Type: view

Profiles with Parameter

P_PROF_PAR is a CDS View that provides data about "Profiles with Parameter" in SAP S/4HANA. It reads from 1 data source (ust04) and exposes 3 fields.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
ust04 ust04 inner

Parameters (1)

NameTypeDefault
prof xuprofile

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPROFPAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Profiles with Parameter view

Fields (3)

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

  ust04.profile
}
where
  ust04.profile = $parameters.prof
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR02",
"UST04"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More