Deleteion of Material groups.

[Former Member]

Hi

I am trying to delete product categories from SRM. These product categories does not have any sub-categories. System dont allow me to delete the product category and gives me error message " product category still in use in table BBP_PDIGP and BBP_PDLIM."

After analysis it is observed that some shopping carts are created against these product categories.

How do I delete these product categories?

If we delete the data from table BBP_PDIGP and BBP_PDLIM, and then delete the product category, what will be implications on shopping cart history? Is this a decent way of deleting product category?

Please help.

Thanks & Regards,

Sunil.katyare

[yann_bouillut]

Hi,

Which SRM version do you use ?

In my SRM50 system, i do not have isue deleting PRCAT even if already used in SC or PO created...

How did you try to delete the PRCAT ? which program ?

Kind regards,

Yann

[Former Member]

Hello Yann,

It is SRM version 4.0.

How to delete using PRCAT.is it is from COMM_HIERARCHY.

Please help

Thanks & Regards,

Sunil.Katyare.

[yann_bouillut]

Hi,

Another question : did you create product category locally or by replication from ECC or R/3 ?

Kind regards,

Yann

[Former Member]

Hello Yann,

The product categories are existing right from the begining. The user want them to be simply deleted from the system.

I guess as they exist in the backend, they are been replicated.

how to delete using PRCAT can you please explain?

Thanks & Regards,

Sunil.Katyare

[yann_bouillut]

Hi,

If PRCAT have ben created in SRM directly (no replication from ECC) : you can delete them directly from transaction comm_hierarchy.

If PRCAT have been replicated from ECC, you cannot delete from comm-hierarchy (error message).

You can delete the entire hierarchy from program COM_HIERARCHY_DELETE_SINGLE

then you can replicate them again from the backend.

If you didn't personnaly replicate them from the backend , i would suggest you to not delete the hierarchy until you know how to replicate them again from ECC !!

Kind regards,

Yann

[yann_bouillut]

Hi,

Another solution is to simply deactivate the product categories you don't need anymore in the extended tab of the PPOMA_BBP.

Thus, these PRCAT could not be used anymore for purchasing.

Kind regards,

Yann

[Former Member]

Hello Yann,

Thanks for the information.

Q1: COM_HIERARCHY_DELETE_SINGLE please clarify will this program deletes all the product catagories.or will it ask for single product catagory deletion.

Q2: If we delete the table entries ( BBP_PDIGP & BBP_PDLIM), it allows to delete the product category. We have tested this in development. Will this be a correct way of deleting the PROCAT?

Please suggest.

Thanks & Regards,

Sunil Katyare.

[yann_bouillut]

Hi,

1- Delete ALL product category of the hierarchy asked by the program

2- This is not a best practice...

Kind regards,

Yann

[Former Member]

Hello Yann,

Thanks for your reply, We with the option like Deactivation of product categories as they want them in backend not in the SRM.

Thanks & Regards,

Sunil Katyare.

[Former Member]

Hello Yann,

Thanks for your Valuable suggestion, our client also accepted to implement this.Deactivation.

Best Regards,

Sunil.Katyare.