SAP ABAP Table CCIHS_MJVAIOT (EHS: IOTAB for Measured Values (CCIHT_MJVA))

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_MJVAIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Measured Values (CCIHT_MJVA)

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: Measured Values
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	RECNTMJ	☐	CCIHE_RECNTMJ	ESDRECN	NUMC	20	0	Reference to Measurement
28	FIELDNAME	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
29	POSNR	☐	CCIHE_POSNR	CCIHD_POSNR	NUMC	4	0	Measured Values
30	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
31	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
32	REFEPTYPE	☐	CCIHE_REFEPTYPE	ESDSUBCAT	CHAR	10	0	Reference Agent Type	CCIHV_HAZTYPE
33	REFEPID	☐	CCIHE_REFEPID	CCIHD_EPID	CHAR	20	0	Reference Agent
34	BDETLIMITFLG	☐	CCIHE_BDETLIMITFLG	CCIHD_BDETLIMITFLG	CHAR	1	0	Degree of Detectability
35	HQVALORIGINAL	☐	CCIHE_HQVALORIGINAL	CHAR30	CHAR	30	0	Measured Value from Analysis Lab
36	HQVALFLOAT	☐	CCIHE_HQVALFLOAT	FLOATING	FLTP	16	16	Measured Physical Variable Value (FLOAT)
37	HQVALDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
38	EPQUNIT	☐	CCIHE_EPQUANTUNIT	MEINS	UNIT	3	0	Unit of Measurement for Exposure Amount	*
39	DETTYPE	☐	CCIHE_DETTYPE	CCIHD_DETTYPE	CHAR	3	0	Determination Type	CCIHC_DETTYPE
40	LTTYPE	☐	CCIHE_LTTYPE	CCIHD_LTTYPE	CHAR	3	0	Measured Value/Reference Value Category	CCIHV_LT01
41	QTTYPE	☐	CCIHE_EPQUANTTYPE	CCIHD_EPQUANTTYP	CHAR	3	0	Amount Category	CCIHC_QT01
42	HAZLIMFLOAT	☐	CCIHE_HAZLIMFLOAT	FLTP	FLTP	16	16	Floating-Point Value of Exposure Reference Value
43	HAZLIMUNIT	☐	CCIHE_HAZLIMUNIT	MEINS	UNIT	3	0	Exposure Reference Value Unit	*
44	HAZLIMDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
45	MVNOTE	☐	CCIHE_MVNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measured Value
46	FLG_FR_LABOR	☐	CCIHE_FR_LABOR	ESDFLAG	CHAR	1	0	Value Taken from Analysis Lab
47	FLG_COMPUTED	☐	CCIHE_FLG_COMPUTED	ESDFLAG	CHAR	1	0	Concentration Calculated
48	UNITORIGINAL	☐	CCIHE_UNITORIGINAL	CHAR10	CHAR	10	0	Unit of Original Analysis Value
49	HQVALORGUNIT	☐	CCIHE_HQVALORGUNIT	MEINS	UNIT	3	0	Unit of Analysis Value Recognized and Accepted by System	*
50	APPL_AREA	☐	CCIHE_APPLAREA	CHAR30	CHAR	30	0	Application Area of Reference Value
51	LEGALLIST	☐	CCIHE_LEGALLIST	CHAR10	CHAR	10	0	Regulatory List
52	STMFACTOR	☐	CCIHE_STMFACTOR	CCIHD_STMFACTOR	DEC	2	1	Overrun Factor for Short-Time Values
53	LIMEXCEEDFLG	☐	CCIHE_LIMEXCEEDFLG	ESDFLAG	CHAR	1	0	Reference Value Exceeded
54	HAZLIM_RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
55	EPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
56	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
57	REFEPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
58	REFEPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
59	DETTYPETXT	☐	CCIHE_DETTYPETXT	TEXT60	CHAR	60	0	Description of Determination Type
60	DETTYPENOTE	☐	CCIHE_DETTYPENOTE	CCIHD_DETTYPENOTE	CHAR	132	0	Remarks on Determination Type
61	LTTYPENAM	☐	CCIHE_LTTYPENAM	TEXT26	CHAR	26	0	Description of Measured Value Category
62	EPQUANTNAM	☐	CCIHE_EPQUANTNAM	TEXT26	CHAR	26	0	Description of Amount Category
63	HQVCHAR12	☐	CCIHE_HQVCHAR12	CHAR12	CHAR	12	0	Measurement of Measured Physical Variable
64	HAZLIMITVAL	☐	CCIHE_HAZLIMITVAL	CHAR10	CHAR	10	0	Reference Value (Measurement Item)
65	HAZLIMITUNIT	☐	CCIHE_HAZLIMITUNIT	MSEH6	CHAR	6	0	Unit of Measurement for Reference Value
66	EPLIMIT	☐	CCIHE_EPLIMIT	ATWRT	CHAR	30	0	Exposure Reference Value (Measurement plus Unit)
67	LIMITEXCEEDVAL	☐	CCIHE_LIMITEXCEEDVAL	CHAR10	CHAR	10	0	Individual Index
68	EXPOSITVAL	☐	CCIHE_EXPOSITVAL	CHAR12	CHAR	12	0	Measurement Result/Exposure
69	EPQUNITNAM	☐	CCIHE_EPQUNITNAM	MSEH6	CHAR	6	0	Unit of Measurement	CCIHV_UNIT
70	ORGUNITNAM	☐	CCIHE_ORGUNITNAM	MSEH6	CHAR	6	0	Unit of Measurement for Analysis Value	CCIHV_UNIT
71	EXPOUNIT	☐	CCIHE_EPQUANTUNIT	MEINS	UNIT	3	0	Unit of Measurement for Exposure Amount	*
72	EXPOUNITNAM	☐	CCIHE_EPQUNITNAM	MSEH6	CHAR	6	0	Unit of Measurement
73	DETTYPEFLG	☐	CCIHE_FLG_DIRECT	ESDFLAG	CHAR	1	0	Determination Type 'Direct'
74	APPL_AREATXT	☐	CCIHE_APPLAREATXT	TEXT132	CHAR	132	0	Description of Application Area of Reference Value
75	SUMGROUP	☐	CCIHE_SUMGROUP	CHAR30	CHAR	30	0	Summated Value Group
76	SUMGROUPTXT	☐	CCIHE_SUMGROUPTXT	TEXT132	CHAR	132	0	Description of Summated Value Group
77	EPQDIMID	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
78	EXPOSITFLOAT	☐	CCIHE_HQVALFLOAT	FLOATING	FLTP	16	16	Measured Physical Variable Value (FLOAT)
79	EXPOSITDEC	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
80	STMFLG	☐	CCIHE_STMFLG	ESDFLAG	CHAR	1	0	Short-Term Sample
81	FLG_ERROR_UNITCON	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
82	FLG_ERROR_LIMCON	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
83	FLG_FALSE_DIMENSION	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
84	MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_MJVAIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_MJVAIOT	DETTYPE	CCIHC_DETTYPE	DETTYPE
3	CCIHS_MJVAIOT	EPQUNITNAM	CCIHV_UNIT	MSEH6	REF	1	CN
4	CCIHS_MJVAIOT	EPTYPE	CCIHV_HAZTYPE	SUBCAT		1	CN
5	CCIHS_MJVAIOT	LTTYPE	CCIHV_LT01	LTTYPE
6	CCIHS_MJVAIOT	MANDT	T000	MANDT
7	CCIHS_MJVAIOT	ORGUNITNAM	CCIHV_UNIT	MSEH6	REF	1	CN
8	CCIHS_MJVAIOT	QTTYPE	CCIHC_QT01	EPQUANTTYPE
9	CCIHS_MJVAIOT	REFEPTYPE	CCIHV_HAZTYPE	SUBCAT		1	CN
10	CCIHS_MJVAIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in