Skip to Content
Author's profile photo Martin Hinderer

Deleting material assignments from inspection plans


Recently I had the issue that a material has been wrongly assigned to an inspection plan in a test system. If you remove the assignment in QP02 via the delete button, the system only sets a deletion indicator in table MAPL on this assignment. Hence the material assignment is still blocking actions like “change of unit of measure”. After digging a bit in the internet I found an SAP report for this, which I like to share also here on SCN.


Standard solution

The correct way to get rid of the assignment is to archive the complete inspection plan (I have not found a way so far to just archive a material-task list assignment).



Beside using transaction QSR6 (which deletes the complete inspection plan from the database without archiving), there is an SAP report that just deletes material assignments from the database: RCPMAPL1


With entering the task list type (e.g. Q) and the group ID, the report displays all assignments. The ones that should be removed can be marked and deleted. It is advisable to first remove the assignment with QP02, as then the deletion indicator will be visible in the report. This ensures that you tick the right assignment…



As always with these kind of actions: be aware that you bypass most SAP security concepts (like dependency/integrity checks,…) with this action! You will most likely need a special approval from (IT) Managment and you normally have to record these actions and document them so that an auditor will understand why this had to be done.




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ayoub Habchi
      Ayoub Habchi

      Good tip Martin. Thanks for the info.

      Author's profile photo Anand Rao
      Anand Rao

      Thanks Martin! Great article 🙂

      Author's profile photo SAP WARRIOR

      Its very informative. Great!!!

      Author's profile photo Sankar AK
      Sankar AK

      Thanks martin. It's not an kind of normal issue. Great effort. Once again thanks for sharing this document

      Author's profile photo GYAN R
      GYAN R

      Nice document.

      Author's profile photo Nitin Jinagal
      Nitin Jinagal

      Great work Martin!! I didn't about this facility.

      Keep posting 🙂


      Author's profile photo Former Member
      Former Member

      Very good information shared. Great work