Determination of Hazardous Substance Quantities for SARA Reports

Use

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

Integration

This report is a prerequisite for the report program REHS_SARA31X to be able to format and provide the data for the SARA reports (see SARA Reports). For this, the report program REHS_HAZARD_AMNT_DET must be run exactly once each day.

Recommendation Recommendation

We recommend scheduling the report as a background job on a daily basis. It should be run as close to midnight as possible so that it can provide the current daily closing stock balances. For more information, see Customizing for Hazardous Substance Management, under Schedule Report to Determine Hazardous Substance Quantities.

End of the recommendation.

Prerequisites

  • In Customizing for Hazardous Substance Management, you have processed the following activities:

    • Configure Customizing of Other Components for SARA Reports

    • Specify Units for SARA Reports

  • Any errors that occur while the report program is run are logged in the application log. For this purpose, from the SAP Menu, choose Tools → ABAP Workbench → Development → Other Tools → Application Log to check whether the log object EHSARA with the subobjects QUANT, RISK, and REPS is created.

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

  • You have entered the quantities and storage locations for the hazardous substance materials in Inventory Management.

  • You have created specifications for all hazardous substances and assigned these to the hazardous substance materials. You have assigned exactly one specification to each material. However, you may assign multiple materials to a specification. The specifications have the specification category Substance or Agent.

Features

  1. The report determines the hazardous substances and their warehouse stocks at your company as follows:

    1. For the plants that you have specified on the selection screen, the report determines all materials that are indicated as environmentally relevant.

    2. The report determines whether an entry exists in Inventory Management for the environmentally relevant materials. If this is the case, the quantity and the storage location are determined.

    3. The report determines the specification for each material for which it found a quantity in Inventory Management.

    4. If you have set the environment parameter IHS_HAZ_AMNT_DECOMP_SPEZ, for each specification found, the report determines the components from the value assignment type that you specified in the environment parameter IHS_HAZ_AMNT_VAL_ASSIGN_TYPE, and uses the specifications of the components from this point on. If you have not set the environment parameter, the report uses the specification found.

      Note Note

      When expanding the specifications in your components, only the first value assignment instance of the specified value assignment is taken into account.

      End of the note.

    5. For each specification, the report converts the quantities found to the base unit of measure that you specified in Customizing for Hazardous Substance Management under Specify Units for SARA Reports. For each specification, the quantities that were found for the individual storage locations are totaled. This means that this total is formed, for example, if a specification appears as a component in more than one composition, or if various materials were assigned to a specification and therefore more than one quantity was found in Inventory Management. If the quantities cannot be converted to the base unit of measure, or if the total cannot be formed due to different dimensions, the system displays an error message and the quantities are not taken into account.

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

      • Number of report runs for which the stock level is greater than 0

        If the report finds stock, it increases the existing value by 1. This value corresponds to the number of days on which the hazardous substance is at the company.

      • Number of report runs in the current month

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

      • Total of all daily warehouse stocks

        The report adds a found value to the total of the daily warehouse stocks in the current month.

      • Maximum stock level that occurred on any single day in the month (maximum amount)

        If the stock level on the current day is higher than the previous highest in the current month, the report uses the value for the current day, otherwise it uses the value already saved.

      Note Note

      So that the number of entries in the table CCIHT_HAZ_AMOUNT does not become too large, you should use the report program REHS_HAZ_AMOUNT_DEL (see Delete Old Data Records from Hazardous Substance Inventory List) to delete older entries on a regular basis.

      End of the note.

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

    1. The report determines whether a work area of the type SL (storage location) exists, to which the storage location and the plant of a hazardous substance are assigned. If such a work area exists it is used, if not, a new one is created. If the report finds more than one work area, or if it finds a work area that has been assigned more than one storage location, the system displays an error message.

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

    3. The report determines whether the risk assessment contains quantities for the hazardous substance that have the exact validity of the current month. If such quantities exist they are used, if not, new quantities are created.

    The report stores the values in the quantities as follows:

    • The highest stock level that occurred on a 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 total of all daily stock levels by the number of report runs in the current month, and is stored on the Mass tab page with the measured value/reference value category DAV (daily average).

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

      Note Note

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

      End of the note.

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

    Note Note

    The report can only be started once each day.

    End of the note.