Table that links article and merchandise category with hierarchies

[Former Member]

Hi,

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

Thanks

MHD

[amit_tunara]

Hello,

Retrieving MCH level is to be done with following logic:

• First take the Merchandise category of an Article from MARA table from field MARA-MAKTL.
• Pass this merchandise category to a function MERCHANDISE_GROUP_HIER_ART_SEL.

This function will return the MCH levels.

I hope this will help.

Regards,

Amit

[joseph_demoya1]

Hello,

If you wish to scale the Hierarchy via tables you will need to do this via the classification structure. SAP Retail uses the class type 026 for the different Hierarchy Levels. Therefore starting at the highest level in WGUS use table KLAH and enter the hierarchy number/name in the CLASS field and retrieve the CLINT field value you can then pass this CLINT value to table KSSK and retrieve the assignments. Your objective is to get the OBJEK enteries and pass these values back to the KLAH table field CLINT to retrieve the CLASS field so you can see the number/name value that are dislayed in transaction WGUS.

Thank you,

Joseph