Tables in EH&S

[Former Member]

Hello,

I want to know the tables used for EH&S substance management.

What are the tables for the substance and properties assigned to these substances?

How can we find that a particular substance is having which properties using Tables. Because I have a requirement to develop a report in EH&S which will show the Substance and the properties assigned to that substance.

[Former Member · Accepted solution]

Hi Abhijit,

the substance headers are in estrh.

Value assignment headers (properties) are in table esthv (connection to estrh is the recnroot). Every estvh entry can have 1..n value assignment instances (estva).

The characteristics for a value-assignment instance are in the SAP class system. But this is very difficult to read out manually.

Better to use the substance APIs. See

Regards,

Andreas

Message was edited by: Andreas Müller

[Former Member · Accepted solution]

Hi Andreas,

The API which you gave was really helpful. With that I got a BAPI 'BAPI_BUS1077_GETDETAIL' which gave me the desired results.

Thanks for Help.

Regards,

Abhijit.