How to delete items massively from CCM 2.0 catalogs

[Former Member]

Hello,

We use SRM 5.0 with CCM 2.0 as the catalog system.

In CCM 2.0 we use Vendor Catalogs to upload the items - we pass them on to purchasing catalogs via the master catalog using asignment of the categories (standard funcionality).

The Purchasing catalogs we published, so the content is available in the SRM shopping cart funcionality.

The R/3 backend is ECC 6.0.

We need to eliminate about 20.000 items from our catalog system. Is there a way to do this with standard funcionality or do we have to construct a program? If so, how does one proceed? We do not have experience in this.

Someone already has experience with masive deletion of CCM 2.0 items?

Thanks for any help.

Aart

[Former Member · Accepted solution]

Hello,

You are right. There is no standard functionality for deleting items from SRM CCM 2.0 Catalog.

Very recently, we have come across the problem that materials/items which are deleted in SAP R/3 4.7 are not getting deleted from SRM CCM 2.0 catalog.

We have done some analysis and found the below conclusion & solution.

- You need to send an action code "04" and drop Product Category information in XML file which XI uses to send the information from ERP to SRM CCM catalog.

For this you need to modify the XML and XI mapping for the ZACTION code(03) received from ERP.

Once the changes are done in XML, you re-publish the catalog.

You will find the item/s have got deleted from the catalog.

Note: It is important to note that even for deletion, system records action as catalog items Update/Created in the logs (SLG1) but not the action as catalog items deleted.

Hope this helps !

- Vikas

[Former Member]

Try to delete the catalog by selecting the load-id of the catalog from mySAP SRM server or else prepare a load file which should contain 3 columns Action,Load-id, SupplierPart No.In the action column write delete. in the load-id column provide the load-id column and in the Supplier part No provide the part No. Save that laod file in Unicode text and load it in Production System.

[jason_boggans]

Hi,

You should not look at removing these from the procurement catalogs but from the supplier catalogs directly, if you remove the items from the procurement catalog then you will leave mass inconsistency in the content mapping tables which will lead to bigger problems in the future. If you have full supplier catalogs which need all content deleted etc then you can just delete the catalog or load a modified schema in FULL mode to the affected catalogs removing the unwanted items. i.e. just load content which is wanted to the catalogs in full mode.

Regards,

jason

[Former Member]

Hi!

Start deleting the vendor-catalog - all itmes.

This will probably not delete all items - there might be a few leftovers (for some unknown reason!).

These leftovers can be deleted manually in the Master Catalog. When deleted here, the Purchase Catalog will be empty

brgs Ziggy