P_PhysInvtryDocItem

PI Document Calculate Difference Values | view: PPIDOCITEM | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: ISEGT150T159C
Column Name Description
PhysicalInventoryDocument Physical Inventory Document
FiscalYear Fiscal Year
PhysicalInventoryDocumentItem Physical Inventory Item Number
Column Name Description
💲 Company Code Currency (Currency):
DifferenceAmountInCoCodeCrcy Value of Difference
EnteredSlsAmtInCoCodeCrcy Externally Entered Value Based on Sales Price
SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy Book Value
DiffSlsPrcAmtInCoCodeCrcy Value of Difference Based on Sales Price
DiffCountedBookAmtInCoCodeCry Difference Value based on Count Entry
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
Quantity Counted Quantity
DifferenceQuantityInBaseUnit Physical Inventory Item Difference Quantity in Base Unit
📏 Entry Unit (UnitOfEntry):
QuantityInUnitOfEntry Counted Quantity in Entry Unit
Column Name Description
LastChangeDate Last Changed On
PhysicalInventoryLastCountDate Date of Last Count
PostingDate Posting Date in the Document
Column Name Description
PhysicalInventoryItemIsCounted Item is Counted Show values
PhysInvtryDifferenceIsPosted Difference of Item is Posted Show values
PhysInvtryItemIsRecounted Item is Recounted Show values
PhysInvtryItemIsDeleted Item is Deleted 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
Column Name Description Domain name
PhysInvtrySitnID Physical Inventory Situation ID
GoodsMovementType Movement Type for Adjustment BWART
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
ScheduleLine Delivery Schedule for Sales Order NUM04
StockOwner Owner of stock LIFNR
LastChangeUser Changed By USNAM
CountedByUser Counted By USNAM
AdjustmentPostingMadeByUser Adjustment Posting Made By USNAM
PhysInventoryReferenceNumber Physical Inventory Reference XBLNR1
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
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant
  • P_PHYSINVTRYDOCITEM.BATCH == MCHA.CHARG
  • P_PHYSINVTRYDOCITEM.MANDT == MCHA.MANDT
  • P_PHYSINVTRYDOCITEM.MATERIAL == MCHA.MATNR
  • P_PHYSINVTRYDOCITEM.PLANT == MCHA.WERKS
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • P_PHYSINVTRYDOCITEM.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
  • P_PHYSINVTRYDOCITEM.MANDT == MARA.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_PHYSINVTRYDOCITEM.MANDT == TCURC.MANDT
  • P_PHYSINVTRYDOCITEM.CURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_PHYSINVTRYDOCITEM.CUSTOMER == KNA1.KUNNR
  • P_PHYSINVTRYDOCITEM.MANDT == KNA1.MANDT
Special Stock Type
  • Client
  • Special Stock Type
  • P_PHYSINVTRYDOCITEM.MANDT == T148.MANDT
  • P_PHYSINVTRYDOCITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Client
  • Material Number
  • P_PHYSINVTRYDOCITEM.MANDT == MARA.MANDT
  • P_PHYSINVTRYDOCITEM.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_PHYSINVTRYDOCITEM.MANDT == T006.MANDT
  • P_PHYSINVTRYDOCITEM.MATERIALBASEUNIT == T006.MSEHI
Plant
  • Client
  • Material Number
  • Plant
  • P_PHYSINVTRYDOCITEM.MANDT == MARC.MANDT
  • P_PHYSINVTRYDOCITEM.MATERIAL == MARC.MATNR
  • P_PHYSINVTRYDOCITEM.PLANT == MARC.WERKS
Difference Reason
  • ?
  • Difference Reason
  • Client
  • P_PHYSINVTRYDOCITEM.[column in domain "BWART"] == T157D.BWART
  • P_PHYSINVTRYDOCITEM.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • P_PHYSINVTRYDOCITEM.MANDT == T157D.MANDT
Storage location
  • Storage location
  • Client
  • Material Number
  • Plant
  • P_PHYSINVTRYDOCITEM.STORAGELOCATION == MARD.LGORT
  • P_PHYSINVTRYDOCITEM.MANDT == MARD.MANDT
  • P_PHYSINVTRYDOCITEM.MATERIAL == MARD.MATNR
  • P_PHYSINVTRYDOCITEM.PLANT == MARD.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • P_PHYSINVTRYDOCITEM.SUPPLIER == LFA1.LIFNR
  • P_PHYSINVTRYDOCITEM.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • P_PHYSINVTRYDOCITEM.UNITOFENTRY == T006.MSEHI
  • P_PHYSINVTRYDOCITEM.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Cycle Count Type
  • Client
  • Plant
  • P_PHYSINVTRYDOCITEM.CYCLECOUNTTYPE == T159C.ABCIN
  • P_PHYSINVTRYDOCITEM.MANDT == T159C.MANDT
  • P_PHYSINVTRYDOCITEM.PLANT == T159C.WERKS