DEMO_CDS_JOIN2: CDS DDIC-based view, association

DEMO_CDS_JOIN2 is the CDS view, which provides access to the CDS DDIC-based view, association 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_JOIN2
DDL SQL View DEMO_CDS_JN2
Status Released
CDS View Type
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

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
CARRIER Airline name SCARR CARRNAME CHAR 20
FLIGHT Flight Connection Number SPFLI CONNID NUMC 4
DEPARTURE Departure city SPFLI CITYFROM CHAR 20
ARRIVAL Arrival city SPFLI CITYTO CHAR 20

CDS View Annotaions

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

CDS Annotation Name CDS Annotation Value
ABAPCATALOG.SQLVIEWNAME ‘DEMO_CDS_JN2’
ACCESSCONTROL.AUTHORIZATIONCHECK #NOT_REQUIRED
ACCESSCONTROL.AUTHORIZATIONCHECK #NOT_REQUIRED
ABAPCATALOG.SQLVIEWNAME ‘DEMO_CDS_JN2’

Availability

The CDS view DEMO_CDS_JOIN2 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

Supported Capabilities are NOT defined for this CDS view.

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.

Extensibility

Coming Soon!!

Related CDS Views

Coming Soon!!