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,
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.
There is no such kind of transaction available for compositions specific searching.
In EH&S, the substance to substance connectivity in 2 ways.
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.
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)