SAP ABAP Table CCIHT_MJVAQT (EHS: Table Temporary Data from Measured Values to Amounts)

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_MJVAQT	Table Relationship Diagram
Short Description	EHS: Table Temporary Data from Measured Values to Amounts

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 Measured Values
19	RECNTMJ	☐	CCIHE_RECNTMJ	ESDRECN	NUMC	20	0	Reference to Measurement
20	FIELDNAME	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
21	POSNR	☐	CCIHE_POSNR	CCIHD_POSNR	NUMC	4	0	Measured Values
22	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
23	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
24	REFEPTYPE	☐	CCIHE_REFEPTYPE	ESDSUBCAT	CHAR	10	0	Reference Agent Type	CCIHV_HAZTYPE
25	REFEPID	☐	CCIHE_REFEPID	CCIHD_EPID	CHAR	20	0	Reference Agent
26	BDETLIMITFLG	☐	CCIHE_BDETLIMITFLG	CCIHD_BDETLIMITFLG	CHAR	1	0	Degree of Detectability
27	HQVALORIGINAL	☐	CCIHE_HQVALORIGINAL	CHAR30	CHAR	30	0	Measured Value from Analysis Lab
28	HQVALFLOAT	☐	CCIHE_HQVALFLOAT	FLOATING	FLTP	16	16	Measured Physical Variable Value (FLOAT)
29	HQVALDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
30	EPQUNIT	☐	CCIHE_EPQUANTUNIT	MEINS	UNIT	3	0	Unit of Measurement for Exposure Amount	*
31	DETTYPE	☐	CCIHE_DETTYPE	CCIHD_DETTYPE	CHAR	3	0	Determination Type	CCIHC_DETTYPE
32	LTTYPE	☐	CCIHE_LTTYPE	CCIHD_LTTYPE	CHAR	3	0	Measured Value/Reference Value Category	CCIHC_LT01
33	QTTYPE	☐	CCIHE_EPQUANTTYPE	CCIHD_EPQUANTTYP	CHAR	3	0	Amount Category	CCIHC_QT01
34	HAZLIMFLOAT	☐	CCIHE_HAZLIMFLOAT	FLTP	FLTP	16	16	Floating-Point Value of Exposure Reference Value
35	HAZLIMUNIT	☐	CCIHE_HAZLIMUNIT	MEINS	UNIT	3	0	Exposure Reference Value Unit	*
36	HAZLIMDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
37	MVNOTE	☐	CCIHE_MVNOTE	CCIHD_MNOTE	CHAR	72	0	Remarks on Measured Value
38	FLG_FR_LABOR	☐	CCIHE_FR_LABOR	ESDFLAG	CHAR	1	0	Value Taken from Analysis Lab
39	FLG_COMPUTED	☐	CCIHE_FLG_COMPUTED	ESDFLAG	CHAR	1	0	Concentration Calculated
40	UNITORIGINAL	☐	CCIHE_UNITORIGINAL	CHAR10	CHAR	10	0	Unit of Original Analysis Value
41	HQVALORGUNIT	☐	CCIHE_HQVALORGUNIT	MEINS	UNIT	3	0	Unit of Analysis Value Recognized and Accepted by System	*
42	APPL_AREA	☐	CCIHE_APPLAREA	CHAR30	CHAR	30	0	Application Area of Reference Value
43	LEGALLIST	☐	CCIHE_LEGALLIST	CHAR10	CHAR	10	0	Regulatory List
44	STMFACTOR	☐	CCIHE_STMFACTOR	CCIHD_STMFACTOR	DEC	2	1	Overrun Factor for Short-Time Values
45	LIMEXCEEDFLG	☐	CCIHE_LIMEXCEEDFLG	ESDFLAG	CHAR	1	0	Reference Value Exceeded
46	HAZLIM_RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
47	IMPDATE	☐	CCIHE_IMPDATE	DATS	DATS	8	0	Date of Import
48	IMPTIME	☐	CCIHE_IMPTIME	TIME	TIMS	6	0	Time of Import
49	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
50	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
51	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
52	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
53	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
54	FLG_MP_VERSION	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHT_MJVAQT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHT_MJVAQT	DETTYPE	CCIHC_DETTYPE	DETTYPE		1	CN
3	CCIHT_MJVAQT	EPTYPE	CCIHV_HAZTYPE	SUBCAT		1	CN
4	CCIHT_MJVAQT	LTTYPE	CCIHC_LT01	LTTYPE		1	CN
5	CCIHT_MJVAQT	MANDT	T000	MANDT
6	CCIHT_MJVAQT	QTTYPE	CCIHC_QT01	EPQUANTTYPE		1	CN
7	CCIHT_MJVAQT	REFEPTYPE	CCIHV_HAZTYPE	SUBCAT		1	CN
8	CCIHT_MJVAQT	SRSID	TCG56	SRSID	REF	1	CN

History

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