P_EWM_PINVDOCCNTITEM01

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_PINVDOCCNTITEM01.
-- 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: PEWMPICNTITM01

CREATE VIEW P_EWM_PINVDOCCNTITEM01 AS
SELECT
  _item.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  _item.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  _item.LineIndexOfPInvItem AS LineIndexOfPInvItem,
  _item.PInvQuantitySequence AS PInvQuantitySequence,
  _item.PInvDocumentItemType AS PInvDocumentItemType,
  _item.PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  _item.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  _item.PhysicalInventoryStockUUID AS PhysicalInventoryStockUUID,
  _item.PInvItemParentUUID AS PInvItemParentUUID,
  _item.StorageBin AS StorageBin,
  _item.EWMStorageBin AS EWMStorageBin,
  _StorageBin.StorageType AS StorageType,
  _StorageBin_2.EWMStorageType AS EWMStorageType,
  _item.ParentHandlingUnitNumber AS ParentHandlingUnitNumber,
  _item.ProductUUID AS ProductUUID,
  _Product.Product AS Product,
  _Product.SerialNumberProfile AS SerialNumberProfile,
  _ActiveHarmonizeSrlNmbr.HarmonizedSerializationIsActv AS HarmonizedSerializationIsActv,
  _item.BatchUUID AS BatchUUID,
  _item.StockType AS StockType,
  _item.EWMStockType AS EWMStockType,
  _item.StockOwner AS StockOwner,
  _item.EWMStockOwner AS EWMStockOwner,
  _item.StockOwnerPartnerRole AS StockOwnerPartnerRole,
  _item.StockUsage AS StockUsage,
  _item.EWMStockUsage AS EWMStockUsage,
  _item.StockDocumentCategory AS StockDocumentCategory,
  _item.StockDocumentNumber AS StockDocumentNumber,
  _item.StockItemNumber AS StockItemNumber,
  _item.DocumentReltdStockDocCat AS DocumentReltdStockDocCat,
  _item.EntitledToDisposeParty AS EntitledToDisposeParty,
  _item.EntitledToDisposePartnerRole AS EntitledToDisposePartnerRole,
  _item.PackagingMaterial AS PackagingMaterial,
  _item.HandlingUnitType AS HandlingUnitType,
  case when _item.HandlingUnitVirtual = 'A' then '' else _item.HandlingUnitNumber end AS HandlingUnitNumber,
  case when _item.HandlingUnitVirtual = 'A' then 'L' else _item.PhysicalInventoryItemType end AS PhysicalInventoryItemType,
  _item.Warehouse AS Warehouse,
  _item.EWMWarehouse AS EWMWarehouse,
  cast ( _item.HndlgUnitItemCountedIsComplete as boole_d ) AS HndlgUnitItemCountedIsComplete,
  cast ( case when _item.HandlingUnitVirtual = 'A' then '' else _item.HndlgUnitItemCountedIsEmpty end as boole_d ) AS HndlgUnitItemCountedIsEmpty,
  cast ( _item.HndlgUnitItemCountedIsNotExist as boole_d ) AS HndlgUnitItemCountedIsNotExist,
  cast ( case when _item.HandlingUnitVirtual = 'A' and _item.HndlgUnitItemCountedIsEmpty = 'X' then 'X' else StorageBinIsEmpty end as boole_d ) AS StorageBinIsEmpty,
  cast ( case when _item.HandlingUnitVirtual = 'A' and _item.HndlgUnitItemCountedIsEmpty = 'X' then 'X' else EWMStorageBinIsEmpty end as boole_d ) AS EWMStorageBinIsEmpty,
  _item.WhseQualityInspectionType AS WhseQualityInspectionType,
  _item.QualityInspectionDocUUID AS QualityInspectionDocUUID,
  _item.StockIdentificationNumber AS StockIdentificationNumber,
  _item.DocumentReltdStockDocUUID AS DocumentReltdStockDocUUID,
  _item.DocumentReltdStockDocItemUUID AS DocumentReltdStockDocItemUUID,
  _item.WhseTaskGoodsReceiptDateTime AS WhseTaskGoodsReceiptDateTime,
  _item.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  _item.CountryOfOrigin AS CountryOfOrigin,
  _item.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  cast ( _item.PInvIsZeroCount as boole_d ) AS PInvIsZeroCount,
  _item.RequestedQuantityUnit AS RequestedQuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS RequestedQuantitySAPUnit,
  _item.RequestedQuantity AS RequestedQuantity,
  _item.PInvItemChgUTCDateTime AS PInvItemChgUTCDateTime,
  _UnitOfMeasure._ISOCode AS _ISOCode
FROM P_ewm_physInventorydoccntitem AS _item
LEFT OUTER JOIN I_EWM_ActiveHarmonizeSrlNmbr AS _ActiveHarmonizeSrlNmbr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_StorageBin AS _StorageBin ON Warehouse = _StorageBin.Warehouse AND StorageBin = _StorageBin.StorageBin  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _StorageBin_2 ON EWMWarehouse = _StorageBin_2.EWMWarehouse AND EWMStorageBin = _StorageBin_2.EWMStorageBin  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON StockType <> '' AND ProductUUID = _Product.ProductUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON RequestedQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;