Select the complete Product Heirarchy.. as F4

[Former Member]

hi everyone,

I have a requirement where there is a field in Java Webdynpro.

if user click F4 or value request,

i want to fetch the complete product heirarchies, like a tree structure .

somehting like, first it should show all the available categories, then sub categories, then products under that sub categroeis,

Is there any stnd BAPI or FM or searchhelp, available for this.

If not, how to fetch the data on these tables, COMM_HEIRARCHY, COMM_CATEGORY.

can someone assist me kindly.

Robin

[Former Member]

Guys,

Could you help me on this anyone please.

Points will be rewarded.

Robin

[Former Member]

Hi Robin,

For getting the complete list of product hierarchies in system you can use the FM - COM_HIERARCHY_READ_ALL.

In order to get the categories assigned to each of this hierarchy, map the above FM’s results esp. – value of column ‘ROOT_CAT_GUID’ to another FM COM_CATEGORY_READ_SUBTREE and you would have the tree kind of structure.

Further, I am not sure if SAP standard has a default tree structuring upto the product level as at times the product database has millions of entries (per category) and it might timeout.

Hope this helps.

Amit Sitlani

[Former Member]

It is solved

table T179 has got those entries. we can select all bassedon the second field which is level.

Robin

[Former Member]

Good that it resolves your query. Btw, was this related to MM, as T179 is a MM table and does it also return the product categories? I would be interested.

Cheers,

Amit Sitlani

[Former Member]

Yes Amit.

T179 has got the entries like STUFFE field is the level.

like if the tree is like this: level1->leve2->level3>level4-> level4 has got 4 products.

now the table will have entries like.

level1 stuffe = 1.

level1level2 stuffe = 2.

level1level2level3 stuffe = 3.

level1level2level3level4 = 4.

so its like concatenating upper levels.

Robin