deleting material from master

[Former Member]

hi i want to delete some items from the material master

can some body plz give me the step by step procedure or example

points wil b rewarded

regards

[Former Member]

Hi

Please follow the Steps for deleting a material master:

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

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

NB – The material must not have any recorded material movements.

Hope it wud have answered ur question

Reward if useful

Shawn

[Former Member]

hi shawn

i m not getting anything in MMREO110

plz help

[Former Member]

You can use archiving process in Tcode SARA ->object -->MM_MATNR.

Please check to this link :

http://help.sap.com/erp2005_ehp_02/helpdata/en/8b/8e963466880c30e10000009b38f83b/frameset.htm

[Former Member]

can somebody provide step by step example

[Former Member]

Before a material master record can be archived and deleted, other objects (such as purchasing documents) that refer to this material must themselves be archived. You can see which objects these are and the dependencies between them in the network graphic.

If a material master record cannot be archived and deleted at a given organizational level, the reason is given in the log (for example, a purchase order exists for the material). The log also contains technical data such as the number of material master records read and the number deleted.

After all the Prereq is fullfill than you can go to tcode SARA, enter the object MM_MATNR:

1.Write.

2.Delete

[former_member218067]

Hi,

You can flag materials for deletion through MM06

If you want to delete table entries then you will have to search for MATNR filed with value where used and delete in all tables appox. around 174 TABLES

BR

Diwakar

reward if useful

[Former Member]

i think there should b some other way to delete it rather than deleting it from 174 tables

[Former Member]

Pls Refer,

http://help.sap.com/saphelp_erp2005/helpdata/en/8d/3e59bc462a11d189000000e8323d3a/content.htm

Reward if useful!

[Former Member]

hI,

Materials master created cannot be deleted.It can flagged for deletion in MM06 & MM16.

Thanks

suresh

[Former Member]

no dear

it can b deleted using mm70 or mm71 by archiving

but i dont know how

may b i wil b wrong