SAP ABAP Table CCIHS_MJIOT (EHS: IOTAB for Measurements (CCIHT_MJ))

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	INTTAB	Structure
Structure	CCIHS_MJIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Measurements (CCIHT_MJ)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
2	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
4	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
5	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
6	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
7	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
8	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
9	.INCLUDE	☐				0	0	EHS: Measurement
10	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
13	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
14	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
15	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
16	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
17	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
18	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
19	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
20	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
21	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
22	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
23	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
24	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
25	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
26	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
27	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
28	MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number
29	MJCAT	☐	CCIHE_MJCAT	CCIHD_MJCAT	CHAR	3	0	Sampling Type	CCIHC_MJCAT
30	MJSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
31	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
32	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
33	RECNTMPWA	☐	CCIHE_RECNTMPWA	ESDRECN	NUMC	20	0	Reference to Assigned Work Area
34	MJVALFR	☐	CCIHE_MJVALFR	DATUM	DATS	8	0	Start of Validity of Measurement
35	MJVALTO	☐	CCIHE_MJVALTO	DATUM	DATS	8	0	End of Validity of Measurement
36	MSRBGNDATE	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
37	MSRBGNTIME	☐	CCIHE_MSRBGNTIME	UZEIT	TIMS	6	0	Time of Start of Measurement
38	MSRENDDATE	☐	CCIHE_MSRENDDATE	DATUM	DATS	8	0	Date of End of Measurement
39	MSRENDTIME	☐	CCIHE_MSRENDTIME	UZEIT	TIMS	6	0	Time of End of Measurement
40	MDURATION	☐	CCIHE_MDURATION	CCIHD_MDURATION	TIMS	6	0	Actual Duration of Measurement
41	MPLDURATION	☐	CCIHE_MPLDURATION	CCIHD_MDURATION	TIMS	6	0	Planned Measurement Duration
42	MEXCHANGE	☐	CCIHE_MEXCHANGE	ESDFLAG	CHAR	1	0	Perform Conversion
43	MSOURCEID	☐	CCIHE_MSOURCEID	CCIHD_MSOURCEID	CHAR	3	0	Sampling Location	CCIHC_MSOURCE
44	MSOURCENOTE	☐	CCIHE_MSOURCENOTE	CCIHD_MSOURCENOTE	CHAR	255	0	Description for Sampling Location
45	FIXLOCFLG	☐	CCIHE_FIXLOCFLG	ESDFLAG	CHAR	1	0	Fixed-Location Measurement
46	MPERIOD	☐	CCIHE_MPERIOD	CCIHD_MPERIOD	NUMC	2	0	Repetition of Measurement in Months
47	FLOW	☐	CCIHE_FLOW	CCIHD_FLOW	DEC	5	2	Flow Quantity of Measuring Device
48	FLOWUNIT	☐	CCIHE_FLOWUNIT	MEINS	UNIT	3	0	Flow Unit	*
49	DVNR	☐	CCIHE_DVNR	CHAR20	CHAR	20	0	Number of the Measuring Device
50	MDEVTYPE	☐	CCIHE_DVTYPE	CCIHD_DVTYPE	CHAR	3	0	Measuring Device Type	CCIHC_DVTYPE
51	METHOD	☐	CCIHE_METHOD	CCIHD_METHOD	CHAR	5	0	Measurement Method	CCIHC_METHOD
52	MPERSON	☐	CCIHE_MJPERSON	CCIHD_MJPERSON	CHAR	10	0	Test Person
53	MPERSONGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
54	MPERSONNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
55	MJNOTE1	☐	CCIHE_MJNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measurement
56	MJNOTEFLG1	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
57	MJNOTE2	☐	CCIHE_MJNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measurement
58	MJNOTEFLG2	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
59	RESPIRATOR	☐	CCIHE_RESPIRATOR	CCIHD_RESPIRATOR	CHAR	1	0	Respiratory Protection
60	SAMPLENR	☐	CCIHE_SAMPLENR	CCIHD_SAMPLENR	CHAR	30	0	Container or Filter
61	MJCOSTAC	☐	CCIHE_MPCOSTAC	KOSTL	CHAR	10	0	Cost Center for Measurement Project	*
62	MJCTRAREA	☐	CCIHE_MPCTRAREA	CACCD	CHAR	4	0	Controlling Area	TKA01
63	RECNTMJ	☐	CCIHE_RECNTREFMJ	ESDRECN	NUMC	20	0	Reference to Partial Measurement
64	LIMEXCEEDFLG	☐	CCIHE_LIMEXCEEDFLG	ESDFLAG	CHAR	1	0	Reference Value Exceeded
65	STMFLG	☐	CCIHE_STMFLG	ESDFLAG	CHAR	1	0	Short-Term Sample
66	METCOASTS	☐	CCIHE_MCOSTS	CCIHD_METCOASTS	CURR	10	2	Cost of Analysis
67	METCUKY	☐	CCIHE_METCUKY	WAERS	CUKY	5	0	Currency Key for Costs	*
68	VOLUME	☐	CCIHE_VOLUME	FLTP	FLTP	16	16	Total Volume in Liters
69	VOLDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
70	MJCOCODE	☐	CCIHE_MPCOCODE	BUKRS	CHAR	4	0	Company Code	*
71	FLGEXPLOCK	☐	CCIHE_FLGEXPLCK	ESDFLAG	CHAR	1	0	Object Is in Export
72	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
73	PLBEGDATE	☐	CCIHE_MSRPLBEGDATE	DATUM	DATS	8	0	Planned Measurement Start Date
74	PLENDDATE	☐	CCIHE_MSRPLENDDATE	DATUM	DATS	8	0	Planned Measurement End Date
75	MSRTEMP	☐	CCIHE_MSRTEMP	DEC5_2	DEC	7	2	Temperature During Measurement
76	MSRTEMPUNIT	☐	CCIHE_MSRTEMPUNIT	MEINS	UNIT	3	0	Temperature Unit During Measurement	*
77	AIRHUM	☐	CCIHE_AIRHUM	DEC5_2	DEC	7	2	Air Humidity During Measurement
78	AIRHUMUNIT	☐	CCIHE_AIRHUMUNIT	MEINS	UNIT	3	0	Air Humidity Unit During Measurement	*
79	AIRCOND	☐	CCIHE_AIRCOND	CHAR21	CHAR	21	0	Ventilation During Measurement
80	AIRCHNGRATE	☐	CCIHE_AIRCHNGRATE	DECV5_2	DEC	5	2	Air Change Rate During Measurement
81	PROTEQUI	☐	CCIHE_PROTEQUI	CHAR21	CHAR	21	0	Safety Device During Measurement
82	FLG_NIGHT	☐	CCIHE_FLG_NIGHT	ESDFLAG	CHAR	1	0	Night Measurement
83	PLBEGTIME	☐	CCIHE_MSRPLBEGTIME	UZEIT	TIMS	6	0	Planned Measurement Start Time
84	PLENDTIME	☐	CCIHE_MSRPLENDTIME	UZEIT	TIMS	6	0	Planned Measurement End Time
85	MJCATTXT	☐	CCIHE_MJCATTXT	TEXT60	CHAR	60	0	Description of Sampling Type
86	MJSHSTATNAM	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
87	MJSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
88	EPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
89	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
90	MSOURCETXT	☐	CCIHE_MSOURCE	CCIHD_MSOURCE	CHAR	120	0	Description of Sampling Location
91	DVTYPETXT	☐	CCIHE_DVTYPETXT	TEXT60	CHAR	60	0	Description of Measuring Device Type
92	METHODTXT	☐	CCIHE_METHODTXT	TEXT60	CHAR	60	0	Description of Measurement Method
93	COSTCNAM	☐	CCIHE_COSTCNAM	CHAR20	CHAR	20	0	Description of Cost Center
94	REF_MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number
95	MPH_WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
96	MPH_WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
97	MPH_RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
98	MPW_WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
99	MPW_WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
100	MPW_RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
101	BUILDINGS	☐	CCIHE_BUILDINGS	CCIHD_BUILDINGS	CHAR	120	0	Building
102	ANLAB	☐	CCIHE_ANLAB	BU_PARTNER	CHAR	10	0	Analysis Laboratory	*
103	ANLABNAM	☐	CCIHE_ANLABNAM	BU_NAME	CHAR	40	0	Description of Analysis Lab
104	REMARK	☐	CCIHE_METINSTRUCT	CCIHD_METINSTRUCT	CHAR	132	0	Instructions for Measurement Method
105	MPTYPE	☐	CCIHE_MPTYPE	CCIHD_MPTYPE	CHAR	3	0	Measurement Project Type	*
106	EPQUNITNAM	☐	CCIHE_EPQUNITNAM	MSEH6	CHAR	6	0	Unit of Measurement
107	HQVCHAR12	☐	CCIHE_VOLUME_CHAR	CHAR12	CHAR	12	0	Total Volume in Liters
108	MDURATION_MIN	☐	CCIHE_MDURATION_MIN	CHAR4	CHAR	4	0	Actual Measurement Duration (in Minutes)
109	MPLDURATION_MIN	☐	CCIHE_MPLDURATION_MIN	CHAR4	CHAR	4	0	Planned Measurement Duration in Minutes
110	CTAREANAM	☐	CCIHE_CTRAREANAM	TEXT25	CHAR	25	0	Description of Controlling Area
111	OPCONDTXT	☐	CCIHE_OPCONDTXT	TEXT30	CHAR	30	0	Description of Operation Status
112	AIRCONDTXT	☐	CCIHE_AIRCONDTXT	TEXT132	CHAR	132	0	Description of Ventilation During Measurement
113	PROTEQUITXT	☐	CCIHE_PROTEQUITXT	TEXT132	CHAR	132	0	Name of Safety Device During Measurement
114	FLOWUNITNAM	☐	CCIHE_FLOWUNITNAM	MSEH6	CHAR	6	0	Flow Unit	CCIHV_UNIT
115	MSRTEMPUNITNAM	☐	CCIHE_MSRTEMPUNITNAM	MSEH6	CHAR	6	0	Temperature Unit During Measurement	CCIHV_UNIT
116	AIRHUMUNITNAM	☐	CCIHE_AIRHUMUNITNAM	MSEH6	CHAR	6	0	Air Humidity Unit During Measurement	CCIHV_UNIT

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in