DEMO_CDS_AGGREGATE: CDS DDIC-based view, aggregates

DEMO_CDS_AGGREGATE is the Unknown CDS view, which provides access to the CDS DDIC-based view, aggregates data in SAP S/HANA system. Core Data Services (CDS) views are semantically rich data models that provide efficient in-built functions such as aggregations, annotations, and conceptual associations.

This CDS view is found in the Demos for ABAP Documentation, not for Production Use (SABAPDEMOS) package and is part of the ABAP Syntax, Compiler, Runtime (BC-ABA-LA) module.

CDS View DEMO_CDS_AGGREGATE
DDL SQL View DEMO_CDS_AGG
Status Released
CDS View Type Unknown
Package SABAPDEMOS
Technical Component BC-ABA-LA

You can create custom CDS views for released views and expose them as a read-only OData service that delivers data tailored to the needs of your external application.

Tables Used

The following are the SAP HANA table(s) used to develop this CDS view

We’re updating the content all the time, so check back regularly.

CDS View Fields

The following is the list of fields available in the CDS view and key fields are highlighted in color:

CDS View Field Text SQL View/Table Table Field Data Type Length
MANDT Client SPFLI MANDT CLNT 3
CARRID Airline Code SPFLI CARRID CHAR 3
CONNID Flight Connection Number SPFLI CONNID NUMC 4

CDS View Annotaions

The following are the CDS View Annotations used in this CDS view:

CDS Annotation Name CDS Annotation Value
ABAPCATALOG.VIEWENHANCEMENTCATEGORY$1$ #PROJECTION_LIST
ABAPCATALOG.SQLVIEWNAME ‘DEMO_CDS_AGG’
ACCESSCONTROL.AUTHORIZATIONCHECK #NOT_REQUIRED
ABAPCATALOG.VIEWENHANCEMENTCATEGORY$2$ #GROUP_BY

Availability

The CDS view DEMO_CDS_AGGREGATE is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Released
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

Supported Capabilities

It is possible for a single CDS view to provide many capabilities such as a data source, association target, or analytical provider. Supported Capabilities indicates clear use cases for CDS views and provides an idea of the most efficient ways to use a CDS view. Each CDS view can have multiple supported capabilities.

Supported Capabilities are not defined for this CDS view.

Extensibility

Coming Soon!!

Related CDS Views

Coming Soon!!