I_Oij06_Events

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 I_Oij06_Events.
-- 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: IOIJ06_EVENTS

CREATE VIEW I_Oij06_Events AS
SELECT
  events.nomtk AS NominationKey,
  events.nomit AS NominationItem,
  events.event_nr AS EventNumber,
  events.type AS EventType,
  events.ev_seq AS EventSequence,
  events.status AS NFStatus,
  events.cha_date AS ChangedDate,
  events.pstdtf AS PlannedStartDateFrom,
  events.pstdtt AS PlannedEndDateTo,
  cast('' as char200) AS Comments
FROM oijne AS events
LEFT OUTER JOIN I_Oij06_My_Nominations AS _NominationItem ON _NominationItem.NominationDoc = NominationKey AND _NominationItem.NominationDocItem = NominationItem  -- association [0..1]
;