Error in Permanent deletion of Material Master.

[shankar_kumar]

While doing the deletion of Material master (As it is no more required)

These are the steps:

1. Flag material for deletion. transaction MM06
2. Run report MMREO001 - Selection of materials flagged for deletion and select the material
3. Run report MMREO050 Archive Materials to archive the material

after the ste No. 3, it gives the error message of all the documents open in the system, once you delete the open documents like PR, PO, RFQ etc the error message disappear.

In this process these error message is not getting deleted as these are master data in the standard tables MARC and MARD (as in the screen shot.)

Without deleting these enteries we can not move forward for archiving the material master.

help me in doing the same. How to do this, still trying.

last step is as below.

4. Run report MMREO110 Deletion Program for Archiving Materials to delete the material

[JL23]

The message says you have open reservations/dependend requirements.

you can use MD04 to see them or directly look into table RESB

You have to get rit of these reservations  before you can archive.

OSS note 900537 guides you for each of the archiving error messages in material master

[shankar_kumar]

Hi Experts,

There is nothing shows in transaction MD04, no reservation exists for this material.

but when we go to table MARC and MARD there is one entry in each against the plant.

There is deletion flag exist in both the table.

taking help from Oss note 900537,

thanks,

Shankar

[prabakaran_gurusamy2]

One handy way to findout open orders for that material..it is indirect way...

Go purchasing view activate batch management if material is not batch managed. if it is batch managed, just untick batch management and press enter, u will be getting  message"

Batch management requirement cannot be changed; choose "Display errors""..then go to Edit --> Display error and u will be getting list of orders or reservation exist for that material.

Delete it and carrry on archieve...the above is suitable only if u get error due to some open orders.

Thanks and regards,

Prabakaran Gurusamy

[Former Member]

Deleting og Master record is not advisable, may be any open documents are in system, that will get affected due to this, so as even though its not required for future then you can update the master record with new material and use the same material no for new material.