P_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 P_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 P_PhysInvtryDocItem AS
SELECT
  PhysicalInventoryDocument,
  FiscalYear,
  PhysicalInventoryDocumentItem,
  cast( concat( FiscalYear, concat( PhysicalInventoryDocument, PhysicalInventoryDocumentItem ) ) as mmim_pi_situation_id) AS PhysInvtrySitnID,
  Material,
  Plant,
  StorageLocation,
  RealProductBatch,
  Batch,
  ValuationType,
  InventorySpecialStockType,
  PhysicalInventoryStockType,
  _MaterialDocumentRecord.GoodsMovementType AS GoodsMovementType,
  SalesOrder,
  cast(SalesOrderItem as pi_kdpos preserving type) AS SalesOrderItem,
  ScheduleLine,
  Supplier,
  cast(Customer as kunnr preserving type) AS Customer,
  StockOwner,
  LastChangeUser,
  LastChangeDate,
  CountedByUser,
  PhysicalInventoryLastCountDate,
  AdjustmentPostingMadeByUser,
  PostingDate,
  PhysInventoryReferenceNumber,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryItemIsDeleted,
  IsHandledInAltvUnitOfMsr,
  PhysicalInventoryItemIsZero,
  BookQtyBfrCountInMatlBaseUnit,
  Quantity,
  MaterialBaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  DifferenceAmountInCoCodeCrcy,
  Currency,
  EnteredSlsAmtInCoCodeCrcy,
  SlsPriceAmountInCoCodeCrcy,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyAmountInCoCodeCrcy,
  cast((Quantity - BookQtyBfrCountInMatlBaseUnit) as pi_item_diff_qty_i_base_unit) AS DifferenceQuantityInBaseUnit,
  cast((EnteredSlsAmtInCoCodeCrcy - SlsPriceAmountInCoCodeCrcy) as pi_item_diff_sls_prc_co_cry) AS DiffSlsPrcAmtInCoCodeCrcy,
  cast((PhysInvtryCtAmtInCoCodeCrcy - BookQtyAmountInCoCodeCrcy) as mmim_pi_dif_count_book_value ) AS DiffCountedBookAmtInCoCodeCry,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  CycleCountType,
  _CycleCounting.NmbrOfPhysInvtryPerFiscalYear AS NmbrOfPhysInvtryPerFiscalYear,
  _CycleCounting.PhysInvtryIntvlForCycCounting AS PhysInvtryIntvlForCycCounting,
  _CycleCounting.PhysInvtryFloatTimeCycCounting AS PhysInvtryFloatTimeCycCounting,
  WBSElementInternalID,
  IsValueOnlyMaterial,
  ProductCategory,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed
FROM I_PhysInvtryDocItem
LEFT OUTER JOIN I_AdjmtPostingMovementType AS _AdjmtPostingMvtType ON PhysicalInventoryStockType = _AdjmtPostingMvtType.PhysicalInventoryStockType AND InventorySpecialStockType = _AdjmtPostingMvtType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentRecord AS _MaterialDocumentRecord ON MaterialDocument = _MaterialDocumentRecord.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentRecord.MaterialDocumentYear AND MaterialDocumentItem = _MaterialDocumentRecord.MaterialDocumentItem AND MaterialDocument <> ''  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryDocSrlNmbr AS _PhysInvtryDocSrlNmbr ON PhysicalInventoryDocument = _PhysInvtryDocSrlNmbr.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryDocSrlNmbr.FiscalYear AND PhysicalInventoryDocumentItem = _PhysInvtryDocSrlNmbr.PhysicalInventoryDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryReasonCode AS _PhysInvtryReasonCode ON GoodsMovementType = _PhysInvtryReasonCode.GoodsMovementType AND ReasonForPhysInvtryDifference = _PhysInvtryReasonCode.ReasonForPhysInvtryDifference  -- association [0..1]
LEFT OUTER JOIN I_CycleCountingSettings AS _CycleCounting ON _CycleCounting.CycleCountType = CycleCountType AND _CycleCounting .Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = PhysInvtrySitnID AND _SitnInstceIndicator.SitnDefAnchorObject = 'PhysInvtrySitnID'  -- association [0..1]
LEFT OUTER JOIN R_PhysInvtryOutpRequestItem AS _PhysInvtryOutpRequestItem ON PhysicalInventoryDocument = _PhysInvtryOutpRequestItem.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryOutpRequestItem.FiscalYear AND PhysicalInventoryDocumentItem = _PhysInvtryOutpRequestItem.PhysicalInventoryDocumentItem  -- association [1..*]
;