cancel
Showing results for 
Search instead for 
Did you mean: 

Delete Material/Service master data from SRM Database

0 Kudos
462

Dear Gurus,

We'd like to delete some material/service master data from the SRM database, because these materials have been flagged for deletion in ECC but are still replicated in SRM. Then I found the standard deletion program COM_PRODUCT_DELETE_SINGLE and I'm satisfied because it does the job.


However I have 2600 material/services master data to delete. I can't do it one by one.

I tried to put it in a Ztcode and use it in LSMW Recording data input. But it does not work.

Please help me and thanks for your support

Accepted Solutions (0)

Answers (2)

Answers (2)

moacir_goelzer
Product and Topic Expert
Product and Topic Expert

Dear Patrick,

Instead, to delete one by one, you can use the COM_PRODUCT_DELETE_ALL report. That report will eliminate all services and materials. It cannot do it any filter to delete just some materials or services.

So, please try this report and do not do it on a production system.

Thank you.

Kind Regards,
Moacir Goelzer

0 Kudos

Dear Moacir,

Thanks for your answser and sorry for the late feedback. I knew about COM_PRODUCT_DELETE_ALL report and I don't want to use it because I have only 2600 materials to delete. I have more than 25000 material master in my database. I don't want to delete them all.

By doing this, I will not solve my problem because as soon as all the materials will be deleted, the replication program will bring back, from ECC, all my materials and services including those flagged for deletion.

Thanks in advance for your feedback.

moacir_goelzer
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Patrick,

In this case you can delete the products and use the R3AC1 transaction and set a filter for all the products then you do not want replicate.

If you need any assist, please let me know.

Thank you,

Moacir

0 Kudos

Hi,

Sorry for the late answer. I finally found the solution. We decided to build a small program to upload multiple material masters to be deleted from SRM database. Indeed, there is no standard solution to do it.

Thanks