CCIHT_MJIMPORT

EHS: Pooled Table for Imported Measurements | #masterdata | Component: Environment, Health, and Safety / Product Compliance
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
💲 Currency Key for Costs (METCUKY):
METCOASTS Cost of Analysis
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
MJVALFR Start of Validity of Measurement
MJVALTO End of Validity of Measurement
MSRBGNDATE Date of Start of Measurement
MSRBGNTIME Time of Start of Measurement
MSRENDDATE Date of End of Measurement
MSRENDTIME Time of End of Measurement
MDURATION Actual Duration of Measurement
MPLDURATION Planned Measurement Duration
IMP_DATE Date of Import
IMP_TIME Time of Import
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
MEXCHANGE Perform Conversion Show values
FIXLOCFLG Fixed-Location Measurement Show values
MPERSONGRP Person Group Show values
MJNOTEFLG1 Long Text Show values
MJNOTEFLG2 Long Text Show values
RESPIRATOR Respiratory Protection Show values
LIMEXCEEDFLG Reference Value Exceeded Show values
STMFLG Short-Term Sample Show values
FLGEXPLOCK Object Is in Export Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
OWNID Data Provider AD_ADDRNUM
RECNROOT Sequential Number of Data Record ESDRECN
OBJNR Object number J_OBJNR
MJID Measurement Number CCIHD_MJID
MJSTAT Status J_STATUS
EPID Agent CCIHD_EPID
RECNTMPWA Reference to Assigned Work Area ESDRECN
MSOURCENOTE Description for Sampling Location CCIHD_MSOURCENOTE
MPERIOD Repetition of Measurement in Months CCIHD_MPERIOD
FLOW Flow Quantity of Measuring Device CCIHD_FLOW
DVNR Number of the Measuring Device CHAR20
MPERSON Test Person CCIHD_MJPERSON
MPERSONNAME Full Name of Person TEXT80
MJNOTE1 Remarks on Measurement CCIHD_MNOTE
MJNOTE2 Remarks on Measurement CCIHD_MNOTE
SAMPLENR Container or Filter CCIHD_SAMPLENR
MJCOSTAC Cost Center for Measurement Project KOSTL
RECNTMJ Reference to Partial Measurement ESDRECN
VOLUME Total Volume in Liters FLTP
VOLDECIMALS Decimal Places for a Measured Physical Variable Value INT4
MJCOCODE Company Code BUKRS
UNAME User Name SYCHAR12
ERRORMODE Indicator: Error or warning in an API function CHAR1
ERRORINFO Count parameters NUMC4
ERRORCLASS Message Class ARBGB
ERRORPARAM 30 Characters CHAR30
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • CCIHT_MJIMPORT.AENNR == AENR.AENNR
  • CCIHT_MJIMPORT.MANDT == AENR.MANDT
Client CCIHT_MJIMPORT.MANDT == T000.MANDT
Measuring Device Type
  • Measuring Device Type
  • Client
Measurement Method
Sampling Type
Controlling Area
  • CCIHT_MJIMPORT.MANDT == TKA01.MANDT
  • CCIHT_MJIMPORT.MJCTRAREA == TKA01.KOKRS
Sampling Location
  • Sampling Location
  • Client
Operation Status of Work Area/Pattern
EHS: Foreign Key for Substance Authorization Group
  • CCIHT_MJIMPORT.MANDT == TCG56.MANDT
  • CCIHT_MJIMPORT.SRSID == TCG56.SRSID