SAP ABAP Table CCIHT_MJIMPORT (EHS: Pooled Table for Imported Measurements)

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_MJIMPORT	Table Relationship Diagram
Short Description	EHS: Pooled Table for Imported Measurements

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	.INCLUDE	☐				0	0	EHS: Structure for Measurements
19	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
20	MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number
21	MJCAT	☐	CCIHE_MJCAT	CCIHD_MJCAT	CHAR	3	0	Sampling Type	CCIHC_MJCAT
22	MJSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
23	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
24	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
25	RECNTMPWA	☐	CCIHE_RECNTMPWA	ESDRECN	NUMC	20	0	Reference to Assigned Work Area
26	MJVALFR	☐	CCIHE_MJVALFR	DATUM	DATS	8	0	Start of Validity of Measurement
27	MJVALTO	☐	CCIHE_MJVALTO	DATUM	DATS	8	0	End of Validity of Measurement
28	MSRBGNDATE	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
29	MSRBGNTIME	☐	CCIHE_MSRBGNTIME	UZEIT	TIMS	6	0	Time of Start of Measurement
30	MSRENDDATE	☐	CCIHE_MSRENDDATE	DATUM	DATS	8	0	Date of End of Measurement
31	MSRENDTIME	☐	CCIHE_MSRENDTIME	UZEIT	TIMS	6	0	Time of End of Measurement
32	MDURATION	☐	CCIHE_MDURATION	CCIHD_MDURATION	TIMS	6	0	Actual Duration of Measurement
33	MPLDURATION	☐	CCIHE_MPLDURATION	CCIHD_MDURATION	TIMS	6	0	Planned Measurement Duration
34	MEXCHANGE	☐	CCIHE_MEXCHANGE	ESDFLAG	CHAR	1	0	Perform Conversion
35	MSOURCEID	☐	CCIHE_MSOURCEID	CCIHD_MSOURCEID	CHAR	3	0	Sampling Location	CCIHC_MSOURCE
36	MSOURCENOTE	☐	CCIHE_MSOURCENOTE	CCIHD_MSOURCENOTE	CHAR	255	0	Description for Sampling Location
37	FIXLOCFLG	☐	CCIHE_FIXLOCFLG	ESDFLAG	CHAR	1	0	Fixed-Location Measurement
38	MPERIOD	☐	CCIHE_MPERIOD	CCIHD_MPERIOD	NUMC	2	0	Repetition of Measurement in Months
39	FLOW	☐	CCIHE_FLOW	CCIHD_FLOW	DEC	5	2	Flow Quantity of Measuring Device
40	FLOWUNIT	☐	CCIHE_FLOWUNIT	MEINS	UNIT	3	0	Flow Unit	*
41	DVNR	☐	CCIHE_DVNR	CHAR20	CHAR	20	0	Number of the Measuring Device
42	MDEVTYPE	☐	CCIHE_DVTYPE	CCIHD_DVTYPE	CHAR	3	0	Measuring Device Type	CCIHC_DVTYPE
43	METHOD	☐	CCIHE_METHOD	CCIHD_METHOD	CHAR	5	0	Measurement Method	CCIHC_METHOD
44	MPERSON	☐	CCIHE_MJPERSON	CCIHD_MJPERSON	CHAR	10	0	Test Person
45	MPERSONGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
46	MPERSONNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
47	MJNOTE1	☐	CCIHE_MJNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measurement
48	MJNOTEFLG1	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
49	MJNOTE2	☐	CCIHE_MJNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measurement
50	MJNOTEFLG2	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
51	RESPIRATOR	☐	CCIHE_RESPIRATOR	CCIHD_RESPIRATOR	CHAR	1	0	Respiratory Protection
52	SAMPLENR	☐	CCIHE_SAMPLENR	CCIHD_SAMPLENR	CHAR	30	0	Container or Filter
53	MJCOSTAC	☐	CCIHE_MPCOSTAC	KOSTL	CHAR	10	0	Cost Center for Measurement Project	*
54	MJCTRAREA	☐	CCIHE_MPCTRAREA	CACCD	CHAR	4	0	Controlling Area	TKA01
55	RECNTMJ	☐	CCIHE_RECNTREFMJ	ESDRECN	NUMC	20	0	Reference to Partial Measurement
56	LIMEXCEEDFLG	☐	CCIHE_LIMEXCEEDFLG	ESDFLAG	CHAR	1	0	Reference Value Exceeded
57	STMFLG	☐	CCIHE_STMFLG	ESDFLAG	CHAR	1	0	Short-Term Sample
58	METCOASTS	☐	CCIHE_MCOSTS	CCIHD_METCOASTS	CURR	10	2	Cost of Analysis
59	METCUKY	☐	CCIHE_METCUKY	WAERS	CUKY	5	0	Currency Key for Costs	*
60	VOLUME	☐	CCIHE_VOLUME	FLTP	FLTP	16	16	Total Volume in Liters
61	VOLDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
62	MJCOCODE	☐	CCIHE_MPCOCODE	BUKRS	CHAR	4	0	Company Code	*
63	FLGEXPLOCK	☐	CCIHE_FLGEXPLCK	ESDFLAG	CHAR	1	0	Object Is in Export
64	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
65	IMP_DATE	☐	CCIHE_IMPDATE	DATS	DATS	8	0	Date of Import
66	IMP_TIME	☐	CCIHE_IMPTIME	TIME	TIMS	6	0	Time of Import
67	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
68	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
69	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
70	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
71	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHT_MJIMPORT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHT_MJIMPORT	EPTYPE	CCIHV_HAZTYPE	SUBCAT
3	CCIHT_MJIMPORT	MANDT	T000	MANDT
4	CCIHT_MJIMPORT	MDEVTYPE	CCIHC_DVTYPE	DVTYPE
5	CCIHT_MJIMPORT	METHOD	CCIHC_METHOD	METHOD
6	CCIHT_MJIMPORT	MJCAT	CCIHC_MJCAT	MJCAT
7	CCIHT_MJIMPORT	MJCTRAREA	TKA01	KOKRS
8	CCIHT_MJIMPORT	MSOURCEID	CCIHC_MSOURCE	MSOURCEID
9	CCIHT_MJIMPORT	OPCOND	CCIHC_OC01	OPCOND
10	CCIHT_MJIMPORT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200