S_Connections

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 S_Connections.
-- 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: S_ConnectionsV

CREATE VIEW S_Connections AS
SELECT
  carrid AS CarrierId,
  connid AS ConnectionId,
  countryfr AS CountryFrom,
  CityFrom,
  airpfrom AS AirportFrom,
  CountryTo,
  CityTo,
  airpto AS AirportTo,
  fltime AS FlightTime,
  deptime AS DepartureTime,
  arrtime AS ArrivalTime,
  Distance,
  distid AS DistanceUnitId,
  fltype AS FlightType,
  period AS ArrivalsDays
FROM spfli
LEFT OUTER JOIN S_Carrier AS _Carrier ON CarrierId = _Carrier.CarrierId  -- association [1]
LEFT OUTER JOIN S_Flights AS _Flights ON CarrierId = _Flights.CarrierId AND ConnectionId = _Flights.ConnectionId  -- association [*]
LEFT OUTER JOIN S_Airports AS _FromAirport ON AirportFrom = _FromAirport.AirportId  -- association [1]
LEFT OUTER JOIN S_CityAirport AS _FromCity ON AirportFrom = _FromCity.AirportId AND CityFrom = _FromCity.City AND CountryFrom = _FromCity.Country  -- association [1]
LEFT OUTER JOIN S_Airports AS _ToAirport ON AirportTo = _ToAirport.AirportId  -- association [1]
LEFT OUTER JOIN S_CityAirport AS _ToCity ON AirportTo = _ToCity.AirportId AND CityTo = _ToCity.City AND CountryTo = _ToCity.Country  -- association [1]
;