Category ID and Product ID relationship in CRM

[Former Member]

Hi folks,

How can find all the Products belonging to one Particular Category ID. What is the table relationship between them?

Thanks

PG

[Former Member]

Hi,

There are table COMM_PRPRDCATR

link with product via PRODUCT_GUID table COMM_PRODUCT

Denis

[Former Member]

Hi Denis,

Thanks for the information. But I have doubt . I think one product belongs to only one Category ID( Correct me If I am wrong).

Bow I can see in comm_product, there are 92000 records. But when I go and see COMM_PRPRDCATR , I can see 277140 records. So I am confused that why COMM_PRPRDCATR table has more entry than comm_Product.

Can you put some light on it!!!!

Thanks PG

[Former Member]

Hi,

This is because one product have many categories.

Denis

[Former Member]

thanks!

[Former Member]

Hi Denis,

I'm aware that I should maybe create another thread for the question I'm about to ask, but it's related to the above.

I need to assign another category to existing products in CRM and I realize that the COMM_PRPRDCATR table needs to be linked to the COMM_PRODUCT via the PRODUCT_GUID.

I'm struggling to find the correct FM/BAPI to update this relationship. I've tried the COM_PROD_CAT_REL_MAINTAIN_UPD FM, but with no luck.

Could you please help if you've got a clue?

Thanks.

Brian