CCIHT_FAL SAP table for – EHS: Injury/Illness Log

Here we would like to draw your attention to CCIHT_FAL 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_FAL is a SAP standard transp table used for storing EHS: Injury/Illness Log related data in SAP. It comes under the package CBIH.

SAP CCIHT_FAL table

Table CCIHT_FAL technical data

TableCCIHT_FAL
Data storingEHS: Injury/Illness Log
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_FAL 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_FAL 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
  • FAID : Injury/Illness Log Entry
    Its data type is CHAR (Character String) with field length 20
  • FATYPE : Injury/Illness Log Entry Type
    Its data type is CHAR (Character String) with field length 3
  • FAPLANT : Plant Assignment
    Its data type is CHAR (Character String) with field length 4
  • FASTATUS : Status
    Its data type is CHAR (Character String) with field length 5
  • FAINITSTATUS : Initial Status of an Object
    Its data type is CHAR (Character String) with field length 5
  • MTNLANGU : Language of Entry
    Its data type is LANG (Language key character with length 1) with field length 1
  • FALOC : Entry Location
    Its data type is CHAR (Character String) with field length 3
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • FATRANSFLG : Data Record Is for Transfer to Incident/Accident Log
    Its data type is CHAR (Character String) with field length 1
  • FATRANSDEC : Transfer decision injury/illness log – incident/accident log
    Its data type is CHAR (Character String) with field length 1
  • RECNTIA : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • TRANSDAT : Date of Data Transfer Injury/Illness Log to Inc./Acc. Log
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TRANSTIME : Time of Data Transfer Injury/Illness Log to Inc./Acc. Log
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TRANSNAM : Administrator Data Transfer Injury/Illness Log to I/A Log
    Its data type is CHAR (Character String) with field length 12
  • FATALFLG : Fatality
    Its data type is CHAR (Character String) with field length 1
  • FAFIRSTRFLG : Initial Treatment After Event
    Its data type is CHAR (Character String) with field length 1
  • FADAT : Date When Aid Was Given
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FATIME : Time and Date of Aid Given
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • FAHELPER : First-Aider
    Its data type is CHAR (Character String) with field length 10
  • FAHELPERFLG : First-Aider (External)
    Its data type is CHAR (Character String) with field length 1
  • FATRTOHC : Transport to First Aid Center By
    Its data type is CHAR (Character String) with field length 21
  • FATRFRHC : Means of Further Transport from Health Center
    Its data type is CHAR (Character String) with field length 21
  • .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
  • .INCLUDE : EHS: Event Data for Person Affected
  • FRTRMT : Further Treatment
    Its data type is CHAR (Character String) with field length 10
  • FRTRMTFLG : Physician Giving Further Treatment (Internal/External)
    Its data type is CHAR (Character String) with field length 1
  • INTNOTE : Commentary for internal use
    Its data type is CHAR (Character String) with field length 72
  • INTNOTEFLG : Long Text Available for an Internal Note
    Its data type is CHAR (Character String) with field length 1
  • EXTNOTE : Information for External Purposes
    Its data type is CHAR (Character String) with field length 72
  • EXTNOTEFLG : Long Text Available on External Note
    Its data type is CHAR (Character String) with field length 1
  • FRTRMTGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : EHS: Absence Person Affected (Event Data)
  • OFFJOBDAT : Date of Ceasing to Work
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OFFJOBTIME : Time of Ceasing to Work
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • IPABSSUBTYPE : Absence Type
    Its data type is CHAR (Character String) with field length 4
  • IPABSBEGDAT : Start Date of Absence
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IPABSENDDAT : End Date of Absence
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IPABSSEQNUM : Number of Infotype Record With Same Key
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • IPABSESTDAYS : Estimated Duration of Absence (in Days)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • IPABSDAYS : Number of Workdays Absent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • IPABSCALDAYS : Calendar Days
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • IPRSWBEGDAT : Start of Restriction or Date of Job Transfer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IPRSWENDDAT : End Date of Restriction or Job Transfer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IPRSWDAYS : Number of Workdays with Restriction or Job Transfer
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • IPRSWCALDAYS : Calendar Days with Restriction or Job Transfer
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • FAHELPERGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • FATIMEZONE : Valid Time Zone
    Its data type is CHAR (Character String) with field length 6
  • EVTIMEZONE : Valid Time Zone
    Its data type is CHAR (Character String) with field length 6
  • OFFJOBTIMEZONE : Valid Time Zone
    Its data type is CHAR (Character String) with field length 6
  • IAREPORTFLG : Reportable Accident
    Its data type is CHAR (Character String) with field length 1
  • PRIVCONCFLG : Privacy Concern Case
    Its data type is CHAR (Character String) with field length 1
  • EMERGRMFLG : Treatment in Emergency Room
    Its data type is CHAR (Character String) with field length 1
  • INPATFLG : Treatment Overnight As Inpatient
    Its data type is CHAR (Character String) with field length 1
  • IPDEATHDATE : Date of Death of Person Affected
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNCONSCIOUS : Person Unconscious
    Its data type is CHAR (Character String) with field length 1
  • RESUSCITATION : Resuscitation Performed
    Its data type is CHAR (Character String) with field length 1
  • HOSPITALIZATION : Hospitalization for over 24 Hours
    Its data type is CHAR (Character String) with field length 1