File link: 


1. Purpose of the file: 

This file provides emission factor (EF) data for alternative raw materials — materials that are being considered as prospective or current substitutes for existing raw materials in the Syensqo Bill of Materials (BOM).
Each row describes one alternative raw material at a specific plant, GBU, and production year, together with its supplier information, carbon footprint indicators (ef_rm, ef_rm_net, rci, bcc, tcc), and commercial context (interchangeability status, buyer, supplier pledge, premium cost).
This data feeds into PCF calculations for finished products that use or could use these alternative raw materials. The raw_material_status field distinguishes between materials that already exist in SAP (Current) and those that are prospective and not yet in SAP (Prospective). The reference_material_code field links each alternative to the existing SAP raw material it is intended to substitute


2. File Structure

2.1. List of tabs

Sheet NameDescriptionMandatoryComment

Sheet1

Main data entry sheet. Contains EF data for alternative raw materials per plant, GBU, and production year.YESDon't delete this sheet


2.2. Main columns description
SHEET: Sheet1

Fieldsource_systemraw_material_statusgbugbu_nameprod_yearplant_site_codeplant_site_nameplant_codeplant_namesite_codesite_namematerial_value_chain_purmaterial_value_chain_pur_namematerial_product_codematerial_product_namealternative_material_codealternative_material_nameadj_coefvendor_group_pur_codevendor_group_pur_namevendor_countryvendor_country_namevendor_codevendor_nameef_rmef_rm_netrcibcctccsource_efdetails_sourcereference_material_codeinterchangeabilitybuyer_namesuppliers_pledgePremium_EUR_per_kgfiscal_year_periodcomment
DescriptionName of the system from which the data is extractedCan be Prospective (it doesn't exist in SAP) or Current (it exists in SAP).SAP code of the Global Business Unit. Validated against known GBU list.SAP name of the Global Business Unit. Validated against known GBU list.Calendar year for which the PCF data is reported.SAP Plant Code identifying the receiving Syensqo plant (coming from Purchasing)SAP Plant Name corresponding to the plant code.SAP Plant Code identifying the receiving Syensqo plant.SAP Plant Name corresponding to the plant code.Unique site code (as assigned in SAP or other systems) identifying the site where the emissions occurName of the site where the emissions are generatedPurchasing Material Code Group uniquely identifying the purchased material.Purchasing Material Name Group uniquely identifying the purchased material.SAP Raw Material Code uniquely identifying the purchased material.SAP Raw Material Name as registered in the ERP system.SAP Raw Material Code uniquely identifying the purchased material.SAP Raw Material Name as registered in the ERP system.Adjustment coefficient accounting for material concentration (e.g. solutions).SAP Purchasing code identifying the vendor groupSAP Purchasing name identifying the vendor groupCountry Code specific to the vendorCountry Name specific to the vendorSAP Purchasing code identifying the vendorSAP Purchasing name identifying the vendorValidated total Product Carbon Footprint (kgCO₂e/kg) excluding Biogenic from the supplier for this raw material.Validated total Product Carbon Footprint (kgCO₂e/kg) including Biogenic from the supplier for this raw material.Recycled Carbon Content: kgC from recycled sources per kg of product.Biogenic Carbon Content: kgC of renewable biological origin per kg of product (from supplier).Total Carbon Content: total kgC per kg of product shared by the supplier.Source of the emission factor (primary or secondary)Comments related to the source of the emission factorSAP Raw material code that will be substituted
Name of the buyer
Premium to be payed for the alternative raw material
Additional comments or clarifications regarding the user-provided values
Data TypeStringStringStringStringString YYYYStringStringStringStringStringStringStringStringStringStringStringStringFloatStringStringStringStringStringStringFloatFloatFloatFloat 0–1Float 0–1StringStringStringStringStringStringStringStringString
MandatoryYESYESYESYESYESYESYESYESYESNONONONOYESYESYESYESNONOYESYESNONONONONONONONONONONONONONONONONO
Validation / Allowed Values
Prospective/CurrentCS (Novecare) or "SP" (Specialty Polymers)Novecaree.g. 2024, 2025MJSMariettae.g. CZS, AQS, MJSFree text; must match SAP record1175CHANGSHU12352298BIOCHEMICAL / VEGETALe.g. 208483Free text; must match SAP recorde.g. WP2/208483Free text; must match SAP record

SASOLITItaly106496BASF CORPValues outside –20 / +20 will be rejectedValues outside –20 / +20 will be rejected
Between 0 and 1Between 0 and 1Supplier Data/SimaPro/Ecoinvent








3. Filling instructions

FieldInstructions
Sheet1_TFS

•  Complete all mandatory fields for every row. Rows with missing mandatory values will be rejected during upload.

•  raw_material_status must be either "Prospective" (material does not yet exist in SAP) or "Current" (material already exists in SAP).

•  gbu must match a valid GBU code validated against the known list (e.g. CS, SP, PA, TS, OG).

•  prod_year must be a 4-digit calendar year string (e.g. 2024, 2025).

•  Carbon content fields (tcc, bcc, rci) are optional but recommended when available from the supplier. If provided: rci must be between 0 and 1; tcc should also be between 0 and 1; bcc should be consistent with tcc and rci (bcc = tcc × rci).

•  source_ef should indicate the origin of the emission factor data: "Supplier Data", "SimaPro", or "Ecoinvent".

•  reference_material_code should be the SAP code of the existing conventional raw material that this alternative is intended to replace.

•  interchangeability indicates the qualification status: "YES" (qualified), "NO" (not qualified), "NEW" (new entry), or "QUALIFICATION REQUIRED".

•  Premium_EUR_per_kg and fiscal_year_period are optional commercial fields used for cost tracking of the alternative material premium.

•  Do not modify, add, or remove columns.

•  Duplicate rows (same source_system + gbu + prod_year + plant_code + alternative_material_code + vendor_code) will be rejected during upload.


4. Maintenance best practices

Please comply with the following instructions to maintain the file:                                                                                                    
• Always keep the original structure (do not add/remove columns without approval).                                                                                                    
• Update only the necessary fields.                                                                                                    
• Save a backup copy before any major changes.                                                                                                    
• Respect data confidentiality. 


5. Contact Points         

File ownerNadia Boudif
Technical SupportCamille Faure Laëtitia Arantes

The data owner will receive the error file by email and will be responsible for making any necessary manual corrections. 
For any questions or issues, please contact the responsible person listed above.
Please strictly follow these guidelines to ensure data quality and reliability.  



  • No labels