P_MappedPhysInvtryItem

PI Items with mapped stock type | view: PMAPPEDPIITEM | 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
DifferenceAmountInCoCodeCrcy Value of Difference
Column Name Description
📏 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
PhysicalInventoryLastCountDate Date of Last Count
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
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
Column Name Description Domain name
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
ScheduleLine Delivery Schedule for Sales Order NUM04
StockOwner Owner of stock LIFNR
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • Plant
  • P_MAPPEDPHYSINVTRYITEM.MATERIAL == MCHA.MATNR
  • P_MAPPEDPHYSINVTRYITEM.BATCH == MCHA.CHARG
  • P_MAPPEDPHYSINVTRYITEM.MANDT == MCHA.MANDT
  • P_MAPPEDPHYSINVTRYITEM.PLANT == MCHA.WERKS
Customer Number
  • Client
  • Customer Number
  • P_MAPPEDPHYSINVTRYITEM.MANDT == KNA1.MANDT
  • P_MAPPEDPHYSINVTRYITEM.CUSTOMER == KNA1.KUNNR
Special Stock Type
  • Special Stock Type
  • Client
  • P_MAPPEDPHYSINVTRYITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_MAPPEDPHYSINVTRYITEM.MANDT == T148.MANDT
Material Number
  • Material Number
  • Client
  • P_MAPPEDPHYSINVTRYITEM.MATERIAL == MARA.MATNR
  • P_MAPPEDPHYSINVTRYITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_MAPPEDPHYSINVTRYITEM.MATERIALBASEUNIT == T006.MSEHI
  • P_MAPPEDPHYSINVTRYITEM.MANDT == T006.MANDT
Plant
  • Material Number
  • Client
  • Plant
  • P_MAPPEDPHYSINVTRYITEM.MATERIAL == MARC.MATNR
  • P_MAPPEDPHYSINVTRYITEM.MANDT == MARC.MANDT
  • P_MAPPEDPHYSINVTRYITEM.PLANT == MARC.WERKS
Storage location
  • Storage location
  • Material Number
  • Client
  • Plant
  • P_MAPPEDPHYSINVTRYITEM.STORAGELOCATION == MARD.LGORT
  • P_MAPPEDPHYSINVTRYITEM.MATERIAL == MARD.MATNR
  • P_MAPPEDPHYSINVTRYITEM.MANDT == MARD.MANDT
  • P_MAPPEDPHYSINVTRYITEM.PLANT == MARD.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • P_MAPPEDPHYSINVTRYITEM.MANDT == LFA1.MANDT
  • P_MAPPEDPHYSINVTRYITEM.SUPPLIER == LFA1.LIFNR