S_MyInboxUser

DDL: S_MYINBOXUSER SQL: SMYINBOXUSER Type: view

Users with My Inbox OData Authorization

S_MyInboxUser is a CDS View that provides data about "Users with My Inbox OData Authorization" in SAP S/4HANA. It reads from 3 data sources (S_MyInboxProfile, S_MyInboxProfile, usrefus) and exposes 1 field.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
S_MyInboxProfile S_MyInboxProfile inner
S_MyInboxProfile S_MyInboxProfile inner
usrefus usrefus inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SMYINBOXUSER view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Users with My Inbox OData Authorization view

Fields (1)

KeyFieldSource TableSource FieldDescription
bnameasUserID 
@AbapCatalog.sqlViewName: 'SMYINBOXUSER'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Users with My Inbox OData Authorization'
define view S_MyInboxUser
  as select distinct from usrbf2 as _User
    inner join            S_MyInboxProfile on S_MyInboxProfile.Profile = _User.auth

{
  _User.bname as UserID
}
where
  _User.objct = 'S_SERVICE'
union
  select distinct from usrbf2
    inner join S_MyInboxProfile on S_MyInboxProfile.Profile = usrbf2.auth
    inner join usrefus          on usrbf2.bname = usrefus.refuser
  {
    usrefus.bname as UserID
  }
where
  usrbf2.objct like 'S_SERVICE'

Learn More