P_USR_AUTH_PROF

DDL: P_USR_AUTH_PROF SQL: PUSRAUTHPROF Type: view

User with Profiles or Authorizations

P_USR_AUTH_PROF is a CDS View that provides data about "User with Profiles or Authorizations" in SAP S/4HANA. It reads from 7 data sources and exposes 13 fields.

7 data source(s) 13 fields

Data Sources (7)

SourceAliasJoin Type
usr10 usr10 left_outer
usr10 usr10 inner
usr11 usr11 left_outer
usr11 usr11 left_outer
ust04 ust04 inner
ust10s ust10s left_outer
ust10s ust10s inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSRAUTHPROF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User with Profiles or Authorizations view

Fields (13)

KeyFieldSource TableSource FieldDescription
bname ust04 bname
profile ust04 profile
objct ust10s objct
auth ust10s auth
refuser
typ usr10 typ
bname
profile ust04 profile
objct ust10s objct
auth ust10s auth
refuser usrefus refuser
typ usr10 typ
ptext usr11 ptext 
@AbapCatalog.sqlViewName: 'PUSRAUTHPROF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'User with Profiles or Authorizations'
define view P_USR_AUTH_PROF
  as select distinct from ust04
    left outer join       ust10s on ust10s.profn = ust04.profile
    left outer join       usr10  on ust04.profile = usr10.profn
    left outer join       usr11  on  usr11.profn = ust04.profile
                                 and usr11.langu = $session.system_language
                                 and usr11.aktps = 'A'

{
  ust04.bname,
  ust04.profile,
  ust10s.objct,
  ust10s.auth,
  cast( '' as us_refus ) as refuser,
  usr10.typ,
  usr11.ptext
}
union select distinct from usrefus
  inner join               ust04  on usrefus.refuser = ust04.bname
  inner join               ust10s on ust10s.profn = ust04.profile
  inner join               usr10  on ust04.profile = usr10.profn
  left outer join          usr11  on  usr11.profn = ust04.profile
                                  and usr11.langu = $session.system_language
                                  and usr11.aktps = 'A'
{
  usrefus.bname,
  ust04.profile,
  ust10s.objct,
  ust10s.auth,
  usrefus.refuser,
  usr10.typ,
  usr11.ptext
}
where
  usrefus.refuser <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR10",
"USR11",
"USREFUS",
"UST04",
"UST10S"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More