Accessible_Views_Comp

DDL: ACCESSIBLE_VIEWS_COMP SQL: ACCESSVIEWSCOMP Type: view Package: S_DICT_VB

Accessible Views - S_RS_COMP validation

Accessible_Views_Comp is a CDS View that provides data about "Accessible Views - S_RS_COMP validation" in SAP S/4HANA. It reads from 3 data sources (CDS_VIEW_FIRST_REFERENCE, ust12, ust12) and exposes 2 fields. Part of development package S_DICT_VB.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
CDS_VIEW_FIRST_REFERENCE allViews inner
ust12 compID inner
ust12 infoCube inner

Parameters (1)

NameTypeDefault
P_User syuname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACCESSVIEWSCOMP view
EndUserText.label Accessible Views - S_RS_COMP validation view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
CSQLViewName CDS_VIEW_FIRST_REFERENCE CSQLViewName
SqlViewName CDS_VIEW_FIRST_REFERENCE SqlViewName 
@AbapCatalog.sqlViewName: 'ACCESSVIEWSCOMP'
@EndUserText.label: 'Accessible Views - S_RS_COMP validation'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Accessible_Views_Comp 
with parameters P_User: syuname
as select distinct from Auth_Profiles(P_User : $parameters.P_User ) as validRSComp

  inner join ust12 as compID
  on compID.auth = validRSComp.Authorization_Profile and validRSComp.Authorization_Object = 'S_RS_COMP'
  and compID.field = 'RSZCOMPID'
  
  inner join ust12 as infoCube
  on infoCube.auth = compID.auth and infoCube.objct = compID.objct and infoCube.field = 'RSINFOCUBE'
  
  inner join CDS_VIEW_FIRST_REFERENCE as allViews 
  on ((infoCube.von = '*' or infoCube.von = '2C*' or allViews.CreferredObject = infoCube.von) 
    and (compID.von = '*' or compID.von = '2C*' or compID.von = allViews.CSQLViewName)) {
    allViews.CSQLViewName,
    allViews.SqlViewName
  }

Learn More