I_ShopFloorItemBatchSerialNmbr

Shop Floor Item Batch and Serial Number | view: IMPESFIBATCHSN | Extraction: Not supported | Component: Shop Floor Execution
Tables used: MPE_COMP_ASSEMBLJESTMCH1MCHAEQUIEQBSEQUZT001WMPE_SFIMARCMARCT377PTCUCHT377
Column Name Description
ShopFloorItem ID of Serialized Material
Material FK Material Number
Batch FK Batch Number
Plant Plant
SerialNumber Serial Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SerialNumberIsOnStock Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
BatchBySupplier Supplier Batch Number LICHN
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • I_SHOPFLOORITEMBATCHSERIALNMBR.MATERIAL == MCH1.MATNR
  • I_SHOPFLOORITEMBATCHSERIALNMBR.MANDT == MCH1.MANDT
  • I_SHOPFLOORITEMBATCHSERIALNMBR.BATCH == MCH1.CHARG
Material Number
  • Material Number
  • Client
  • I_SHOPFLOORITEMBATCHSERIALNMBR.MATERIAL == MARA.MATNR
  • I_SHOPFLOORITEMBATCHSERIALNMBR.MANDT == MARA.MANDT