P_EWM_OUTBDLVORDERHEADER01_2

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 P_EWM_OUTBDLVORDERHEADER01_2.
-- 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 P_EWM_OUTBDLVORDERHEADER01_2 AS
SELECT
  OutboundDeliveryOrderUUID,
  EWMWarehouse,
  EWMOutboundDeliveryOrder,
  EWMDeliveryDocumentCategory,
  EWMDeliveryDocumentType,
  ShipToParty,
  ShipToPartyName,
  EWMShipToIsBusPurposeCmpltd,
  Carrier,
  CarrierName,
  EWMCarrierIsBusPurposeCmpltd,
  OutboundDelivery,
  BusinessSystemName,
  FreightOrder,
  MasterBillOfLading,
  TranspOrdPartnerReference,
  EWMShippingReadinessStatus,
  PlannedDeliveryUTCDateTime,
  PlannedOutOfYardUTCDateTime,
  WarehouseTimeZone,
  IncotermsPart1,
  IncotermsPart2,
  EWMRoute,
  EWMMeansOfTransport,
  EWMMeansOfTransportType,
  EWMTranspPlanningType,
  cast( EWMOutbDlvOrdImmdLoadgIsActv as abap_boolean preserving type ) AS EWMOutbDlvOrdImmdLoadgIsActv,
  EWMOutbDlvOrdAdhocLoadgIsActv,
  SalesOrganization,
  ShippingOffice,
  EWMWhseReqProductionCode,
  EWMDeliveryCreationUTCDateTime,
  EWMDelivLastChangeUTCDateTime,
  EWMWhseReqHasWarehouseTask,
  case when _SCMRouteText[1:Language = $session.system_language].RouteName is not null then _SCMRouteText[1:Language = $session.system_language].RouteName else _RouteText[1:Language = $session.system_language].RouteName end as RouteName AS RouteNameendasRouteName
FROM I_EWM_OutbDelivOrdHdr AS pdo_h
LEFT OUTER JOIN I_EWM_WhseSystIsDecentralized AS _WhseSystIsDecentralized ON 1 = 1  -- association [1..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _WarehouseText ON EWMWarehouse = _WarehouseText.EWMWarehouse  -- association [1..1]
LEFT OUTER JOIN I_EWM_MnsOfTransptTypeText_2 AS _MeansOfTransportText ON EWMMeansOfTransportType = _MeansOfTransportText.EWMMeansOfTransportType  -- association [0..*]
LEFT OUTER JOIN I_EWM_DeliveryTypeText_2 AS _OutbDelivOrderHdrTypeText ON EWMDeliveryDocumentCategory = _OutbDelivOrderHdrTypeText.EWMDeliveryDocumentCategory AND EWMDeliveryDocumentType = _OutbDelivOrderHdrTypeText.EWMDeliveryDocumentType  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _ShippingReadinessStatusText ON EWMShippingReadinessStatus = _ShippingReadinessStatusText.EWMWarehouseRequestStatus AND _ShippingReadinessStatusText.EWMWarehouseRequestStatusType = 'DSH'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqTrPlngTypeText AS _TranspPlanningTypeText ON EWMTranspPlanningType = _TranspPlanningTypeText.EWMTranspPlanningType  -- association [0..*]
LEFT OUTER JOIN I_RouteText AS _RouteText ON EWMRoute = _RouteText.Route  -- association [0..*]
LEFT OUTER JOIN I_EWM_SCMRouteText AS _SCMRouteText ON EWMRoute = _SCMRouteText.EWMRoute  -- association [0..*]
;