Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Computations in background are performed:

Every week day at 1pm : load of only Advanced_GBU_Access_rights_PROD_ 

Weekly 

  • every Tuesday evening:   Validation       +  Cerise load   +   calculation based on input flat files
  • every Thursday evening: Validation only 

Monthly every 14th of each month for a full load (all sources) + validation + calculation

Data source and Lineage

Data source mapping and lineage, DPL creation:
sheet DataLineage_BQ_202503 Data Knowledge PCF - Sustainability IT11672
Looker Studio   https://lookerstudio.google.com/s/u7OZwfhNNSM

Data sources

Filters 

SAP ZWEHST098

Filter to keep only ( authorization_group IN (ALL ,

Product Carbon Footprint project 

Data source: 

Data source

Filters 

SAP 098

filters keep only 

 authorization group = "ALL","

ZZ_BU_00

"

,

"

ZZ_

BU_02" et "ZZ_BU_02X"

RM_SCO , ZZ_RM_ECO )    OR   business_unit IN (CS, SP, PA, CM, TS, OG) )

and

material_code not equal to ""

DPL views filters: 

Topic

Rules

Keep only non-Confidential products 

select material from SAPWP1_0000_F001_F_M_zwehst098_conso

where authorization_group = ZZ_BU_02

Last calculated PCF, not historized

Select when Is_valid = YES or visible_on_tableau_flag = YES

Preparation: 

Table WRK_BOM
  • PA-391 - Create Table Finished_Product_STD_QTY
  • Conversion Master table
  • Scope 3.1 Raw Materials: 

  • Suppliers / Ecoinvent Emission Factor : PA-261 - Integrate Solvay Suppliers RawMat Carbon Footprint to our PCF
  • CO2 Contribution calculations: DM_SCOPE_3_1_WP1_Estimated
  • Special PDS aggregation rule : Bug PDS
  • For info to get the commercial product code (basic_material or material_group for SPP)(case  whensource_systemlike'SP'thenmaterial_groupelsebasic_materialend)asspecification_codeJOIN DM.DIM_sap_zwehst098 AS sapON sap.source_system_material_name = material_code

    This file can be found here: Functional documentation links

    Overview on the calculation flows :  PCF Calculation Functional documentation

    Flat File management

    Data Preparation 

    New FACT_imep from ODS.imep_conso (without order_type for WP2) and ODS_imep_pf2 (with order type for PF2): 

    Validation process

    Historization & Flat files mgt including Ecoinvent

    Scope 3.1 Raw Materials 

    • Suppliers / Secondary ( Proxy or Ecoinvent ) Emission Factor : 

    → Initial calculation of ef_rm for Scope 3.1 Calculation EF at Raw Material Level

    >>>> Updated with PA-2551 | Update Scopes 3.1 and 3.4 to comply with TFS guidelines

    Updates from primary and secondary data import up to FACT_CALC_scope_3_1_3_4_updstream_estimated

    → Details ont secondary data sources (full and bom to Reporting 3.1): PA-2180 | Corporate Reporting 3.1 detailed specification

    >>>> replaced by last part in PA-2551 | Update Scopes 3.1 and 3.4 to comply with TFS guidelines

    • Quality KPI : Raw material emission factor coverage
    Quality KPI

    Scope 3.1 Corporate Reporting 

    Scope 3.4 upstream Transport 

    Scope 1, 2 and 3.3 Energy

    • CO2 Contribution calculations:

    WRK

    Energy type, activity code and vector mapping WP1

    V.2 Allocate PF1 energy CO2 contribution to Intermediate ProductsExcluded Cost Objects Flat file: Energy SPP // Excluded Cost Objects flat file  

    Scope 3.4

    transportation: Scope 1 GHG and 3.5Waste : 

    • CO2 Contribution calculations:

    WRK

    Biogenic

    • Biogenic

    NEW // Remove commercial product aggregations from the final tables: PA-2634 | Remove Commercial Product aggregation from Biogenic tables

    Fact_Pcf

    What is PCF: 

    It is the quantity of greenhouse gas that was emitted to manufacture a product. It can also include emissions during use and end of life.

    It is expressed in CO2e, meaning CO2 equivalent, as other GHG are counted.

    Here we are talking about cradle to gate footprint, meaning we are targeting emissions from our raw materials purchased or the extraction of our fossil energies up to the gate of our plants, meanning of course that we include the emissions to transform our raw materials into finished products.   

    Why is it important for Solvay to calculate its PCFs ?

    Our clients and the final consumers are asking for lower impact products. 

    So we need to measure our products’ impact to be able to improve it and share it with our clients. We also want to progress towards a sustainable by design innovation and sustainable portfolio management.

    Small enhancements: 

    Data Quality 


    DPL specifications

    Why do we need a digital initiative to calculate our PCFs?

    Today the PCF is an output of Life Cycle Assessments, which are performed manually by R&I experts. They require weeks to months of work and one paint point is the data availability. 

    With our initiative we want to automate the PCF calculations and make it available to our SD Champions, and even to our clients.

    PCF breakdown by scope: 

    Scope numberScope nameScope 1 EnergieDirect energy emission (Electricity, Steam, Gas, Fuel)Scope 2Indirect energy emission (link to energy production) 

    Scope 3.1

    Raw materials Scope 3.3Energy emission upstream (Ressources before the energy production, for exemple carbon footprint produce by the truck to get uranium)Scope 3.4Transportation of intermediateScope 3.5Waste produce during the End to End production of the finish productScope 1 other GHGOther Green house Gas

    How are calculated our PCFs?

    Image Removed

    Functional Data Flow: