delete material

[Former Member]

hi friends,

how to delete the material permanently from the plant

thank you

[Former Member]

hi, you can use mk06.

regards

points if helpful

[JL23]

Thats new for me, that a material can be deleted with MK06. In my system this will only set a deletion flag in vendor masters.

If a material is archived, then it is permanently deleted from the SAP tables.

Using MMDE is a poor solution for a test client, which is mainly meant to erase material masters after a test migration. This programm can only be executed in a test client. Once you have transactional data, this program will not check on this, it will delete material masters and leave the transactional data for this material in the system, means it is creating inconsistencies.

The only way to get rit of material master is and should be thru archiving.

[former_member192897]

Using MMDE / RMMMDE00 you can Delete all Materials from Current Client.

Instead of Deleting Material from a Particular Plant It is Better to Set Material Status Blocked for Procurement in that Plant in Material Master Purchasing View.

Even if you want to Delete the Material then first you have to Set the Material Flag for Deletion. Then you Need to Do SARA Trxn for Archiving Material.

Material Cannot be Deleted Permanently. But, Can be Archived from Database Tables.

Please Go thru the Below Links which will give you Clear Idea on Deleting / Archiving Material Master.

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

http://www.sap-img.com/materials/block-or-delete-any-material-from-material-master.htm

http://web.mit.edu/sapr3/windocs/bpmds17m.htm

Regards,

Ashok

[former_member335885]

Hi

Archiving is the process to delete the materials from from the data base tables.

First you need to flag the materials for deletion using MM06 & then goto transaction SARA, the archiving object for Material Master is MM_MATNR

enter the Object & Click on write & Maintain the variant , here we maintain the materials which are to be archived.

Maintain the materials & save the variant & execute. This will create an archive file in the system.

Next delete the archive file selecting the File & execute.

This will remove the Materials from the data base.

Please go through the link for archiving process

http://help.sap.com/saphelp_erp2004/helpdata/EN/8d/3e4f1d462a11d189000000e8323d3a/frameset.htm

BASIS consultants are required to do the archiving process

Thanks & Regards

Kiran

[Former Member]

hi ,

Maintain the materials & save the variant & execute. This will create an archive file in the system.

Next delete the archive file selecting the File & execute.

From your answer i maintained the archive file bnut i cannot able to view the file for deletion in SARA DELETE button please explain

Nothing is coming after i click the archieving file button

why how to see my archieve file to be deleted

thanks

jai

Edited by: Jai on Sep 28, 2008 5:44 PM

[former_member581212]

hi,

Transaction SARA contains all the SAP archiving objects for all the SAP R/3 applications modules. 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. Provided here will be an example on how to archive the SAP 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. 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.

To delete all the Material from Client Use MMDE Trxn code.

regards

Priyanka.P

[Former Member]

hi

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.

from this step

when i click delete button nothing is displayed why and how to see my archiev datas

Please explain why

thanks

jai

[former_member581212]

hi,

Archive Material Documents MBAR

Delete Material Documents MBAD

Manage Material Document Archive MBAV

hope it helps..

Regards

Priyanka.P

[Former Member]

Use transaction MM70 - Material Master->Other->Reorganization->Material->Choose.Build variant with selection range of material master records to be selected for deletion and maintain run parameters.Execute.Use transaction MM71 - Material Master-> other-> Re organizationn-->Material->ReorganizationBuild a second variantMaintain run parameters and execute.It is also important to remove the records manually from info record, POs, PRs, reservation etc for successful deletion of the material