HS 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
The SAP module is installed and used on Solvay/RCS legacy systems. The standard SVT does not bit business rules.
The SVT reporting is now based on a BW solution.
Tool Leader + IT leader of the application:
Describe the key User profiles that exist for the application. General role/Viewer role: Approver role: Roles and access
Useful 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. Useful to know concerning BUTA Chimie (Company Code ZFR9) : A filter on C_PLANT from authorization has been added in all SVT queries :
Following perimeter role will have to be managed for all EHS SVT users :
The BUTA data will have to be loaded in cube REACH (SVT Analysis - EU (Rhodia) / CREHS06). |
Target Users: As examples: Controllers / Accountants Around 90 users, worldwide. Each country can only report on its data. |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 03.11.2023 | Abidemi Rajiu | Initial draft |
|
Capture the business process that the application supports . This can be describe through a process diagram or a business capability model
Documentation:

Information about the existent Workbooks and the respective BW queries.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.
Could be specific fields, closing activities, additional information to work and understand the reports.

| Domain | <insert name> |
|---|---|
| Application | >insert name> |
| Provider | <insert name> |
| Existing Documentation | <insert link> |
This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.
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)
New Query: SVT Report-Notification of nanomaterials Europe (core query) => BW_QRY_MPR_EHS07_EU_0002
NB : Following queries are not yet available as workbook (not part of convergence project), a freshdesk has to be created by the Business Team.
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
Here are the different filters for each report
Reg List (C_REG) | Cube (0INFOPROV) | Scenario (C_SCEN) | Others | ||
BW_WBK_EHS_SVT_GENERIC Generic SVT - Substance Level (Core Workbook) | BW_QRY_CPEHSV01_0002 EHS - SVT Generic reporting Query (Core) | All | ABEHSV02, ABEHSV04 (Composite Provider CPEHSV01: ) | All | |
BW_WBK_EHS_SVT_GENERIC Generic SVT - Product Level (Core Workbook) | BW_QRY_CPEHSV01_0003 EHS - SVT Generic reporting Synthesis Query (Core) | All | ABEHSV02, ABEHSV04 (Composite Provider CPEHSV01: ) | All | |
BW_WBK_EHS_SVT_CN_001 CN Registered New Chemicals (Core Workbook) | BW_QRY_MPR_EHS07_CN_0001 CN Registered new chemicals (Core Query) | ZCN_NEW_CH | CUB_EHS07, CREHS02 | all except PUR | Regulation Code ( C_REGCODE) / Type of substance = CN001 + '#' |
BW_WBK_EHS_SVT_CN_002 CN KECH Chemicals (Core Workbook) | BW_QRY_MPR_EHS07_CN_0002 CN Key environmental controlled haz. chemicals (Core Query) | ZCN_KECHC | CUB_EHS07, CREHS02 | PRO | Regulation Code ( C_REGCODE) / Type of subst. = CN002 + '#' |
BW_WBK_EHS_SVT_JP_001 JP Annual Reporting (Core Workbook) | BW_QRY_MPR_EHS07_JP_0001 JP Annual reporting of chemicals (Core Query) | ZJP_AN_REP | CREHS01, CUB_EHS06 | All excpect PUR | Regulation Code ( C_REGCODE) / Type of subst. = JP001, JP002, JP003, # |
BW_WBK_EHS_SVT_JP_002 JP SVE-LPN Annual Reporting (Core Workbook) | BW_QRY_MPR_EHS07_JP_0002 JP Annual reporting of SVE/LPN of new chemicals (Core Query) | ZJP_CSCL, ZJP_ISHL | CREHS01, CUB_EHS06 | EXP, IMP, PRO, ICI | Regulation Code ( C_REGCODE) / Type of subst. = JP004, JP005, JP006, # |
BW_WBK_EHS_SVT_KR_001 KR Annual Reporting (Core Workbook) | BW_QRY_MPR_EHS07_KR_0001 KR Annual reporting of chemicals (Core Query) | ZKR_AN_REP | CREHS03, CUB_EHS08 | all | Regulation Code ( C_REGCODE) / Type of subst. = KR001, KR002, #' |
BW_WBK_EHS_SVT_KR_002 KR Registration (Core Workbook) | BW_QRY_MPR_EHS07_KR_0002 KR Registration (Core Query) | ZKR_DESIGN, ZKR_NEW | CREHS03, CUB_EHS08 | PRO/ICI/IMP On devrait ajouter le filtre dans qry | Regulation Code ( C_REGCODE) / Type of subst. = KR003, KR004, # |
BW_WBK_EHS_SVT_TR_001 TR Substances Notification (Core Workbook) | BW_QRY_MPR_EHS07_TR_0001 TR Substances Notification (Core Query) | ZTR_CICR | CUB_EHS07, CREHS02 | ICI, SO | Regulation Code ( C_REGCODE) / Type of substance = TR001, # |
BW_WBK_EHS_SVT_EU_001 EU REACH (Core Workbook) | BW_QRY_MPR_EHS07_EU_0001 EU REACH (Core Query) | REACH | CREHS04, CREHS06 | ICI, PRO, IMP | |
BW_WBK_EHS_SVT_US_001 US TSCA CDR (Core Workbook) | BW_QRY_MPR_EHS07_US_0001 US TSCA CDR (Core Query) | TSCA | CREHS05, CREHS07 | IMP, ICI, PRO, EXP | |
BW_WBK_EHS_SVT_US_002 US TSCA 12b (Core Workbook) | BW_QRY_MPR_EHS07_US_0002 US TSCA 12b (Core Query) | ZUS_T12B | CREHS05, CREHS07 | EXP | |
BW_WBK_EHS_SVT_CA_001 Canada Non DSL Tracking (Core Workbook) | BW_QRY_MPR_EHS07_CA_0001 Canada Non DSL Tracking (Core Query) | ZCA_DSL | CREHS05, CREHS07 | IMP, PRO, ICI | Substance <> EXCLUDED |
BW_WBK_EHS_SVT_CA_002 Extended tracking for Canada (Core Workbook) | BW_QRY_MPR_EHS07_CA_0002 Extended tracking for Canada (Core Query) | ZCA_SVT | CREHS05, CREHS07 | IMP, ICI, PRO | |
BW_WBK_EHS_SVT_EU_003 SVT Report-Notification of nanomaterials Europe (core Work book) | BW_QRY_MPR_EHS07_EU_0002 SVT Report-Notification of nanomaterials Europe (core Query) | ZEU_NANO | CREHS04 CREHS06 | IMP, ICI, PRO | |
BW_WBK_EHS_SVT_AU_001 AU Annual Reporting (Core Workbook) | BW_QRY_MPR_EHS07_AU_0001 AU Annual reporting of chemicals - SO | ZAU_AICS | CREHS08 | SO | |
BW_QRY_MPR_EHS07_AU_0002 AU Annual reporting of chemicals - IMP+ICI | ZAU_AICS | CREHS08 | ICI, IMP | ||
BW_QRY_MPR_EHS07_AU_0003 AU Annual reporting of chemicals - PRO | ZAU_AICS | CREHS08 | PRO | ||
BW_QRY_MPR_EHS07_AU_0004 AU Annual reporting of chemicals - LOG | ZAU_AICS | CREHS08 | ALL | Log_ID = Non initial | |
Usability is about the ease with which a User can learn to start using the solution and the ease with which they can use the system. In addition to ease of learning and ease of use, usability also includes areas such as ease of recall, error avoidance and handling, accessibility among others e.g., 99% of metadata entry Users who have use the Maintenance Dashboard should be able to change filters, extract etc., when required. Maintenance data will be centrally stored in the Google Cloud platform, which will be available to other applications e.g., and Dashboards if needed.
Software systems must comply with legal and regulatory e.g., GDPR requirements, this can change depending on country, organisation industry and / or region. The software systems must be secure from unauthorized access. The Maintenance Dashboard will comply with Solvay’s regulations and compliance e.g., access only granted to authorized Users.
Security refers to essential aspects that assure a solution and its components will be protected against unauthorized access or malware attacks. Important considerations related to security aspects of a system are User authentication, User authorization or User access privileges, data theft, malware attacks, data encryption, and maintaining audit trails, e.g., only Users with administrator access shall be able to create new accounts and assign data access privileges to the new accounts e.g.,
Performance defines how fast a software system or a particular section of it responds to certain User actions under a certain workload. In most cases, this metric explains how long a User must wait before the target operation happens e.g., the page renders, a transaction is processed, etc., given the overall number of Users now. Performance requirements may describe background processes invisible to Users, e.g., backup and speed of data transfers.
Reliability is the ability of a solution or its component to perform its required functions without failure under predefined conditions for a specified time / period. Reliability can possibly be specified in terms of average time system runs before failure occurs, percentage of operations completed successfully within a time / period, maximum acceptable failure probability, or number of failures within a period. Reliability aspects are in reference to (but not limited to) evaluation of the system to be considered as reliable, classification of reliability defining failures vs. regular failures, and the impact of failure on business operations. The Maintenance Dashboard will display data from the previous refresh of data.
Scalability refers to the degree to which a solution can evolve to handle increased amounts of work. The increased amount of work could be in terms of the user base, transactions, data, network traffic, or other factors e.g., the system should be able to handle an additional load of a maximum of 5,000 Users every month for the next 6 months without any noticeable performance impacts.
Interoperability is the degree to which the solution is compatible with other components. It is a measure of how effectively the system interoperates with other software systems and how easily it integrates with external hardware devices.
Interoperability aspects to be discussed during elicitation are in reference to (but not limited to) software systems to be interfaced with along with data / messages to be exchanged and any standard data formats, hardware components to be integrated with, and any standard communication protocols to be followed e.g., Order Management system will push the order file into a secured file transfer protocol server from where it will be loaded into the system through a daily job. To guarantee between Google Cloud platform and SAP BW Queries e.g., BW_QRY_MVPMOR01_0002, Solvay has introduced a new tool called Xtract (Xtract).
Availability is the degree to which the solution is operable and accessible when required. It is a measure of time during which the system is fully operational e.g., available for use and sometimes included as a Service Level Agreement (SLA) considering its criticality to the business, e.g., the system shall be at least 99% available on weekdays between 09:00 to 18:30 Central European Time (CET).
Frequency, data, and time of the data refresh in the data product.