List of materials by product Category

[Former Member]

Hi Experts

we are on SRM version 4.

Is there a FM where in we enter the Product Category and it will list down all materials in SRM belonging to the prod category

How do we link Comm_Product and comm_Category

Thanks

[Former Member]

Hi,

Have a look at these tables:

COMM_PRPRDCATR Product -> category assignment

This table stores all the products for a product catgeory.Query on this table and you can get all the products assigned to a prod category.(you will get the GUID's for a product based on which you can further get all the prodcu details from COMM_PRODUCT)

COMM_PRPRDCATRH Product -> category assignment history

BR,

Disha.

DO reward points for useful answers.