P_CDS_EDM_TESTVIEW

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 P_CDS_EDM_TESTVIEW.
-- 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: PCDSEDMTESTV

CREATE VIEW P_CDS_EDM_TESTVIEW AS
SELECT
  SitnDemoCarrierID,
  SitnDemoConnectionID,
  SitnDemoFlightDate,
  'edmString' AS edmString,
  hextobin( '12345678901234561234567890123456' ) AS x16_carrid_edm_UUID,
  cast ( '1234567890123456' as char16 ) AS c16_NO_EdmGuid,
  cast ( '1234567890123456789012' as char22 ) AS c22_EdmGuid,
  cast ( '12345678901234567890123456' as char26 ) AS c26_edm_EdmGuid,
  cast ( '12345678901234567890123456789012' as char32 ) AS c32_EdmGuid,
  cast ( '506B4BC3-45CC-1EEB-879B-A5EC0A8B7878' as abap.char( 36 ) ) AS c36_EdmGuid,
  cast ( '1234567890123456789012' as sysuuid_c22 ) AS c22_EdmGuid_2,
  cast ( '12345678901234567890123456' as sysuuid_c26 ) AS c26_EdmGuid_2,
  cast ( '12345678901234567890123456789012' as sysuuid_c32 ) AS c32_EdmGuid_2,
  cast ( '506B4BC3-45CC-1EEB-879B-A5EC0A8B7878' as sysuuid_c36 ) AS c36_EdmGuid_2,
  cast ( '1' as char1 ) AS c1_edmBoolean,
  cast ( '12345678901234' as char14 ) AS c14_EdmDateTimeOffset,
  SitnDemoPrice,
  SitnDemoSeatsMaxQty,
  SitnDemoCurrency
FROM R_Sitn2DemoFlight
;