General presentation

Objective of the application

EHS stands for Environment, Health and Safety. The Goal of EHS is to protect employees, the public, the environment and to comply with applicable laws and protect the Company's reputation. EHS departments, of some companies are responsible for environmental protection, occupational health and safety. 

This application described below concerns one of EHS goals : Reporting for Substance Volume Tracking (SVT)

In many countries, regulations state that, above a certain quantity of chemicals and other hazardous substances, you must register with the authorities the maximum quantities of these substances that you plan to purchase, import, produce, sell, or export within a certain period. Substance volume tracking helps you to comply with the relevant regulations by recording the quantities of substances needing to be tracked that you purchase, import, produce, sell, or export. By comparing the recorded quantities with the limit values, the system can warn you in good time before a limit value is exceeded

Tool Leader + IT leader of the application: 

Usage information

Around 90 users, worldwide. Each country can only report on its data.

History

2014 - SVT Roll Out Asia/Turkey => KT document "SVT RO // Knowledge Transfer" => https://drive.google.com/open?id=1yWblSq3wGJGdm-T7D97nWF3I7Ufeawe-HYb91RmZ26Q

2015 - SVT Roll Out Europe/USA/Canada => KT document "EHS-SVT-Documentation" => https://drive.google.com/open?id=1W-NDge82ePPYy4fBiMhr57DVYeBxzRsuyPxjK1ZWQuM

Roles & Access

Roles and access

Usefull to know :

1- Menu Roles ZR_RCS_CA_M40 “EHS – Substance Volume Tracking Asia” and ZR_RCS_CA_M36 “EHS – Substance Volume Tracking North America” are now obsolete.

There are replaced by ZR_RCS_CA_M48.

2- Perimeter roles ZBI_RCS_EHS_P06 to ZBI_RCS_EHS_P12 are obsolete because Authorization Team has decided to use naming ZBI_xx_EHS_P06 (xx = country)

3- Perimeter roles ZR_RCS_EHS_P06 to P09 and P11, P13 to P15  are obsolete because old naming.

Usefull to know concerning BUTA Chimie (Company Code ZFR9) : 

A filter on C_PLANT from authorization has been added in all SVT queries :

• variable V_AUT_C_PLANT_0001 for EU report as the Plant is a selection criteria

• variable V_C_PLANT_0001 for all other as the Plant is not a selection citeria

The C_PLANT will have to be removed in object ZBI_SVT (Application Role ZR_RCS_EHS_A07) 

 Following perimeter role will have to be managed for all EHS SVT users :

• For all plants, except BUTA, use perimeter role ZR_TOUT_CA_P02 / object ZTOUTCAP02

• • For BUTA plants, use perimeter role ZR_7866_CA_P02 / object Z7866CAP02

The BUTA data will have to be loaded in cube REACH (SVT Analysis - EU (Rhodia) / CREHS06).

Usefull current authorization matrix

See also file maintained by Authorization team : BW Catalog of Roles / link: https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

The dataflow is in the following document : EHS-SVT-Documentation https://drive.google.com/open?id=1W-NDge82ePPYy4fBiMhr57DVYeBxzRsuyPxjK1ZWQuM

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Unit conversions

The Unit conversion is done in the Bex queries (Quantity Conversion Type), depending on reports

• Reporting in pound (LB) for US
• Reporting in kilogram (KG) for Canada
• Reporting in Ton (TO) for all others

Transactionnal data are stored in material base unit, except of SPRINT Reception quantities (PO Unit)

• if base unit / po unit is managed in dimension MASS, conversion within table T006 works well

• if base unit / po unit is not managed in dimension MASS, conversions for KG/LB/TO have to be managed on ERP side (MM03 / Alternative Conversion).

Example : production done on unit KRE; other used units 1KG, M2, M3, KN3...

There are many "special" units on Solvay ERP.

Important : 

Quantities are not converted when loading data, and are not store into cubes (The conversion is done when running the report)

So, if a conversion is missing for a material ask the material referent to 

1- manage the conversion on ERP Side by managed the material master (MM03) / unit of measure tab

2- the day after, when the DSO UOMCMAT2 is filled, the conversion is applied in the reports. It applies to whole data without any reloading.

Dependencies with other applications

EHS SVT is adding EHS information on transactional data : Purchasing (Application SPRINT), Production, Sales (OBAS)

Data loadings

Info providers and objects loaded

Main Chains

Slave Chains

Other Chains

Loading frequency

The application is done weekly on saturdays at 11am

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

For EHS SVT, queries have been developped, but for each query, an analysis workbook has been settled => only one access mode.

All queries/workbooks are published in an unique role menu “EHS – Substance Volume Tracking” (ZR_RCS_CA_M48)

NB : Following queries  are not yet available as workbook (not part of convergence project), a freshdesk has to be created by the Business Team.

• EHS - Imported Material without Composition (Core query) => BW_QRY_MPR_EHS02_0005
• EHS - Imports List by Material (Core query) => BW_QRY_MPR_EHS02_0004
• EHS - Imports list from GTS (Core query) => BW_QRY_MPR_EHS02_0002
• EHS - Imports List by Substance (Core query) => BW_QRY_MPR_EHS02_0006

All reports have following common filtrers

• Country of Origin (C_CNTRY_O) = autorisation

• Tracking Flag (C_TRCKFLG) = 'Y'

• Component Type Exclusion (C_IMPFLG) = 'N'

• Material Exclusion Flag (C_EXCLUSI) = 'N'

• Chemical reaction <> 0 'NO'

All reports have following condition 

• Quantites PRO >= 0
  
  

 Here are the different filters for each report

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution