P_PhysInvtryKeyFiguresBase

Basis for the calc. of PI Key Figures for a Stock Sep. Comb. | view: PPIKEYFIGBASE | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: ISEG, T001, TKA02, T001W, T001K, MARV, T150, T159C, FINSC_FISC_DATE
Column Name Description
Material FK Material Number
Plant FK Plant
StorageLocation FK Storage location
Batch FK Batch Number
Supplier FK Vendor's account number
SalesOrder Sales Order Number
SalesOrderItem Sales Order Item
WBSElementInternalID FK Work Breakdown Structure Element (WBS Element)
Customer FK Customer Number
StockOwner Owner of stock
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
InventorySpecialStockType FK Special Stock Type
MaterialBaseUnit FK Base Unit of Measure
Column Name Description
Column Name Description
Column Name Description
PhysicalInventoryLastCountDate null
CurrentDate null
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
Column Name Description Domain name
NumberOfPhysInventoryCounts null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Plant
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.BATCH == MCHA.CHARG
  • P_PHYSINVTRYKEYFIGURESBASE.MATERIAL == MCHA.MATNR
  • P_PHYSINVTRYKEYFIGURESBASE.PLANT == MCHA.WERKS
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == MCHA.MANDT
Customer Number
  • Customer Number
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.CUSTOMER == KNA1.KUNNR
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == KNA1.MANDT
Special Stock Type
  • Special Stock Type
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == T148.MANDT
Material Number
  • Material Number
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.MATERIAL == MARA.MATNR
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.MATERIALBASEUNIT == T006.MSEHI
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == T006.MANDT
Plant
  • Material Number
  • Plant
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.MATERIAL == MARC.MATNR
  • P_PHYSINVTRYKEYFIGURESBASE.PLANT == MARC.WERKS
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == MARC.MANDT
Storage location
  • Storage location
  • Material Number
  • Plant
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.STORAGELOCATION == MARD.LGORT
  • P_PHYSINVTRYKEYFIGURESBASE.MATERIAL == MARD.MATNR
  • P_PHYSINVTRYKEYFIGURESBASE.PLANT == MARD.WERKS
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == MARD.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • P_PHYSINVTRYKEYFIGURESBASE.SUPPLIER == LFA1.LIFNR
  • P_PHYSINVTRYKEYFIGURESBASE.MANDT == LFA1.MANDT