The CCIHT_ANQS table in SAP ERP or S/4HANA stores EHS: Analysis Method Questionnaire data. There are total 20 fields in CCIHT_ANQS table. The EHS: Analysis Method Questionnaire 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_ANQS 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_ANQS Table Fields
Following is the list of fields that are available in SAP CCIHT_ANQS table. The primary key fields of EHS: Analysis Method Questionnaire 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) | |
| RECNTRA | Reference to Risk Assessment | CCIHE_RECNTRA | NUMC (20) | |
| RECNTWAQS | Reference to the Assignment Work Area to Spec. Questionnaire | CCIHE_RECNTWAQS | NUMC (20) | |
| SETNUMBER | Number of Data Record | CCIHE_SETNUMBER | NUMC (8) | |
| RATINGCAT | Exposure Rating Category | CCIHE_RATINGCAT | CCIHC_IH06 | CHAR (3) |
| RATING | Exposure Rating | CCIHE_RATING | CCIHC_IH07 | CHAR (3) |
