Table that links article and merchandise category with hierarchies
I am searching for a table which links article with merchandise category hierarchies.
For eg in transaction WGUS we are getting the hierarchy levels in a tree , we would like to get the same in table format as below
we have also searched table T023S and it is empty,please suggest a suitable table to retrieve the data ( if there are multiple tables to be joined please explain the same)
|Artcicle||Merchardise Category||Mercharndise hieracrchy|
|Mangobar||Ice Cream/Bars||Level1 - 1 - Fresh Food|
|Mangobar||Ice Cream/Bars||Level2 - 101 -Frozen|
|Mangobar||Ice Cream/Bars||Level3-101001-Ice Cream / Ice Dessert / Ice Cream, Sma|