The CCIHT_MPPL table in SAP ERP or S/4HANA stores EHS: Project Plan data. There are total 31 fields in CCIHT_MPPL table. The EHS: Project Plan 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_MPPL 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_MPPL Table Fields
Following is the list of fields that are available in SAP CCIHT_MPPL table. The primary key fields of EHS: Project Plan 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) | |
| RECNTMPWA | Reference to Assigned Work Area | CCIHE_RECNTMPWA | NUMC (20) | |
| MPPLFLG | Agent Is to Be Measured | CCIHE_MPPLFLG | CHAR (1) | |
| EPTYPE | Agent Type | CCIHE_EPTYPE | * | CHAR (10) |
| EPID | Agent | CCIHE_EPID | CHAR (20) | |
| REFEPTYPE | Reference Agent Type | CCIHE_REFEPTYPE | * | CHAR (10) |
| REFEPID | Reference Agent | CCIHE_REFEPID | CHAR (20) | |
| DETTYPE | Determination Type | CCIHE_DETTYPE | CCIHC_DETTYPE | CHAR (3) |
| MPPLNUM1 | **Obsolete** | CCIHE_MPPLNUMB | NUMC (2) | |
| MPPLNUM2 | **Obsolete** | CCIHE_MPPLNUMB | NUMC (2) | |
| MPPLNOTE | Remarks on Measurement Plan | CCIHE_MPPLNOTE | CHAR (72) | |
| MPPLNOTEFLG | Long Text | ESELTXTFLG | CHAR (1) | |
| METHOD | Measurement Method | CCIHE_METHOD | CCIHC_METHOD | CHAR (5) |
| MJCAT | Sampling Type | CCIHE_MJCAT | CCIHC_MJCAT | CHAR (3) |
| OPCOND | Operation Status of Work Area/Pattern | CCIHE_OPCOND | CCIHC_OC01 | CHAR (3) |
| QTTYPE | Amount Category | CCIHE_EPQUANTTYPE | CCIHC_QT01 | CHAR (3) |
| LTTYPE | Measured Value/Reference Value Category | CCIHE_LTTYPE | * | CHAR (3) |
