P_EWM_ODONoParam_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_ODONoParam_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.
-- SQL view name: PEWMODONP2

CREATE VIEW P_EWM_ODONoParam_2 AS
SELECT
  EWMWarehouse,
  EWMOutboundDeliveryOrder,
  EWMOutboundDeliveryOrderItem,
  OutboundDeliveryOrderUUID,
  OutboundDeliveryOrderItemUUID,
  EWMDeliveryDocumentCategory,
  EWMOutbDelivOrderItemCategory,
  EWMOutbDeliveryOrderItemType,
  Product,
  Batch,
  RequirementSegment,
  StockSegment,
  WarehouseDoor,
  StagingArea,
  StagingAreaGroup,
  GoodsIssueStatus,
  CompletionStatus,
  EntitledToDisposeParty,
  WarehouseProcessType,
  ShippingCondition,
  PlannedPickingStatus,
  ProductQuantity,
  QuantityUnit,
  WrhsTimeZonePlannedGIDate,
  WrhsTimeZonePlannedGITime,
  WrhsTmznPlndGIStrtDateTime,
  PlndGoodsIssueStartUTCDateTime,
  ActlGoodsIssueStartUTCDateTime,
  WrhsTmznActlGIStrtDateTime,
  EWMWhseTmznActlGIEndDateTime,
  WrhsTimeZoneActualGIDate,
  WrhsTimeZoneActualGITime,
  cast(substring(cast(WrhsTmznPlndGIStrtDateTime as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WrhsTimeZonePlndGImins,
  cast(substring(cast(WrhsTmznActlGIStrtDateTime as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WrhsTimeZoneActualGImins,
  _OutboundDeliveryOrderHeader.DeliveryType AS EWMOutboundDeliveryOrderType,
  _OutboundDeliveryOrderHeader.WrhsTmznCreationDateTime AS WrhsTmznCreationDateTime,
  _OutboundDeliveryOrderHeader.WrhsTmZnCreationDate AS WrhsTmZnCreationDate,
  _OutboundDeliveryOrderHeader.WrhsTmznCreationTime AS WrhsTmznCreationTime,
  _OutboundDeliveryOrderHeader._BPShipTo.BusinessPartner AS ShipToParty,
  _OutboundDeliveryOrderHeader.ShipToPartyName AS ShipToPartyName,
  _OutboundDeliveryOrderHeader._BPCarrier.BusinessPartner AS Carrier,
  _OutboundDeliveryOrderHeader.CarrierName AS CarrierName,
  _OutboundDeliveryOrderHeader._WarehouseTimezone.TimeZoneID AS TimeZoneID,
  _OutboundDeliveryOrderHeader.EWMWarehouseCurrentDate AS EWMWarehouseCurrentDate,
  _DeliveryItemWave.Wave AS Wave,
  _DeliveryItemWave.ODOItmWaveAssgmtIsNotUnique AS ODOItmWaveAssgmtIsNotUnique,
  _OutboundDeliveryItem.EWMOutboundDelivery AS EWMOutboundDelivery,
  _OutboundDeliveryItem.EWMOutboundDeliveryItem AS EWMOutboundDeliveryItem,
  case when _OutboundDeliveryItem.EWMRoute is not null then _OutboundDeliveryItem.EWMRoute else _OutboundDeliveryOrderHeader.EWMRoute end as EWMRoute AS EWMRouteendasEWMRoute,
  case when _OutboundDeliveryItem.RouteSchedule is not null then _OutboundDeliveryItem.RouteSchedule else odo_item.RouteSchedule end as RouteSchedule AS RouteScheduleendasRouteSchedule,
  _PickingStatus.EWMOutboundDeliveryOrderStatus AS PickingStatus,
  _BlockStatus.EWMOutboundDeliveryOrderStatus AS OverallBlockStatus,
  _TransPlanBlock.EWMOutboundDeliveryOrderStatus AS TranspPlanBlockStatus,
  _ItemInconsistencyBlkStatus.EWMOutboundDeliveryOrderStatus AS ItemInconsistencyBlkStatus,
  _GoodsMovementBlockStatus.EWMOutboundDeliveryOrderStatus AS GoodsMovementBlockStatus,
  _UncheckedItemBlockStatus.EWMOutboundDeliveryOrderStatus AS UncheckedItemBlockStatus,
  _DeliveryCreationStatus.EWMOutboundDeliveryOrderStatus AS DeliveryCreationStatus,
  _TransitProcedStatus.EWMOutboundDeliveryOrderStatus AS TransitProcedureStatus,
  _DeliveryLoadingStatus.EWMOutboundDeliveryOrderStatus AS LoadingStatus,
  _PickingAndDistributionStatus.EWMOutboundDeliveryOrderStatus AS PickingAndDistributionStatus,
  _WarehouseActivityStatus.EWMOutboundDeliveryOrderStatus AS WarehouseActivityStatus,
  _GlobalTradeServiceStatus.EWMOutboundDeliveryOrderStatus AS GlobalTradeServicesCheckStatus,
  _TransportationUnitAssgmtSts.EWMOutboundDeliveryOrderStatus AS TransportationUnitAssgmtStatus,
  _ValuationQtyAssgmtStatusName.EWMOutboundDeliveryOrderStatus AS ValuationQtyAssignmentStatus,
  _ValueAddedServiceOrderStatus.EWMOutboundDeliveryOrderStatus AS ValueAddedServiceOrderStatus,
  cast( case when GoodsIssueStatus = '9' and WrhsTmznPlndGIStrtDateTime < EWMWhseTmznActlGIEndDateTime then tstmp_seconds_between(WrhsTmznPlndGIStrtDateTime, EWMWhseTmznActlGIEndDateTime, 'NULL') when GoodsIssueStatus <> '9' and PlndGoodsIssueStartUTCDateTime < tstmp_current_utctimestamp() then tstmp_seconds_between (PlndGoodsIssueStartUTCDateTime, tstmp_current_utctimestamp(), 'NULL' ) else 0 end as abap.int4 ) as GoodsIssueDelayInSeconds AS int4asGoodsIssueDelayInSeconds,
  _QuantityAdjustment.EWMDeliveryAdjustmentQuantity AS EWMDeliveryAdjustmentQuantity
FROM I_EWM_OutbDelivOrdItemBasic AS odo_item
LEFT OUTER JOIN I_EWM_OutbDelivOrdHdrWithBP AS _OutboundDeliveryOrderHeader ON OutboundDeliveryOrderUUID = _OutboundDeliveryOrderHeader.OutboundDeliveryOrderUUID  -- association [1]
LEFT OUTER JOIN I_EWM_OutboundDeliveryItem AS _OutboundDeliveryItem ON OutboundDeliveryOrderUUID = _OutboundDeliveryItem.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _OutboundDeliveryItem.OutboundDeliveryOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemWave_2 AS _DeliveryItemWave ON OutboundDeliveryOrderUUID = _DeliveryItemWave.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _DeliveryItemWave.OutboundDeliveryOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_SplitItemWaveAssgmt AS _SplitWaveAssign ON OutboundDeliveryOrderUUID = _SplitWaveAssign.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _SplitWaveAssign.OutboundDeliveryOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_DelivPartnerLocation AS _ShippingOffice ON OutboundDeliveryOrderUUID = _ShippingOffice.OutboundDeliveryOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_DelivWrhsLocation AS _WarehouseLocation ON OutboundDeliveryOrderUUID = _WarehouseLocation.OutboundDeliveryOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _PickingStatus ON OutboundDeliveryOrderUUID = _PickingStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _PickingStatus.OutboundDeliveryOrderItemUUID AND _PickingStatus.DeliveryStatusType = 'DPI'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _BlockStatus ON OutboundDeliveryOrderUUID = _BlockStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _BlockStatus.OutboundDeliveryOrderItemUUID AND _BlockStatus.DeliveryStatusType = 'DBO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _TransPlanBlock ON OutboundDeliveryOrderUUID = _TransPlanBlock.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _TransPlanBlock.OutboundDeliveryOrderItemUUID AND _TransPlanBlock.DeliveryStatusType = 'DBT'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _ItemInconsistencyBlkStatus ON OutboundDeliveryOrderUUID = _ItemInconsistencyBlkStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _ItemInconsistencyBlkStatus.OutboundDeliveryOrderItemUUID AND _ItemInconsistencyBlkStatus.DeliveryStatusType = 'DBD'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _GoodsMovementBlockStatus ON OutboundDeliveryOrderUUID = _GoodsMovementBlockStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _GoodsMovementBlockStatus.OutboundDeliveryOrderItemUUID AND _GoodsMovementBlockStatus.DeliveryStatusType = 'DWG'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _UncheckedItemBlockStatus ON OutboundDeliveryOrderUUID = _UncheckedItemBlockStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _UncheckedItemBlockStatus.OutboundDeliveryOrderItemUUID AND _UncheckedItemBlockStatus.DeliveryStatusType = 'DBP'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _DeliveryCreationStatus ON OutboundDeliveryOrderUUID = _DeliveryCreationStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _DeliveryCreationStatus.OutboundDeliveryOrderItemUUID AND _DeliveryCreationStatus.DeliveryStatusType = 'DDC'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _TransitProcedStatus ON OutboundDeliveryOrderUUID = _TransitProcedStatus.OutboundDeliveryOrderUUID AND _TransitProcedStatus.DeliveryStatusType = 'DWN'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _DeliveryLoadingStatus ON OutboundDeliveryOrderUUID = _DeliveryLoadingStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _DeliveryLoadingStatus.OutboundDeliveryOrderItemUUID AND _DeliveryLoadingStatus.DeliveryStatusType = 'DLO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _PickingAndDistributionStatus ON OutboundDeliveryOrderUUID = _PickingAndDistributionStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _PickingAndDistributionStatus.OutboundDeliveryOrderItemUUID AND _PickingAndDistributionStatus.DeliveryStatusType = 'DPD'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _WarehouseActivityStatus ON OutboundDeliveryOrderUUID = _WarehouseActivityStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _WarehouseActivityStatus.OutboundDeliveryOrderItemUUID AND _WarehouseActivityStatus.DeliveryStatusType = 'DWA'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _GlobalTradeServiceStatus ON OutboundDeliveryOrderUUID = _GlobalTradeServiceStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _GlobalTradeServiceStatus.OutboundDeliveryOrderItemUUID AND _GlobalTradeServiceStatus.DeliveryStatusType = 'DGT'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _TransportationUnitAssgmtSts ON OutboundDeliveryOrderUUID = _TransportationUnitAssgmtSts.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _TransportationUnitAssgmtSts.OutboundDeliveryOrderItemUUID AND _TransportationUnitAssgmtSts.DeliveryStatusType = 'DTU'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _ValuationQtyAssgmtStatusName ON OutboundDeliveryOrderUUID = _ValuationQtyAssgmtStatusName.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _ValuationQtyAssgmtStatusName.OutboundDeliveryOrderItemUUID AND _ValuationQtyAssgmtStatusName.DeliveryStatusType = 'DVQ'  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _ValueAddedServiceOrderStatus ON OutboundDeliveryOrderUUID = _ValueAddedServiceOrderStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _ValueAddedServiceOrderStatus.OutboundDeliveryOrderItemUUID AND _ValueAddedServiceOrderStatus.DeliveryStatusType = 'DWV'  -- association [0..1]
LEFT OUTER JOIN I_EWM_MnsOfTranspType_2 AS _MeansOfTransportType ON EWMMeansOfTransportType = _MeansOfTransportType.EWMMeansOfTransportType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseControl_2 AS _whseControl ON EWMWarehouse = _whseControl.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN P_EWM_ProcessCodeDelivQtyChg AS _QuantityAdjustment ON OutboundDeliveryOrderUUID = _QuantityAdjustment.DeliveryUUID AND OutboundDeliveryOrderItemUUID = _QuantityAdjustment.DeliveryItemUUID AND _QuantityAdjustment.DeliveryDocumentCategory = 'PDO'  -- association [0..1]
;