DEMO_CDS_VIEW_ENTITY_HAVING

DDL: DEMO_CDS_VIEW_ENTITY_HAVING Type: view_entity

DEMO_CDS_VIEW_ENTITY_HAVING is a CDS View in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 3 fields.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
ID
col_count
seatsmax seatsmax 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity DEMO_CDS_VIEW_ENTITY_HAVING
  as select from sflight
  {
    concat_with_space(carrid, connid, 1) as ID,
    count(*)                             as col_count,
    seatsmax
  }
  group by
    carrid,
    connid,
    seatsmax
  having
    seatsmax > abap.int2'500'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More