R_Sitn2DemoFlightCalcFields

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 R_Sitn2DemoFlightCalcFields.
-- 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: RSITN2DCALCFLD

CREATE VIEW R_Sitn2DemoFlightCalcFields AS
SELECT
  SitnDemoCarrierID,
  SitnDemoConnectionID,
  SitnDemoFlightDate,
  SitnDemoLuggageWgtRatio,
  cast (SitnDemoLuggageWgtRatio as sit2_demo_eco_index_chart) AS SitnDemoLuggageWgtChtRatio,
  SitnDemoEconomyClSoldAmount,
  SitnDemoBusClSoldAmount,
  SitnDemo1stClSoldAmount,
  SitnDemoCurrentSoldAmount,
  SitnDemoMaxSoldAmount,
  SitnDemoOccupiedSeatsRatio,
  cast ( SitnDemoOccupiedSeatsRatio as sit2_demo_seats_occpcy_chart ) AS SitnDemoOccupiedSeatsChtRatio,
  SitnDemoSeatOccpcyEconomyRatio,
  SitnDemoSeatsOccpcyBusClRatio,
  SitnDemoSeatsOccpcy1stClRatio,
  cast ( SitnDemoMaxSoldAmount - SitnDemoCurrentSoldAmount as sit2_demo_sales_diff ) AS SitnDemoSalesDiffAmount,
  cast( SitnDemoMaxSoldEconomyClAmount - SitnDemoMaxSoldEconomyClAmount as sit2_demo_sales_diff_eco_cl ) AS SitnDemoSlsDiffEconomyClAmount,
  cast ( SitnDemoMaxSoldBusClAmount - SitnDemoCurSoldBusClAmount as sit2_demo_sales_diff_bus_cl ) AS SitnDemoSalesDiffBusClAmount,
  cast ( SitnDemoMaxSold1stClAmount - SitnDemoCurSold1stClAmount as sit2_demo_sales_diff_1st_cl ) AS SitnDemoSalesDiff1stClAmount,
  SitnDemoBusClPrice,
  SitnDemo1stClPrice,
  SitnDemoCurrency
FROM P_Sitn2DemoFlightCalc2
;