Determination of Hazardous Substance Quantities for SARA Reports 

Use

This report program (REHS_HAZARD_AMNT_DET) determines the quantities of hazardous substances in environmentally relevant materials at their storage locations in inventory management. The quantities determined are stored in risk assessments and are then available to prepare the data for the reports prescribed by the U.S. Superfund Amendments and Reauthorization Act (SARA).

Integration

This report program is a prerequisite for the report program REHS_SARA31X to be able to prepare the data for the SARA reports and make it available (see SARA Reports). The report program REHS_HAZARD_AMNT_DET must be executed exactly once per day.

We recommend that you schedule the report program daily as a background job. If possible, it should be run shortly before midnight so that it can provide the current daily closing stock balances. For more information, see the Implementation Guide for Hazardous Substance Management under Schedule Report to Determine Hazardous Substance Quantities.

Prerequisites

·        In Customizing for Hazardous Substance Management, you have edited the following IMG activities:

¡        Configure Customizing of Other Components for SARA Reports

¡        Specify Units for SARA Reports

·        Any errors that occur when the report program is run are logged in the application log. Check in the SAP menu under Tools ® ABAP Workbench ® Development ® Other Tools ® Application Log whether the log object EHSARA with the subobjects QUANT, RISK, and REPS has been created as the application log.

·        You have created materials for all hazardous substances and marked them as environmentally relevant. The materials have a base unit of measure of the dimension mass or volume.

·        In inventory management you have entered the quantities and storage locations for the hazardous substance materials.

·        You have created specifications for all hazardous substances and assigned them to the hazardous substance materials. Here you have assigned exactly one specification to each material. However, you can assign several materials to one specification. The specifications have the specification category Substance or Agent.

Features

...

       1.      The report program determines the hazardous substances and their stock levels in your company as follows:

                            a.      For the plants you entered on the selection screen, the report program determines all materials that are marked as environmentally relevant.

                            b.      The report program determines whether an entry exists in inventory management for the environmentally relevant materials. If it does, the quantity and the storage location is determined.

                            c.      The report program determines the specification for each material for which it has found a quantity in inventory management.

                            d.      If you have set the environment parameter IHS_HAZ_AMNT_DECOMP_SPEZ, the report program determines the components for each specification found from the value assignment type you specified in the environment parameter IHS_HAZ_AMNT_VAL_ASSIGN_TYPE, and uses the specifications of the components in further processing. If you have not set the environment parameter, the report program uses the specification found.

If the specifications are broken down into their components, only the first value assignment instance of the specified value assignment type is taken into account.

                            e.      For each specification, the program converts the quantities found into the base unit of measure you specified in Customizing for Hazardous Substance Management under Specify Units for SARA Reports. Here the quantities found for the individual storage locations are totaled for each specification. This means this total is formed, for example, if a specification occurs as a component in a number of compositions, or if different materials were assigned to a specification and thus a number of quantities were found in inventory management. If the quantities cannot be converted to the base unit of measure or if the total cannot be formed because of different dimensions, an error message is issued and the quantities are not taken into account.

                              f.      The report program also determines the following data for each specification and saves it in the table CCIHT_HAZ_AMOUNT. If numeric values are totaled, these are totaled only for the current month; the program starts again at value 0 in the next month:

§         Number of report program runs where the stock is greater than 0

If the report program finds a stock, it increments the existing value by 1. This value corresponds to the number of days on which the hazardous substance is present in the company.

§         Number of report program runs in the current month

This value is required to determine the average stock level in the month.

§         Sum of all daily stocks

The report program adds the value it finds to the sum of the daily stocks in the current month.

§         Maximum stock level that occurred on any single day in the month

If the stock level on the current day is greater than the previous highest level in the current month, the report program uses the level for the current day; otherwise it uses the value that was already saved.

So that the number of entries in the table CCIHT_HAZ_AMOUNT does not become too large, you should delete older entries regularly using the report program REHS_HAZ_AMOUNT_DEL (see Deletion of Old Data Records from Hazardous Substance Inventory List).

       2.      The report program transfers the results to the risk assessment. Before you run the program, you can decide whether the risk assessment is updated daily or at the end of the month. The program determines as follows whether existing data is then updated or whether new data is created:

...

                            a.      The program determines whether a work area of the type SL (storage location) exists, to which the storage location and the plant for a hazardous substance is assigned. If a work area of this type exists, it is used; if not, a new one is created. If the report program finds a number of work areas or if it finds a work area to which a number of storage locations were assigned, an error message is issued.

                            b.      The report program determines whether a risk assessment exists to which the work area and the specification for the hazardous substance are assigned. If such a risk assessment exists, it is used; if not, a new one is created.

                            c.      The report program determines whether the risk assessment contains amounts for the hazardous substance whose validity matches the current month exactly. If such amounts exist, they are used; if not, new amounts are created.

The report program stores the values as follows in the amounts:

¡        The highest stock level that occurred on one day in the month is stored on the Mass tab page with the measured value/reference value category DMX (daily maximum).

¡        The average daily stock level is calculated by dividing the sum of all daily stock levels by the number of report program runs in the current month and stored on the Mass tab page with the measured value/reference value category DAV (daily average).

¡        The number of report program runs where the stock level is greater than 0 is stored on the Time tab page with the measured value/reference value category DOS (days on site).

If you change values manually in the risk assessments affected, the report program overwrites your changes if you run it again for the respective month.

       3.      The report program updates the date of its last run in the environment parameter IHS_HAZ_AMNT_LAST_START.

The report program can be started only once per day.