delete bunch of materials from database without using program

[Former Member]

Hi Friends,

This is regarding MM01 transaction.

By mistake .... I have created around 10,000 materials through BDC program. after that I have written one program and deleted those records from MARA, MARC, MARD and MBEW tables.

It is creating big problem for me. I am unable to create those materials again. there are so many other table records need to be deleted. I am not sure other tables.

Could you pls suggest me how can I acheive this.

1. Is there any way creating all the materials from database in one shot. (i treied through transaction by deleting one by one. But even I deleted it is not possible to create same material again with different plant/ storage loc) please help me.

2. If you know other tables need to be deleted pls tell me one by one in sequence.

This is very urgent.

Thanks in advance

Raghunath

After deleting like that

[Former Member]

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.

These reports are called by the SARA transaction too.