EHS Tables

[Former Member]

Hi,

Can anyone please let me know which EHS tables holds fields: Material Storage Code, Regulated Material Information?

Thank you.

[christoph_bergemann]

Dear Naga

are we talking about EH&S DG topics? PLease provide an example what you are asking for.

Storage Codes are used in several circumstances; therefore the term you used is not clear enough Which regulation are you thinking about if you use the term "Regulated Material Information"? DG? other regulation?

C.B.

[Former Member]

Hi Christoph:

Yes, It is about EHS DG.

Can you please let me know the EHS Tables which contains this information.

Thanks,

Naga

[christoph_bergemann]

Dear Naga

e.g. refer to:

http://help.sap.com/saphelp_45b/helpdata/en/3e/60957d0d1311d286e7080009b98822/frameset.htm

Chapter:  Allocating Table Fields

DGTM

and

DGTM2

are the most important tables in DG context.

Refer as well to chapter: Non-Fillable Fields

If you use higher SAP versions and if you have activated Business Functions in EH&S additional tables in context of EH&S DG could be important as well.

Per regulation e.g. "IATA" one data record is created in DG master

Hope this is what you need

C.B.

[Former Member]

Hi Naga,

what i understand from your question is, you are looking for storage class. and i am not sure what is your expectation about regulated material information.

If you are using hazardous material in your system. that is very easy to get the storage class, instead of getting that from substance work bench (property tree)

table - MGEF, field - LAGKL

If it's not maintained as hazardous material, you can check for the values in substance work bench.

not an easy task to fetch the values directly as like transparent tables. as the values stored in EHS substance property tree as charactersitics, which linked to classes/ value assignment types.

In property tree under substance work bench you can check the classification value in the value assignment SAP_EHS_1022_023

you can use the function modules - BAPI_BUS1077_GETDETAIL & BAPI_BUS1077_GETLIST  to pick the values.

you can use the below tables to to link one to one and fetch the desired values.

Specification Material Assignment - ESTMJ

Specification header - ESTRH

specification - value assignment  assignment (Property tree) - ESTVH

value assignment item - ESTVP

charactersistic values - ESTAUSP, CABN

Value Assignment table - ESTVA

Regards

kamal