Skip to Content

Mass deletion of Quality Inspection types in Material Codes


I want to delete a particular inspection type in multiple material codes.

I have already deactivated it using QA08.

In QMAT table and in MM03 I can still see the Material code with this inspection type in deactivated state.

I want to delete it in mass. In MM17 or QA08 option is not available for deletion.

I searched earlier discussions regarding this topic but could not find clear cut solution.

Is there any way to delete inspection type of material codes in mass without directly deleting from table QMAT??

Thanks in advance.

Ananth Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 02, 2016 at 04:03 AM

    Hi Ananth Krishna,

    Have you tried using QA08 => 2nd tab (Deactivate Inspection type) option for these materials? If you do so then there is a field AKTIV which will be set as "BLANK", meaning this inspection type, though added to the material, but this is no more useful. Thus the impact for incorrect assignment for inspection type can be removed. There may not need any specific or rather special program to practically delete these incorrect inspection types form material master.

    Otherwise, you still need to delete any inspection type form QM View, you can work with ABAP team and try custom program to call MM02 => Add Material + Plant => Go to QM view => Open Inspection Setup => Select the inspection type => Delete Inspection type => Save. Please check if that is feasible.



    Add comment
    10|10000 characters needed characters exceeded

    • You Need to activate the "QA08 enhancements" in customizing. After that you will have two new Option on the "deactivate insp. type" tab:

      - "Inactive inspection Setup"

      - "Delete inspection Setup"

      The second one is the one you will need...



  • Aug 02, 2016 at 04:15 AM

    Hi Ananth,

    There are no such standard transaction in which you can delete the inspection type in mass. You must create a LSMW or BDC to do so.

    But, as I can see that, you have already deactivated the inspection type which is not required and the system is not generating the inspection lot, too. So, technically, your problem is motive to not to generate inspection of a particular inspection type is achieved. Also, there is no problem if the system shows the inspection type in QMAT as deactivated. Just put a filter to only show active inspection type.


    Dipeshkumar Bhavsar

    Add comment
    10|10000 characters needed characters exceeded