ANA_AQD_ANNO_DATACATEGORY

DDL: ANA_AQD_ANNO_DATACATEGORY SQL: ANA_AQD_DATAC Type: view

CDS view to filter on header annotation

ANA_AQD_ANNO_DATACATEGORY is a CDS View that provides data about "CDS view to filter on header annotation" in SAP S/4HANA. It reads from 1 data source (ddheadanno) and exposes 3 fields. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
ddheadanno a_ddheadanno from

Parameters (1)

NameTypeDefault
p_datacategory abap.char(10)

Associations (1)

CardinalityTargetAliasCondition
[0..1] ANA_AQD_ENDUSERLABEL _enduserlabel _enduserlabel.name = a_ddheadanno.strucobjn

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ANA_AQD_DATAC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view to filter on header annotation view

Fields (3)

KeyFieldSource TableSource FieldDescription
name ddheadanno strucobjn
description _enduserlabel description
type ddheadanno value 
// ****************

// This CDS view returns the datasource which have the datacategory matching the parameter passed.


// Parameter Definition:

//   - p_datacategory: Data category of the views (#CUBE / #DIMENSION)

// Annotation ex:

//     "ANALYTICS.DATACATEGORY:#CUBE"

//

// *******************


@AbapCatalog.sqlViewName: 'ANA_AQD_DATAC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#NOT_REQUIRED
@EndUserText.label: 'CDS view to filter on header annotation'
define view ANA_AQD_ANNO_DATACATEGORY
  with parameters
    p_datacategory : abap.char(10)

  as select from ddheadanno as a_ddheadanno
  association [0..1] to ANA_AQD_ENDUSERLABEL as _enduserlabel on _enduserlabel.name = a_ddheadanno.strucobjn


{

  a_ddheadanno.strucobjn as name,
  _enduserlabel.description,
  a_ddheadanno.value     as type
}
where
      a_ddheadanno.value = :p_datacategory

  and a_ddheadanno.name  = 'ANALYTICS.DATACATEGORY';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANA_AQD_ENDUSERLABEL",
"DDHEADANNO"
],
"ASSOCIATED":
[
"ANA_AQD_ENDUSERLABEL"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More