P_EWM_InboundDlvItem01

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_InboundDlvItem01.
-- 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: PINBDLVITEM01

CREATE VIEW P_EWM_InboundDlvItem01 AS
SELECT
  InboundDelivery,
  InboundDeliveryItem,
  Warehouse,
  DeliveryDocumentCategory AS DeliveryCategory,
  DeliveryItemCategory,
  InboundDeliveryItemType,
  cast( Product as char40 preserving type ) AS Product,
  cast( ProductExternalID as char40 preserving type ) AS ProductExternalID,
  cast( Batch as /scdl/dl_batchno ) AS ProductBatch,
  CountryOfOrigin,
  ProductQuantity,
  cast( QuantityUnit as /scwm/de_base_uom preserving type ) AS QuantityUnit,
  StagingAreaGroup,
  StagingArea,
  StagingBay,
  GoodsReceiptStatus,
  _ItemStatus[1:DeliveryStatusType = 'DEU'].Status AS PlanningPutawayStatus,
  _ItemStatus[1:DeliveryStatusType = 'DPT'].Status AS PutawayStatus,
  CompletionStatus,
  WarehouseProcessType,
  GoodsMovementBin,
  ProductionSupplyArea,
  EntitledToDisposeParty,
  StockUsage,
  StockType AS WarehouseStockCategory,
  cast( StockOwner as char10 preserving type ) AS StockOwner,
  DeliveryItemStockTypeDetnCode,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  cast( SpecialStockIdfgSalesOrder as /scwm/de_stock_docno ) AS SpecialStockIdfgSalesOrder,
  _ReferenceDocument[1:ReferenceDocumentCategory = 'PO'].ReferenceDocumentNumber AS PurchasingDocument,
  _ReferenceDocument[1:ReferenceDocumentCategory = 'PO'].ReferenceDocumentItemNumber AS PurchasingDocumentItem,
  _ReferenceDocument[1:ReferenceDocumentCategory = 'PPO'].ReferenceDocumentNumber AS ManufacturingOrder,
  InboundDeliveryUUID,
  InboundDeliveryItemUUID
FROM I_EWM_InbDeliveryItemBasic AS pdi_i
LEFT OUTER JOIN I_EWM_DeliveryReferenceDoc AS _ReferenceDocument ON pdi_i.InboundDeliveryUUID = _ReferenceDocument.DeliveryUUID AND pdi_i.InboundDeliveryItemUUID = _ReferenceDocument.DeliveryItemUUID AND DeliveryCategory = _ReferenceDocument.DeliveryCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _ProjectStockEmbedded ON StockDocumentNumber = _ProjectStockEmbedded.WBSElementInternalID AND StockDocumentCategory = 'PJS'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _ProjectStockDecentral ON StockDocumentNumber = _ProjectStockDecentral.StockDocumentNumber AND StockDocumentCategory = 'PJS'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseSystIsDecentralized AS _WhseSystemIsDecentralized ON _WhseSystemIsDecentralized.WarehouseSystemIsDecentralized = 'X'  -- association [0..1]
;