Cerise (Co2 Energy Report Improvement Software Efficiency) has been launched end of 2019 and implemented in 2020/2021; the aim of the project is to provide Solvay with:
- A robust and simple reporting solution, giving a detailed view of energy consumption/expenses and CO2 emissions
- An automated solution to manage ETS (European Trading Scheme) exposition for all sites concerned in Europe (~30 registers), giving a projection of EUA (EU Allowances) balance for 10 years, to be able to decide the right time to hedge EUAs on the market
Key profiles:
HSE experts
Group reporting on CO2 emission
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 27.11.2023 | Emma Glasson | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
BW transaction ZECO2:
The purpose of this transaction in BW is to be able to manage following situations by the Energy expert:
Case 1: for SAP Sites, completion of data with entries not managed by technical flows put in place in Cerise solution (ex. sales of Energy)
Case 2: for SAP Sites, correction of data updated from SAP sources by increasing/decreasing amounts/quantities
Case 3: for non SAP Sites, entry of all data relevant for Energy/CO2 follow up
Data have to be entered at following level: ProdEquipt / Vector / Prod/Cons. indicator / Period
☛ If several periods are entered as an interval, input amounts/qties are divided for reporting by the number of corresponding periods; ex. if 1 200 is entered for 01.2020 to 12.2020 (i.e. 12 periods), 100 is saved for each period
Key figures (amount and/or qty) have to be updated with their UoMs:
Both can be entered as positive or negative values
☛ Warning: Production increase (stored as a negative value) has to be entered as a positive value / Production decrease (stored as a positive value) has to be entered as a negative value
Input quantities/UoMs are converted in standard UoM like other SAP data (see above SAP data enhanc.: qty conversion)
The Energy expert can also add some flat file to add data for Site that are not in SAP via the transaction :
Some data can also be flag for historisation. Like this the data flag for a specific period of time define by the Energy Expert will not be impacted by the futur changes like change of conversion rates because they are old data and at the time it was a different conversion rule in place.
Information
Input data are available in reporting as soon as table entries are saved in ZECO2 via ECO2 - Manual entries before CO2 conv. (Core Query)
Conversion Energy Quantity into CO2 rules:
3.0 Application Feature Overview
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| ECO2 - Database before CO2 conv. (Core Query) | Collect all data related to Energy from the site. Data related to energy quantity, not converted in CO2 Emission. Data sources are SAP (WP1/PF1) , including IMEP data, Cost center postings and SKF postings. We also have some manual entry for site that are not in SAP. Contains SAP data + Manual entries | Authorization scope Fiscal Year Period Index 1 Plant Site
| BW_WBK_ECO2_0001 | BW_QRY_CPECO201_0001 |
| ECO2 - SAP database after CO2 conv. (Core Query) | Energy data converted into CO2 Emission. | Authorization scope Fiscal Year Period Plant Site
| BW_WBK_ECO2_0002 | BW_QRY_CPECO202_0001 |
| ECO2 - Historical data from external file incl. CO2 conv. (Core Query) | Historical data from external file, energy quantity converted in CO2. | BW_WBK_ECO2_0003 | BW_QRY_CPECO202_0002 | |
| ECO2 - Manual entries before CO2 conv. (Core Query) | Capture energy data for site that are not in SAP. The expert can input data via the transaction ZECO2. Contains only only manual entries | BW_WBK_ECO2_0004 | BW_QRY_CPECO201_0002 | |
ECO2 - DataSource for ABECO204 (Core Query) | Technical datasource from CPECO01 in order to fuel conversion process in CPECO202 | No prompt | n.a | BW_QRY_CPECO201_0000 |
ECO2 - QV interface before CO2 conv. (Core Query) | For QV update with amounts and quantities in origin UoM | Authorization scope Fiscal Year Period Site
| n.a | QV_BW_QRY_CPECO201_0001 |
ECO2 - QV interface after CO2 conv. (Core Query) | For QV update with converted quantities in CO2 quantities. | Authorization scope Fiscal Year Period Plant Site
| n.a | QV_BW_QRY_CPECO202_0001 |
4.0 Functional Specification
4.1 General Data/Calculations
| Dimension | Definition | ZECO2 BW Transaction | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Vector | Vector is the element that conveys energy and CO2 content, including:
For reporting purposes, Vectors are grouped in a multi levels hierarchy:
| |||||||||||||||||||||||||||||||||||||||||||
| Vector EPS Family | EPS Family is a Vector attribute that can be used to facilitate reconciliation with former EPS Coach tool | |||||||||||||||||||||||||||||||||||||||||||
| Vector Free Grp | Free Grp is an uncontrolled field that can be populated for kind of user grouping (in combination with ProdEquipt Free Grp) | |||||||||||||||||||||||||||||||||||||||||||
| CO2 ETS % Group [Vector] | CO2 ETS % Group attribute is also allocated to corresponding Vectors; it is used to calculate specific emission key figure (in combination with ProdEquipt CO2 ETS % attribute and Site ETS attribute) | |||||||||||||||||||||||||||||||||||||||||||
Scope 1 Scope 2 Scope 3 [Vector] | Scope 1/2/3 Group attributes are allocated to corresponding Vectors; they are used to calculate specific emission key figures (in combination with ProdEquipt Scope 1/2/3 attributes). Scope 1 represents direct energy emission. Scope 2 represents indirect energy emission link to energy production. Scope 3.3 represents energy emission upstream (Ressources before the energy production, for exemple emission emitted by the truck to get uranium for the Power plant that produce electricity) | |||||||||||||||||||||||||||||||||||||||||||
| Production Equipment | Production Equipment is a subset of a physical production Site; this is the level at which calculated energy and CO2 contents of input and output Vectors are balanced. For reporting purposes, ProdEquipts are grouped in a multi levels hierarchy:
| |||||||||||||||||||||||||||||||||||||||||||
| Production Unit | A production unit is assigned to one single Site | |||||||||||||||||||||||||||||||||||||||||||
GBU PRS Company code | PRS Company code and BFC GBU are needed only for non SAP Sites (otherwise they are automatically derived from SAP master data) | |||||||||||||||||||||||||||||||||||||||||||
ETS Register | ETS Register is the lowest level of ETS structure; only ProdUnit belonging to an ETS Site have to be assigned to a Register | |||||||||||||||||||||||||||||||||||||||||||
EPS Usage | EPS Usage is a free text that is defined as Production Unit attribute in order to facilitate reconciliation with former EPS Coach tool | |||||||||||||||||||||||||||||||||||||||||||
Multi Prod. Vectors | Multi Prod. Vectors flag is an critical attribute in conversion process, used to identify equipments with more than 1 ouput Vector (see above) | |||||||||||||||||||||||||||||||||||||||||||
Prod/Cons. | Assigned for all SAP entries to a Production (P) or Consumption (C) indicator in order to differentiate input and output Vectors in a ProdEquipt. | Update rule depending on the source:
| ||||||||||||||||||||||||||||||||||||||||||
UoM = Unit | The purpose is to convert all origin quantities and corresponding UoMs (Ref. UoMs) in few key UoMs (Std UoM) in order to facilitate subsequente CO2 conversion process. | Conversion table:
Info: Reference UoM of each dimension is maintained in T006D; conversion ratios of each UoM into reference UoM is maintained in T006. | ||||||||||||||||||||||||||||||||||||||||||
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Sustainability |
|---|---|
| Application | BW CERISE Queries |
| Provider | CPECO201 - Before CO2 CPECO202 - After CO2 |
| Existing Documentation |
4.2.2. KPI's/Calculations/Indicators
Indicators available in Before CO2 Core Query:
Indicators | Definition | Calculation/Extraction of data |
|---|---|---|
Qty | Quantity in local quantity (base UoM) | |
Qty Std UoM | Quantity in Standard Unit of Measure (dimension Std UoM is available to show the unit) | |
Qty in AI | Quantity produced (negative) or consumed (positive) in Active ingredient (AI) in base UoM Active ingredient (AI) is when Index_1=1, meaning Finished product | |
Qty in AI Std UoM | quantity produced (negative) or consumed (positive) in Active ingredient (AI) in Std UoM. | |
Actual Costs | Actual costs of consumption (positive) or production (negative). | |
ML Costs | In WP1, the value is the same as Actual Costs. In PF1 value from source Imep : Actual costs produced (negative) or consumed (positive) = ML VC + ML FX + ML DP Field in local currency | For PF1 only: ML Costs = ML VC + ML FX + ML DP |
ML Costs EUR | Actual costs produced (negative) or consumed (positive) = ML VC + ML FX + ML DP in Euro |
Indicators available in After CO2 Core Query:
Indicators | Definition | Calculation/Extraction of data |
|---|---|---|
| Qty Sdt UoM | Quantity in Standard Unit of Measure (dimension Std UoM is available to show the unit) | |
| Total Energy content GJ | ||
| Energy/NRJ GJ | ||
| Energy/NRJ GJ/Std UoM | ||
| Energy/RM+UT GJ | ||
| Energy/RM+UT GJ/Std UoM | ||
| Total CO2 content Kg | Total CO2 content Kg = CO2 Scope 1/NRJ Kg+CO2 Scope 1/Process Kg+CO2 Scope 2 Kg+CO2 Scope 3.1 Kg+CO2 Scope 3.3 Kg | |
| CO2 Scope 1/NRJ Kg | ||
| CO2 Scope 1/NRJ Kg/Sdt UoM | ||
| CO2 Scope 1/Process Kg | ||
| CO2 Scope 1/Process Kg/Sdt UoM | ||
| CO2 Scope 2 Kg | ||
| CO2 Scope 2 Kg/Sdt UoM | ||
| CO2 Scope 3.1 Kg | ||
| CO2 Scope 3.1 Kg/Sdt UoM | ||
| CO2 Scope 3.3 Kg | ||
| CO2 Scope 3.3 Kg/Sdt UoM | ||
| CO2 Emiss. Scope 1/NRJ Kg | ||
| CO2 Emiss. Scope 1/Process Kg | ||
| CO2 Emiss. Scope 2 Kg | ||
| CO2 Emiss. Scope 3.1 Kg | ||
| CO2 Emiss. Scope 3.3 Kg | ||
| CO2 Emiss. ETS/NRJ Kg | ||
| CO2 Emiss. ETS/Process Kg |
5.0 Non-functional Descriptions
5.1 Usability
as per standards
5.2 Regulatory Compliance
GDPR compliant.
5.3 Security
- Only authorised Users be able to access data.
- PO2 split : Authorization group
5.4 Performance
as per standards
5.5 Reliability
as per standards
5.6 Scalability
Historical report, no small enhancements will be performed and no new access except for new joiners in HR domain.
5.7 Compatibility
as per standards
5.8 Availability
as per standards
5.9 Refresh of the Data
2 daily refresh : 2pm CET and 2 am CET




