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