ViewProvAnnotatedCDSViews

DDL: CVIEW_PROVISIONING_ANNO_REPL SQL: ANOCDSVIEWS Type: view

CDS View Provisioning scope for annoted CDS views

ViewProvAnnotatedCDSViews is a CDS View that provides data about "CDS View Provisioning scope for annoted CDS views" in SAP S/4HANA. It reads from 2 data sources (ddddlsrct, ViewProvFilterAnnotation) and exposes 4 fields with key field ViewName.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
ddddlsrct _dddlsrc left_outer
ViewProvFilterAnnotation _vpa from

Parameters (1)

NameTypeDefault
p_ddlanguage ddlanguage

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ANOCDSVIEWS 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 CDS View Provisioning scope for annoted CDS views view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ViewName ViewProvFilterAnnotation ddlname
entityname ViewProvFilterAnnotation entityname
ViewAnnotation ViewProvFilterAnnotation annoname
Description ddddlsrct ddtext 
@AbapCatalog.sqlViewName: 'ANOCDSVIEWS'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_INDEPENDENT
@ClientHandling.algorithm: #NONE
@EndUserText.label: 'CDS View Provisioning scope for annoted CDS views'
define view ViewProvAnnotatedCDSViews 
with parameters
    p_ddlanguage : ddlanguage as select from ViewProvFilterAnnotation as _vpa
    left outer join       ddddlsrct                as _dddlsrc    on  _dddlsrc.ddlname    = _vpa.ddlname
                                                                  {

//ViewProvFilterAnnotation 

key _vpa.ddlname as ViewName, 
    _vpa.entityname, 
    _vpa.annoname as ViewAnnotation, 
    _dddlsrc.ddtext as Description
} where _dddlsrc.ddlanguage  = $parameters.p_ddlanguage and _dddlsrc.as4local = 'A'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VIEWPROVFILTERANNOTATION",
"DDDDLSRCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More