Skip to Content
author's profile photo Former Member
Former Member

How to delete data from a SRM standard table (COMM_CATEGORY)

Dear Friends,

We are having some problems related to table entries in one of the SRM standard table COMM_CATEGORY. we need to delete one of the table entries. Request your help in this regards.

Thanks in Advance,

Abhishek

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 02:55 PM

    Hello Abhishek,

    I can tell u the hard way, but don't use this idea in prodcution system and on client site.

    use it while practicing.

    Follows listed steps:

    1. Go to table and display that entry only (mean to say when u get table entries, u need to double click on the enrty which u want to delete, on the next screen u will see only ur entry in display mode).

    2. then on the same screen in the transaction window put "/h" (debugging mode) and press enter and then again press enter. The debugging will be started.

    3. Now Ur cursor will be on line "Code = 'DISP'", double click on the code line.

    4. Now in place of value "DISP" Put "DELE" and on ur right hand side Click on the "Pencil(Change)"

    5. Then press "F8" and one screen will open and there u will get DELETE Button.

    now u can delete the entry.

    With the baove way u can insert , edit, delete ur master table entries

    But don't try this in production system

    One motre thing take all proper screen shots and record of wat are u doing beacsue u may need to insert that entry which also u can do it from this method

    This doesn't take more than 10 sec.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Abhishek,

      -Maintain entries in table for userid COMC_PR_TOOL_REG

      -Run program for deleting the single materials COM_PRODUCT_DELETE_SINGLE

      -Run program for deleting the all materials

      COM_PRODUCT_DELETE_ALL

      For deleting product categories run FM COM_HIERARCHY_DELETE.

      Also delete entries from CRMMLSGUID from SE14 before deleting the categories. Once you complete these steps, you can carry out a fresh replication.

      Make sure you have tables CRMMLSGUID in SRM and CRMPRLS in R3 matched when you do the fresh replication.

      Pls assign points if answer is usefull

      Sundeep

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 07:10 AM

    Hi,

    We have a std program for deleting categories but with the HIERACHIES. i.e. COM_HIERARCHY_DELETE_ALL and

    COM_HIERARCHY_DELETE_SINGLE.

    But to delete a single category form the table you will have to write a custom program for the table COMM_CATEGORY.

    BR,

    Disha.

    Pls reward points for helpful answers.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.