P_Sitn2DemoFlightCalc2

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 P_Sitn2DemoFlightCalc2.
-- 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: PSITN2DFLIC2

CREATE VIEW P_Sitn2DemoFlightCalc2 AS
SELECT
  SitnDemoCarrierID,
  SitnDemoConnectionID,
  SitnDemoFlightDate,
  SitnDemoLuggageWgtRatio,
  SitnDemoOccupiedSeatsRatio,
  SitnDemoSeatOccpcyEconomyRatio,
  SitnDemoSeatsOccpcyBusClRatio,
  SitnDemoSeatsOccpcy1stClRatio,
  cast (SitnDemoPrice * SitnDemoSeatsOccupiedQty as sit2_demo_sales_total_eco_cl ) AS SitnDemoEconomyClSoldAmount,
  cast ( SitnDemoBusClPrice * SitnDemoSeatsOccupiedBusClQty as sit2_demo_sales_total_bus_cl ) AS SitnDemoBusClSoldAmount,
  cast ( SitnDemo1stClPrice * SitnDemoSeatsOccupied1stClQty as sit2_demo_sales_total_1st_cl ) AS SitnDemo1stClSoldAmount,
  cast( SitnDemoPrice * SitnDemoSeatsOccupiedQty as s_price) AS SitnDemoCurSoldEconomyClAmount,
  cast( SitnDemoBusClPrice * SitnDemoSeatsOccupiedBusClQty as s_price) AS SitnDemoCurSoldBusClAmount,
  cast( SitnDemo1stClPrice * SitnDemoSeatsOccupied1stClQty as s_price) AS SitnDemoCurSold1stClAmount,
  cast( SitnDemoPrice * SitnDemoSeatsMaxQty as s_price) AS SitnDemoMaxSoldEconomyClAmount,
  cast( SitnDemoBusClPrice * SitnDemoSeatsMaxBusClQty as s_price) AS SitnDemoMaxSoldBusClAmount,
  cast( SitnDemo1stClPrice * SitnDemoSeatsMax1stClQty as s_price) AS SitnDemoMaxSold1stClAmount,
  SitnDemoBusClPrice,
  SitnDemo1stClPrice,
  SitnDemoCurrency,
  $session.system_date AS Today
FROM P_Sitn2DemoFlightCalc1
;