cancel
Showing results for 
Search instead for 
Did you mean: 

EHS flash point values

surajhny
Explorer
0 Kudos
988

Hello everyone,

I need to create a report where I need to find substances having flash point below certain values and classify them under certain category.

I'm not able to find in which tables Flash point values are stored ..Is it AUSP? I tried searching in it as well but couldn't find it

Can you please let me know in which backend table can I find a the Flash point for a substance stored ?

Thanks in Advance

Accepted Solutions (1)

Accepted Solutions (1)

Mark-Pfister
Active Contributor

HI surajhny,

You can use the build ins search in the CG02 transaction to search for the relevant specifications. Click on the button behind "Substance with values assigned..." and enter the flash-point or flash-point range:

In a 2nd step you can use easy-expert to write the needed data en-mass.

Hope this helps


Mark

surajhny
Explorer

Thank you Mark for the detailed explanation. Helps a lot

Answers (3)

Answers (3)

christoph_bergemann
Active Contributor
0 Kudos

Hello

your topic has been discussed very often here... As explained above:

we have to differentiate. A user acting in CG02/Cg02BD and an "ABAP Report" trying to bring the pieces together

For the later one.... huge number of threads can be found.

E.g. in https://blogs.sap.com/2013/05/07/sap-ehs-management-for-beginners/

you will find links to similar threads... But you topic is, i assume, under the top 10 often asked questions

C.B.

tkfain
Discoverer
0 Kudos

You will need to use AUSP, CABN, ESTVA, ESTRH. This is for ABAP for a specific characteristic value: From bottom up wrt tables - Use CABN to get teh ATINN of the characteristic you want the value for. Put that ATTIN into the internal char of ausp. Filter those results for the ones relevant to your criteria. Take the relevant part of the object number of the selected ausp records and use that as the recn to estva. Once you get that list, the recnroot will be the recn of the specification you need, so use that recnroot in table estrh-recn and that will tell you the actual specification (if you need that far) . Use ESTDU if the usage of the value is important. The recn of estva will be the recnmst of the estdu record for that sort sequence.

surajhny
Explorer
0 Kudos

Thank you Terri for the detailed Explanation ..Helps a lot

vijay_hariharan
Contributor
0 Kudos

Hello Suraj,

Short Answer - Data is in AUSP

Elaboration:
There are two ways to access EHS Flash Point values technically. You may use the BAPI_BUS1077_GETDETAIL if you have already used this OR go to the tables in the ESTVH(with ESTCAT = 'SAP_EHS_1014_009' - Flash point VAT) -> ESTVA(with ESTVH-RECN = ESTVA-RECNTVH) -> AUSP(with OBJECT = CONCATENATION of ESTVA-RECN & ESTVA-ACTN AND ATINN = 'SAP_EHS_1014_009_VALUE')

The only challenge i see here is there might be just too many records. Hopefully the list of Substances you have in your system is not too high. Performance might be something to consider. Other Filter additions are going to help if you have any like Specification types(assuming this is mostly REAL_SUB) in which case you can add ESTRH before ESTVH selection then use only the relevant ESTRH-RECN to filter ESTVH-RECNROOT

Hope this helps

Regards,
Vijay

surajhny
Explorer
0 Kudos

Thank you So much Vijay for the detailed explanation .. could you please suggest me some resources where I can get the understanding of the EHS concepts and backend tables? It would be very useful for me ..

Thanks in advance