need a report of material no , batch no , material's ( length & width )

[digvijay_rai]

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 .

[Former Member]

Hello

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.