Delete materials not assigned to any plant.

[Former Member]

Dear Readers,

I am trying to find out a means by which I can identify and delete materials that are not assigned to any of the plants. During the data loads in Production, there were duplicate materials created and only one of the 5 duplicates is assigned to a plant. Is there a means of doing that with standard SAP programs or do we need to write a custom ABAP program for that.

There could be more than 10,000 materials like that.

Thank you for reading and answers are appreciated.

[JL23]

if you know already the numbers of those unwanted materials, then you can archive them with SARA object MM_MATNR.

(it is not mandatory to set a deletion flag first)

if you dont know the materials that do not have plant views, then do se16 for table MARA and check the field PSTAT

The characters in the field indicate which view exist.

call MM50 and press F4 in field maintenance status to get info about what character represents which view.

[Former Member]

Thanks Jurgen,

I have identified that there are 63K materials that need to be deleted based on the maintenance status. What is the best way to delete them; I tried going to MM06, but see that you have to enter the material numbers in it to mark them for deletion.

Appreciate your answers.

[JL23]

do you want them off the database? if yes, then the only way is via archiving.

You can even archive materials that are not flagged for deletion, hence the MM06 step is not necessary.

If you jsut want flag them for deletion, then you have to do it with MM06 one by one or with MM17 en mass.