QM Tables- Help Needed

[Former Member]

Hi all,

I need to make a report on Defective Quantity ( Materialwise & Vendorwise).

I am trying to make it using the following tables...

qave

qals

marc

mkpf

mseg

qamb

Can somebody suggest me from which table should get Defect type(code) & code group..? Is there any other table for the same..?Coz I need to display defect type alongwith defective material.

[alejandro_lpez]

Hi,

Look at table QMFE, fields FEGRP (Code Group - Problem) and FECOD (Problem or Damage Code)

regards,

Alejandro.

[alejandro_lpez]

Hi,

Make a Select from table QMEL to get field qmnum (Notification No) with the field prueflos (Inspection Lot Number).

SELECT prueflos qmnum INTO TABLE i_defect

FROM qmel FOR ALL ENTRIES IN i_orden

WHERE prueflos = p_prueflos.

Then with table i_defect you can select all the defects and groups asociated to Inspection Lot Number

SELECT qmnum fenum fegrp fecod anzfehler pnlkn merknr probenr

arbpl arbplwerk feqklas

INTO TABLE i_defect_complete

FROM qmfe FOR ALL ENTRIES IN i_defect

WHERE qmnum = i_defect-qmnum.

regards,

Alejandro.