I_PhysInvtryDocItem

Physical Inventory Document Item | view: IPIDOCITEM | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: ISEG
Column Name Description
FiscalYear Fiscal Year
PhysicalInventoryDocument Physical Inventory Document
PhysicalInventoryDocumentItem Physical Inventory Item Number
Column Name Description
💲 Company Code Currency (Currency):
DifferenceAmountInCoCodeCrcy Value of Difference
SlsPrcAmtInclVATInCoCodeCrcy Value at Sales Prices Including Value-Added Tax
SlsPrcAmtExclVATInCoCodeCrcy Value at Sales Prices Excluding Value Added Tax
DiffAmountOnCountEntryInCCCrcy Inventory Difference Value Upon Count Entry
EnteredSlsAmtInCoCodeCrcy Externally Entered Value Based on Sales Price
SlsPriceAmountInCoCodeCrcy Sales Price Book Value
PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy Book Value
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
BookQtyBfrCountInMatlBaseUnit Book Quantity Immediately Prior to Count
Quantity Counted Quantity
📏 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
SalesOrder Sales Order Number VBELN
SalesOrderItem Item Number in Sales Order 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
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Material Document Item MBLPO
PhysInvtryRecountDocument Number of Recount Document BELNR
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Plant
  • Client
  • I_PHYSINVTRYDOCITEM.BATCH == MCHA.CHARG
  • I_PHYSINVTRYDOCITEM.MATERIAL == MCHA.MATNR
  • I_PHYSINVTRYDOCITEM.PLANT == MCHA.WERKS
  • I_PHYSINVTRYDOCITEM.MANDT == MCHA.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_PHYSINVTRYDOCITEM.MANDT == MARA.MANDT
  • I_PHYSINVTRYDOCITEM.CROSSPLANTCONFIGURABLEMATERIAL == MARA.MATNR
Company Code Currency
  • Client
  • Company Code Currency
  • I_PHYSINVTRYDOCITEM.MANDT == TCURC.MANDT
  • I_PHYSINVTRYDOCITEM.CURRENCY == TCURC.WAERS
Account number of customer
  • Account number of customer
  • Client
  • I_PHYSINVTRYDOCITEM.CUSTOMER == KNA1.KUNNR
  • I_PHYSINVTRYDOCITEM.MANDT == KNA1.MANDT
Special Stock Type
  • Special Stock Type
  • Client
  • I_PHYSINVTRYDOCITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_PHYSINVTRYDOCITEM.MANDT == T148.MANDT
Material Number
  • Material Number
  • Client
  • I_PHYSINVTRYDOCITEM.MATERIAL == MARA.MATNR
  • I_PHYSINVTRYDOCITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PHYSINVTRYDOCITEM.MATERIALBASEUNIT == T006.MSEHI
  • I_PHYSINVTRYDOCITEM.MANDT == T006.MANDT
Plant
  • Material Number
  • Plant
  • Client
  • I_PHYSINVTRYDOCITEM.MATERIAL == MARC.MATNR
  • I_PHYSINVTRYDOCITEM.PLANT == MARC.WERKS
  • I_PHYSINVTRYDOCITEM.MANDT == MARC.MANDT
Difference Reason
  • ?
  • Difference Reason
  • Client
  • I_PHYSINVTRYDOCITEM.[column in domain "BWART"] == T157D.BWART
  • I_PHYSINVTRYDOCITEM.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • I_PHYSINVTRYDOCITEM.MANDT == T157D.MANDT
Storage location
  • Material Number
  • Plant
  • Storage location
  • Client
  • I_PHYSINVTRYDOCITEM.MATERIAL == MARD.MATNR
  • I_PHYSINVTRYDOCITEM.PLANT == MARD.WERKS
  • I_PHYSINVTRYDOCITEM.STORAGELOCATION == MARD.LGORT
  • I_PHYSINVTRYDOCITEM.MANDT == MARD.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_PHYSINVTRYDOCITEM.SUPPLIER == LFA1.LIFNR
  • I_PHYSINVTRYDOCITEM.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • I_PHYSINVTRYDOCITEM.UNITOFENTRY == T006.MSEHI
  • I_PHYSINVTRYDOCITEM.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Cycle Count Type
  • Plant
  • Client
  • I_PHYSINVTRYDOCITEM.CYCLECOUNTTYPE == T159C.ABCIN
  • I_PHYSINVTRYDOCITEM.PLANT == T159C.WERKS
  • I_PHYSINVTRYDOCITEM.MANDT == T159C.MANDT