ViewProvWhiteListedCds

DDL: CVIEW_PROV_WHITELISTED_CDS SQL: CVIEWPROVWHLST Type: view

View Provision Whitelist

ViewProvWhiteListedCds is a CDS View that provides data about "View Provision Whitelist" in SAP S/4HANA. It reads from 3 data sources (ViewProvFilterAnnotation, ARS_APIS_RELEASED_FOR_C1, ddddlsrct) and exposes 5 fields with key field ViewName.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
ViewProvFilterAnnotation _anno left_outer
ARS_APIS_RELEASED_FOR_C1 _assignment inner
ddddlsrct _dddlsrc left_outer

Parameters (1)

NameTypeDefault
p_ddlanguage ddlanguage

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVWHLST view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_INDEPENDENT view
ClientHandling.algorithm #NONE view
EndUserText.label View Provision Whitelist view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ViewName _wCdsView cds_view
Description ddddlsrct ddtext
p_ddlanguagekeyViewName
Description Description
ViewAnnotation 
@AbapCatalog.sqlViewName: 'CVIEWPROVWHLST'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_INDEPENDENT
@ClientHandling.algorithm: #NONE
@EndUserText.label: 'View Provision Whitelist'
define view ViewProvWhiteListedCds
  with parameters
    p_ddlanguage : ddlanguage
  as select distinct from ddlsview_wl              as _wCdsView
    inner join            ARS_APIS_RELEASED_FOR_C1 as _assignment on _assignment.tadir_obj_name = _wCdsView.cds_view
    left outer join       ddddlsrct                as _dddlsrc    on  _dddlsrc.ddlname    = _wCdsView.cds_view
                                                                  and _dddlsrc.ddlanguage = $parameters.p_ddlanguage
    left outer join       ViewProvFilterAnnotation as _anno       on _anno.ddlname = _wCdsView.cds_view
{
  key _wCdsView.cds_view as ViewName,
      _dddlsrc.ddtext    as Description,
      case _anno.value
      when 'false' then 'Disabled'
      else 'Enabled'
      end                as ViewAnnotation
}

union

select distinct from ViewProvAnnotatedCDSViews( p_ddlanguage:$parameters.p_ddlanguage )
{
  key ViewName,
      Description,
      cast( ViewAnnotation  as abap.char( 8 ) ) as ViewAnnotation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_APIS_RELEASED_FOR_C1",
"VIEWPROVANNOTATEDCDSVIEWS",
"VIEWPROVFILTERANNOTATION",
"DDDDLSRCT",
"DDLSVIEW_WL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More