CCIHT_IAL SAP table for – EHS: Incident/Accident Log – Header

Here we would like to draw your attention to CCIHT_IAL 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_IAL is a SAP standard transp table used for storing EHS: Incident/Accident Log – Header related data in SAP. It comes under the package CBIH.

SAP CCIHT_IAL table

Table CCIHT_IAL technical data

TableCCIHT_IAL
Data storingEHS: Incident/Accident Log – Header
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_IAL 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_IAL 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
  • IALID : Incident/Accident Log Entry
    Its data type is CHAR (Character String) with field length 20
  • IATYPE : Incident/Accident Log Entry Type
    Its data type is CHAR (Character String) with field length 3
  • IAPLANT : Plant Assignment for the Log Entry
    Its data type is CHAR (Character String) with field length 4
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • IASTATUS : Status
    Its data type is CHAR (Character String) with field length 5
  • EVDESC : Event Description
    Its data type is CHAR (Character String) with field length 60
  • DMTYPE : Type of Damage
    Its data type is CHAR (Character String) with field length 21
  • TPLNR : Functional Location
    Its data type is CHAR (Character String) with field length 30
  • EQUNR : Equipment Number
    Its data type is CHAR (Character String) with field length 18
  • EQDESC : Description of Machine
    Its data type is CHAR (Character String) with field length 80
  • FATALFLG : Fatality
    Its data type is CHAR (Character String) with field length 1
  • CNTRFLG : Contractor Affected
    Its data type is CHAR (Character String) with field length 1
  • INVRESULT : Investigation Result
    Its data type is CHAR (Character String) with field length 60
  • INVRESULTFLG : Indicator for SAPscript Text
    Its data type is CHAR (Character String) with field length 1
  • PMFLG : Maintenance Required
    Its data type is CHAR (Character String) with field length 1
  • PRODLFLG : Production Time Lost
    Its data type is CHAR (Character String) with field length 1
  • MTNLANGU : Language of Entry
    Its data type is LANG (Language key character with length 1) with field length 1
  • .INCLUDE : EHS: Event Data
  • EVDAT : Event Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EVTIME : Event Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RECNTWAH : Reference to Work Area
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACLOC : Accident Location
    Its data type is CHAR (Character String) with field length 10
  • ACLOCDESC : Description of Accident Location
    Its data type is CHAR (Character String) with field length 60
  • EVTIMEZONE : Valid Time Zone
    Its data type is CHAR (Character String) with field length 6
  • IAREPHDFLG : Reportable Event
    Its data type is CHAR (Character String) with field length 1
  • FLPLANT : Functional Location Plant
    Its data type is CHAR (Character String) with field length 4