I_PhysInvtryDocItem

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_PhysInvtryDocItem.
-- 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_PhysInvtryDocItem AS
SELECT
  iseg.gjahr AS FiscalYear,
  cast(iseg.iblnr as pi_item_document preserving type) AS PhysicalInventoryDocument,
  cast(iseg.zeili as pi_item_number preserving type) AS PhysicalInventoryDocumentItem,
  iseg.matnr AS Material,
  iseg.werks AS Plant,
  iseg.lgort AS StorageLocation,
  iseg.charg AS Batch,
  cast( case when ( _ProductPlantBasic.ValuationCategory <> '' and _ProductPlantBasic.IsBatchManagementRequired = '' ) then ( '' ) else ( iseg.charg ) end as charg_d ) as RealProductBatch AS chargendascharg_dasRealProductBatch,
  _BatchPlant.InventoryValuationType AS ValuationType,
  cast(iseg.sobkz as nsdm_spcl_stock_type preserving type) AS InventorySpecialStockType,
  iseg.bstar AS PhysicalInventoryStockType,
  iseg.kdauf AS SalesOrder,
  cast(iseg.kdpos as pi_sales_order_item preserving type) AS SalesOrderItem,
  cast(iseg.kdein as pi_sales_order_sched_line preserving type) AS ScheduleLine,
  cast(iseg.lifnr as mmim_supplier preserving type) AS Supplier,
  cast(iseg.kunnr as mmim_customer preserving type) AS Customer,
  iseg.disub_owner AS StockOwner,
  iseg.usnam AS LastChangeUser,
  iseg.aedat AS LastChangeDate,
  iseg.usnaz AS CountedByUser,
  iseg.zldat AS PhysicalInventoryLastCountDate,
  cast(iseg.usnad as pi_item_adjustment_posting_usr preserving type) AS AdjustmentPostingMadeByUser,
  cast(iseg.budat as mmim_postingdate preserving type) AS PostingDate,
  cast(iseg.xblni as pi_item_reference preserving type ) AS PhysInventoryReferenceNumber,
  cast(iseg.xzael as pi_is_item_counted preserving type) AS PhysicalInventoryItemIsCounted,
  cast(iseg.xdiff as pi_is_item_difference_posted preserving type) AS PhysInvtryDifferenceIsPosted,
  cast(iseg.xnzae as pi_is_item_recounted preserving type) AS PhysInvtryItemIsRecounted,
  cast(iseg.xloek as pi_is_item_deleted preserving type) AS PhysInvtryItemIsDeleted,
  cast(iseg.xamei as pi_item_is_handled_in_altv_uom preserving type) AS IsHandledInAltvUnitOfMsr,
  iseg.buchm AS BookQtyBfrCountInMatlBaseUnit,
  cast(iseg.xnull as pi_item_is_zero_count preserving type) AS PhysicalInventoryItemIsZero,
  cast(iseg.menge as pi_item_cntd_qty preserving type) AS Quantity,
  iseg.meins AS MaterialBaseUnit,
  cast(iseg.erfmg as pi_item_qty_in_entry_uom preserving type) AS QuantityInUnitOfEntry,
  cast(iseg.erfme as pi_item_entry_uom preserving type) AS UnitOfEntry,
  cast(iseg.mjahr as nsdm_mjahr preserving type) AS MaterialDocumentYear,
  iseg.mblnr AS MaterialDocument,
  cast(iseg.zeile as nsdm_mblpo preserving type) AS MaterialDocumentItem,
  iseg.nblnr AS PhysInvtryRecountDocument,
  cast(iseg.dmbtr as pi_item_diff_value preserving type) AS DifferenceAmountInCoCodeCrcy,
  cast(iseg.waers as nsdm_comp_code_currency preserving type) AS Currency,
  cast(iseg.abcin as pi_item_cycle_count_type preserving type) AS CycleCountType,
  iseg.ps_psp_pnr AS WBSElementInternalID,
  cast ( iseg.ps_psp_pnr as ps_s4_pspnr ) AS WBSElementInternalID_2,
  iseg.vkwrt AS SlsPrcAmtInclVATInCoCodeCrcy,
  iseg.vkwra AS SlsPrcAmtExclVATInCoCodeCrcy,
  iseg.diwzl AS DiffAmountOnCountEntryInCCCrcy,
  cast(iseg.exvkw as pi_item_ext_value_sp preserving type) AS EnteredSlsAmtInCoCodeCrcy,
  cast(iseg.buchw as pi_item_sp_of_book_qty preserving type) AS SlsPriceAmountInCoCodeCrcy,
  cast(iseg.kwart as pi_item_is_value_only_mat preserving type) AS IsValueOnlyMaterial,
  cast(iseg.wrtzl as pi_item_counted_qty_value preserving type) AS PhysInvtryCtAmtInCoCodeCrcy,
  cast(iseg.wrtbm as pi_item_book_value preserving type) AS BookQtyAmountInCoCodeCrcy,
  cast(iseg.attyp as prodcategory preserving type) AS ProductCategory,
  cast(iseg.grund as pi_item_difference_reason preserving type) AS ReasonForPhysInvtryDifference,
  cast(iseg.samat as pi_item_cross_plant_cnf_mat preserving type) AS CrossPlantConfigurableMaterial,
  cast(iseg.xdispatch as pi_item_is_diff_distributed preserving type) AS PhysInvtryDiffIsDistributed
FROM iseg
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_BatchPlant AS _BatchPlant ON Material = _BatchPlant.Material AND Plant = _BatchPlant.Plant AND Batch = _BatchPlant.Batch  -- association [0..1]
LEFT OUTER JOIN I_Material AS _CrossPlantConfigurableMatl ON CrossPlantConfigurableMaterial = _CrossPlantConfigurableMatl.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _CrossPlantConfigurableProd ON CrossPlantConfigurableMaterial = _CrossPlantConfigurableProd.Product  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangeUser ON LastChangeUser = _LastChangeUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CountedByUser ON CountedByUser = _CountedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _AdjustmentPostingMadeByUser ON AdjustmentPostingMadeByUser = _AdjustmentPostingMadeByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfEntry ON UnitOfEntry = _UnitOfEntry.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Supplier = _SupplierCompanyByPlant.Supplier AND Plant = _SupplierCompanyByPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompanyByPlant AS _CustomerCompanyByPlant ON Customer = _CustomerCompanyByPlant.Customer AND Plant = _CustomerCompanyByPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderScheduleLine AS _SalesOrderScheduleLine ON SalesOrder = _SalesOrderScheduleLine.SalesOrder AND SalesOrderItem = _SalesOrderScheduleLine.SalesOrderItem AND ScheduleLine = _SalesOrderScheduleLine.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryStatusT AS _PhysInvtryStatusT ON PhysicalInventoryItemIsCounted = _PhysInvtryStatusT.PhysicalInventoryItemIsCounted AND PhysInvtryDifferenceIsPosted = _PhysInvtryStatusT.PhysInvtryDifferenceIsPosted AND PhysInvtryItemIsRecounted = _PhysInvtryStatusT.PhysInvtryItemIsRecounted AND PhysInvtryItemIsDeleted = _PhysInvtryStatusT.PhysInvtryItemIsDeleted  -- association [0..*]
LEFT OUTER JOIN I_PhysInvtryDocHeader AS _PhysInvtryDocHeader ON PhysicalInventoryDocument = _PhysInvtryDocHeader.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryDocHeader.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_PhysInvtryStockType AS _PhysicalInventoryStockType ON PhysicalInventoryStockType = _PhysicalInventoryStockType.PhysicalInventoryStockType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ProductCategory = _ProductCategory.ProductCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND WBSElementInternalID <> '00000000'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID = _WBSElementBasic.WBSElementInternalID AND WBSElementInternalID <> '00000000'  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryDocFiscalYear AS _PhysInvtryDocFiscalYear ON FiscalYear = _PhysInvtryDocFiscalYear.FiscalYear  -- association [1..1]
LEFT OUTER JOIN E_PhysInvtryDocumentItem AS _Extension ON FiscalYear = _Extension.FiscalYear AND PhysicalInventoryDocument = _Extension.PhysicalInventoryDocument AND PhysicalInventoryDocumentItem = _Extension.PhysicalInventoryDocumentItem  -- association [0..1]
;