need a report of material no , batch no , material's ( length & width )
Hi friends i need a report in which i am to show material , plant , storage location , batch no , & material length & material width ( its charcteristics are defined by using a class ) , i have found table AUSP in which
field ATFLV field is populated with length & width details but i am not getting how to link this with material no & batch kindly anybody send me elaborated steps will be very thankful if with appropriate codes , ifound atcode MMBE also but client want to see all the above said detail in a single list .
Dzed Maroz replied
select single * from MCH1 where matnr = material_number and charg = batch_number. if sy-subrc = 0. select * from AUSP where objek = MCH1-CUOBJ_BM and atinn = number_of_charcteristic and klart = number_of_class. * do anything here ... endselect. endif.