P_UserObjectAuth

DDL: P_USEROBJECTAUTH SQL: PUSEROBJECTAUTH Type: view Package: SUSR

Users with Object and Authorization

P_UserObjectAuth is a CDS View that provides data about "Users with Object and Authorization" in SAP S/4HANA. It reads from 4 data sources (usrefus, ust04, ust10s, ust10s) and exposes 7 fields. Part of development package SUSR.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
usrefus usrefus left_outer
ust04 ust04 left_outer
ust10s ust10s left_outer
ust10s ust10s left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSEROBJECTAUTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Users with Object and Authorization view

Fields (7)

KeyFieldSource TableSource FieldDescription
bname ust04 bname
profile ust04 profile
objct ust10s objct
bname
profile ust04 profile
objct ust10s objct
auth ust10s auth 
@AbapCatalog.sqlViewName: 'PUSEROBJECTAUTH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Users with Object and Authorization'
define view P_UserObjectAuth
  as select distinct from ust04
  left outer join ust10s on ust04.profile = ust10s.profn
{
  ust04.bname,
  ust04.profile,
  ust10s.objct,
  ust10s.auth

}
union all

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    ust10s  on ust04.profile = ust10s.profn

{
  ust04.bname,
  ust04.profile,
  ust10s.objct,
  ust10s.auth
}

Learn More