A_PhysInventoryDocItem

Document Items | view: API_PIDOCITEM | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: IKPFISEGPRTET001KT001WPROJPRPS
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
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
IsValueOnlyMaterial Is Value-Only Material Show values
PhysicalInventoryItemIsZero Is Zero Count Show values
Column Name Description Domain name
SalesOrder Sales Order Number VBELN
SalesOrderItem Item Number in Sales Order NUM06
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
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
LastChangeDateTime Last Change Timestamp TZNTSTMPL
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Plant
  • Client
  • Material Number
  • A_PHYSINVENTORYDOCITEM.BATCH == MCHA.CHARG
  • A_PHYSINVENTORYDOCITEM.PLANT == MCHA.WERKS
  • A_PHYSINVENTORYDOCITEM.MANDT == MCHA.MANDT
  • A_PHYSINVENTORYDOCITEM.MATERIAL == MCHA.MATNR
Company Code Currency
  • Company Code Currency
  • Client
  • A_PHYSINVENTORYDOCITEM.CURRENCY == TCURC.WAERS
  • A_PHYSINVENTORYDOCITEM.MANDT == TCURC.MANDT
Account number of customer
  • Account number of customer
  • Client
  • A_PHYSINVENTORYDOCITEM.CUSTOMER == KNA1.KUNNR
  • A_PHYSINVENTORYDOCITEM.MANDT == KNA1.MANDT
Special Stock Type
  • Client
  • Special Stock Type
  • A_PHYSINVENTORYDOCITEM.MANDT == T148.MANDT
  • A_PHYSINVENTORYDOCITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Client
  • Material Number
  • A_PHYSINVENTORYDOCITEM.MANDT == MARA.MANDT
  • A_PHYSINVENTORYDOCITEM.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • A_PHYSINVENTORYDOCITEM.MANDT == T006.MANDT
  • A_PHYSINVENTORYDOCITEM.MATERIALBASEUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • Material Number
  • A_PHYSINVENTORYDOCITEM.PLANT == MARC.WERKS
  • A_PHYSINVENTORYDOCITEM.MANDT == MARC.MANDT
  • A_PHYSINVENTORYDOCITEM.MATERIAL == MARC.MATNR
Difference Reason
  • ?
  • Difference Reason
  • Client
  • A_PHYSINVENTORYDOCITEM.[column in domain "BWART"] == T157D.BWART
  • A_PHYSINVENTORYDOCITEM.REASONFORPHYSINVTRYDIFFERENCE == T157D.GRUND
  • A_PHYSINVENTORYDOCITEM.MANDT == T157D.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • Material Number
  • A_PHYSINVENTORYDOCITEM.STORAGELOCATION == MARD.LGORT
  • A_PHYSINVENTORYDOCITEM.PLANT == MARD.WERKS
  • A_PHYSINVENTORYDOCITEM.MANDT == MARD.MANDT
  • A_PHYSINVENTORYDOCITEM.MATERIAL == MARD.MATNR
Vendor's account number
  • Vendor's account number
  • Client
  • A_PHYSINVENTORYDOCITEM.SUPPLIER == LFA1.LIFNR
  • A_PHYSINVENTORYDOCITEM.MANDT == LFA1.MANDT
Entry Unit
  • Entry Unit
  • Client
  • A_PHYSINVENTORYDOCITEM.UNITOFENTRY == T006.MSEHI
  • A_PHYSINVENTORYDOCITEM.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Count Type
  • Cycle Count Type
  • Plant
  • Client
  • A_PHYSINVENTORYDOCITEM.CYCLECOUNTTYPE == T159C.ABCIN
  • A_PHYSINVENTORYDOCITEM.PLANT == T159C.WERKS
  • A_PHYSINVENTORYDOCITEM.MANDT == T159C.MANDT