I_OIL_VehicleEvent

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_VehicleEvent.
-- 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_VehicleEvent AS
SELECT
  app_area AS ApplicationArea,
  object_id AS TransportationEventObjectID,
  event_nr AS TransportationEventNumber,
  type AS EventType,
  drivercode AS TransportationVehicleDriver,
  cparid AS LocationPartner,
  rpart AS OilPartnerRoleType,
  loc_id AS TSWLocationID,
  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,
  aeddtf AS EventActualEndFromDate,
  aedtmf AS EventActualEndFromTime,
  aeddtt AS EventActualEndToDate,
  aedtmt AS EventActualEndToTime,
  longtext AS IndicatorHasEventLongText
FROM oijev
LEFT OUTER JOIN I_OIL_BulkTransportDriver AS _VehicleDriver ON _VehicleDriver.BulkTransportDriver = TransportationVehicleDriver  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransportVehicle AS _Vehicle ON _Vehicle.TransportationVehicle = TransportationEventObjectID  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocationTSWBasic AS _Location ON _Location.TSWLocationID = TSWLocationID  -- association [1..1]
LEFT OUTER JOIN I_OIL_TranspVehApplAreaVH AS _ApplicationArea ON _ApplicationArea.ApplicationArea = ApplicationArea  -- 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_BulkTransacVehicleTypeVH AS _TransactionType ON _TransactionType.NominationEventTransactionType = NominationEventTransactionType  -- association [1..1]
LEFT OUTER JOIN I_OIL_BulkTransptVehEvtStsVH AS _EventStatus ON _EventStatus.EventStatus = EventStatus  -- association [1..1]
;