P_EWM_PhysInvtryDocItem_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_PhysInvtryDocItem_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_PhysInvtryDocItem_2 AS
SELECT
  _DocItem.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  _DocItem.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  _LogHeader.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  _LogHeader.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  _DocItem.PInvDocumentItemType AS PInvDocumentItemType,
  _DocItem.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  _DocItem.EWMPhysInvtryDifferenceReason AS EWMPhysInvtryDifferenceReason,
  _DocItem.EWMPhysicalInventoryPriority AS EWMPhysicalInventoryPriority,
  _DocItem.PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  _DocItem.PhysicalInventoryCreateDate AS PhysInventoryCrtnUTCDateTime,
  _DocItem.PhysicalInventoryCountUserName AS PhysicalInventoryCountUserName,
  cast(substring(_WhseOrder.PhysicalInventoryRefDocNumber ,5, 10) as /scwm/de_who_noconv) AS WarehouseOrder,
  cast(_DocItem.PInvDocumentItemIsPrinted as boole_d) AS PInvDocumentItemIsPrinted,
  cast(_DocItem.PhysicalInventoryIsBlock as boole_d) AS PhysicalInventoryIsBlock,
  cast(_DocItem.PInvBookQuantityIsFreeze as boole_d) AS PInvBookQuantityIsFreeze,
  _DocItem.EWMWarehouse AS EWMWarehouse,
  _DocItem._ParentItem.EWMStorageType AS EWMStorageType,
  _DocItem._ParentItem.EWMStorageBin AS EWMStorageBin,
  _PIAreaMapping.PhysicalInventoryArea AS PhysicalInventoryArea,
  _PIAreaMapping.ActivityArea AS ActivityArea,
  cast(_DocItem._KeyItem.ProductUUID as /scwm/de_matid_noconv) AS ProductUUID,
  _DocItem._KeyItem.BatchUUID AS BatchUUID,
  _DocItem._KeyItem.EWMStockType AS EWMStockType,
  _DocItem._KeyItem.EWMStockUsage AS EWMStockUsage,
  _DocItem._KeyItem.EWMStockOwner AS EWMStockOwner,
  _DocItem._KeyItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  _DocItem._KeyItem.StockDocumentCategory AS StockDocumentCategory,
  _DocItem._KeyItem.StockDocumentNumber AS StockDocumentNumber,
  _DocItem._KeyItem.StockItemNumber AS StockItemNumber,
  cast(substring(_PrecedingDocument.PhysicalInventoryRefDocNumber ,5, 4) as /lime/pi_doc_year) AS PhysicalInventoryRefDocYear,
  cast(substring(_PrecedingDocument.PhysicalInventoryRefDocNumber ,9, 20) as /lime/pi_doc_number) AS EWMRefPhysicalInventoryDoc,
  cast(substring(_PrecedingDocument.PhysicalInventoryRefDocNumber ,29, 6) as /lime/line_item_id) AS PhysicalInventoryRefDocItem,
  _Reference.PhysicalInventoryRefDocNumber AS PInvFreeDefinedRefText,
  cast(_LastChange.PInvLogItemTimeStamp as /lime/timestamp_int) AS PInvItemChgUTCDateTime
FROM I_EWM_PhysicalInventoryDocItem AS _DocItem
LEFT OUTER JOIN I_EWM_PInvDocHeaderLog AS _LogHeader ON PhysicalInventoryDocumentUUID = _LogHeader.PhysicalInventoryDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocItemLog AS _WhseOrder ON PhysicalInventoryDocumentUUID = _WhseOrder.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _WhseOrder.PhysicalInventoryItemNumber AND _WhseOrder.PhysicalInventoryProcessType = 'SCWM' AND _WhseOrder.PhysicalInventoryRefDocType = 'SCWM_WHO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocItemLog AS _PrecedingDocument ON PhysicalInventoryDocumentUUID = _PrecedingDocument.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _PrecedingDocument.PhysicalInventoryItemNumber AND _PrecedingDocument.PhysicalInventoryLogType = 'RO' AND _PrecedingDocument.PhysicalInventoryProcessType = 'SCWM' AND _PrecedingDocument.PhysicalInventoryRefDocType = 'SCWM_PIDO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocItemLog AS _Reference ON PhysicalInventoryDocumentUUID = _Reference.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _Reference.PhysicalInventoryItemNumber AND _Reference.PhysicalInventoryProcessType = 'SCWM' AND _Reference.PhysicalInventoryRefDocType = 'SCWM_REFUI'  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _StockOwner ON ewmstockowner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Entitled ON entitledtodisposeparty = _Entitled.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvDocItemLastChange AS _LastChange ON PhysicalInventoryDocumentUUID = _LastChange.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _LastChange.PhysicalInventoryItemNumber  -- association [0..1]
;