P_EWM_PINVDOCCNTITEM02_2

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_PINVDOCCNTITEM02_2.
-- 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_PINVDOCCNTITEM02_2 AS
SELECT
  PhysicalInventoryDocumentUUID,
  PhysicalInventoryItemNumber,
  LineIndexOfPInvItem,
  PInvQuantitySequence,
  _item.EWMWarehouse AS EWMWarehouse,
  _LogHeader.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  _LogHeader.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  PInvDocumentItemType,
  PhysicalInventoryStatusText,
  PhysicalInventoryStockUUID,
  PInvItemParentUUID,
  cast( EWMStorageBin as /scwm/lgpla ) AS EWMStorageBin,
  EWMStorageType,
  ParentHandlingUnitNumber,
  ProductUUID,
  _item.Product AS Product,
  BatchUUID,
  case when _Batch.Batch is not null then _Batch.Batch else _MaterialValuation.InventoryValuationType end AS Batch,
  EWMStockType,
  EWMStockOwner,
  StockOwnerPartnerRole,
  EWMStockUsage,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  DocumentReltdStockDocCat,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  PackagingMaterial,
  HandlingUnitType,
  PInvItemParentType,
  PhysicalInventoryItemLevel,
  HandlingUnitNumber,
  PhysicalInventoryItemType,
  HndlgUnitItemCountedIsComplete,
  HndlgUnitItemCountedIsEmpty,
  HndlgUnitItemCountedIsNotExist,
  EWMStorageBinIsEmpty,
  WhseQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationNumber,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  WhseTaskGoodsReceiptDateTime,
  ShelfLifeExpirationDate,
  _item.CountryOfOrigin AS CountryOfOrigin,
  MatlBatchIsInRstrcdUseStock,
  PInvIsZeroCount,
  RequestedQuantityUnit,
  RequestedQuantityISOUnit,
  RequestedQuantitySAPUnit,
  RequestedQuantity,
  PInvItemChgUTCDateTime
FROM P_EWM_PINVDOCCNTITEM01_2 AS _item
LEFT OUTER JOIN I_EWM_PInvDocHeaderLog AS _LogHeader ON PhysicalInventoryDocumentUUID = _LogHeader.PhysicalInventoryDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_SerialNumberHeader_2 AS _SerialNumberHeader ON _item.EWMWarehouse = _SerialNumberHeader.EWMWarehouse AND _item.ProductUUID = _SerialNumberHeader.ProductUUID AND _item.EntitledToDisposeParty = _SerialNumberHeader.EntitledToDisposeParty  -- association [0..1]
LEFT OUTER JOIN I_EWM_SerialNumberProfile AS _SerialNumberProfile ON _item.SerialNumberProfile = _SerialNumberProfile.SerialNumberProfile  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseSerialNmbrProfile_2 AS _WhseSerialNumberProfile ON _item.SerialNumberProfile = _WhseSerialNumberProfile.SerialNumberProfile AND _item.EWMWarehouse = _WhseSerialNumberProfile.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_BatchDistinct AS _Batch ON Product = _Batch.Material AND BatchUUID = _Batch.BatchExtWhseMgmtInternalId  -- association [0..1]
LEFT OUTER JOIN I_EWM_MaterialValuation AS _MaterialValuation ON Product = _MaterialValuation.Product AND BatchUUID = _MaterialValuation.BatchUUID AND EntitledToDisposeParty = _MaterialValuation.EntitledToDisposeParty  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON StockDocumentCategory = 'PJS' AND StockDocumentNumber = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _WBSElementDecentralized ON StockDocumentCategory = 'PJS' AND StockDocumentNumber = _WBSElementDecentralized.StockDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseSystIsDecentralized AS _WhseSystemIsDecentralized ON _WhseSystemIsDecentralized.WarehouseSystemIsDecentralized = 'X'  -- association [0..1]
;