cancel
Showing results for 
Search instead for 
Did you mean: 

SQVI Report for SAP CRM Product Hierarchy and its Product

Former Member
0 Kudos

Hi

How to create a SQVI report for generating a list for SAP CRM Product Hierarchy which should show the outputs->Level 1, level 2, level 3 and level 4 categories and its products?

I tried COMM_Hierarchy table and Comm_product but not able to achieve this requirement.

or Is there any chance of getting related tables so that I could try more for this requirement.

In which table both product id and its category Id can be found?

Pravin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

In which table both product id and its category Id can be found?

1.You will get the Category GUID from table - CRMV_PROD_CATEG (Enter the product ID or product GUID from COMM_PRODUCT table as an input)

2.You can put the Category GUID in table - COMM_CATEGORY to get the category ID.

Hope this will be helpful

Former Member
0 Kudos

Thanks DJ

Is there any possibility to get a report for product hierarchy in SQVI ?

say in SAP CRM system, the product category is maintained in COMM_HIERARCHY as

Parent category Id->

Level2 Category Id->

Level 3 Category Id->

Level 4 category Id ->

Product Id's

(I understood the link between Level 4 category id and product id with your info.) but not able to achieve the requirement fully.

Is there any possiblity to achive for generateing a report?