I_EWM_PInvItemFlattenedRow

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 I_EWM_PInvItemFlattenedRow.
-- 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 I_EWM_PInvItemFlattenedRow AS
SELECT
  _PIHeader.EWMWarehouse AS EWMWarehouse,
  _PIHeader.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  _PIHeader.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  item.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  item.LineIndexOfPInvItem AS LineIndexOfPInvItem,
  _storagebin.EWMStorageType AS EWMStorageType,
  _storagebin.EWMStorageBin AS EWMStorageBin,
  item.EWMPhysicalInventoryStatus AS EWMPhysicalInventoryStatus,
  _PIAreaMapping.ActivityArea AS ActivityArea,
  cast( _PIItemBinEmpty.EWMStorageBinIsEmpty as boole_d ) AS EWMStorageBinIsEmpty,
  _parent.PackagingMaterial AS PackagingMaterial,
  _parent.HandlingUnitType AS HandlingUnitType,
  _PIItemBusKey.Product AS Product,
  _PIItemBusKey.ProductUUID AS ProductUUID,
  _PIItemBusKey.Batch AS Batch,
  _PIItemBusKey.BatchUUID AS BatchUUID,
  _PIItemBusKey.SerialNumberRequiredLevel AS SerialNumberRequiredLevel,
  _PIItemBusKey.EWMStockType AS EWMStockType,
  _PIItemBusKey.EWMStockOwner AS EWMStockOwner,
  _PIItemBusKey.StockOwnerPartnerRole AS StockOwnerPartnerRole,
  _PIItemBusKey.EWMStockUsage AS EWMStockUsage,
  _PIItemBusKey.EntitledToDisposeParty AS EntitledToDisposeParty,
  _PIItemBusKey.EntitledToDisposePartnerRole AS EntitledToDisposePartnerRole,
  _PIItemBusKey.StockDocumentCategory AS StockDocumentCategory,
  _PIItemBusKey.WBSElementInternalID AS WBSElementInternalID,
  _PIItemBusKey.WBSElementExternalID AS WBSElementExternalID,
  _PIItemBusKey.SpecialStockIdfgSalesOrder AS SpecialStockIdfgSalesOrder,
  _PIItemBusKey.SpecialStockIdfgSalesOrderItem AS SpecialStockIdfgSalesOrderItem,
  item.WhseQualityInspectionType AS WhseQualityInspectionType,
  item.QualityInspectionDocUUID AS QualityInspectionDocUUID,
  _QualityInspection.QualityInspectionDocument AS QualityInspectionDocument,
  item.StockIdentificationNumber AS StockIdentificationNumber,
  item.EWMStockReferenceDocCategory AS EWMStockReferenceDocCategory,
  item.EWMStockRefDocumentUUID AS EWMStockRefDocumentUUID,
  item.EWMStockRefDocItemUUID AS EWMStockRefDocItemUUID,
  item.EWMGoodsReceiptDateTime AS EWMGoodsReceiptDateTime,
  item.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  item.CountryOfOrigin AS CountryOfOrigin,
  item.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  cast( _PIItemCountedQuan.PInvIsZeroCount as boole_d ) AS PInvIsZeroCount,
  cast(_PIItemProposedQuan.QuantityOfPInvItemInBaseUoM as ewm_de_pi_suggestedquantity preserving type ) AS EWMPhysInvtrySuggestedQty,
  cast(_PIItemProposedQuan.UnitOfMeasure as ewm_de_pi_suggestedquantityuom preserving type ) AS EWMPhysInvtrySuggestedQtyUnit,
  cast(_PIItemProposedQuan.QuantityOfPInvItemInBaseUoM as ewm_de_pi_bookedquantity preserving type ) AS EWMPhysInvtryBookQuantity,
  cast(_PIItemProposedQuan.UnitOfMeasure as ewm_de_pi_bookedquantityuom preserving type ) AS EWMPhysInvtryBookQtyUnit,
  cast(_PIItemCountedQuan.EnteredQuantityOfPInvItem as ewm_de_pi_enteredquanity preserving type ) AS EWMPhysInvtryEnteredQuantity,
  cast(_PIItemCountedQuan.EnteredUoMOfPInv as ewm_de_pi_enteredquanityuom preserving type ) AS EWMPhysInvtryEnteredQtyUnit,
  cast(_PIItemDiffQuan.EWMPhysInvtryDiffQuantity as ewm_de_pi_differencequantity preserving type ) AS EWMPhysInvtryDiffQuantity,
  cast(_PIItemDiffQuan.EWMPhysInvtryDiffQuantityUnit as ewm_de_pi_differenceqtyuom preserving type ) AS EWMPhysInvtryDiffQuantityUnit,
  item.PhysicalInventoryStockUUID AS PhysicalInventoryStockUUID
FROM P_EWM_PInvItemFlattenedRow06 AS item
LEFT OUTER JOIN P_EWM_PhysicalInventoryItem01 AS _storagebin ON _storagebin.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID AND _storagebin.PhysicalInventoryItemNumber = item.PhysicalInventoryItemNumber  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvItemFlattenedRow04 AS _parent ON item.PhysicalInventoryDocumentUUID = _parent.PhysicalInventoryDocumentUUID AND item.PhysicalInventoryItemNumber = _parent.PhysicalInventoryItemNumber AND item.PhysicalInventoryChangeVersion = _parent.PhysicalInventoryChangeVersion AND item.ParentHandlingUnitNumber = _parent.HandlingUnitNumber AND item.ParentHandlingUnitNumber is not initial  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocHeaderLog AS _PIHeader ON _PIHeader.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID  -- association [1..1]
LEFT OUTER JOIN P_EWM_ActyAreaMappgPInvArea AS _PIAreaMapping ON _PIAreaMapping.PhysicalInventoryAreaUUID = item.PhysicalInventoryAreaUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_QltyInspDocUUID AS _QualityInspection ON _QualityInspection.QualityInspectionDocUUID = item.QualityInspectionDocUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestInbHdr AS _WarehouseRequestInbHdr ON _WarehouseRequestInbHdr.EWMWarehouseRequestUUID = item.EWMStockRefDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestOutHdr AS _WarehouseRequestOutHdr ON _WarehouseRequestOutHdr.EWMWarehouseRequestUUID = item.EWMStockRefDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_ProdnMatlReqHeader AS _ProdnMatlReqHeader ON _ProdnMatlReqHeader.EWMProductionMaterialReqUUID = item.EWMStockRefDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_InbDeliveryItemBasic AS _InbDeliveryItem ON _InbDeliveryItem.InboundDeliveryUUID = item.EWMStockRefDocumentUUID AND _InbDeliveryItem.InboundDeliveryItemUUID = item.EWMStockRefDocItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestOutItem AS _WarehouseRequestOutItem ON _WarehouseRequestOutItem.EWMWarehouseRequestUUID = item.EWMStockRefDocumentUUID AND _WarehouseRequestOutItem.EWMWarehouseRequestItemUUID = item.EWMStockRefDocItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_ProdnMatlReqItem AS _ProdnMatlReqItem ON _ProdnMatlReqItem.EWMProductionMaterialReqUUID = item.EWMStockRefDocumentUUID AND _ProdnMatlReqItem.EWMProductionMatlReqItemUUID = item.EWMStockRefDocItemUUID  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvDocBusKeyItem AS _PIItemBusKey ON _PIItemBusKey.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID AND _PIItemBusKey.PhysicalInventoryItemNumber = item.PhysicalInventoryItemNumber AND _PIItemBusKey.LineIndexOfPInvItem = item.LineIndexOfPInvItem AND _PIItemBusKey.PhysicalInventoryChangeVersion = item.PhysicalInventoryChangeVersion AND _PIItemBusKey.PInvDocumentItemType = item.PInvDocumentItemType  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvDocBusItemQty AS _PIItemProposedQuan ON _PIItemProposedQuan.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID AND _PIItemProposedQuan.PhysicalInventoryItemNumber = item.PhysicalInventoryItemNumber AND _PIItemProposedQuan.LineIndexOfPInvItem = item.LineIndexOfPInvItem AND _PIItemProposedQuan.PhysicalInventoryChangeVersion = item.PhysicalInventoryChangeVersion AND _PIItemProposedQuan.PInvDocumentItemType = 'P' AND _PIItemProposedQuan.PInvQuantityDocStatus = 'PR' AND _PIItemProposedQuan.PInvQuantitySequence = 1  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvDocBusItemQty AS _PIItemCountedQuan ON _PIItemCountedQuan.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID AND _PIItemCountedQuan.PhysicalInventoryItemNumber = item.PhysicalInventoryItemNumber AND _PIItemCountedQuan.LineIndexOfPInvItem = item.LineIndexOfPInvItem AND _PIItemCountedQuan.PhysicalInventoryChangeVersion = item.PhysicalInventoryChangeVersion AND _PIItemCountedQuan.PInvDocumentItemType = 'C' AND _PIItemCountedQuan.PInvQuantityDocStatus = 'CO' AND _PIItemCountedQuan.PInvQuantitySequence = 1  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvItemRow_DiffQty AS _PIItemDiffQuan ON _PIItemDiffQuan.PhysicalInventoryDocumentUUID = item.PhysicalInventoryDocumentUUID AND _PIItemDiffQuan.PhysicalInventoryItemNumber = item.PhysicalInventoryItemNumber AND _PIItemDiffQuan.LineIndexOfPInvItem = item.LineIndexOfPInvItem  -- association [0..1]
LEFT OUTER JOIN P_EWM_PhysInvtryStorBinIsEmpty AS _PIItemBinEmpty ON item.PhysicalInventoryDocumentUUID = _PIItemBinEmpty.PhysicalInventoryDocumentUUID AND item.PhysicalInventoryItemNumber = _PIItemBinEmpty.PhysicalInventoryItemNumber AND _PIItemBinEmpty.PInvDocumentItemType = 'C' AND item.PhysicalInventoryChangeVersion = _PIItemBinEmpty.PhysicalInventoryChangeVersion  -- association [0..1]
;