Skip to Content
author's profile photo
Former Member

Where-used of substance in composition


I am new to EHS, and I am searching for a transaction or a function that could give me the where-used of a substance in all compositions.

Is there any standard transaction or function that would exist for this query?

Thanks in advance,


Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Jun 13, 2013 at 07:25 AM

    Hi Rudy,

    If you have technical knowledge, Please follow below steps.

    1. go to table ESTRH and provide SUBID(Component ID) and get RECNROOT number

    2. go to table ESTVP and provide above RECNROOT number of component in ESTVP-RECNCMP

    get all RECNROOT numbers from ESTVP. these numbers gives all Specification roots.

    3. to get all specifications for component goto ESTRH table again and give all ESTVP-RECROOTS

    found in 2nd point. Now observe ESTRH-SUBID fields.



    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Jun 12, 2013 at 02:52 PM

    Hi Rudy,

    There is no such kind of transaction available for compositions specific searching.

    In EH&S, the substance to substance connectivity in 2 ways.

    1. Inheritance

    2. Reference

    you can get more information in regarding this.

    In the transactions like CG02, CGCL2, CG02BD, you have multiple options available for search criteria.

    like -

    Header data

    values assigned


    reference substances etc.,

    If you are not convinced with the search criteria provided by sap, you can use your own logic to build some report.

    Standard BAPI's available to gather the data from specification database.

    BAPI_BUS1077_GETDETAIL (Read specification)

    BAPI_BUS1077_GETLIST (List of Specifications)

    BAPI_BUS1077_GET_COMP_TREE (explode specification composition)



    Add comment
    10|10000 characters needed characters exceeded

    • Dear Rudy

      if we define the term function as "function module" may be check:; be aware of the fact that:

      1.) the result you will obtain by using the standard functionalities as mentioned by Kamal are depending on your access rights

      2.) that the functionality is restricted in the start screen of CG02 etc. to one spec only; if you have a "hit list" you can use this list as the starting point to get the "where used" list. It is EHS standard; there is only one "but". if you really work with a list you have no indication which spec of your first hit list is part of what spec of the new hit list; therefore this functionality (in most cases) does not really fit the cusomer demand

      3. be aware of the fact that if you use a "hit list" as a starting point the topic will need a lot of time (depending on your criterias; amount of data in your database) and in many cases you will get a "out of time" dump by ABAP

      4.) the standard functionality works per value assignemnt type/property; there are many value assignment types of type B or C (spec listing; composition) and therefore you will be only successful if you reduce your query to on value assignment type (in most cases)

      5.) with higher SAP release you will get enhanced functionality; If i remeber correct with EnhPack 7 the "where used list" will be extended (not sure if you need to activate something)

      Check e.g.:

      as well. Similar are:

      I assume that these function modules wil be caleld internyll by the BAPIs mentioned by Kamal (depeneding on the demand) but you can use them by your own as well.


      PS: regarding other SAP EHS topics related to your topic ths link might be helpful in the future as well:

  • author's profile photo
    Former Member
    Posted on Jun 14, 2013 at 12:12 PM

    Thank you to all of you for your help.

    Obviously, Rambabu's advice sounds to fit my needs.

    Anyway, on my side, I found transaction /TDAG/CPR05 which returns the same results as using Rambabu's way to work, but in a easier way for normal users.

    Thanks again!



    Add comment
    10|10000 characters needed characters exceeded