EHS - SAP table in play..

Navigating the Core of SAP EHS: Essential Tables

This article provides a comprehensive overview of key tables within the SAP EHS (Environment, Health, and Safety) module. Understanding these tables is crucial for anyone working with SAP EHS, from configuration and customization to data analysis and reporting.

Table of Contents

1. Introduction
2. General EHS Tables
3. Product Safety
4. Industrial Hygiene and Safety
5. Waste Management
6. Incident Management
7. Occupational Health
8. Dangerous Goods Management
9. Reporting and Document Management
10. Regulations and Compliance
11. Integration Tables
12. Finding More Information

1. Introduction

SAP EHS is a comprehensive suite of applications designed to manage environmental, health, and safety processes within an organization. It encompasses various components, including:

• Product Safety: Managing hazardous substances, safety data sheets, and compliance with regulations.
• Industrial Hygiene: Monitoring workplace hazards, assessing risks, and implementing control measures.
• Incident Management: Recording, investigating, and analyzing workplace incidents to prevent recurrence.
• Occupational Health: Managing employee health, including medical surveillance and health assessments.
• Waste Management: Tracking waste generation, disposal, and compliance with environmental regulations.
• Dangerous Goods Management: Handling, transporting, and storing dangerous goods safely and compliantly.

Each of these components relies on a set of underlying database tables to store and manage its data.

2. General EHS Tables

These tables provide foundational data used across multiple EHS components:

Table Name	Description
ESTRH	Specification Header: Stores general information about specifications, such as the specification type and status.
ESTVA	Usage and Validity Area: Defines the validity of a specification, including time periods and organizational units.
ESTVP	Specification-Property Allocation: Links specifications to specific properties or characteristics.
ESTMJ	Inheritance Relationship: Defines inheritance relationships between specifications.
ESSSUB	Substances: Stores information about substances, including their names, CAS numbers, and hazard classifications.
ESSTECH	Technical Data: Stores technical data related to substances and materials, such as physical and chemical properties.

3. Product Safety

These tables are essential for managing product safety data and compliance:

Table Name	Description
EHSWAT	Phrases: Stores standardized phrases used in safety data sheets and labels.
EHSKLM	Value Assignment Types: Defines the types of values that can be assigned to properties.
EHSWATR	Phrase Sets: Groups related phrases together for use in safety data sheets and labels.
CCGLC	Specification Management - Legal Classifications: Stores legal classifications for substances and mixtures.
CCGTM	Dangerous Goods Transport Management: Stores information relevant to the transportation of dangerous goods.

4. Industrial Hygiene and Safety

These tables support industrial hygiene and safety processes:

Table Name	Description
CFF_MEAS	Measurement Data: Stores measurement data collected during workplace monitoring.
CFF_MON	Monitoring Plans: Defines plans for monitoring workplace hazards.
TQ80	Notification Type: Defines types of notifications for incidents and near misses.
EHS_IDK	Identification Keys: Stores identification keys for various EHS objects.

5. Waste Management

These tables manage waste-related data and processes:

Table Name	Description
WWI_CDOC	Waste Disposal Documents: Stores information about waste disposal documents.
WWI_WAS	Waste Management Assessments: Stores assessments of waste management practices.
EHS_WASTE	Waste Classifications: Defines different classifications for waste materials.
TCG42	Waste Codes: Stores codes used to identify different types of waste.

6. Incident Management

These tables are used to record and analyze incident data:

Table Name	Description
CINOTIF	Incident Notification Header: Stores general information about incidents.
CINOTIFI	Incident Notification Items: Stores specific details about incidents, such as injuries and damages.
CI_ACTI	Incident Activities: Stores information about activities related to incident investigation and follow-up.
CI_ROOT	Root Cause Analysis: Stores data from root cause analyses of incidents.

7. Occupational Health

These tables manage employee health data and processes:

Table Name	Description
HCMT_BSP	Health Surveillance Protocols: Defines protocols for employee health surveillance.
HCMT_EHSM	Health Services Master Data: Stores master data related to health services.
HCMT_OCCH	Occupational Health Checkups: Stores data from employee health checkups.
HCMT_DOC	Medical Records Documents: Stores employee medical records and documents.

8. Dangerous Goods Management

These tables are crucial for managing dangerous goods safely:

Table Name	Description
DG12	Dangerous Goods Master: Stores master data for dangerous goods, including UN numbers and hazard classifications.
DGCF	Dangerous Goods Check Functions: Defines functions used to check compliance with dangerous goods regulations.
DGSBT	Dangerous Goods Texts: Stores descriptive texts for dangerous goods.
DGDGR	Dangerous Goods Regulation: Stores information about dangerous goods regulations.

9. Reporting and Document Management

These tables support EHS reporting and document management:

Table Name	Description
TCGPC	Generation of Report from WWI: Stores data for generating reports from waste management data.
CG54	Label Templates: Stores templates for generating labels for hazardous materials.
TCG11	Report Symbols: Stores symbols used in EHS reports.
TCG60	Report Templates: Stores templates for generating EHS reports.
TCG71	Report Generation Variants: Stores variants for generating EHS reports.

10. Regulations and Compliance

These tables manage regulatory data and compliance checks:

Table Name	Description
REGCA	Compliance Check Catalog: Stores a catalog of compliance checks.
REGCF	Compliance Check Functions: Defines functions used to perform compliance checks.
REGCL	Compliance Check Levels: Defines different levels of compliance checks.

11. Integration Tables

These tables facilitate integration between EHS and other SAP modules:

Table Name	Description
EHSINT	Integration Scenarios for EHS: Defines different integration scenarios between EHS and other modules.
EHSINTMAP	Integration Mapping Table: Maps data between EHS and other modules.

12. Finding More Information

This list provides a starting point for understanding key SAP EHS tables. To delve deeper, consider the following resources:

• SAP Help Portal: Provides detailed documentation on SAP EHS tables and functionality.
• SAP Community Network: Offers forums, blogs, and other resources for SAP EHS users.
• SAP Transactions: Use transactions like SE11 (ABAP Dictionary) and SE16 (Data Browser) to explore table structures and data.

By familiarizing yourself with these tables and leveraging available resources, you can effectively navigate the SAP EHS landscape and unlock its full potential for managing environment, health, and safety processes.