I_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 I_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.

CREATE VIEW I_EWM_PhysicalInventoryDocItem AS
SELECT
  guid_doc AS PhysicalInventoryDocumentUUID,
  item_no AS PhysicalInventoryItemNumber,
  line_idx AS LineIndexOfPInvItem,
  change_seq AS PhysicalInventoryChangeVersion,
  item_type AS PInvDocumentItemType,
  item_group AS PInvDocumentItemsGroup,
  lvl AS PhysicalInventoryItemLevel,
  doc_type AS PhysicalInventoryDocumentType,
  doc_status AS PhysicalInventoryStatusText,
  count_date AS EWMPhysInventoryCountDateTime,
  count_user AS PhysicalInventoryCountUserName,
  create_date AS PhysicalInventoryCreateDate,
  post_date AS PhysicalInventoryPostDate,
  dif_direction AS MovementDirectionOfPInv,
  post_item AS PhysInvtryDifferenceIsPosted,
  guid_item AS PhysicalInventoryStockUUID,
  type_item AS PhysicalInventoryItemType,
  guid_parent AS PInvItemParentUUID,
  type_parent AS PInvItemParentType,
  pi_area AS PhysicalInventoryAreaUUID,
  block_ind AS PhysicalInventoryIsBlock,
  freeze_ind AS PInvBookQuantityIsFreeze,
  vsi_item AS PInvStockIsVirtual,
  priority AS PriorityCode,
  priority AS EWMPhysicalInventoryPriority,
  item_new_ind AS PInvItemIsAdditionalNew,
  ind_printed AS PInvDocumentItemIsPrinted,
  order_seq AS SequenceOfPInvDocumentItems,
  line_guid AS PhysicalInventoryItemLineUUID,
  ind_hu_item_comp AS HndlgUnitItemCountedIsComplete,
  ind_hu_item_empt AS HndlgUnitItemCountedIsEmpty,
  ind_hu_item_noex AS HndlgUnitItemCountedIsNotExist,
  ind_loc_par_empt AS StorageBinIsEmpty,
  ind_loc_par_empt AS EWMStorageBinIsEmpty,
  ind_item_checked AS StorageBinIsChecked,
  ind_add_it_check AS AdditionalItemIsFound,
  insptyp AS WhseQualityInspectionType,
  inspid AS QualityInspectionDocUUID,
  idplate AS StockIdentificationNumber,
  qdoccat AS DocumentReltdStockDocCat,
  qdocid AS DocumentReltdStockDocUUID,
  qitmid AS DocumentReltdStockDocItemUUID,
  reason AS ReasonForPhysInvtryDifference,
  reason AS EWMPhysInvtryDifferenceReason,
  wdatu AS WhseTaskGoodsReceiptDateTime,
  vfdat AS ShelfLifeExpirationDate,
  coo AS CountryOfOrigin,
  brestr AS MatlBatchIsInRstrcdUseStock,
  exccode AS WarehouseTaskExceptionCode,
  iprcode AS InternalProcessCode,
  _ParentItem.Warehouse AS Warehouse,
  _ParentItem.Warehouse AS EWMWarehouse
FROM /lime/pi_doc_it
LEFT OUTER JOIN I_EWM_PInvDocBusKeyItem AS _KeyItem ON PhysicalInventoryDocumentUUID = _KeyItem.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _KeyItem.PhysicalInventoryItemNumber AND LineIndexOfPInvItem = _KeyItem.LineIndexOfPInvItem AND PhysicalInventoryChangeVersion = _KeyItem.PhysicalInventoryChangeVersion AND PInvDocumentItemType = _KeyItem.PInvDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocBusKeyParent AS _ParentItem ON PhysicalInventoryDocumentUUID = _ParentItem.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _ParentItem.PhysicalInventoryItemNumber AND LineIndexOfPInvItem = _ParentItem.LineIndexOfPInvItem AND PhysicalInventoryChangeVersion = _ParentItem.PhysicalInventoryChangeVersion AND PInvDocumentItemType = _ParentItem.PInvDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvDocBusItemQty AS _Quantity ON PhysicalInventoryDocumentUUID = _Quantity.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _Quantity.PhysicalInventoryItemNumber AND LineIndexOfPInvItem = _Quantity.LineIndexOfPInvItem AND PhysicalInventoryChangeVersion = _Quantity.PhysicalInventoryChangeVersion AND PInvDocumentItemType = _Quantity.PInvDocumentItemType  -- association [0..*]
;