P_PROF

DDL: P_PROF SQL: PPROF Type: view

Get Profiles for users

P_PROF is a CDS View that provides data about "Get Profiles for users" in SAP S/4HANA. It reads from 3 data sources (usrefus, ust04, ust04) and exposes 5 fields.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
usrefus usrefus left_outer
ust04 ust04 left_outer
ust04 ust04 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPROF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get Profiles for users view

Fields (5)

KeyFieldSource TableSource FieldDescription
bname usr02 bname
class usr02 class
bname
class usr02 class
profile ust04 profile 
@AbapCatalog.sqlViewName: 'PPROF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get Profiles for users'
define view P_PROF
  as select distinct from usr02
    left outer join       ust04 on usr02.bname = ust04.bname
{
  usr02.bname,
@Consumption.hidden: true
  usr02.class, // Do not export usergroup!    

  ust04.profile
}
union select distinct from usr02
  left outer join          usrefus on usr02.bname = usrefus.bname
  left outer join          ust04   on usrefus.refuser = ust04.bname
{
  usr02.bname,
@Consumption.hidden: true
  usr02.class, // Do not export usergroup!    

  ust04.profile
}

Learn More