ViewProvFilterAnnotation

DDL: CVIEW_PROV_FILTER_ANNOTATION SQL: CVIEWPROVANNO Type: view

CDS View to filter based on annotation

ViewProvFilterAnnotation is a CDS View that provides data about "CDS View to filter based on annotation" in SAP S/4HANA. It reads from 2 data sources (ddheadanno, ddldependency) and exposes 5 fields.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
ddheadanno head from
ddldependency obj inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CVIEWPROVANNO view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.type #CLIENT_INDEPENDENT view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #NONE view
EndUserText.label CDS View to filter based on annotation view

Fields (5)

KeyFieldSource TableSource FieldDescription
ddlname ddldependency ddlname
entityname ddheadanno strucobjn
annoname ddheadanno name
position ddheadanno position
value ddheadanno value 
@AbapCatalog.sqlViewName: 'CVIEWPROVANNO'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@ClientHandling.type: #CLIENT_INDEPENDENT
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #NONE
@EndUserText.label: 'CDS View to filter based on annotation'

define view ViewProvFilterAnnotation
  as select from ddheadanno    as head
    inner join   ddldependency as obj on  head.strucobjn = obj.objectname
                                      and obj.objecttype = 'STOB'
                                      and obj.state      = 'A'
{
  obj.ddlname    as ddlname,
  head.strucobjn as entityname,
  head.name      as annoname,
  head.position  as position,
  head.value     as value
}
where head.name like '%VIEWMODELREPLICATION.ENABLED%' and head.value != 'false'

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

Learn More