Skip to Content
avatar image
Former Member

How to get data from hierachy lookup table using MDM ABAP API

Hi,

I have 'Categories' as Hierarchy lookup table. When I see this table in MDM Data Manager Client. It shows me the tree like structure of categories (categories with sub-categories).

Can I fetch these different level entries shown in the tree (categories and sub-categories) separately from this Hierarchy Lookup table using MDM ABAP API.

Thanks & Regards,

Gaurav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 17, 2007 at 06:47 AM

    Hi Gaurav,

    yes this is possible. Check the ABAP API how-to guides available on MDM" target="_blank">http://service.sap.com/installmdm">MDM Documentation Center. How-to number 11 contains a description including some sample source coding how-to retrieve hierarchies. Having the ABAP API installed in your SAP system, you can check package "MDE_API_SAMPLES" for all how-to reports, or report "MDE_API_HOW_TO_11" for the source code as well!

    BR Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Michael,

      Thanks for quick response but I have already gone through these how-to guides.

      Yeah you are right how-to 11 tells how to read the category for particular product in the products table. But My issue is different - I just want to read all the categories from the categories table so that I can populate my dropdown list with these categories. This is possible by just using retrive_simple on 'categories' table but this category table also contains subcategories which I can see in taxonomy mode or hierarchical mode. I want to get these subcategories also for my another dropdown. So I want both categories and subcategories separately, which are stored in a single table category - I cant see any identifier which tells that the particular entry is category or subcategory.

      Hope I am not confusing you.

      Gaurav

  • avatar image
    Former Member
    Sep 05, 2007 at 04:03 AM

    got myself

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gaurav,

      Can you explain how you got your answer. I have a similar issue in which I would like to retrieve all fields in a hierarchy table as well as their parent child relationships.

      Thanks.