SAP Table CCIHT_MJIMPORT

EHS: Pooled Table for Imported Measurements

The table CCIHT_MJIMPORT (EHS: Pooled Table for Imported Measurements) is a standard table in SAP ERP. It belongs to the package CBIH.

Technical Information

Table	CCIHT_MJIMPORT
Short Text	EHS: Pooled Table for Imported Measurements
Package	CBIH
Table Type	Transparent Table

Fields for Table CCIHT_MJIMPORT

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
RECN	✔	Sequential Number of Data Record	ESERECN	NUMC	20
ACTN	✔	Sequential Number of the Change State	ESEACTN	NUMC	20
VALFR		Valid-From Date	ESEVALFR	DATS	8
VALTO		Valid-To Date	ESEVALTO	DATS	8
AENNR		Change Number	ESEAENNR	CHAR	12	AENR
DELFLG		Deletion Indicator	ESEDELFLG	CHAR	1
PARKFLG		Data Record Is Inactive	ESEPARKFLG	CHAR	1
CRDAT		Created On	ESECRDAT	DATS	8
CRNAM		Created By	ESECRNAM	CHAR	12
UPDDAT		Changed On	ESEUPDDAT	DATS	8
UPDNAM		Last Changed By	ESEUPDNAM	CHAR	12
SRSID		Source of Data	ESESRSID	CHAR	10	TCG56
OWNID		Data Provider	ESEVENDRID	CHAR	10	*
RECNROOT		Sequential Number of Data Record	ESERECN	NUMC	20
Include Structure: CCIHS_MJ
OBJNR		Object number	J_OBJNR	CHAR	22	*
MJID		Measurement Number	CCIHE_MJID	CHAR	30
MJCAT		Sampling Type	CCIHE_MJCAT	CHAR	3	CCIHC_MJCAT
MJSTAT		Status	EHSBE_STATUS	CHAR	5
EPTYPE		Agent Type	CCIHE_EPTYPE	CHAR	10	CCIHV_HAZTYPE
EPID		Agent	CCIHE_EPID	CHAR	20
RECNTMPWA		Reference to Assigned Work Area	CCIHE_RECNTMPWA	NUMC	20
MJVALFR		Start of Validity of Measurement	CCIHE_MJVALFR	DATS	8
MJVALTO		End of Validity of Measurement	CCIHE_MJVALTO	DATS	8
MSRBGNDATE		Date of Start of Measurement	CCIHE_MSRBGNDATE	DATS	8
MSRBGNTIME		Time of Start of Measurement	CCIHE_MSRBGNTIME	TIMS	6
MSRENDDATE		Date of End of Measurement	CCIHE_MSRENDDATE	DATS	8
MSRENDTIME		Time of End of Measurement	CCIHE_MSRENDTIME	TIMS	6
MDURATION		Actual Duration of Measurement	CCIHE_MDURATION	TIMS	6
MPLDURATION		Planned Measurement Duration	CCIHE_MPLDURATION	TIMS	6
MEXCHANGE		Perform Conversion	CCIHE_MEXCHANGE	CHAR	1
MSOURCEID		Sampling Location	CCIHE_MSOURCEID	CHAR	3	CCIHC_MSOURCE
MSOURCENOTE		Description for Sampling Location	CCIHE_MSOURCENOTE	CHAR	255
FIXLOCFLG		Fixed-Location Measurement	CCIHE_FIXLOCFLG	CHAR	1
MPERIOD		Repetition of Measurement in Months	CCIHE_MPERIOD	NUMC	2
FLOW		Flow Quantity of Measuring Device	CCIHE_FLOW	DEC	5
FLOWUNIT		Flow Unit	CCIHE_FLOWUNIT	UNIT	3	*
DVNR		Number of the Measuring Device	CCIHE_DVNR	CHAR	20
MDEVTYPE		Measuring Device Type	CCIHE_DVTYPE	CHAR	3	CCIHC_DVTYPE
METHOD		Measurement Method	CCIHE_METHOD	CHAR	5	CCIHC_METHOD
MPERSON		Test Person	CCIHE_MJPERSON	CHAR	10
MPERSONGRP		Person Group	CCIHE_PERSGRP	CHAR	1
MPERSONNAME		Full Name of Person	CCIHE_FULLNAME	CHAR	80
MJNOTE1		Remarks on Measurement	CCIHE_MJNOTE	CHAR	72
MJNOTEFLG1		Long Text	ESELTXTFLG	CHAR	1
MJNOTE2		Remarks on Measurement	CCIHE_MJNOTE	CHAR	72
MJNOTEFLG2		Long Text	ESELTXTFLG	CHAR	1
RESPIRATOR		Respiratory Protection	CCIHE_RESPIRATOR	CHAR	1
SAMPLENR		Container or Filter	CCIHE_SAMPLENR	CHAR	30
MJCOSTAC		Cost Center for Measurement Project	CCIHE_MPCOSTAC	CHAR	10	*
MJCTRAREA		Controlling Area	CCIHE_MPCTRAREA	CHAR	4	TKA01
RECNTMJ		Reference to Partial Measurement	CCIHE_RECNTREFMJ	NUMC	20
LIMEXCEEDFLG		Reference Value Exceeded	CCIHE_LIMEXCEEDFLG	CHAR	1
STMFLG		Short-Term Sample	CCIHE_STMFLG	CHAR	1
METCOASTS		Cost of Analysis	CCIHE_MCOSTS	CURR	10
METCUKY		Currency Key for Costs	CCIHE_METCUKY	CUKY	5	*
VOLUME		Total Volume in Liters	CCIHE_VOLUME	FLTP	16
VOLDECIMALS		Decimal Places for a Measured Physical Variable Value	CCIHE_HQVALDECIMALS	INT4	10
MJCOCODE		Company Code	CCIHE_MPCOCODE	CHAR	4	*
FLGEXPLOCK		Object Is in Export	CCIHE_FLGEXPLCK	CHAR	1
OPCOND		Operation Status of Work Area/Pattern	CCIHE_OPCOND	CHAR	3	CCIHC_OC01
IMP_DATE		Date of Import	CCIHE_IMPDATE	DATS	8
IMP_TIME		Time of Import	CCIHE_IMPTIME	TIMS	6
UNAME		User Name	SYUNAME	CHAR	12
ERRORMODE		Indicator: Error or warning in an API function	ESEERRMODE	CHAR	1
ERRORINFO		Count parameters	NUMC4	NUMC	4
ERRORCLASS		Message Class	SYMSGID	CHAR	20	*
ERRORPARAM		30 Characters	CHAR30	CHAR	30