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.
-- SQL view name: IAUPIDOCITEM

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,
  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_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
;