P_USER_COMPOSITE_PROF

DDL: P_USER_COMPOSITE_PROF SQL: PUSRPROFC Type: view

Get Profiles for users

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

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
usr10 usr10 left_outer
usr10 usr10 left_outer
usrefus usrefus left_outer
ust04 ust04 left_outer
ust04 ust04 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSRPROFC 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: 'PUSRPROFC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get Profiles for users'
define view P_USER_COMPOSITE_PROF
  as select distinct from usr02
    left outer join       ust04 on usr02.bname = ust04.bname
    left outer join       usr10 on ust04.profile = usr10.profn
{
  usr02.bname,
  @Consumption.hidden: true
  usr02.class, // Do not export usergroup!

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

  ust04.profile
}
where
  usr10.typ = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR02",
"USR10",
"USREFUS",
"UST04"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More