Skip to Content

Delete Material/Service master data from SRM Database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 23 at 02:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Apr 27 at 10:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded