Software Solutions within SAP R/3 for Environmental
Management and Sustainability Reporting
Results from a case study with Continental
Automotive Systems in the research project
I N T U S
Severin Beucker
T h o m a s L o e w
Content
§
Research project INTUS and the case study at Continental
§
Initial Situation at Continental
§
Objectives and Solution
§
Results
The research project INTUS: partners and objective
Title:INTUS = Operationalisation of Environmental Accounting
Instruments through the use of Environmental Management Information Systems Objectives: • Improvement of existing environmental accounting instruments
• Better understanding on how to select the right EMA instrument
• Efficient application of the instruments by the support of Environmental Management Information Systems (EMIS)
Case Study: Continental Temic Nürnberg
Company profile:Continental Temic is part of Continental Automotive Systems (CAS) and has
production sites in 13 countries (more than 3000 employees in Germany). Main office is situated in Nürnberg. Products are electronic components for automotive safety systems (brakes, airbags, etc.)
Targets of the case study:
The company faces an increased demand for information on the use of
environmentally relevant materials
• Input-Output-Balances,
Environmental Management
• use of defined materials
such as lead in solder and VOC in adhesives
Initial Situation: Different and Inconsistent Data
Hazardous Substances Management hazardous substances database Waste Management Waste/residue database PPS Production Planning-System Corporate Accounting common data partial IntegrationERP
System
Input-Output Balancing in spread sheets with data from ERPBusiness Applications:
Integrated software for business processes, ERP-system (SAP R/3) Environmental Management:
• Input Output Balance work intense (manual queries to evaluate material consumption)
• Separate software for management of waste and hazardous substances
• Register for hazardous substances in spread sheets, quantitative
infor-mation in SAP R/3 Resulting Problems:
• Input-Output-Balance to much effort and imprecise
Objective and Solution: Efficient Use of Existing ERP-data
ObjectiveMaking data from ERP-System easily available for environmental management
• Focus: consumption of environmentally relevant materials
• Option: automatic input output balance
Solution
• Classification of materials in SAP R/3 according to a developed scheme of an “Eco-Key”
• Storage and administration of Eco Key data in SAP MM and SAP EH& S
• Standardized and self defined queries with ABAP List Viewer
• Long term: complete integration of data on hazardous substances
X2 Y1 Y2 Y3 U1 U2 U3 U4 U5 U6 A U10-15 Material typ Ökokontenrah menschlüssel Klassische Uw.eigenschaften laut Gefahrstoffgesetzgebung Aggregat -zustand TEMIC- bzw. CAS-spezifische Umwelteigensc haften
Storage, Administration and Analysis of Data from Eco Key
- material number
- attributes of Eco Key (material typ, material group)
- attributes of Eco Key (environmental properties)
ABAP List Viewer
SAP MM SAP EH&S U1 U2 U3 U4 U5 U6 A Ux-y Spezielle Umwelteigenschaften Aggregat -zustand Klassische Uw.eigen-schaften laut Gefahrstoffges etzgebung X2 Y1 Y2 Y3 Material typ Ökokontenrah menschlüssel
Results
standard queries
• hazardous substances inventory
• Input side of I/o balance (optional)
• Other standard queries Self defined queries
• Use of substances containing lead
• Use of substances containing VOC
Challenges and Conclusions
Case study:• Technical solution rather easy to develop
• Highest efforts for checking and completing master data
• Implementation of SAP/EH+S was scheduled but not yet decided in the Temic group
• Other projects to maintain compliance had a higher priority (especially IMDS in the automotive sector)
Project INTUS/ general:
• ERP systems contain valuable useful information and data for environmental management purposes
• Today the cost benefit ratio of such projects is still difficult to determine, development of software solutions in the environmental field is still often driven by regulations
• In the future integrated solutions for environmental management in ERP systems will be provided
sector-Thank you for Your Attention !
Thank you for Your Attention !
Severin Beucker
Institut für Arbeitswirtschaft und Organisation (IAO) Nobelstraße 12 70569 Stuttgart, Germany Tel: ++49/711/ 970 - 5132 Fax: ++49/ 711/ 970 - 2287 e.mail: severin.beucker@iao.fhg.de www.bum.iao.fjg.de
Dr. Gunnar Jürgens
Continental Teves AG & Co. oHG Guerickestraße 7 60488 Frankfurt, Germany Tel: ++49/ 69/ 7603 - 5864 Fax: ++49/ 69/ 7603 - 4813 e.mail: gunnar.juergens@contiteves.com