P_EWM_OutboundDlvOrderItem01

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_OutboundDlvOrderItem01.
-- 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: POUTBDLVORDITM01

CREATE VIEW P_EWM_OutboundDlvOrderItem01 AS
SELECT
  OutboundDeliveryOrder,
  OutboundDeliveryOrderItem,
  Warehouse,
  DeliveryCategory,
  OutbDeliveryOrderItemCategory,
  OutboundDeliveryOrderItemType,
  cast( Product as char40 preserving type ) AS Product,
  cast( ProductExternalID as char40 preserving type ) AS ProductExternalID,
  ProductBatch,
  ProductQuantity,
  cast( QuantityUnit as /scwm/de_base_uom preserving type ) AS QuantityUnit,
  StagingArea,
  StagingAreaGroup,
  StagingBay,
  GoodsIssueStatus,
  PlannedPickingStatus,
  _PickingStatus.Status AS PickingStatus,
  CompletionStatus,
  WarehouseProcessType,
  ShippingCondition,
  GoodsMovementBin,
  ProductionSupplyArea,
  StorageType,
  StorageSection,
  PlndGoodsIssueStartUTCDateTime,
  ActlGoodsIssueStartUTCDateTime,
  RouteSchedule,
  EntitledToDisposeParty,
  StockUsage,
  WarehouseStockCategory,
  cast( StockOwner as char10 preserving type ) AS StockOwner,
  DeliveryItemStockTypeDetnCode,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  cast( SpecialStockIdfgSalesOrder as /scdl/dl_refdocno ) AS SpecialStockIdfgSalesOrder,
  cast( ltrim( SpecialStockIdfgSalesOrderItem , '0') as abap.char( 10 ) ) AS SpecialStockIdfgSalesOrderItem,
  CountryOfOrigin,
  cast( ltrim( SalesOrder, '0' ) as /scdl/dl_refdocno ) AS SalesOrder,
  cast( ltrim( SalesOrderItem, '0') as /scdl/dl_refitemno ) AS SalesOrderItem,
  _ManufacturingOrder.ReferenceDocumentNumber AS ManufacturingOrder,
  pdo_i.OutboundDeliveryOrderUUID AS OutboundDeliveryOrderUUID,
  pdo_i.OutboundDeliveryOrderItemUUID AS OutboundDeliveryOrderItemUUID
FROM I_EWM_OutbDelivOrdItemBasic AS pdo_i
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _PickingStatus ON OutboundDeliveryOrderUUID = _PickingStatus.OutboundDeliveryOrderUUID AND OutboundDeliveryOrderItemUUID = _PickingStatus.OutboundDeliveryOrderItemUUID AND _PickingStatus.DeliveryStatusType = 'DPI'  -- association [1..1]
LEFT OUTER JOIN I_EWM_DeliveryReferenceDoc AS _ManufacturingOrder ON OutboundDeliveryOrderUUID = _ManufacturingOrder.DeliveryUUID AND OutboundDeliveryOrderItemUUID = _ManufacturingOrder.DeliveryItemUUID AND DeliveryCategory = _ManufacturingOrder.DeliveryCategory AND _ManufacturingOrder.ReferenceDocumentCategory = 'PPO'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _ProjectStock ON StockDocumentNumber = _ProjectStock.WBSElementInternalID AND StockDocumentCategory = 'PJS'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _ProjectStockDecentralized ON StockDocumentNumber = _ProjectStockDecentralized.StockDocumentNumber AND StockDocumentCategory = 'PJS'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseSystIsDecentralized AS _WhseSystemIsDecentralized ON _WhseSystemIsDecentralized.WarehouseSystemIsDecentralized = 'X'  -- association [0..1]
;