Product category based on Product ID

[former_member504447]

Hi Friends,

Is there anyway to get Product category based on Product ID in SRM?

Thanks,

San.

[konstantin_anikeev · Accepted solution]

Hi Sankar,

check the table COMM_PRPRDCATR

Regards

Konstantin

[former_member504447 · Accepted solution]

Hi,

thanks for the reply..

but for this table i need Product GUID not product ID right?

is there any other table where i can see Category based on product ID

[konstantin_anikeev · Accepted solution]

COMM_PRODUCT

[former_member504447 · Accepted solution]

So conclusion is we cannot get info i asked in signle table

we have to use both

COMM_PRODUCT & COMM_PRPRDCATR

[venkatakrishna · Accepted solution]

Hi Sankar,

  COMM_PRODUCT : Product details (PRODUCT_GUID  ,PRODUCT_ID)

  COMM_PRPRDCATR :  - Product Category Assig

  COMM_PRSHTEXT  : Product Description

FM: COM_PRODUCT_READ_VIA_RFC

Regards,

Venkat