P_EWM_PINVCOUNTITEM04

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_PINVCOUNTITEM04.
-- 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: PEWMPICNTLIST04

CREATE VIEW P_EWM_PINVCOUNTITEM04 AS
SELECT
  item.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  item.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  item.LineIndexOfPInvItem AS LineIndexOfPInvItem,
  item.PhysicalInventoryChangeVersion AS PhysicalInventoryChangeVersion,
  item.PInvDocumentItemType AS PInvDocumentItemType,
  item.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  item.PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  item.WhseTaskGoodsReceiptDateTime AS WhseTaskGoodsReceiptDateTime,
  item.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  item.CountryOfOrigin AS CountryOfOrigin,
  item.PInvItemParentUUID AS PInvItemParentUUID,
  item.PInvItemParentType AS PInvItemParentType,
  item.PhysicalInventoryStockUUID AS PhysicalInventoryStockUUID,
  item.SequenceOfPInvDocumentItems AS SequenceOfPInvDocumentItems,
  item.ProductUUID AS ProductUUID,
  item.BatchUUID AS BatchUUID,
  item.HandlingUnitNumber AS HandlingUnitNumber,
  item.EntitledToDisposeParty AS EntitledToDisposeParty,
  item.StockOwner AS StockOwner,
  item.EWMStockOwner AS EWMStockOwner,
  item.StockType AS StockType,
  item.EWMStockType AS EWMStockType,
  item.StockUsage AS StockUsage,
  item.EWMStockUsage AS EWMStockUsage,
  item.StockDocumentCategory AS StockDocumentCategory,
  item.StockDocumentNumber AS StockDocumentNumber,
  item.StockItemNumber AS StockItemNumber,
  item.ProducedMaterial AS ProducedMaterial,
  item.Warehouse AS Warehouse,
  item.EWMWarehouse AS EWMWarehouse,
  item.ParentStorageBin AS ParentStorageBin,
  item.ParentHandlingUnitNumber AS ParentHandlingUnitNumber,
  item.BookQtyOfPInvItemInBookQtyUoM AS BookQtyOfPInvItemInBookQtyUoM,
  item.BookQuantityUnitOfMeasure AS BookQuantityUnitOfMeasure,
  higherParent.HigherParentStorageBin AS HigherParentStorageBin,
  higherParent.HigherParentHandlingUnitNumber AS HigherParentHandlingUnitNumber
FROM P_EWM_PINVCOUNTITEM02 AS item
LEFT OUTER JOIN P_EWM_PINVCOUNTITEM03 AS higherParent ON /* join condition not captured in parsed metadata */
;