P_PhysInvtryDocItemPerYear

PI Difference per year | view: PPIDIFFPY | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: ISEG, T150, T159C
Column Name Description
Column Name Description
DifferenceAmtPerYrInCoCodeCrcy null
Column Name Description
PInvDiffQtyPerYearInBaseUnit null
Column Name Description
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
Column Name Description Domain name
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
StockOwner Owner of stock LIFNR
NumberOfPInvAdjustmentsPerYear null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Plant
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.BATCH == MCHA.CHARG
  • P_PHYSINVTRYDOCITEMPERYEAR.MATERIAL == MCHA.MATNR
  • P_PHYSINVTRYDOCITEMPERYEAR.PLANT == MCHA.WERKS
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == MCHA.MANDT
Customer Number
  • Customer Number
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.CUSTOMER == KNA1.KUNNR
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == KNA1.MANDT
Special Stock Type
  • Special Stock Type
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == T148.MANDT
Material Number
  • Material Number
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.MATERIAL == MARA.MATNR
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == MARA.MANDT
Plant
  • Material Number
  • Plant
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.MATERIAL == MARC.MATNR
  • P_PHYSINVTRYDOCITEMPERYEAR.PLANT == MARC.WERKS
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == MARC.MANDT
Storage location
  • Material Number
  • Plant
  • Storage location
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.MATERIAL == MARD.MATNR
  • P_PHYSINVTRYDOCITEMPERYEAR.PLANT == MARD.WERKS
  • P_PHYSINVTRYDOCITEMPERYEAR.STORAGELOCATION == MARD.LGORT
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == MARD.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • P_PHYSINVTRYDOCITEMPERYEAR.SUPPLIER == LFA1.LIFNR
  • P_PHYSINVTRYDOCITEMPERYEAR.MANDT == LFA1.MANDT