I_OIL_BulkTransportUnitEvent

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_OIL_BulkTransportUnitEvent.
-- 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.

CREATE VIEW I_OIL_BulkTransportUnitEvent AS
SELECT
  app_area AS ApplicationArea,
  object_id AS TransportationEventObjectID,
  event_nr AS TransportationEventNumber,
  type AS EventType,
  rpart AS OilPartnerRoleType,
  doc_type AS DocumentEventType,
  doc_number AS BulkShipmentEventDocument,
  updflag AS NominationEventTransactionType,
  ev_seq AS EventSequence,
  status AS EventStatus,
  pstdtf AS EventPlannedStartFromDate,
  psttmf AS PlannedStartTimeFrom,
  pstdtt AS PlannedStartDateTo,
  psttmt AS EventPlannedStartToTime,
  peddtf AS PlannedEndDateFrom,
  pedtmf AS EventPlannedEndFromTime,
  peddtt AS PlannedEndDateTo,
  pedtmt AS EventPlannedEndToTime,
  cre_date AS CreationDate,
  cre_time AS CreationTime,
  cre_name AS CreatedByUser,
  cha_date AS LastChangeDate,
  cha_time AS LastChangeTime,
  cha_name AS LastChangedByUser,
  astdtf AS EventActualStartFromDate,
  asttmf AS EventActualStartFromTime,
  astdtt AS EventActualStartToDate,
  asttmt AS EventActualStartToTime,
  eddtf AS EventActualEndFromDate,
  aedtmf AS EventActualEndFromTime,
  aeddtt AS EventActualEndToDate,
  aedtmt AS EventActualEndToTime,
  longtext AS IndicatorHasEventLongText
FROM oijec
LEFT OUTER JOIN I_OIL_TranspVehApplAreaVH AS _ApplicationArea ON _ApplicationArea.ApplicationArea = ApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransacVehicleTypeVH AS _TransactionType ON _TransactionType.NominationEventTransactionType = NominationEventTransactionType  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransptVehEvtTypeVH AS _EventType ON _EventType.ApplicationArea = ApplicationArea AND _EventType.EventType = EventType  -- association [1..1]
LEFT OUTER JOIN I_OIL_RolePartnerTypeVH AS _RolePartnerType ON _RolePartnerType.RolePartnerType = OilPartnerRoleType  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransptVehEvtStsVH AS _EventStatus ON _EventStatus.EventStatus = EventStatus  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransportUnit AS _TransportUnit ON _TransportUnit.TransportUnitNumber = TransportationEventObjectID  -- association [1..1]
;