SADL_V_ExpVoc_Connection_Par

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_Par.
-- 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_CONP
-- Parameters: p_airpfrom : s_fromairp, p_airpto : s_toairp

CREATE VIEW SADL_V_ExpVoc_Connection_Par 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,
  deptime AS DepartureTime,
  arrtime AS ArrivalTime,
  Distance,
  distid AS DistanceUnit
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..*]
;