1. Home
  2. Resources
  3. SAP Tables
  4. CCIHT_FAL - EHS: Injury/Illness Log

SAP Table CCIHT_FAL

EHS: Injury/Illness Log

CCIHT_FAL (EHS: Injury/Illness Log) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CCIHT_FAL to other SAP tables.

CCIHT_FAL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
VALFR Valid-From Date ESEVALFR DATS 8 0
VALTO Valid-To Date ESEVALTO DATS 8 0
AENNR Change Number ESEAENNR AENR CHAR 12 0
DELFLG Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CRDAT Created On ESECRDAT DATS 8 0
CRNAM Created By ESECRNAM CHAR 12 0
UPDDAT Changed On ESEUPDDAT DATS 8 0
UPDNAM Last Changed By ESEUPDNAM CHAR 12 0
SRSID Source of Data ESESRSID TCG56 CHAR 10 0
OWNID Data Provider ESEVENDRID CHAR 10 0
RECNROOT Sequential Number of Data Record ESERECN NUMC 20 0
FAID Injury/Illness Log Entry CCIHE_FAID CHAR 20 0
FATYPE Injury/Illness Log Entry Type CCIHE_FATYPE CCIHC_FATYPE CHAR 3 0
FAPLANT Plant Assignment CCIHE_FAPLANT T001W CHAR 4 0
FASTATUS Status EHSBE_STATUS CHAR 5 0
FAINITSTATUS Initial Status of an Object CCIHE_INITSTATUS CHAR 5 0
MTNLANGU Language of Entry CCIHE_MTNLANGU T002 LANG 1 0
FALOC Entry Location CCIHE_FALOC CCIHC_FALOC CHAR 3 0
OBJNR Object number J_OBJNR CHAR 22 0
FATRANSFLG Data Record Is for Transfer to Incident/Accident Log CCIHE_FATRANSFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FATRANSDEC Transfer decision injury/illness log - incident/accident log CCIHE_FATRANSDEC CHAR 1 0
NULL Not specified
Y Yes
N No
RECNTIA Sequential Number of Data Record ESERECN NUMC 20 0
TRANSDAT Date of Data Transfer Injury/Illness Log to Inc./Acc. Log CCIHE_TRANSDAT DATS 8 0
TRANSTIME Time of Data Transfer Injury/Illness Log to Inc./Acc. Log CCIHE_TRANSTIME TIMS 6 0
TRANSNAM Administrator Data Transfer Injury/Illness Log to I/A Log CCIHE_TRANSNAM CHAR 12 0
FATALFLG Fatality CCIHE_FATALFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FAFIRSTRFLG Initial Treatment After Event CCIHE_FAFIRSTRFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FADAT Date When Aid Was Given CCIHE_FADAT DATS 8 0
FATIME Time and Date of Aid Given CCIHE_FATIME TIMS 6 0
FAHELPER First-Aider CCIHE_FAHELPER CHAR 10 0
FAHELPERFLG First-Aider (External) CCIHE_FAHELPERFLG CHAR 1 0
FATRTOHC Transport to First Aid Center By CCIHE_FATRTOHC CHAR 21 0
FATRFRHC Means of Further Transport from Health Center CCIHE_FATRFRHC CHAR 21 0
EVDAT Event Date CCIHE_EVDAT DATS 8 0
EVTIME Event Time CCIHE_EVTIME TIMS 6 0
RECNTWAH Reference to Work Area CCIHE_RECNTWAH NUMC 20 0
ACLOC Accident Location CCIHE_ACLOC CHAR 10 0
ACLOCDESC Description of Accident Location CCIHE_ACLOCDESC CHAR 60 0
FRTRMT Further Treatment CCIHE_FRTRMT CHAR 10 0
FRTRMTFLG Physician Giving Further Treatment (Internal/External) CCIHE_FRTRMTFLG CHAR 1 0
INTNOTE Commentary for internal use CCIHE_INTNOTELXT CHAR 72 0
INTNOTEFLG Long Text Available for an Internal Note CCIHE_INTNOTEFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EXTNOTE Information for External Purposes CCIHE_EXTNOTELXT CHAR 72 0
EXTNOTEFLG Long Text Available on External Note CCIHE_EXTNOTEFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
FRTRMTGRP Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
OFFJOBDAT Date of Ceasing to Work CCIHE_OFFJOBDAT DATS 8 0
OFFJOBTIME Time of Ceasing to Work CCIHE_OFFJOBTIME TIMS 6 0
IPABSSUBTYPE Absence Type CCIHE_IPABSSUBTYPE CHAR 4 0
IPABSBEGDAT Start Date of Absence CCIHE_IPABSBEGDAT DATS 8 0
IPABSENDDAT End Date of Absence CCIHE_IPABSENDDAT DATS 8 0
IPABSSEQNUM Number of Infotype Record with Same Key SEQNR NUMC 3 0
IPABSESTDAYS Estimated Duration of Absence (in Days) CCIHE_IPABSESTDAYS DEC 6 2
IPABSDAYS Number of Workdays Absent CCIHE_IPABSDAYS DEC 6 2
IPABSCALDAYS Calendar Days CCIHE_IPABSCALDAYS DEC 8 2
IPRSWBEGDAT Start of Restriction or Date of Job Transfer CCIHE_IPRSWBEGDAT DATS 8 0
IPRSWENDDAT End Date of Restriction or Job Transfer CCIHE_IPRSWENDDAT DATS 8 0
IPRSWDAYS Number of Workdays with Restriction or Job Transfer CCIHE_IPRSWDAYS DEC 6 2
IPRSWCALDAYS Calendar Days with Restriction or Job Transfer CCIHE_IPRSWCALDAYS DEC 8 2
FAHELPERGRP Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
FATIMEZONE Valid Time Zone CCIHE_TIMEZONE TTZZ CHAR 6 0
EVTIMEZONE Valid Time Zone CCIHE_TIMEZONE TTZZ CHAR 6 0
OFFJOBTIMEZONE Valid Time Zone CCIHE_TIMEZONE TTZZ CHAR 6 0
IAREPORTFLG Reportable Accident CCIHE_IAREPORTFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PRIVCONCFLG Privacy Concern Case CCIHE_PRIVCONCFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
EMERGRMFLG Treatment in Emergency Room CCIHE_EMERGRMFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
INPATFLG Treatment Overnight As Inpatient CCIHE_INPATFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
IPDEATHDATE Date of Death of Person Affected CCIHE_IPDEATHDATE DATS 8 0
UNCONSCIOUS Person Unconscious CCIHE_UNCONSCIOUS CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
RESUSCITATION Resuscitation Performed CCIHE_RESUSCITATION CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
HOSPITALIZATION Hospitalization for over 24 Hours CCIHE_HOSPITALIZATION CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive

CCIHT_FAL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CCIHT_FAL AENNR CCIHT_FAL AENNR AENR Change Master AENNR
CCIHT_FAL AENNR SY MANDT AENR Change Master MANDT
CCIHT_FAL EVTIMEZONE * TTZZ Time zones CLIENT
CCIHT_FAL EVTIMEZONE CCIHT_FAL EVTIMEZONE TTZZ Time zones TZONE
CCIHT_FAL FALOC CCIHT_FAL MANDT CCIHC_FALOC EHS: Entry Location MANDT
CCIHT_FAL FALOC CCIHT_FAL FALOC CCIHC_FALOC EHS: Entry Location FALOC
CCIHT_FAL FAPLANT CCIHT_FAL MANDT T001W Plants/Branches MANDT
CCIHT_FAL FAPLANT CCIHT_FAL FAPLANT T001W Plants/Branches WERKS
CCIHT_FAL FATIMEZONE * TTZZ Time zones CLIENT
CCIHT_FAL FATIMEZONE CCIHT_FAL FATIMEZONE TTZZ Time zones TZONE
CCIHT_FAL FATYPE CCIHT_FAL MANDT CCIHC_FATYPE EHS: Category of Injury/Illness Log Entry MANDT
CCIHT_FAL FATYPE CCIHT_FAL FATYPE CCIHC_FATYPE EHS: Category of Injury/Illness Log Entry FATYPE
CCIHT_FAL MANDT CCIHT_FAL MANDT T000 Clients MANDT
CCIHT_FAL MTNLANGU CCIHT_FAL MTNLANGU T002 Language Keys (Component BC-I18) SPRAS
CCIHT_FAL OFFJOBTIMEZONE CCIHT_FAL OFFJOBTIMEZONE TTZZ Time zones TZONE
CCIHT_FAL OFFJOBTIMEZONE * TTZZ Time zones CLIENT
CCIHT_FAL SRSID * TCG56 EHS: Data Origin MANDT
CCIHT_FAL SRSID CCIHT_FAL SRSID TCG56 EHS: Data Origin SRSID