C_PhysInvtryDocItemObjPage

PI Document Item Object Page | view: CPIDOCITEMOP | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Column Name Description
FiscalYear Fiscal Year
PhysicalInventoryDocument Physical Inventory Document
PhysicalInventoryDocumentItem Physical Inventory Item Number
Column Name Description
💲 Company Code Currency (Currency):
SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy Book Value
DifferenceAmountInCoCodeCrcy Value of Difference
DiffCountedBookAmtInCoCodeCry Difference Value based on Count Entry
EnteredSlsAmtInCoCodeCrcy Externally Entered Value Based on Sales Price
DiffSlsPrcAmtInCoCodeCrcy Value of Difference Based on Sales Price
Column Name Description
📏 Entry Unit (UnitOfEntry):
QuantityInUnitOfEntry Counted Quantity in Entry Unit
📏 Base Unit of Measure (MaterialBaseUnit):
Quantity Counted Quantity
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
DifferenceQuantityInBaseUnit Physical Inventory Item Difference Quantity in Base Unit
Column Name Description
LastChangeDate Last Changed On
PhysicalInventoryLastCountDate Date of Last Count
PostingDate Posting Date in the Document
Column Name Description
GoodsMovementReasonControl Control: Reason for Movement Show values
IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal Show values
PhysicalInventoryItemIsZero Is Zero Count Show values
IsValueOnlyMaterial Is Value-Only Material Show values
ProductCategory Material Category Show values
PhysInvtryDiffIsDistributed Is Difference Distributed Show values
PhysicalInventoryItemIsCounted Item is Counted Show values
PhysInvtryDifferenceIsPosted Difference of Item is Posted Show values
PhysInvtryDocHasQtySnapshot Book Inventory Freeze Show values
SalesPriceValuationIsActive Is Sales Price Valuation Active Show values
Column Name Description Domain name
SitnNumberOfInstances Number of Situations INT4
SitnRowCriticalityCode Row Criticality
PhysInvtrySitnID Physical Inventory Situation ID
WarehouseStorageBin Storage Bin CHAR10
GoodsMovementType Movement Type for Adjustment BWART
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
ScheduleLine Delivery Schedule for Sales Order NUM04
LastChangeUser Changed By USNAM
LastChangeUserDescription User Description SUIDTECHDESC
CountedByUser Counted By USNAM
CountedByUserDescription User Description SUIDTECHDESC
AdjustmentPostingMadeByUser Adjustment Posting Made By USNAM
AdjmtPostingMadeByUserDesc User Description SUIDTECHDESC
PhysInventoryReferenceNumber Physical Inventory Reference XBLNR1
PhysicalInventoryStatusText Physical Inventory Status TEXT20
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
MaterialDocumentItem Material Document Item MBLPO
PhysInvtryRecountDocument Number of Recount Document BELNR
NmbrOfPhysInvtryPerFiscalYear No. of Phys. Inventories per Fiscal Year for Cycle Counting NUM3
PhysInvtryIntvlForCycCounting Physical Inventory Interval (in Workdays) for Cycle Counting NUM3
PhysInvtryFloatTimeCycCounting Float Time (in Workdays) for Cycle Counting NUM2
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
PhysicalInventoryNumber Physical Inventory Number XBLNR1
SerialNumberProfile Serial Number Profile SERAIL
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant
  • C_PHYSINVTRYDOCITEMOBJPAGE.BATCH == MCHA.CHARG
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == MCHA.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MATERIAL == MCHA.MATNR
  • C_PHYSINVTRYDOCITEMOBJPAGE.PLANT == MCHA.WERKS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == MARA.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
Company Code Currency
  • Company Code Currency
  • Client
  • C_PHYSINVTRYDOCITEMOBJPAGE.CURRENCY == TCURC.WAERS
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • C_PHYSINVTRYDOCITEMOBJPAGE.CUSTOMER == KNA1.KUNNR
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == KNA1.MANDT
Special Stock Type
  • Special Stock Type
  • Client
  • C_PHYSINVTRYDOCITEMOBJPAGE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == T148.MANDT
Material Number
  • Client
  • Material Number
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == MARA.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == T006.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MATERIALBASEUNIT == T006.MSEHI
Plant
  • Client
  • Material Number
  • Plant
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == MARC.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MATERIAL == MARC.MATNR
  • C_PHYSINVTRYDOCITEMOBJPAGE.PLANT == MARC.WERKS
Difference Reason
  • ?
  • Difference Reason
  • Client
  • C_PHYSINVTRYDOCITEMOBJPAGE.[column in domain "BWART"] == T157D.BWART
  • C_PHYSINVTRYDOCITEMOBJPAGE.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == T157D.MANDT
Storage location
  • Storage location
  • Client
  • Material Number
  • Plant
  • C_PHYSINVTRYDOCITEMOBJPAGE.STORAGELOCATION == MARD.LGORT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == MARD.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.MATERIAL == MARD.MATNR
  • C_PHYSINVTRYDOCITEMOBJPAGE.PLANT == MARD.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == LFA1.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.SUPPLIER == LFA1.LIFNR
Entry Unit
  • Client
  • Entry Unit
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == T006.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.UNITOFENTRY == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Physical Inventory Indicator for Cycle Counting
  • Physical Inventory Indicator for Cycle Counting
  • Client
  • Plant
  • C_PHYSINVTRYDOCITEMOBJPAGE.CYCLECOUNTTYPE == T159C.ABCIN
  • C_PHYSINVTRYDOCITEMOBJPAGE.MANDT == T159C.MANDT
  • C_PHYSINVTRYDOCITEMOBJPAGE.PLANT == T159C.WERKS