The CCIHT_ANML table in SAP ERP or S/4HANA stores EHS: Analysis Method – Meas. Value – Ref. Value Comparison data. There are total 49 fields in CCIHT_ANML table. The EHS: Analysis Method – Meas. Value – Ref. Value Comparison 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_ANML 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_ANML Table Fields
Following is the list of fields that are available in SAP CCIHT_ANML table. The primary key fields of EHS: Analysis Method – Meas. Value – Ref. Value Comparison 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) | |
| EPQUANTTYPE | Amount Category | CCIHE_EPQUANTTYPE | CCIHC_QT01 | CHAR (3) |
| LTTYPE | Measured Value/Reference Value Category | CCIHE_LTTYPE | * | CHAR (3) |
| EPQUANTSET | Measurement Number | CCIHE_EPQUANTSET | NUMC (8) | |
| EPQUANTVAL | Measurement Value of Physical Variable | CCIHE_EPQUANTVAL | DEC (10) | |
| HQVALFLOAT | Measured Physical Variable Value (FLOAT) | CCIHE_HQVALFLOAT | FLTP (16) | |
| HQVALDECIMALS | Decimal Places for a Measured Physical Variable Value | CCIHE_HQVALDECIMALS | INT4 (10) | |
| EPQUNIT | Unit of Measurement for Exposure Amount | CCIHE_EPQUANTUNIT | * | UNIT (3) |
| MSRBGNDATE | Date of Start of Measurement | CCIHE_MSRBGNDATE | DATS (8) | |
| MSRBGNTIME | Time of Start of Measurement | CCIHE_MSRBGNTIME | TIMS (6) | |
| MSRENDDATE | Date of End of Measurement | CCIHE_MSRENDDATE | DATS (8) | |
| MSRENDTIME | Time of End of Measurement | CCIHE_MSRENDTIME | TIMS (6) | |
| MSRNAM | Person Acting or Responsible | CCIHE_MSRNAM | CHAR (12) | |
| MSRNAMFLG | External Person | CCIHE_IPPFLAG | CHAR (1) | |
| MSRORDNR | Measurement Job Number | CCIHE_MSRORDNR | CHAR (20) | |
| MSRDESC | Description of Measurement | CCIHE_MSRDESC | CHAR (132) | |
| MSRDESCFLG | Indicator for SAPscript Text | CCIHE_MSRDESCFLG | CHAR (1) | |
| MSRPROCEDURE | Measurement Method | CCIHE_MSRPROCEDURE | CHAR (21) | |
| MSRSTAT | Status | EHSBE_STATUS | CHAR (5) | |
| MSRINITSTAT | Initial Status of an Object | CCIHE_INITSTATUS | CHAR (5) | |
| OBJNR | Object number | J_OBJNR | * | CHAR (22) |
| MSRNAMGRP | Person Group | CCIHE_PERSGRP | CHAR (1) | |
| RECNTMJ | Reference to Measurement | CCIHE_RECNTMJ | NUMC (20) | |
| RECNTMP | Reference to Measurement Project | CCIHE_RECNTMP | NUMC (20) | |
| PROBANDGRP | Person Group | CCIHE_PERSGRP | CHAR (1) | |
| PROBAND | Test Person | CCIHE_MJPERSON | CHAR (10) | |
| RECNTRA | Reference to Risk Assessment | CCIHE_RECNTRA | NUMC (20) | |
| RECNTQT | Reference to Measured Value | CCIHE_RECNTQT | 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) |
| HAZLIMFLOAT | Floating-Point Value of Exposure Reference Value | CCIHE_HAZLIMFLOAT | FLTP (16) | |
| HAZLIMUNIT | Exposure Reference Value Unit | CCIHE_HAZLIMUNIT | UNIT (3) | |
| HAZLIMDEC | Number of Decimal Places of a Reference Value | CCIHE_HAZLIMITDECIMALS | INT4 (10) | |
| RATREASON | Reason for a Rating | CCIHE_RATREASON | CHAR (21) |
