Skip to Content
author's profile photo Former Member
Former Member

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



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Feb 03, 2014 at 02:20 AM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 07, 2014 at 10:07 PM


    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,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.