Category ID table

[Former Member]

Hello. Friends

I want to know the table and field name for Material type(Category ID).

How can I find the table and field for material type using material code (comm_product)?

Thank you

Best Regards

[Former Member · Accepted solution]

Hello, the table for product category is COMM_CATEGORY.

Regards, Luciano

[Former Member · Accepted solution]

Thank you for your reply

Actually, I want to find the category ID using <b>Product ID</b>.

When user choose the product ID, we should check the material type.

Because we have a validation rule. So If material types are " ERSA" or "ZERS",

user can not create SC except some users.

Could you tell me how to find the category ID, if you know?

Thank you

Best Regards

Lee so hee

[yann_bouillut · Accepted solution]

Hi,

Please check table COMM_PRODUCT

Kind regards,

Yann

[Former Member · Accepted solution]

Hi So Hee Lee,

Try to use that these tables:

COMM_PRODUCT for product ID and GUID

COMM_PRPDACTR for map product to category

COMM_CATEGORY for category

Example:

select * from prod~comm_product

into ls_table

from comm_product as prod

inner join comm_prpdcatr as prpd

on prod_{guid = prpd}product_guid

inner join comm_category as cat

on prpd_{category_guid = cat}guid

where prod~product_id = lv_productid.

Regards,

Marcin Gajewski

[Former Member · Accepted solution]

Thank you a lot.

OK, I'll try it.