SAP ABAP Table CCIHT_MPPL (EHS: Project Plan)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CCIHT_MPPL	Table Relationship Diagram
Short Description	EHS: Project Plan

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	RECNTMPWA	☐	CCIHE_RECNTMPWA	ESDRECN	NUMC	20	0	Reference to Assigned Work Area
19	MPPLFLG	☐	CCIHE_MPPLFLG	ESDFLAG	CHAR	1	0	Agent Is to Be Measured
20	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
21	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
22	REFEPTYPE	☐	CCIHE_REFEPTYPE	ESDSUBCAT	CHAR	10	0	Reference Agent Type	CCIHV_HAZTYPE
23	REFEPID	☐	CCIHE_REFEPID	CCIHD_EPID	CHAR	20	0	Reference Agent
24	DETTYPE	☐	CCIHE_DETTYPE	CCIHD_DETTYPE	CHAR	3	0	Determination Type	CCIHC_DETTYPE
25	MPPLNUM1	☐	CCIHE_MPPLNUMB	CCIHD_MPPLNUM	NUMC	2	0	**Obsolete**
26	MPPLNUM2	☐	CCIHE_MPPLNUMB	CCIHD_MPPLNUM	NUMC	2	0	**Obsolete**
27	MPPLNOTE	☐	CCIHE_MPPLNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measurement Plan
28	MPPLNOTEFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
29	METHOD	☐	CCIHE_METHOD	CCIHD_METHOD	CHAR	5	0	Measurement Method	CCIHC_METHOD
30	MJCAT	☐	CCIHE_MJCAT	CCIHD_MJCAT	CHAR	3	0	Sampling Type	CCIHC_MJCAT
31	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
32	QTTYPE	☐	CCIHE_EPQUANTTYPE	CCIHD_EPQUANTTYP	CHAR	3	0	Amount Category	CCIHC_QT01
33	LTTYPE	☐	CCIHE_LTTYPE	CCIHD_LTTYPE	CHAR	3	0	Measured Value/Reference Value Category	CCIHV_LT01

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHT_MPPL	AENNR	AENR	AENNR	REF	1	CN
2	CCIHT_MPPL	DETTYPE	CCIHC_DETTYPE	DETTYPE
3	CCIHT_MPPL	EPTYPE	CCIHV_HAZTYPE	SUBCAT
4	CCIHT_MPPL	LTTYPE	CCIHV_LT01	LTTYPE	REF	1	CN
5	CCIHT_MPPL	MANDT	T000	MANDT
6	CCIHT_MPPL	METHOD	CCIHC_METHOD	METHOD
7	CCIHT_MPPL	MJCAT	CCIHC_MJCAT	MJCAT
8	CCIHT_MPPL	OPCOND	CCIHC_OC01	OPCOND	REF	1	CN
9	CCIHT_MPPL	QTTYPE	CCIHC_QT01	EPQUANTTYPE
10	CCIHT_MPPL	REFEPTYPE	CCIHV_HAZTYPE	SUBCAT
11	CCIHT_MPPL	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in