In BMBC i can see all batches at a time but i cant see its characteristics at a time i need to click one by one batch .so i want a report or with combination of tables to find out characteristics of a material batch wise at one glance.
Please advice if any possibility
No other such report there in standard SAP.
I have already give u set of tables. use to make this report.
MCH1, INOB, AUSP, CABNT.
MCH1 & INOB
(If only characteristics required which maintain in material master & same for all batches not depend upon batch like source)
MCH1 u2013 MATNR = INOB u2013 OBJEK
INOB u2013 OBTAB = u2018MARAu2019
(If all characteristics required which maintain in material master or in batch)
Then concatenate material & batch in one field first 18 digit taken material & then batch ex. MB
Internal Table u2013 MB = INOB u2013 OBJEK or MCHB u2013 MATNR = INOB u2013 OBJEK
INOB & AUSP
INOB u2013 CUOBJ = AUSP u2013 OBJEK ( For joining INOB-CUOBJ must have 18 digit length for making it 18 digit length plz add zero before value)
INOB u2013 KLART = AUSP u2013 KLART.
AUSP & CABNT
AUSP u2013 ATINN = CABNT u2013 ATINN.
CABNT u2013 SPRAS = u2018Eu2019.
Hope it work