P_EWM_PhysicalInventoryDocItem

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_PhysicalInventoryDocItem.
-- 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: PEWMPIDOCIT

CREATE VIEW P_EWM_PhysicalInventoryDocItem AS
SELECT
  _DocItem.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  _DocItem.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  _LogHeader.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  _LogHeader.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  PInvDocumentItemType,
  _DocItem.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  _DocItem.ReasonForPhysInvtryDifference AS ReasonForPhysInvtryDifference,
  _DocItem.PriorityCode AS PriorityCode,
  _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(PInvDocumentItemIsPrinted as boole_d) AS PInvDocumentItemIsPrinted,
  cast(PhysicalInventoryIsBlock as boole_d) AS PhysicalInventoryIsBlock,
  cast(PInvBookQuantityIsFreeze as boole_d) AS PInvBookQuantityIsFreeze,
  _DocItem.Warehouse AS Warehouse,
  _ParentItem.StorageType AS StorageType,
  _ParentItem.StorageBin AS StorageBin,
  _PIAreaMapping.PhysicalInventoryArea AS PhysicalInventoryArea,
  _PIAreaMapping.ActivityArea AS ActivityArea,
  cast(_KeyItem.ProductUUID as /scwm/de_matid_noconv) AS ProductUUID,
  _KeyItem.BatchUUID AS BatchUUID,
  _KeyItem.StockType AS StockType,
  _KeyItem.StockUsage AS StockUsage,
  _KeyItem.StockOwner AS StockOwner,
  _KeyItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  _KeyItem.StockDocumentCategory AS StockDocumentCategory,
  _KeyItem.StockDocumentNumber AS StockDocumentNumber,
  _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 PhysicalInventoryRefDocNumber,
  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_PhysicalInventoryArea AS _PIArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_ActyAreaMappingPInvArea AS _PIAreaMapping ON /* join condition not captured in parsed metadata */
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_EWM_BusinessPartner AS _StockOwner ON stockowner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_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]
;