C_BulkShipment

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_BulkShipment.
-- 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: CBULKSHIPMENT

CREATE VIEW C_BulkShipment AS
SELECT
  BulkShipment,
  BulkShipmentType,
  BulkShipmentModeOfTransport,
  TransportationPlanningPoint,
  BulkShipmentCostCalcStatus,
  BulkShipmentStatus,
  BulkShipmentIsBlocked
FROM I_BulkShipmentHeader
LEFT OUTER JOIN C_BulkShipmentVehicle AS _BulkShipmentVehicle ON BulkShipment = _BulkShipmentVehicle.BulkShipment  -- association [0..*]
LEFT OUTER JOIN C_BulkShipmentDocument AS _BulkShipmentDocument ON BulkShipment = _BulkShipmentDocument.BulkShipment  -- association [0..*]
LEFT OUTER JOIN C_BulkShipmentEvent AS _BulkShipmentEvent ON BulkShipment = _BulkShipmentEvent.BulkShipment  -- association [0..*]
LEFT OUTER JOIN C_BulkShipmentPartnerDetail AS _BulkShipmentPartnerDetail ON BulkShipment = _BulkShipmentPartnerDetail.BulkShipment  -- association [0..*]
LEFT OUTER JOIN C_BulkShipmentOverview AS _BulkShipmentOverview ON BulkShipment = _BulkShipmentOverview.BulkShipment  -- association [0..*]
;