S_Carrier

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_Carrier.
-- 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_CARRIERV

CREATE VIEW S_Carrier AS
SELECT
  carrid AS CarrierId,
  carrname AS Name,
  currcode AS currencyCode,
  url
FROM scarr
LEFT OUTER JOIN tcurc AS _Currency ON currencyCode = _Currency.waers  -- association [1]
LEFT OUTER JOIN S_Connections AS _Connections ON CarrierId = _Connections.CarrierId  -- association [*]
LEFT OUTER JOIN S_Flights AS _Flights ON CarrierId = _Flights.CarrierId  -- association [*]
LEFT OUTER JOIN S_Bookings AS _Bookings ON CarrierId = _Bookings.CarrierId  -- association [*]
LEFT OUTER JOIN S_Tickets AS _Tickets ON CarrierId = _Tickets.CarrierId  -- association [*]
;