Accessible_Views

DDL: ACCESSIBLE_VIEWS SQL: ACCESSIBLEVIEWS Type: view Package: S_DICT_VB

Accessible views(START auth checked)

Accessible_Views is a CDS View that provides data about "Accessible views(START auth checked)" in SAP S/4HANA. It reads from 5 data sources (Accessible_Views_Comp, CDS_VIEW_FIRST_REFERENCE, ust12, ust12, ust12) and exposes 1 field. Part of development package S_DICT_VB.

5 data source(s) 1 fields

Data Sources (5)

SourceAliasJoin Type
Accessible_Views_Comp Accessible_Views_Comp inner
CDS_VIEW_FIRST_REFERENCE allViews inner
ust12 compID inner
ust12 ddlname inner
ust12 ddlscrname inner

Parameters (1)

NameTypeDefault
P_User syuname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACCESSIBLEVIEWS view
EndUserText.label Accessible views(START auth checked) view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (1)

KeyFieldSource TableSource FieldDescription
SqlViewName 
@AbapCatalog.sqlViewName: 'ACCESSIBLEVIEWS'
@EndUserText.label: 'Accessible views(START auth checked)'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Accessible_Views 
with parameters P_User: syuname

as select distinct from Auth_Profiles(P_User : $parameters.P_User ) as validRSComp1

  inner join ust12 as compID
  on compID.auth = validRSComp1.Authorization_Profile and validRSComp1.Authorization_Object = 'S_RS_COMP1'
  and compID.field = 'RSZCOMPID'
    
  inner join Accessible_Views_Comp( P_User:$parameters.P_User ) as allViews 
  on ((compID.von = '*' or compID.von = '2C*' or compID.von = allViews.csqlviewname)) {
    allViews.sqlviewname  
  }
 
union

select distinct from Auth_Profiles(P_User : $parameters.P_User ) as validRSComp

  inner join ust12 as ddlname
  on ddlname.auth = validRSComp.Authorization_Profile and validRSComp.Authorization_Object = 'SDDLVIEW'
  and ddlname.field = 'DDLNAME'
  
  inner join ust12 as ddlscrname
  on ddlscrname.auth = ddlname.auth and ddlscrname.objct = ddlname.objct and ddlscrname.field = 'DDLSRCNAME'
  
  inner join CDS_VIEW_FIRST_REFERENCE as allViews 
  on (allViews.ReferredObjectDDLSourceName = ddlscrname.von and allViews.ObjectDDLSourceName = ddlname.von) {
    allViews.SqlViewName
  }

Learn More