Read Product category and sales org for product

[Former Member]

Hi,

I want to read the Item category group from the product master for Sales Org XXXX.

Then I want to read the item category group as well to complete my requirement.

Thank you for your time.

Reagrds,

Dhruv

[former_member200342 · Accepted solution]

Hi,

Please follow the below steps to get the item category group for a material for a specific sales area from the CRM database.

1. 1. Get the product guid from the table COMM_PRODUCT
2. 2. Get the FRAGMENT_GUID from the table COMM_PR_FRG_ROD for a specific sales area SALES_ORG and DISTR_CHAN in the input parameter
3. 3. Enter this FRAGMENT_GUID in the table CRMV_PR_SALESA to get the item category group for that product in the field S_ITEM_CAT_GROUP

Regards,

PP