C_PhysInvtryDocItemObjPage

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 C_PhysInvtryDocItemObjPage.
-- 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.
-- Parameters: P_Language : sylangu

CREATE VIEW C_PhysInvtryDocItemObjPage AS
SELECT
  FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  P_PhysInvtryDocItem._SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  PhysInvtrySitnID,
  Material,
  Plant,
  StorageLocation,
  P_PhysInvtryDocItem._ProductStorageLocation.WarehouseStorageBin AS WarehouseStorageBin,
  RealProductBatch AS Batch,
  ValuationType,
  InventorySpecialStockType,
  MovementTypeForReasonCode,
  GoodsMovementType,
  _GoodsMovementReasonControl.GoodsMovementReasonControl AS GoodsMovementReasonControl,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  Customer,
  LastChangeUser,
  P_PhysInvtryDocItem._LastChangeUser.UserDescription AS LastChangeUserDescription,
  LastChangeDate,
  CountedByUser,
  P_PhysInvtryDocItem._CountedByUser.UserDescription AS CountedByUserDescription,
  PhysicalInventoryLastCountDate,
  AdjustmentPostingMadeByUser,
  P_PhysInvtryDocItem._AdjustmentPostingMadeByUser.UserDescription AS AdjmtPostingMadeByUserDesc,
  PostingDate,
  PhysInventoryReferenceNumber,
  _PhysInvtryStatusT[1: Language=$parameters.P_Language].PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  IsHandledInAltvUnitOfMsr,
  PhysicalInventoryItemIsZero,
  QuantityInUnitOfEntry,
  Quantity,
  BookQtyBfrCountInMatlBaseUnit,
  DifferenceQuantityInBaseUnit,
  MaterialBaseUnit,
  UnitOfEntry,
  Currency,
  SlsPriceAmountInCoCodeCrcy,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyAmountInCoCodeCrcy,
  DifferenceAmountInCoCodeCrcy,
  DiffCountedBookAmtInCoCodeCry,
  EnteredSlsAmtInCoCodeCrcy,
  DiffSlsPrcAmtInCoCodeCrcy,
  IsValueOnlyMaterial,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  cast( CycleCountType as mmim_cycle_count_type ) AS CycleCountType,
  NmbrOfPhysInvtryPerFiscalYear,
  PhysInvtryIntvlForCycCounting,
  PhysInvtryFloatTimeCycCounting,
  WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  ProductCategory,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed,
  P_PhysInvtryDocItem._PhysInvtryDocHeader.PhysicalInventoryNumber AS PhysicalInventoryNumber,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsDeleted,
  P_PhysInvtryDocItem._PhysInvtryDocHeader.PhysInvtryDocHasQtySnapshot AS PhysInvtryDocHasQtySnapshot,
  P_PhysInvtryDocItem._PhysInvtryDocHeader.SalesPriceValuationIsActive AS SalesPriceValuationIsActive,
  _ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  cast( cast( '10' as char3) as msehi) AS UnitOfMeasure
FROM P_PhysInvtryDocItem
LEFT OUTER JOIN C_PhysInvtryDocSrlNmbrObjPage AS _PhysInvtryDocSrlNmbrObjPage ON PhysicalInventoryDocument = _PhysInvtryDocSrlNmbrObjPage.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryDocSrlNmbrObjPage.FiscalYear AND PhysicalInventoryDocumentItem = _PhysInvtryDocSrlNmbrObjPage.PhysicalInventoryDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND WBSElementInternalID <> '00000000'  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementReasonControl AS _GoodsMovementReasonControl ON MovementTypeForReasonCode = _GoodsMovementReasonControl.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_PhysInvtryReasonCode AS _PhysInvtryReasonCode ON MovementTypeForReasonCode = _PhysInvtryReasonCode.GoodsMovementType AND ReasonForPhysInvtryDifference = _PhysInvtryReasonCode.ReasonForPhysInvtryDifference  -- association [1..1]
LEFT OUTER JOIN I_PhysInvtryDocPrintCount AS _PhysInvtryDocPrintCount ON PhysicalInventoryDocument = _PhysInvtryDocPrintCount.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryDocPrintCount.FiscalYear AND PhysicalInventoryDocumentItem = _PhysInvtryDocPrintCount.PhysicalInventoryDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_PhysInvtryDocumentItem AS _Extension ON FiscalYear = _Extension.FiscalYear AND PhysicalInventoryDocument = _Extension.PhysicalInventoryDocument AND PhysicalInventoryDocumentItem = _Extension.PhysicalInventoryDocumentItem  -- association [0..1]
;