I_EWM_PhysInvtryItemC

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_PhysInvtryItemC.
-- 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_PhysInvtryItemC AS
SELECT
  PhysicalInventoryDocNumber,
  PhysicalInventoryDocYear,
  EWMWarehouse,
  PhysicalInventoryItemNumber,
  cast( case when PhysicalInventoryItemNumber = '000001' then 1 else 0 end as ewm_de_pi_numberofpinvdocs ) AS EWMNrOfPhysicalInventoryDocs,
  cast( 1 as ewm_de_pi_numberofpinvitems ) AS EWMNrOfPhysicalInventoryItems,
  EWMPhysicalInventoryStatus,
  EWMPhysicalInventoryStatusText,
  PhysicalInventoryDocumentType,
  cast(PInvCountedUTCDateTime as timestamp) AS PInvCountedUTCDateTime,
  tstmp_to_dats( cast( PInvCountedUTCDateTime as tstmp), 'UTC', $session.client, 'NULL' ) as EWMPhysInvtryCountedDate AS clientNULLasEWMPhysInvtryCountedDate,
  PhysicalInventoryCountUserName,
  cast(PhysInventoryCrtnUTCDateTime as timestamp) AS PhysInventoryCrtnUTCDateTime,
  tstmp_to_dats( cast( PhysInventoryCrtnUTCDateTime as tstmp), 'UTC', $session.client, 'NULL' ) as EWMPhysInvtryCreationDate AS clientNULLasEWMPhysInvtryCreationDate,
  cast(EWMPhysInvtryPostingDateTime as timestamp) AS EWMPhysInvtryPostingDateTime,
  tstmp_to_dats( cast( EWMPhysInvtryPostingDateTime as tstmp), 'UTC', $session.client, 'NULL' ) as EWMPhysInvtryPostingDate AS clientNULLasEWMPhysInvtryPostingDate,
  ActivityArea,
  EWMPhysicalInventoryPriority,
  EWMPhysInvtryReason,
  PInvDocumentItemIsPrinted,
  EWMStorageType,
  EWMStorageBin,
  1 AS EWMNumberOfStorageBins,
  _StorageBin.EWMStorageSection AS EWMStorageSection,
  _StorageBin.EWMStorageBinType AS EWMStorageBinType,
  _StorageBin.EWMStorageBinAccessType AS EWMStorageBinAccessType,
  _StorageBin.EWMStorageBinSubdivision AS EWMStorageBinSubdivision,
  Product,
  Batch,
  EWMStockType,
  EWMStockUsage,
  EWMStockOwner,
  _Owner.BusinessPartnerName AS StockOwnerName,
  EntitledToDisposeParty,
  _Entitled.BusinessPartnerName AS NameOfEntitledToDisposeParty,
  StockDocumentCategory,
  WBSElementInternalID,
  WBSElementExternalID,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  WhseQualityInspectionType,
  EWMStockReferenceDocCategory,
  EWMStockReferenceDocument,
  EWMStockReferenceDocumentItem,
  StockIdentificationNumber,
  EWMGoodsReceiptDateTime,
  cast( substring( cast( EWMGoodsReceiptDateTime as abap.char(23) ), 1, 8 ) as ewm_de_gr_date ) AS EWMGoodsReceiptDate,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  MatlBatchIsInRstrcdUseStock,
  EWMPhysInventoryCountingCycle,
  EWMPInvCycCountingIntvlValue,
  EWMPInvCycCountingBufferValue,
  WarehouseOrder,
  PhysicalInventoryRefDocYear,
  EWMRefPhysicalInventoryDoc,
  PhysicalInventoryRefDocItem,
  PInvFreeDefinedRefText
FROM I_EWM_PhysicalInventoryItem AS _PIItem
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [1..1]
LEFT OUTER JOIN I_EWM_StorageType_2 AS _StorageType ON EWMStorageType = _StorageType.EWMStorageType AND EWMWarehouse = _StorageType.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageSection_2 AS _StorageSection ON EWMStorageSection = _StorageSection.EWMStorageSection AND EWMStorageType = _StorageSection.EWMStorageType AND EWMWarehouse = _StorageSection.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _StorageBin ON EWMStorageBin = _StorageBin.EWMStorageBin AND EWMWarehouse = _StorageBin.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBinType_2 AS _StorageBinType ON EWMWarehouse = _StorageBinType.EWMWarehouse AND EWMStorageBinType = _StorageBinType.EWMStorageBinType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBinAccessType AS _StorageBinAccessType ON EWMWarehouse = _StorageBinAccessType.EWMWarehouse AND EWMStorageBinAccessType = _StorageBinAccessType.EWMStorageBinAccessType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StockType_2 AS _StockType ON EWMStockType = _StockType.EWMStockType AND EWMWarehouse = _StockType.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StockUsage AS _StockUsage ON EWMStockUsage = _StockUsage.EWMStockUsage  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Owner ON EWMStockOwner = _Owner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Entitled ON EntitledToDisposeParty = _Entitled.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_EWM_PhysInvtryItemIndicator AS _PhysicalInventoryItemInd ON PhysicalInventoryDocNumber = _PhysicalInventoryItemInd.PhysicalInventoryDocNumber AND PhysicalInventoryDocYear = _PhysicalInventoryItemInd.PhysicalInventoryDocYear AND PhysicalInventoryItemNumber = _PhysicalInventoryItemInd.PhysicalInventoryItemNumber  -- association [0..1]
LEFT OUTER JOIN I_EWM_ActivityArea_2 AS _ActivityArea ON ActivityArea = _ActivityArea.ActivityArea AND EWMWarehouse = _ActivityArea.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_PhysInvtryCycleCounting AS _PhysInvtryCycleCounting ON EWMPhysInventoryCountingCycle = _PhysInvtryCycleCounting.EWMPhysInventoryCountingCycle AND EWMWarehouse = _PhysInvtryCycleCounting.EWMWarehouse  -- association [0..1]
;