Skip to Content
0

Delete Material/Service master data from SRM Database

Mar 22 at 08:58 AM

82

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Moacir Goelzer
Mar 23 at 02:20 PM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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
Patrick K-M Apr 27 at 10:42 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded