Cds_Field_Annotation_Query

DDL: CDS_FIELD_ANNOTATION_QUERY SQL: CDSFIELDANNOQRY Type: view

CDS Field Annotations Query

Cds_Field_Annotation_Query is a CDS View that provides data about "CDS Field Annotations Query" in SAP S/4HANA. It reads from 3 data sources (ddddlsrc, ddfieldanno, ddldependency) and exposes 6 fields with key fields DDLSourceName, CDSName, FieldName, AnnotationName.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
ddddlsrc ddddlsrc from
ddfieldanno ddfieldanno left_outer
ddldependency ddldependency inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CDSFIELDANNOQRY view
EndUserText.label CDS Field Annotations Query view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddddlsrc ddlname
KEY CDSName ddfieldanno strucobjn
KEY FieldName ddfieldanno lfieldname
KEY AnnotationName ddfieldanno name
AnnotationValue ddfieldanno value
ActualPosition ddfieldanno position 
@AbapCatalog.sqlViewName: 'CDSFIELDANNOQRY'
@EndUserText.label: 'CDS Field Annotations Query'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #B
@ObjectModel.usageType.sizeCategory:  #M
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_Field_Annotation_Query 
 as select from ddddlsrc
inner join ddldependency
on ddddlsrc.ddlname = ddldependency.ddlname
and ddddlsrc.as4local = 'A' and ddldependency.state = 'A' and ddldependency.objecttype = 'STOB'
left outer join ddfieldanno
on ddldependency.objectname = ddfieldanno.strucobjn
//and ddfieldanno.AnnotationName = 'ANALYTICS.QUERY' and Cds_View_Annotation.AnnotationValue = 'true'

 {
key ddddlsrc.ddlname as DDLSourceName, 
key ddfieldanno.strucobjn as CDSName,
key ddfieldanno.lfieldname as FieldName,
key ddfieldanno.name as AnnotationName,
ddfieldanno.value as AnnotationValue,
ddfieldanno.position as ActualPosition
} where ddfieldanno.name != '' and ddfieldanno.value != ''

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

Learn More