I_MaterialSerialNumber

Serial No for Material and Stock Segment | view: IMATERIALSERNR | Extraction: Not supported | Component: Plant Maintenance
Tables used: EQUIEQBSEQUZ
Column Name Description
Material FK Material Number
SerialNumber Serial Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Batch Batch Number CHARG
Master Data Relations Join Conditions
Equipment Number
  • Equipment Number
  • Client
  • I_MATERIALSERIALNUMBER.EQUIPMENT == EQUI.EQUNR
  • I_MATERIALSERIALNUMBER.MANDT == EQUI.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_MATERIALSERIALNUMBER.MANDT == T148.MANDT
  • I_MATERIALSERIALNUMBER.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number
  • Client
  • Material Number
  • I_MATERIALSERIALNUMBER.MANDT == MARA.MANDT
  • I_MATERIALSERIALNUMBER.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • I_MATERIALSERIALNUMBER.PLANT == T001W.WERKS
  • I_MATERIALSERIALNUMBER.MANDT == T001W.MANDT
Storage location
  • Plant
  • Client
  • Storage location
  • I_MATERIALSERIALNUMBER.PLANT == T001L.WERKS
  • I_MATERIALSERIALNUMBER.MANDT == T001L.MANDT
  • I_MATERIALSERIALNUMBER.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Stock Type of Goods Movement (Primary Posting)
  • Special Stock Indicator
  • Stock Type of Goods Movement (Primary Posting)
  • I_MATERIALSERIALNUMBER.INVENTORYSPECIALSTOCKTYPE == T156C.SOBKZ
  • I_MATERIALSERIALNUMBER.INVENTORYSTOCKTYPE == T156C.LBBSA