I_PhysInvtryIndBatchStorLoc

Physical Inventory Indicators of Batches on Storage Location | view: IPHYSINDSTORLOC | TRAN | Extraction: Not supported | Component: Physical Inventory
Tables used: MCHB
Column Name Description
Material FK Material Number
Plant FK Plant
StorageLocation FK Storage location
Batch FK Batch Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
Column Name Description
Column Name Description Domain name
InvtryCurrentYearStockInd Physical inventory indicator for whse stock in current year INVKZ
InvtryQualInspCurrentYrStkInd Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
InvtryRestrictedUseStockInd Physical inventory indicator for restricted-use stock INVKZ
InventoryBlockStockInd Physical inventory indicator for blocked stock INVKZ
InventoryStockPrevPeriod Physical inventory indicator for stock in previous year INVKZ
InvtryStockQltyInspPrevPeriod Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
InvtryRestStockPrevPeriodInd Physical inventory ind. for restricted-use stock, prev.pd INVKZ
HasInvtryBlockStockPrevPeriod Phys. inventory indicator for blocked stock in prev. period INVKZ
Master Data Relations Join Conditions
Material/plant/batch
  • Client
  • Plant
  • Batch Number
  • Material Number
  • I_PHYSINVTRYINDBATCHSTORLOC.MANDT == MCHA.MANDT
  • I_PHYSINVTRYINDBATCHSTORLOC.PLANT == MCHA.WERKS
  • I_PHYSINVTRYINDBATCHSTORLOC.BATCH == MCHA.CHARG
  • I_PHYSINVTRYINDBATCHSTORLOC.MATERIAL == MCHA.MATNR
Material
  • Client
  • Material Number
  • I_PHYSINVTRYINDBATCHSTORLOC.MANDT == MARA.MANDT
  • I_PHYSINVTRYINDBATCHSTORLOC.MATERIAL == MARA.MATNR
Material/plant
  • Client
  • Plant
  • Material Number
  • I_PHYSINVTRYINDBATCHSTORLOC.MANDT == MARC.MANDT
  • I_PHYSINVTRYINDBATCHSTORLOC.PLANT == MARC.WERKS
  • I_PHYSINVTRYINDBATCHSTORLOC.MATERIAL == MARC.MATNR
Material/plant/storage location
  • Client
  • Storage location
  • Plant
  • Material Number
  • I_PHYSINVTRYINDBATCHSTORLOC.MANDT == MARD.MANDT
  • I_PHYSINVTRYINDBATCHSTORLOC.STORAGELOCATION == MARD.LGORT
  • I_PHYSINVTRYINDBATCHSTORLOC.PLANT == MARD.WERKS
  • I_PHYSINVTRYINDBATCHSTORLOC.MATERIAL == MARD.MATNR