Product Hierarchy/Category

[Former Member]

Hi,

How can i download the Hierarchy and its Category to the deepest level, like what i can find in COMM_HIERARCHY transaction.

for example if i have the hierarchy and category like this.

ROOT----> Hierarchy

CD01----->category

CD01_01--->sub category

CD001_01_01--->sub category.

can i download this tree view in excel in the same format as above and if not then at least with there level in tree structure

for example CD001_01_01 is at level 3 and is child of CD01_01.

Thanks,

Sanju

[Former Member · Accepted solution]

Hi ,

You can use FM COM_PRDCAT_SEARCH_CATEGORIES to get category guid and heirarchy_guid using category_id as input . Then use FM COM_PCAT_READPHIERCHILDREN_O to get child categories by passing heirarcy guid as iv_product_hierarchy and category_guid as iv_parent_category.

Regards,

Nithish

[Former Member]

Hello,

You can check table COMM_CATEGORY and see whether you can get the structure into excel.

Best Regards,

Shanthala Kudva.

[Former Member]

that wont help, i need detail in parent and child relationship