P_EWM_PInvCountItem01

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_PInvCountItem01.
-- 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: PEWMPICNTLIST01

CREATE VIEW P_EWM_PInvCountItem01 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,
  _KeyItem.ProductUUID AS ProductUUID,
  _KeyItem.BatchUUID AS BatchUUID,
  _KeyItem.HandlingUnitNumber AS HandlingUnitNumber,
  _KeyItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  _KeyItem.StockOwner AS StockOwner,
  _KeyItem.EWMStockOwner AS EWMStockOwner,
  _KeyItem.StockType AS StockType,
  _KeyItem.EWMStockType AS EWMStockType,
  _KeyItem.StockUsage AS StockUsage,
  _KeyItem.EWMStockUsage AS EWMStockUsage,
  _KeyItem.StockDocumentCategory AS StockDocumentCategory,
  _KeyItem.StockDocumentNumber AS StockDocumentNumber,
  _KeyItem.StockItemNumber AS StockItemNumber,
  _KeyItem.ProducedMaterial AS ProducedMaterial,
  _KeyItem.Warehouse AS Warehouse,
  _KeyItem.EWMWarehouse AS EWMWarehouse,
  _ParentItem.StorageBin AS ParentStorageBin,
  _ParentItem.HandlingUnitNumber AS ParentHandlingUnitNumber
FROM I_EWM_PhysicalInventoryDocItem AS item
;