cancel
Showing results for 
Search instead for 
Did you mean: 

Category ID and Product ID relationship in CRM

Former Member
0 Kudos
2,204

Hi folks,

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

Thanks

PG

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

There are table COMM_PRPRDCATR

link with product via PRODUCT_GUID table COMM_PRODUCT

Denis

Former Member
0 Kudos

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
0 Kudos

Hi,

This is because one product have many categories.

Denis

Former Member
0 Kudos

thanks!

Former Member
0 Kudos

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