The CCIHT_MJIMPORT table in SAP ERP or S/4HANA stores EHS: Pooled Table for Imported Measurements data. There are total 68 fields in CCIHT_MJIMPORT table. The EHS: Pooled Table for Imported Measurements 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_MJIMPORT 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_MJIMPORT Table Fields
Following is the list of fields that are available in SAP CCIHT_MJIMPORT table. The primary key fields of EHS: Pooled Table for Imported Measurements 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) | |
| OBJNR | Object number | J_OBJNR | * | CHAR (22) |
| MJID | Measurement Number | CCIHE_MJID | CHAR (30) | |
| MJCAT | Sampling Type | CCIHE_MJCAT | CCIHC_MJCAT | CHAR (3) |
| MJSTAT | Status | EHSBE_STATUS | CHAR (5) | |
| EPTYPE | Agent Type | CCIHE_EPTYPE | * | CHAR (10) |
| EPID | Agent | CCIHE_EPID | CHAR (20) | |
| RECNTMPWA | Reference to Assigned Work Area | CCIHE_RECNTMPWA | NUMC (20) | |
| MJVALFR | Start of Validity of Measurement | CCIHE_MJVALFR | DATS (8) | |
| MJVALTO | End of Validity of Measurement | CCIHE_MJVALTO | DATS (8) | |
| 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) | |
| MDURATION | Actual Duration of Measurement | CCIHE_MDURATION | TIMS (6) | |
| MPLDURATION | Planned Measurement Duration | CCIHE_MPLDURATION | TIMS (6) | |
| MEXCHANGE | Perform Conversion | CCIHE_MEXCHANGE | CHAR (1) | |
| MSOURCEID | Sampling Location | CCIHE_MSOURCEID | CCIHC_MSOURCE | CHAR (3) |
| MSOURCENOTE | Description for Sampling Location | CCIHE_MSOURCENOTE | CHAR (255) | |
| FIXLOCFLG | Fixed-Location Measurement | CCIHE_FIXLOCFLG | CHAR (1) | |
| MPERIOD | Repetition of Measurement in Months | CCIHE_MPERIOD | NUMC (2) | |
| FLOW | Flow Quantity of Measuring Device | CCIHE_FLOW | DEC (5) | |
| FLOWUNIT | Flow Unit | CCIHE_FLOWUNIT | * | UNIT (3) |
| DVNR | Number of the Measuring Device | CCIHE_DVNR | CHAR (20) | |
| MDEVTYPE | Measuring Device Type | CCIHE_DVTYPE | CCIHC_DVTYPE | CHAR (3) |
| METHOD | Measurement Method | CCIHE_METHOD | CCIHC_METHOD | CHAR (5) |
| MPERSON | Test Person | CCIHE_MJPERSON | CHAR (10) | |
| MPERSONGRP | Person Group | CCIHE_PERSGRP | CHAR (1) | |
| MPERSONNAME | Full Name of Person | CCIHE_FULLNAME | CHAR (80) | |
| MJNOTE1 | Remarks on Measurement | CCIHE_MJNOTE | CHAR (72) | |
| MJNOTEFLG1 | Long Text | ESELTXTFLG | CHAR (1) | |
| MJNOTE2 | Remarks on Measurement | CCIHE_MJNOTE | CHAR (72) | |
| MJNOTEFLG2 | Long Text | ESELTXTFLG | CHAR (1) | |
| RESPIRATOR | Respiratory Protection | CCIHE_RESPIRATOR | CHAR (1) | |
| SAMPLENR | Container or Filter | CCIHE_SAMPLENR | CHAR (30) | |
| MJCOSTAC | Cost Center for Measurement Project | CCIHE_MPCOSTAC | * | CHAR (10) |
| MJCTRAREA | Controlling Area | CCIHE_MPCTRAREA | TKA01 | CHAR (4) |
| RECNTMJ | Reference to Partial Measurement | CCIHE_RECNTREFMJ | NUMC (20) | |
| LIMEXCEEDFLG | Reference Value Exceeded | CCIHE_LIMEXCEEDFLG | CHAR (1) | |
| STMFLG | Short-Term Sample | CCIHE_STMFLG | CHAR (1) | |
| METCOASTS | Cost of Analysis | CCIHE_MCOSTS | CURR (10) | |
| METCUKY | Currency Key for Costs | CCIHE_METCUKY | * | CUKY (5) |
| VOLUME | Total Volume in Liters | CCIHE_VOLUME | FLTP (16) | |
| VOLDECIMALS | Decimal Places for a Measured Physical Variable Value | CCIHE_HQVALDECIMALS | INT4 (10) | |
| MJCOCODE | Company Code | CCIHE_MPCOCODE | * | CHAR (4) |
| FLGEXPLOCK | Object Is in Export | CCIHE_FLGEXPLCK | CHAR (1) | |
| OPCOND | Operation Status of Work Area/Pattern | CCIHE_OPCOND | CCIHC_OC01 | CHAR (3) |
| IMP_DATE | Date of Import | CCIHE_IMPDATE | DATS (8) | |
| IMP_TIME | Time of Import | CCIHE_IMPTIME | TIMS (6) | |
| UNAME | User Name | SYUNAME | CHAR (12) | |
| ERRORMODE | Indicator: Error or warning in an API function | ESEERRMODE | CHAR (1) | |
| ERRORINFO | Count parameters | NUMC4 | NUMC (4) | |
| ERRORCLASS | Message Class | SYMSGID | * | CHAR (20) |
| ERRORPARAM | 30 Characters | CHAR30 | CHAR (30) |
