I_AugmentedPhysInvtryDocItem

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_AugmentedPhysInvtryDocItem.
-- 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_AugmentedPhysInvtryDocItem AS
SELECT
  FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  Plant,
  StorageLocation,
  Material,
  RealProductBatch,
  Batch,
  ValuationType,
  InventorySpecialStockType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  Customer,
  WBSElementInternalID,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryItemIsDeleted,
  CycleCountType,
  _MaterialDocumentRecord.GoodsMovementType AS GoodsMovementType,
  PhysicalInventoryLastCountDate,
  PostingDate,
  ReasonForPhysInvtryDifference,
  LastChangeDate,
  PhysInvtryDiffIsDistributed,
  Currency,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  IsValueOnlyMaterial,
  IsHandledInAltvUnitOfMsr,
  ProductCategory,
  CrossPlantConfigurableMaterial,
  BookQtyBfrCountInMatlBaseUnit,
  PhysicalInventoryItemIsZero,
  Quantity,
  MaterialBaseUnit,
  QuantityInUnitOfEntry,
  cast ((Quantity - BookQtyBfrCountInMatlBaseUnit) as pi_item_diff_qty_i_base_unit preserving type ) AS DifferenceQuantityInBaseUnit,
  UnitOfEntry,
  EnteredSlsAmtInCoCodeCrcy,
  SlsPriceAmountInCoCodeCrcy,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyAmountInCoCodeCrcy,
  cast(DifferenceAmountInCoCodeCrcy as pi_item_max_diff_value preserving type ) AS MaxAbsDiffAmountInCoCodeCrcy,
  cast(DifferenceAmountInCoCodeCrcy as pi_item_min_diff_value preserving type ) AS MinAbsDiffAmountInCoCodeCrcy,
  cast((EnteredSlsAmtInCoCodeCrcy - SlsPriceAmountInCoCodeCrcy) as pi_item_diff_sls_prc_co_cry2 preserving type ) AS DiffSlsPrcAmtInCoCodeCrcy,
  cast( 1 as pi_number_of_items) AS NumberOfPhysInvtryItems
FROM I_PhysInvtryDocItem
LEFT OUTER JOIN I_AdjmtPostingMovementType AS _AdjmtPostingMovementType ON PhysicalInventoryStockType = _AdjmtPostingMovementType.PhysicalInventoryStockType AND InventorySpecialStockType = _AdjmtPostingMovementType.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_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
;