on 06-06-2011 1:33 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.