The CCIHT_IAREP table in SAP ERP or S/4HANA stores EHS: Period-Based Accident Reports data. There are total 22 fields in CCIHT_IAREP table. The EHS: Period-Based Accident Reports table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CCIHT_IAREP table. It is in EH&S: Industrial Hygiene and Safety (CBIH) ABAP package and is part of the Environment, Health and Safety (EHS) module.
SAP CCIHT_IAREP Table Fields
Following is the list of fields that are available in SAP CCIHT_IAREP table. The primary key fields of EHS: Period-Based Accident Reports table in SAP are MANDT (Client), EVMONTHYEAR (Period to analyze – month), IAPLANT (Plant Assignment for the Log Entry), RECNTWAH (Reference to Work Area), WERKS (Personnel Area), BTRTL (Personnel Subarea).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| EVMONTHYEAR | Period to analyze – month | SPMON | NUMC (6) | |
| IAPLANT | Plant Assignment for the Log Entry | CCIHE_IAPLANT | T001W | CHAR (4) |
| RECNTWAH | Reference to Work Area | CCIHE_RECNTWAH | NUMC (20) | |
| WERKS | Personnel Area | PERSA | T500P | CHAR (4) |
| BTRTL | Personnel Subarea | BTRTL | T001P | CHAR (4) |
| MOLGA | Country Grouping | MOLGA | * | CHAR (2) |
| NUMDEAD | Total Number of Deaths | CCIHE_NUMDEAD | DEC (8) | |
| NUMABS | Total Number of Cases with Days Away from Work | CCIHE_NUMABS | DEC (8) | |
| NUMRSW | Number of Cases with Restriction or Job Transfer | CCIHE_NUMRSW | DEC (8) | |
| NUMOTHRECDBL | Number of Other Reportable Cases | CCIHE_NUMOTHRECDBL | DEC (8) | |
| SUMRSWDAYS | Total Number of Days of Restriction or Job Transfer | CCIHE_SUMRSWDAYS | DEC (11) | |
| SUMABSDAYS | Total Number of Days Away from Work | CCIHE_SUMABSDAYS | DEC (11) | |
| NUMINJURY | Total Number of Cases with Injuries | CCIHE_NUMINJURY | DEC (8) | |
| NUMDISMSCSKL | Number of Cases with Musculoskeletal Disorders | CCIHE_NUMDISMSCSKL | DEC (8) | |
| NUMDISSKIN | Number of Cases with Skin Disorders | CCIHE_NUMDISSKIN | DEC (8) | |
| NUMDISRESP | Number of Cases with Respiratory Conditions | CCIHE_NUMDISRESP | DEC (8) | |
| NUMDISPOIS | Number of Cases with Poisonings | CCIHE_NUMDISPOIS | DEC (8) | |
| NUMDISHEAR | Number of Cases with Hearing Loss | CCIHE_NUMDISHEAR | DEC (8) | |
| NUMDISOTHERS | Number of Cases with Other Illnesses | CCIHE_NUMDISOTH | DEC (8) | |
| EMPLAVER | Average Number of Employees | CCIHE_EMPLAVER | DEC (11) | |
| SUMWTHOURS | Total Number of Working Hours | CCIHE_SUMWTHOURS | DEC (11) |
