ViewProvWhiteListedCdsView

DDL: CVIEW_PROV_WHITELISTED_CDSVIEW SQL: CVIEWPROVCDSVIEW Type: view

View Provision Whitelist 1711

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

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
ViewProvFilterAnnotation _anno left_outer
ARS_APIS_RELEASED_FOR_C1 _assignment inner
ddddlsrct _dddlsrc inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVCDSVIEW 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 1711 view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ViewName _wCdsView cds_view
Description ddddlsrct ddtext 
@AbapCatalog.sqlViewName: 'CVIEWPROVCDSVIEW'
@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 1711'
define view ViewProvWhiteListedCdsView
  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
    inner join            ddddlsrct                as _dddlsrc    on _dddlsrc.ddlname = _wCdsView.cds_view 
    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
}
where
      _dddlsrc.ddlanguage = 'E'

Learn More