CCIHT_ERH SAP table for – EHS: Risk Assessment – Header

Here we would like to draw your attention to CCIHT_ERH table in SAP. As we know it is being mainly used with the SAP EHS-IHS (Industrial Hygiene and Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). CCIHT_ERH is a SAP standard transp table used for storing EHS: Risk Assessment – Header related data in SAP. It comes under the package CBIH.

SAP CCIHT_ERH table

Table CCIHT_ERH technical data

TableCCIHT_ERH
Data storingEHS: Risk Assessment – Header
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_ERH Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CCIHT_ERH table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for General Administration Information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • RECNTWAH : Reference to Work Area
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • EPTYPE : Agent Type
    Its data type is CHAR (Character String) with field length 10
  • EPID : Agent
    Its data type is CHAR (Character String) with field length 20
  • ERSTATUS : Status
    Its data type is CHAR (Character String) with field length 5
  • ERINITSTATUS : Initial Status of an Object
    Its data type is CHAR (Character String) with field length 5
  • REM : Note
    Its data type is CHAR (Character String) with field length 60
  • RISKASSETNUM : Sequential Number of Risk Assessment
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • OPCOND : Operation Status of Work Area/Pattern
    Its data type is CHAR (Character String) with field length 3
  • RATINGCAT : Exposure Rating Category
    Its data type is CHAR (Character String) with field length 3
  • MAINRATING : Main Rating for Exposure
    Its data type is CHAR (Character String) with field length 3
  • RAINVRESULT : Result of Risk Assessment
    Its data type is CHAR (Character String) with field length 60
  • LTXTFLG : Long Text
    Its data type is CHAR (Character String) with field length 1
  • ASSCONTRVAL : Value Assignment After Check
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 1
  • ASSCONTRDAT : Date of Rating After Check
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASSCTRPER : Person Responsible for Checking Risk Assessment
    Its data type is CHAR (Character String) with field length 10
  • ASSCTRPEREXFLG : Internal/External Person
    Its data type is CHAR (Character String) with field length 1
  • ASSCTRPERGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • RAR : Reason for Risk Assessment
    Its data type is CHAR (Character String) with field length 3
  • NEXTRADAT : Date of Next Risk Assessment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEVERE : Severity of Risk
    Its data type is CHAR (Character String) with field length 3
  • PROBLTY : Probability of Risk
    Its data type is CHAR (Character String) with field length 3
  • SOID : Source Object Identifier
    Its data type is CHAR (Character String) with field length 40
  • SOTYPE : Source Object Type
    Its data type is CHAR (Character String) with field length 20
  • SOPART : Part of Source Object
    Its data type is CHAR (Character String) with field length 20
  • SOTXT : Source Object Text
    Its data type is CHAR (Character String) with field length 120
  • PLANBEGDAT : Planned Risk Assessment Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PLANENDDAT : Planned Risk Assessment End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTBEGDAT : Actual Risk Assessment End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTENDDAT : Actual Risk Assessment End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • QUALPROTECT : Quality of Protection Level
    Its data type is CHAR (Character String) with field length 3
  • CHKRATING : Rating After Check
    Its data type is CHAR (Character String) with field length 3