C_Oij06_Myeventss1_Object

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 C_Oij06_Myeventss1_Object.
-- 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: CMYEVENTSOBJ

CREATE VIEW C_Oij06_Myeventss1_Object AS
SELECT
  e.NominationDoc AS NominationDoc,
  e.NominationDocItem AS NominationDocItem,
  e.NominationEventNumber AS NominationEventNumber,
  e.NominationEventSequence AS NominationEventSequence,
  e.NominationExtNumber AS NominationExtNumber,
  e.NominationEventType AS NominationEventType,
  _TSWLocationTimeZone.LocationTimeZone AS LocationTimeZone,
  e.NominationEventChangedDate AS NominationEventChangedDate,
  e.NominationEventChangedTime AS NominationEventChangedTime,
  e.PlannedStartDateFrom AS PlannedStartDateFrom,
  e.PlannedStartTimeFrom AS PlannedStartTimeFrom,
  e.PlannedStartFromDateTime AS PlannedStartFromDateTime,
  e.PlannedEndDateFrom AS PlannedEndDateFrom,
  e.PlannedEndTimeFrom AS PlannedEndTimeFrom,
  e.PlannedEndFromDateTime AS PlannedEndFromDateTime,
  e.PlannedStartDateTo AS PlannedStartDateTo,
  e.PlannedStartTimeTo AS PlannedStartTimeTo,
  e.PlannedStartToDateTime AS PlannedStartToDateTime,
  e.PlannedEndDateTo AS PlannedEndDateTo,
  e.PlannedEndTimeTo AS PlannedEndTimeTo,
  e.PlannedEndToDateTime AS PlannedEndToDateTime,
  e.ActualStartDateFrom AS ActualStartDateFrom,
  e.ActualStartTimeFrom AS ActualStartTimeFrom,
  e.ActualStartFromDateTime AS ActualStartFromDateTime,
  e.ActualStartDateTo AS ActualStartDateTo,
  e.ActualStartTimeTo AS ActualStartTimeTo,
  e.ActualStartToDateTime AS ActualStartToDateTime,
  e.ActualEndDateFrom AS ActualEndDateFrom,
  e.ActualEndTimeFrom AS ActualEndTimeFrom,
  e.ActualEndFromDateTime AS ActualEndFromDateTime,
  e.ActualEndDateTo AS ActualEndDateTo,
  e.ActualEndTimeTo AS ActualEndTimeTo,
  e.ActualEndToDateTime AS ActualEndToDateTime,
  cast( 0 as tzntstmps) AS NominationEventLogUpdate,
  e.ScheduledQuantity AS ScheduledQuantity,
  e.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  e.LocationId AS LocationId,
  e.LocationName AS LocationName,
  e.TransportSystem AS TransportSystem,
  e.TransportSystemName AS TransportSystemName,
  e.ScheduledMaterial AS ScheduledMaterial,
  e.MaterialDesc AS MaterialDesc,
  e.OriginCityCode AS OriginCityCode,
  e.DestinationCityCode AS DestinationCityCode,
  e.NominationScheduleDate AS NominationScheduleDate,
  e.NominationExtDocItem AS NominationExtDocItem,
  cast('' as char200 ) AS NominationEventComments,
  EventIsAdded,
  EventIsChanged,
  e.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_Oij06_Myeventss1_Object AS e
LEFT OUTER JOIN I_TSWLocationTimeZone AS _TSWLocationTimeZone ON LocationId = _TSWLocationTimeZone.TSWLocationID  -- association [1..1]
;