I_BulkShipmentVehicle

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_BulkShipmentVehicle.
-- 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: IBULKSHPTVEHICLE

CREATE VIEW I_BulkShipmentVehicle AS
SELECT
  oigsv.shnumber AS BulkShipment,
  oigsv.veh_nr AS BulkShipmentVehicleSequence,
  oigsv.vehicle AS TransportationVehicle,
  oigsv.veh_type AS BulkShipmentVehicleType,
  oigsv.carrier AS BulkShipmentCarrier,
  oigsv.route AS BulkShipmentVehicleRoute,
  oigsv.oig_sstsf AS BulkShipmentVehicleStatus
FROM oigsv
LEFT OUTER JOIN I_BulkShipmentHeader AS _BulkShipmentHeader ON BulkShipment = _BulkShipmentHeader.BulkShipment  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON BulkShipmentCarrier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentVehicleHeaderTxt AS _BulkShipmentVehicleHeaderTxt ON TransportationVehicle = _BulkShipmentVehicleHeaderTxt.TransportationVehicle  -- association [0..*]
LEFT OUTER JOIN I_Route AS _Route ON BulkShipmentVehicleRoute = _Route.Route  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentStatusText AS _BulkShipmentStatusText ON BulkShipmentVehicleStatus = _BulkShipmentStatusText.BulkShipmentStatus  -- association [0..*]
LEFT OUTER JOIN I_BulkShipmentVehicleType AS _BulkShipmentVehicleType ON BulkShipmentVehicleType = _BulkShipmentVehicleType.BulkShipmentVehicleType  -- association [0..1]
;