P_EWM_InboundDlvItem01_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_InboundDlvItem01_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_InboundDlvItem01_2 AS
SELECT
  EWMInboundDelivery,
  InboundDeliveryItem AS EWMInboundDeliveryItem,
  EWMWarehouse,
  DeliveryDocumentCategory AS EWMDeliveryDocumentCategory,
  DeliveryItemCategory AS EWMInboundDeliveryItemCategory,
  InboundDeliveryItemType AS EWMInboundDeliveryItemType,
  cast( Product as char40 preserving type ) AS Product,
  cast( ProductExternalID as char40 preserving type ) AS ProductExternalID,
  cast( Batch as charg_d ) AS Batch,
  _ExtProdBatch.EWMBatchBySupplierPlanned AS EWMBatchBySupplierPlanned,
  CountryOfOrigin,
  ProductQuantity,
  cast( QuantityUnit as /scwm/de_base_uom preserving type ) AS QuantityUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS EWMInbDelivItmQuantitySAPCode,
  _UnitOfMeasure.UnitOfMeasureISOCode AS EWMInbDelivItmQuantityISOCode,
  StagingAreaGroup,
  StagingArea,
  StagingBay,
  GoodsReceiptStatus,
  _ItemStatus[1:DeliveryStatusType = 'DEU'].Status AS PlanningPutawayStatus,
  _ItemStatus[1:DeliveryStatusType = 'DPT'].Status AS PutawayStatus,
  CompletionStatus,
  WarehouseProcessType,
  GoodsMovementBin,
  EWMProductionSupplyArea,
  EntitledToDisposeParty,
  StockUsage AS EWMStockUsage,
  StockType AS EWMStockType,
  cast( StockOwner as char10 preserving type ) AS EWMStockOwner,
  DeliveryItemStockTypeDetnCode,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  cast( SpecialStockIdfgSalesOrder as mat_kdauf ) AS SpecialStockIdfgSalesOrder,
  cast( SpecialStockIdfgSalesOrderItem as mat_kdpos ) AS SpecialStockIdfgSalesOrderItem,
  cast( PurchasingDocument as fis_ebeln ) AS PurchasingDocument,
  cast( ltrim( PurchasingDocumentItem, '0' ) as fis_ebelp ) AS PurchasingDocumentItem,
  cast(_ManufacturingOrder.EWMRefDeliveryDocumentNumber as manufacturingorder ) AS ManufacturingOrder,
  InboundDeliveryUUID,
  InboundDeliveryItemUUID
FROM I_EWM_InbDeliveryItemBasic AS pdi_i
LEFT OUTER JOIN I_EWM_DeliveryReferenceDoc_2 AS _ManufacturingOrder ON pdi_i.InboundDeliveryUUID = _ManufacturingOrder.DeliveryUUID AND pdi_i.InboundDeliveryItemUUID = _ManufacturingOrder.DeliveryItemUUID AND EWMDeliveryDocumentCategory = _ManufacturingOrder.EWMDeliveryDocumentCategory AND _ManufacturingOrder.EWMReferenceDocumentCategory = 'PPO'  -- 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]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasureSAPCode  -- association [0..1]
;