R_Sitn2DemoBooking

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 R_Sitn2DemoBooking.
-- 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: RSITN2DBOOK

CREATE VIEW R_Sitn2DemoBooking AS
SELECT
  carrid AS SitnDemoCarrierID,
  connid AS SitnDemoConnectionID,
  fldate AS SitnDemoFlightDate,
  bookid AS SitnDemoBookingID,
  unique_key AS SitnDemoBookingUniqueKey,
  title AS SitnDemoTitle,
  wunit AS SitnDemoWeightUnit,
  luggweight AS SitnDemoLuggageWeight,
  confirmed AS SitnDemoIsConfirmed,
  invoice AS SitnDemoIsInvoiced,
  reserved AS SitnDemoIsReserved,
  class AS SitnDemoBookingClass,
  loccuram AS SitnDemoPrice,
  loccurkey AS SitnDemoCurrency,
  order_date AS SitnDemoOrderDate,
  agencynum AS SitnDemoAgencyID,
  pass_name AS SitnDemoPssngrName,
  pass_phono AS SitnDemoPssngrPhoneNumber,
  _Carrier.SitnDemoCarrierRegion AS SitnDemoCarrierRegion,
  _Agency.SitnDemoAgencyRegion AS SitnDemoAgencyRegion
FROM sit2_demo_book
LEFT OUTER JOIN I_Currency AS _Currency ON SitnDemoCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON SitnDemoWeightUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_Sitn2DemoCarrier AS _Carrier ON SitnDemoCarrierID = _Carrier.SitnDemoCarrierID  -- association [1..1]
LEFT OUTER JOIN R_Sitn2DemoAgency AS _Agency ON SitnDemoAgencyID = _Agency.SitnDemoAgencyID  -- association [1..1]
;