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

[Former Member]

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

[Former Member]

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

[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

[Former Member]

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.