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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.