Showing results for 
Search instead for 
Did you mean: 

Deleting ? Archive Material Master

Former Member
0 Kudos


Please help me how to delete or Archieve Material Master?

how to use Tx SARA and MM71?

Please Urgent.



Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Prasad,

Delete a material master - MM module :

If you created an material by error and you want to delete that material from the data base you can do it in this simple 4 steps. The only condition is that this material has to have no material movement recorded.

These are the steps:1

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 (some customisig settings might be required)

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


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.


Use transaction MM71 - Material Master-> other-> Reorganizationn-->Material->Reorganization

Build a second variant

Maintain 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.

Alternative 2 :

Alternative 3:

If you want to delete all the materials in the current client use t-code MMDE.

Reward if useful.

Thanks and Regards,

Naveen Dasari.

Former Member
0 Kudos


Archiving the Material Master

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.

Reward points if helpful

Thanks and regards

Ravikant Dewangan

Former Member
0 Kudos


Thanks for your input.

I have done MM71.

But in Tc sara in Archieve selection i am not able to maintain.

It says "No Data Available".

In job Log it says Job Finished and also "Logical file name or logical path name incorrectly defined "

what is this error?

Pl help



Active Contributor
0 Kudos

If you decide to use SARA (which is recommended for any archiving) then you should never use the old transactions like MM71.

"MM71" is just the write button you get when executing SARA for MM_MATNR.

Beeing in SARA, this is the archiving cockpit, you can do almost everything. Including customizing the paths.

You have not archived anything, this is fact. SAP does not archive if the paths are not defined and it can not create the file nor store the archive file anywhere.

Sit togehter with your basis guys and talk about where you want store the archive, so that nobody is able to change data in an archive.

Then define logical file name and logical path and define how SAP should build the physical file name and find the path.

More to this can be found in OSS note 35992 - File name/directory for application archiving

Former Member
0 Kudos


Please help me how to Archieve Material Master?

how to use Tx SARA and MM71?

Please Urgent.



Active Contributor
0 Kudos
Former Member
0 Kudos

Hi ,

Please consult your BW consultant as they will have a archieve schedule.