SAP Environment, Health and Safety Tables

Are you looking for the right table related to SAP Environment, Health and Safety Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Environment, Health and Safety (EHS) module.

Top 10 tables in Environment, Health and Safety

TableDescription
CCIHT_IALEHS: Incident/Accident Log - Header
CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data
TDGD5DG: Definition of an Indicator Category
CCIHT_MPPLEHS: Project Plan
CCIHT_MPEHS: Measurement Project
CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job
CCIHT_AM09EHS: Customer Analysis Method 09
CCIHT_ERHOBSOLETE - EHS: Risk Assessment - Header
CCIHT_AM07EHS: Customer Analysis Method 07
CCIHT_MJEHS: Measurement

List of tables in Environment, Health and Safety

TableDescription
CCIHT_IALEHS: Incident/Accident Log - Header
CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data
TDGD5DG: Definition of an Indicator Category
CCIHT_MPPLEHS: Project Plan
CCIHT_MPEHS: Measurement Project
CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job
CCIHT_AM09EHS: Customer Analysis Method 09
CCIHT_ERHOBSOLETE - EHS: Risk Assessment - Header
CCIHT_AM07EHS: Customer Analysis Method 07
CCIHT_MJEHS: Measurement
CCIHT_IPEHS: List of Persons Involved
CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)
CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)
CCIHT_MPMTEHS: Measurement Plan - Measurement Method
CCIHT_RFMJEHS: Reference Measurement
CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts
CCIHT_AM08EHS: Customer Analysis Method 08
CCIHT_WAAEHS: Accident Location
CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)
CCIHT_AM05EHS: Customer Analysis Method 05
CCIHC_AC06EHS: Effectiveness - Language-Dependent Description
CCIHC_PBEHS: Probability of Risk
CCIHC_AC05EHS: Effectiveness of a Safety Measure
CCIHC_RCTREEIDTXDescriptions for Trees in Cause Analysis
CCIHT_WAPTEHS: Assignment of Template to Work Area
CCIHT_RCEHS: Accident Causes (Root Causes)
CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected
CCIHC_AY03EHS: Assignment Table Analysis Method - Agent Type
CCIHT_IPEVINJEHS: Injuries to Person Affected
CCIHT_MPDVEHS: Devices Required for Measurement Project
CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment
CCIHT_AM10EHS: Customer Analysis Method 10
CCIHT_WADOEHS: Work Area - Links to Info Objects
CCIHC_IHOBJEHS: Value Assignment Type - Object Type Assignment
CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment
CCIHC_FALOCEHS: Entry Location
CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System
CCIHC_OC02EHS: Operation Status - Language-Dependent Description
CCIHC_OBJNAMEHS: Description for the Object Types
CCIHT_WAHEHS: Work Area - Header
CCIHC_IPTYPETXTEHS: Role of Person Involved -> Language-Dependent Texts
CCIHC_AC07EHS: IHS Safety Measure Category
CCIHT_MJVAEHS: Measured Values
CCIHC_RCNODECauses and Root Causes
CCIHC_OBJTYPEEHS: Object Type - Object Subtype
CCIHT_AM04EHS: Customer Analysis Method 04
CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data
CCIHT_IPEVALIMOBSOLETE - Incident/Accident Log - Link Accident to Restr.
CCIHC_DVTYPEEHS: Measuring Device Type
CCIHT_IAREPEHS: Period-Based Accident Reports
CCIHC_MPREGEHS: Control Table for Evaluation Objects
CCIHT_FALMAOBSOLETE - EHS: Medical Measures
CCIHC_MPWATYPEEHS: Assignment Level Measurement Project to Work Area Type
CCIHT_HAZ_AMOUNTInventory Data Hazardous Substances
CCIHC_BUILDINGTXEHS: Building
CCIHT_MJVAIMPEHS: Imported Measured Values
CCIHC_WA02EHS: Work Area Type - Language-Dependent Name
CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment
CCIHC_METDVTYPEEHS: Assignment Measurement Method to Device Type
CCIHC_RARTXTEHS: Reason for Risk Assessment - Language-Dependent Desc.
CCIHT_IPEVAOBSOLETE - Inc./Acc. Log - Data for Person Affected (Event)
CCIHC_IALPCATEHS: Accident Category
CCIHC_WA07EHS: Control Table for Integration Objects
CCIHC_LOCMETHODEHS: Assignment Location to Measurement Method
CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements
CCIHC_IHTABEHS: Tabs in Industrial Hygiene and Safety
CCIHC_IAOBJEHS: Object Types in Industrial Hygiene and Safety
CCIHC_METHODTXTEHS: Language-Dependent Description for Measurement Method
CCIHC_AC04EHS: Priorities - Language-Dependent Description
CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison
DGTMD_LKEYDG: Dummy Table for Lock Object on Log. Key for DGTMD
CCIHC_IHTABNAMEHS: Tabs in IHS - Language-Dependent Description
CCIHC_MJCATEHS: Sampling Type
CCIHC_IH09EHS: Categorized Exposure Rating
CCIHC_DVTYPETXTEHS: Language-Dependent Description for Device Type
CCIHC_AC03EHS: Priorities for Safety Measures
EHQMT_GRPEH&S-QM: Assignment of Phrase Groups to Code Groups
CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area
CCIHC_MJCATTXTEHS: Language-Dependent Description for Sampling Type
CCIHC_AC08EHS: IHS Safety Measure Category - Language-Dependent Descr.
CCIHC_SVEHS: Severity of Risk
CCIHC_RCTREECause Hierarchy Tree
CCIHT_ANQSEHS: Analysis Method Questionnaire
CCIHC_RCNTYPETXTTexts for Node Categories
CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts
CCIHC_MPREGTXTEHS: Language-Dependent Description for Evaluation Objects
CCIHC_FATYPEEHS: Category of Injury/Illness Log Entry
CCIHC_WA01EHS: Work Area Types
CCIHC_QT06EHS: Assignment Measured Value-Reference Value and Rating
TDGD2DG: Description Regulation Profile
TCGL1Report types
CCIHC_RCTREEIDCause Analysis Trees
EHQMT_IP_MEMORYEH&S-QM: Memorize Created Inspection Plans
CCIHC_QUALPROTXTEHS: Quality of Protection - Language-Dependent Description
CCIHC_FATRMTEHS: Type of Aid Given
CCIHC_FATYPETXTEHS: Categ. of Injury/Illness Log Entry -> Lang.-Dep. Texts
CCIHT_EPIEHS: Exposure Profile Entry
CCIHC_PBTXTEHS: Probability of Risk - Language-Dependent Description
DGTEXCEPTExceptions to DG Regulations - Header Table
CCIHC_MPLEVELTXTEHS: Lang.-Dependent Desc. for Assgmt Level MP to Work Area
DGTEXCUNNOExceptions to DG Regulations: UN Numbers
CCIHC_QT01EHS: Category of Exposure Amount
TDGA1DG: Activating Dangerous Goods Checks
CCIHC_FALOCTXTEHS: Entry Location --> Language-Dependent Texts
CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project
TDG102Dangerous Goods Packaging Status Descriptions
CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)
CCIHC_QUALPROTEHS: Quality of Protection
DGTPKDG: Packing Requirement
TCGC3Exchange profile
CCIHC_RAREHS: Reason for Risk Assessment
CCIHC_AC02EHS: Safety Measure Type - Language-Dependent Name
CCIHT_AM03EHS: Customer Analysis Method 03
CCIHC_IPTYPEEHS: Role of Person Involved
CCIHC_IATYPEEHS: Type of Incident/Accident Log Entry
CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)
CCIHC_IALPCATABSEHS: Assignment Grp Absence Type - Accident Category
TDG41DG: DG Indicator Profiles for Material Master
EHS_TDG83Categories of Package
CCIHC_EPI01EHS: --Obsolete-- Origin of an Exposure Profile Entry
CCIHC_MPTYPCATEHS: Assignment Measurement Project Type to Sampling Type
CCIHC_AC01EHS: Safety Measure Types
CCIHC_AY06EHS: Analysis Method Questionnaire - Rating
VEDGDG: Supplement Table for DG Data (Handling Unit)
CCIHC_AY04EHS: Assignment Question Catalog - Agent Type
CCIHC_LOCPLANTEHS: Assignment Plant to Location
CCIHC_MPTYPETXTEHS: Language-Dependent Description for Project Type
CCIHT_ERAIEHS: Exposure Log - Additional Information
CCIHC_DETTYPEEHS: Determination Types
EHQMT_CODEEH&S-QM: Assignment of Phrases to Codes
CCIHC_REP_UNITSSARA Reporting: Specify Units and Measured Value Categories
CCIHC_IH07EHS: Exposure Rating
CCIHC_METHODEHS: Measurement Method
CCIHC_BUILDINGEHS: Building
TDG85Exceptions to DG Regulations: Assignment Profiles
TCG01Specification Value Assignment Category (System Table)
CCIHC_WA08EHS: Integration Objects - Language-Dependent Description
CCIHC_LOCATIONEHS: Location
CCIHC_MPTYPEEHS: Measurement Project Type
CCIHT_WAADEHS: Language-Dependent Description of Accident Location
CCIHT_ANNCEHS: Analysis Method - Standardized Criteria
TDG87Exceptions to DG Regulations: Assgmt Objects to Assgmt Prof.
CCIHC_IATYPETXTEHS: Type of I/A Log Entry -> Language-Dependent Texts
CCIHT_AM02EHS: Customer Analysis Method 02
CCIHC_IH03EHS: Exposure Value Assignment (Obsolete)
CCIHC_DETTYPETXTEHS: Language-Dependent Description for Determination Type
CCIHT_AM06EHS: Customer Analysis Method 06
CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions
LIPSDGAPDG: Appendix Table for LIPSDG
CCIHC_IH02EHS: Language-Dependent Desc. for Value Assignmt Type (IHS)
CCIHC_MPLEVELRPTEHS: Assignment Measurement Project Level - Report Category
CCIHC_WA11EHS: Authorization Groups for Work Areas
HSMC_BDAActivation of Extended Hazardous Substance Checks
CCIHC_AY05EHS: Assignment Risk to Rating
CCIHC_FATRMTTXTEHS: Type of Aid Given -> Language-Dependent Texts
EHQMT_CHARTYPETEH&S-QM: Descriptions of Types of Characteristics
CCIHC_AC09EHS: Safety Measure Category-Safety Measure Type Assignment
CCIHC_QT04EHS: Assignment Table Amount Category - Meas. Value Category
CCIHC_OBJEHS: Object Types for Industrial Hygiene and Safety
CCIHC_SVTXTEHS: Severity of Risk - Language-Dependent Description
CCIHT_AM01EHS: Customer Analysis Method 01
CCIHT_FALEHS: Injury/Illness Log
CCIHC_OC01EHS: Operation Status
LIPSDGAppendix Table for Dangerous Goods Data
CCIHT_ACHEHS: Safety Measures - Header
EHQMT_CHARTYPEEH&S-QM: Types of Characteristics
CCIHC_IPTYPEOBJEHS: Exclusion of Person's Role for Object Type
CCIHC_MSOURCETXTEHS: Language-Dependent Description for Sampling Locations
CCIHC_WA12EHS: Language-Dependent Name for Auth. Groups in Work Area
TCG96Usage profile
TDG86Exceptions to DG Regulations: Assgmt Profile Descriptions
THM072Risk Potential Description
CCIHC_IS01EHS: Assignment of Information Trees to IHS
DGMSDDG: Dangerous Goods Document Table DGMSD
TCG52Language-Dependent Description for Property Tree
TDGC5DG: Dangerous Goods Management Profile for SD Documents
CCIHC_IALPCATTXTEHS: Accident Category
DGTEXCTEXTSExceptions to DG Regulations: Texts and Documents
CCIHC_IHTYPE1EHS: Object Type - Object Subtype Assignment
CCIHC_IH10EHS: Categ. Exposure Rating - Language-Dependent Description
CCIHC_EPTYPE_FCEHS: Assignment of Functions to Agent Type
CCIHC_LT02EHS: Meas./Ref. Value Category - Language-Dependent Name
CCIHC_AY01EHS: Control Table for Analysis Methods
TCGL3Report Applications
CCIHC_REP_RANGESSpecify Intervals for Reports
CCIHC_TCG41EHS: User-Defined Text Type - Object Type Assignment
CVCBPBusiness process - valid business process IDs
CCIHC_AY02EHS: Analysis Methods - Language-Dependent Description
CCIHC_IHAWMEHS: Object Type - Object Subtype - Phrase Set Assignment
THM071DG: Risk Potential
CCIHC_IH04EHS: Exposure Value Assignment - Language-Dependent Name
DGTEXCCNTRIESExceptions to Dangerous Goods Regulations: Countries
CCIHC_IH01EHS: Value Assignment Types for Objects in IHS
TDGD1DG: Definition of a Regulation Profile
TDG101Dangerous Goods Packaging Status
EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation
TCG76Component category
CCIHC_IH06EHS: Exposure Rating Category
EHQMT_CODE2EH&S-QM: Assignment of Characteristic Values to Codes
TDG95DG: Define Level of Dangerous Goods Packaging
TDGD7DG: Assignment Indicator Category / Regulation Profile
TCG36Specification Authorization Object
CCIHC_RCNTYPENode Categories for Causes and Root Causes
CCIHC_IH08EHS: Description of Exposure Rating Category
TDGC6Text table for DG indicator profiles in the delivery header
TCG51Property Tree
TDG96DG: Text Table for Level of Dangerous Goods Packaging
CCIHC_MSOURCEEHS: Sampling Locations
CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data
CCIHC_IH05EHS: Assignment Display Field to Agent Characteristic
EHSBT_APPL_SCOPEGeneral Scope of Application
EHQMT_BASIC_DATAEH&S-QM: Basic Data for Inspection Plans
DGMS2DG: Dangerous Goods Document Table (Appendix Table)
CCIHC_QT02EHS: Exposure Amount Categ. - Language-Dependent Description
CCIHC_MPLEVELEHS: Assignment Level Measurement Project
CCIHC_LT01EHS: Measurement Value Category/Reference Value Category
EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation
TCG86Characteristic rating
CCIHC_RCNODETXTTexts for Causes and Root Causes
CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data
TCG02Description - Specification Value Assignment Category
CCIHC_IHTYPEEHS: Object Type - Object Subtype Assignment
VBEPDGAppendix Table for Dangerous Goods Data
TCG31Specification Type
CCIHC_QT05EHS: Assignment Table Agent Type/Amount Category