Material Master Deletion

[Former Member]

Hi,

I want to delete the material master for some material and like to use the same deleted material code for some other material type.Does Archiving process thru SARA removes the material from database & does it allow to use the same material code.

Thanks,

Karthik

[csaba_szommer · Accepted solution]

Yes.

After sucessful archiving you will be able to create material master with the archived ID. But why don't you test it?

http://help.sap.com/erp2005_ehp_04/helpdata/EN/8d/3e59bc462a11d189000000e8323d3a/frameset.htm

http://www.sap-img.com/bc003.htm

Regards,

Csaba

[former_member659143]

Hi ,

You want to use the same material code for other material number then ,you can simply change the description of the material & use it for the New material as required.In this case please clear the stock available on OLDER Material code.

If material is procured externaly then clear open PO as well.

Deleting --When you don't want the material code to be used or material obsolute , which u will block for usage and still data exits in the system

Archiving is something where u permanently remove the data from the system

Go through the follow steps to archive the material master.

Archive a Material Master Record

When a material is no longer required in a company or plant, you can archive and delete the material master record.

You have to Flag the material master record for deletion(T.code MM06/MM16). This is known as logical deletion.

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.

Some of the archive error log message :-

Costing data exists

Use in routing

Use in sales and distribution

Use in bill of material

Delivery exists

Costing data exists

Info record exists

Purchase order exists

The Archiving steps :-

Archiving object MM_MATNR for archiving material master records.

You can display the archived data, but not reload it.

To archive the material master, first goto transaction MM71.

Type in a variant name and click Maintain. (Tick the Test Mode for archive simulation).

Save the variant.

Maintain the Start date and Spool parameters and click execute.

Click Goto Job Overview to check the archive status.

To do a permanent delete, goto transaction SARA and click Delete button.

Maintain the Archive Selection, Start date and Spool parameters.

Click Test Session for testing or click execute to start the deletion program.

Click Goto Job Overview to check the delete status.

Now, if you goto MM02/MM03, you will not be able to find the record in the material master.

Thanks,

AMIT

[former_member199502]

Hi,

Deleting is something which u will block for usage and still data exits in the system

Archiving is something where u permanently remove the data from the system

Go through the follow steps to archive the material master.

Archiving the Material Master

Before Archiving the Material Master the materials need to be flagged for deletion in T Code MM06/MM16.

Archiving the materials is done thro T Code SARA. All the SAP archive functions are shown in SARA. Choose the corresponding SAP archive object, hit enter and the archive administration menu will be shown.

When a material is no longer required in a company or plant, you can archive and delete the material master record.

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.

Archiving object MM_MATNR for archiving material master records.

To archive the material master, first go to transaction SARA

Type in a variant name and click Maintain. (Tick the Test Mode for archive simulation).

Save the variant.

Maintain the Start date and Spool parameters and click execute.

Click Go to Job Overview to check the archive status.

To do a permanent delete, click Delete button.

Maintain the Archive Selection, Start date and Spool parameters.

Click Test Session for testing or click execute to start the deletion program.

Click Go to Job Overview to check the delete status.

This need to be done carefully and better to first do it in testing client.

After archiving those materials will not be displayed in reports unless categorically selected

Note: SARA is a general transaction where you can archive all types of records using respective archiving object

[JL23]

if you want reuse the number, then just change the description and maybe the one or other field that may need a different content for the new material and dont go thru archiving.

(I am just assuming that you have no used that material before)

If it was used, then you have to archive all dependend data first before you can archive the material master.

And reusing the number is dependend on your nuber range setup. If you do not allow external numbers, then you cannot reuse the number.