SADL_V_ExpVoc_Connection

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 SADL_V_ExpVoc_Connection.
-- 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: SADL_V_E_CONN

CREATE VIEW SADL_V_ExpVoc_Connection AS
SELECT
  carrid AS Airline,
  connid AS ConnectionID,
  spfli.countryfr AS CountryOfDeparture,
  cityfrom AS CityOfDeparture,
  airpfrom AS AirportOfDeparture,
  spfli.countryto AS countryto,
  cityto AS DestinationCity,
  airpto AS DestinationAirport
FROM spfli
LEFT OUTER JOIN SADL_V_ExpVoc_Airline AS _Airline ON Airline = _Airline.Code  -- association [1..1]
LEFT OUTER JOIN SADL_V_ExpVoc_Airport AS _FromAirport ON AirportOfDeparture = _FromAirport.Airport  -- association [1..1]
LEFT OUTER JOIN SADL_V_ExpVoc_Airport AS _ToAirport ON DestinationAirport = _ToAirport.Airport  -- association [1..1]
LEFT OUTER JOIN SADL_V_ExpVoc_Airport AS _Airports ON ( AirportOfDeparture = _Airports.Airport OR DestinationAirport = _Airports.Airport )  -- association [0..*]
;