Where-used of substance in composition

[rudy_schmitz]

Hello,

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,

Rudy

[rambabu_k3 · Accepted solution]

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.

Thanks

Rambabu

[rudy_schmitz]

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!

Regards,

Rudy

[former_member212503]

Hello Rudy ,

There is where used functionality provided by sap standard solution . I tried to use that but some error message that property tree cannot be displayed . have you tried using that ?

Regards,

Krishna

[christoph_bergemann]

Dear Krishna

please refer to my answer in:

C.B:

[Former Member]

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 sap.help regarding this.

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

like -

Header data

values assigned

components

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)

Regards

kamal

[christoph_bergemann]

Dear Rudy

if we define the term function as "function module" may be check: http://scn.sap.com/docs/DOC-42178; 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.:

http://www.se80.co.uk/sapfms/c/c1f2/c1f2_substances_used.htm

as well. Similar are:

http://www.se80.co.uk/sapfms/c/c1f2/c1f2_substances_used_by_mat.htm

http://www.se80.co.uk/sapfms/c/c1f2/c1f2_substance_get_comp_tree.htm

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.

C.B.

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

http://help.sap.com/saphelp_erp60_sp/helpdata/en/e8/ebc0419e1a6224e10000000a1550b0/content.htm