DEMO_CDS_AGGREGATES_VE

DDL: DEMO_CDS_AGGREGATES_VE Type: view_entity

DEMO_CDS_AGGREGATES_VE is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
count1
countNull 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity DEMO_CDS_AGGREGATES_VE
  as select from scarr
{
  count( distinct case carrid when 'LH' then 'LH' end ) as count1,

  count( distinct case carrid when 'XX' then 'LH' end ) as countNull
}
where
  carrid = 'LH'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SCARR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More