I_Sitn2DemoFlight

DDL: I_SITN2DEMOFLIGHT SQL: ISITN2DFLAP Type: view COMPOSITE
40 Fields 1 Data Sources 4 Associations

Flights for Situation Demo

I_Sitn2DemoFlight is a Composite CDS View that provides data about "Flights for Situation Demo" in SAP S/4HANA. It reads from 1 data source (R_Sitn2DemoFlight) and exposes 40 fields with key fields SitnDemoCarrierID, SitnDemoConnectionID, SitnDemoFlightDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_Sitn2DemoFlight R_Sitn2DemoFlight from

Associations (4)

CardinalityTargetAliasCondition
[0..1] R_Sitn2DemoFlightCalcFields _FlightAggr _FlightAggr.SitnDemoCarrierID = $projection.SitnDemoCarrierID and _FlightAggr.SitnDemoConnectionID = $projection.SitnDemoConnectionID and _FlightAggr.SitnDemoFlightDate = $projection.SitnDemoFlightDate
[0..1] R_Sitn2DemoCarrier _Carrier _Carrier.SitnDemoCarrierID = $projection.SitnDemoCarrierID
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.SitnDemoSeatsUnit = _UnitOfMeasure.UnitOfMeasure
[0..1] I_Currency _Currency $projection.SitnDemoCurrency = _Currency.Currency

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISITN2DFLAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Flights for Situation Demo view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY SitnDemoCarrierID SitnDemoCarrierID Carrier
KEY SitnDemoConnectionID SitnDemoConnectionID Flight Number
KEY SitnDemoFlightDate SitnDemoFlightDate Flight Date
SitnDemoFlightUniqueKey SitnDemoFlightUniqueKey Unique Flight Key
SitnDemoFlightIsScheduled SitnDemoFlightIsScheduled Scheduled
SitnDemoPlaneType SitnDemoPlaneType Planetype
SitnDemoSeatsUnit
SitnDemoSeatsMaxQty SitnDemoSeatsMaxQty Max. Seats
SitnDemoSeatsOccupiedQty SitnDemoSeatsOccupiedQty Occupied Econ.
SitnDemoSeatsMaxBusClQty SitnDemoSeatsMaxBusClQty Max. Capacity Bus.
SitnDemoSeatsOccupiedBusClQty SitnDemoSeatsOccupiedBusClQty Occupied Bus.
SitnDemoSeatsMax1stClQty SitnDemoSeatsMax1stClQty Max. Capacity 1st
SitnDemoSeatsOccupied1stClQty SitnDemoSeatsOccupied1stClQty Occupied 1st
SitnDemoPrice SitnDemoPrice RVP f.PricePro.
SitnDemoCurrency SitnDemoCurrency Valuation Crcy
SitnDemoLuggageWgtRatio _FlightAggr SitnDemoLuggageWgtRatio
SitnDemoLuggageWgtChtRatio _FlightAggr SitnDemoLuggageWgtChtRatio
SitnDemoEconomyClSoldAmount _FlightAggr SitnDemoEconomyClSoldAmount
SitnDemoBusClSoldAmount _FlightAggr SitnDemoBusClSoldAmount
SitnDemo1stClSoldAmount _FlightAggr SitnDemo1stClSoldAmount
SitnDemoCurrentSoldAmount _FlightAggr SitnDemoCurrentSoldAmount
SitnDemoMaxSoldAmount _FlightAggr SitnDemoMaxSoldAmount
SitnDemoOccupiedSeatsRatio _FlightAggr SitnDemoOccupiedSeatsRatio
SitnDemoOccupiedSeatsChtRatio _FlightAggr SitnDemoOccupiedSeatsChtRatio
SitnDemoSeatOccpcyEconomyRatio _FlightAggr SitnDemoSeatOccpcyEconomyRatio
SitnDemoSeatsOccpcyBusClRatio _FlightAggr SitnDemoSeatsOccpcyBusClRatio
SitnDemoSeatsOccpcy1stClRatio _FlightAggr SitnDemoSeatsOccpcy1stClRatio
SitnDemoSalesDiffAmount _FlightAggr SitnDemoSalesDiffAmount
SitnDemoSlsDiffEconomyClAmount _FlightAggr SitnDemoSlsDiffEconomyClAmount
SitnDemoSalesDiffBusClAmount _FlightAggr SitnDemoSalesDiffBusClAmount
SitnDemoSalesDiff1stClAmount _FlightAggr SitnDemoSalesDiff1stClAmount
SitnDemoSalesRatio _FlightAggr SitnDemoSalesRatio
SitnDemoEconomyClSalesRatio _FlightAggr SitnDemoEconomyClSalesRatio
SitnDemoBusClSalesRatio _FlightAggr SitnDemoBusClSalesRatio
SitnDemo1stClSalesRatio _FlightAggr SitnDemo1stClSalesRatio
SitnDemoBusClPrice _FlightAggr SitnDemoBusClPrice
SitnDemo1stClPrice _FlightAggr SitnDemo1stClPrice
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
SitnDemoCarrierRegion _Carrier SitnDemoCarrierRegion

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 I_Sitn2DemoFlight.
-- 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.
-- SQL view name: ISITN2DFLAP

CREATE VIEW I_Sitn2DemoFlight AS
SELECT
  SitnDemoCarrierID,
  SitnDemoConnectionID,
  SitnDemoFlightDate,
  SitnDemoFlightUniqueKey,
  SitnDemoFlightIsScheduled,
  SitnDemoPlaneType,
  cast('PCE' as sit2_demo_seats_unit) AS SitnDemoSeatsUnit,
  SitnDemoSeatsMaxQty,
  SitnDemoSeatsOccupiedQty,
  SitnDemoSeatsMaxBusClQty,
  SitnDemoSeatsOccupiedBusClQty,
  SitnDemoSeatsMax1stClQty,
  SitnDemoSeatsOccupied1stClQty,
  SitnDemoPrice,
  SitnDemoCurrency,
  _FlightAggr.SitnDemoLuggageWgtRatio AS SitnDemoLuggageWgtRatio,
  _FlightAggr.SitnDemoLuggageWgtChtRatio AS SitnDemoLuggageWgtChtRatio,
  _FlightAggr.SitnDemoEconomyClSoldAmount AS SitnDemoEconomyClSoldAmount,
  _FlightAggr.SitnDemoBusClSoldAmount AS SitnDemoBusClSoldAmount,
  _FlightAggr.SitnDemo1stClSoldAmount AS SitnDemo1stClSoldAmount,
  _FlightAggr.SitnDemoCurrentSoldAmount AS SitnDemoCurrentSoldAmount,
  _FlightAggr.SitnDemoMaxSoldAmount AS SitnDemoMaxSoldAmount,
  _FlightAggr.SitnDemoOccupiedSeatsRatio AS SitnDemoOccupiedSeatsRatio,
  _FlightAggr.SitnDemoOccupiedSeatsChtRatio AS SitnDemoOccupiedSeatsChtRatio,
  _FlightAggr.SitnDemoSeatOccpcyEconomyRatio AS SitnDemoSeatOccpcyEconomyRatio,
  _FlightAggr.SitnDemoSeatsOccpcyBusClRatio AS SitnDemoSeatsOccpcyBusClRatio,
  _FlightAggr.SitnDemoSeatsOccpcy1stClRatio AS SitnDemoSeatsOccpcy1stClRatio,
  _FlightAggr.SitnDemoSalesDiffAmount AS SitnDemoSalesDiffAmount,
  _FlightAggr.SitnDemoSlsDiffEconomyClAmount AS SitnDemoSlsDiffEconomyClAmount,
  _FlightAggr.SitnDemoSalesDiffBusClAmount AS SitnDemoSalesDiffBusClAmount,
  _FlightAggr.SitnDemoSalesDiff1stClAmount AS SitnDemoSalesDiff1stClAmount,
  _FlightAggr.SitnDemoSalesRatio AS SitnDemoSalesRatio,
  _FlightAggr.SitnDemoEconomyClSalesRatio AS SitnDemoEconomyClSalesRatio,
  _FlightAggr.SitnDemoBusClSalesRatio AS SitnDemoBusClSalesRatio,
  _FlightAggr.SitnDemo1stClSalesRatio AS SitnDemo1stClSalesRatio,
  _FlightAggr.SitnDemoBusClPrice AS SitnDemoBusClPrice,
  _FlightAggr.SitnDemo1stClPrice AS SitnDemo1stClPrice,
  _Carrier.SitnDemoCarrierRegion AS SitnDemoCarrierRegion
FROM R_Sitn2DemoFlight
LEFT OUTER JOIN R_Sitn2DemoFlightCalcFields AS _FlightAggr ON _FlightAggr.SitnDemoCarrierID = SitnDemoCarrierID AND _FlightAggr.SitnDemoConnectionID = SitnDemoConnectionID AND _FlightAggr.SitnDemoFlightDate = SitnDemoFlightDate  -- association [0..1]
LEFT OUTER JOIN R_Sitn2DemoCarrier AS _Carrier ON _Carrier.SitnDemoCarrierID = SitnDemoCarrierID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON SitnDemoSeatsUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SitnDemoCurrency = _Currency.Currency  -- association [0..1]
;

Learn More