DEMO_CDS_SFLIGHT_VE

DDL: DEMO_CDS_SFLIGHT_VE Type: view_entity Package: SABAP_DEMOS_ABAP_CDS_CLOUD
13 Fields 1 Data Sources

CDS view entity, sflight

DEMO_CDS_SFLIGHT_VE is a CDS View that provides data about "CDS view entity, sflight" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 13 fields with key fields Carrid, Connid, Fldate. Part of development package SABAP_DEMOS_ABAP_CDS_CLOUD.

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view entity, sflight view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Carrid carrid Carrier
KEY Connid connid Flight Number
KEY Fldate fldate Flight Date
Price price RVP f.PricePro.
Currency currency Valuation Crcy
Planetype planetype Planetype
Seatsmax seatsmax Max. Seats
Seatsocc seatsocc Occupied Econ.
Paymentsum paymentsum Total
SeatsmaxB seatsmax_b Max. Capacity Bus.
SeatsoccB seatsocc_b Occupied Bus.
SeatsmaxF seatsmax_f Max. Capacity 1st
SeatsoccF seatsocc_f Occupied 1st

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view DEMO_CDS_SFLIGHT_VE.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW DEMO_CDS_SFLIGHT_VE AS
SELECT
  Carrid,
  Connid,
  Fldate,
  Price,
  Currency,
  Planetype,
  Seatsmax,
  Seatsocc,
  Paymentsum,
  seatsmax_b AS SeatsmaxB,
  seatsocc_b AS SeatsoccB,
  seatsmax_f AS SeatsmaxF,
  seatsocc_f AS SeatsoccF
FROM sflight
;

Learn More