sadl_sb_aunit_sflight

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_sb_aunit_sflight.
-- 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: VSADLSB_AU_SFLGH

CREATE VIEW sadl_sb_aunit_sflight AS
SELECT
  carrid AS carrier_id,
  concat(concat(concat(concat(substring(fldate, 1, 4), '-') , substring(fldate, 5, 2)), '-'), substring(fldate, 7, 2)) AS flight_date,
  planetype AS plane_type,
  seatsmax AS seats_total,
  (seatsmax - seatsocc) AS seats_free,
  price,
  currency,
  schedule
FROM sflight
LEFT OUTER JOIN SADL_SB_AUNIT_SPFLI AS schedule ON carrier_id = schedule.carrier_id AND connection_id = schedule.connection_id  -- association [1..1]
;