The CCIHT_IHVA table in SAP ERP or S/4HANA stores EHS: Value Assignment Data Records for Classific. System data. There are total 18 fields in CCIHT_IHVA table. The EHS: Value Assignment Data Records for Classific. System 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_IHVA 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_IHVA Table Fields
Following is the list of fields that are available in SAP CCIHT_IHVA table. The primary key fields of EHS: Value Assignment Data Records for Classific. System 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) | |
| RECNTOBJ | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| REFOBJ | Reference Object | CCIHE_IHREFOBJ | * | CHAR (3) |
| IHVALCAT | Value Assignment Type for Objects in IHS | CCIHE_IHVALCAT | TCG11 | CHAR (30) |
