P_EWM_PINVCOUNTITEM02

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_PINVCOUNTITEM02.
-- 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_PINVCOUNTITEM02 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,
  child.LineIndexOfPInvItem AS ChildLineIdx
FROM P_EWM_PInvCountItem01 AS item
LEFT OUTER JOIN I_EWM_PInvDocBusKeyParent AS child ON /* join condition not captured in parsed metadata */
;