The CCIHT_ERRA table in SAP ERP or S/4HANA stores EHS: – Obsolete – Exposure Assignment – Risk Assessment data. There are total 23 fields in CCIHT_ERRA table. The EHS: – Obsolete – Exposure Assignment – Risk Assessment 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_ERRA 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_ERRA Table Fields
Following is the list of fields that are available in SAP CCIHT_ERRA table. The primary key fields of EHS: – Obsolete – Exposure Assignment – Risk Assessment table in SAP are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC (20) | |
| VALFR | Valid-From Date | ESEVALFR | DATS (8) | |
| VALTO | Valid-To Date | ESEVALTO | DATS (8) | |
| AENNR | Change Number | ESEAENNR | AENR | CHAR (12) |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR (1) | |
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR (1) | |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR (10) |
| OWNID | Data Provider | ESEVENDRID | * | CHAR (10) |
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| RISKASSETNUM | Sequential Number of Risk Assessment | CCIHE_RISKASSETNUM | NUMC (8) | |
| OPCOND | Operation Status of Work Area/Pattern | CCIHE_OPCOND | CCIHC_OC01 | CHAR (3) |
| RATINGCAT | Exposure Rating Category | CCIHE_RATINGCAT | CCIHC_IH06 | CHAR (3) |
| MAINRATING | Main Rating for Exposure | CCIHE_MAINRATING | CCIHC_IH07 | CHAR (3) |
| RAINVRESULT | Result of Risk Assessment | CCIHE_RAINVRESULT | CHAR (60) | |
| LTXTFLG | Long Text | ESELTXTFLG | CHAR (1) | |
| ASSCONTRVAL | Value Assignment After Check | CCIHE_ASSCONTRVAL | DEC (1) | |
| ASSCONTRDAT | Date of Rating After Check | CCIHE_ASSCONTRDAT | DATS (8) |
