CCIHT_MJIMPORT SAP table for – EHS: Pooled Table for Imported Measurements

Here we would like to draw your attention to CCIHT_MJIMPORT table in SAP. As we know it is being mainly used with the SAP EHS-IHS (Industrial Hygiene and Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). CCIHT_MJIMPORT is a SAP standard transp table used for storing EHS: Pooled Table for Imported Measurements related data in SAP. It comes under the package CBIH.

SAP CCIHT_MJIMPORT table

Table CCIHT_MJIMPORT technical data

TableCCIHT_MJIMPORT
Data storingEHS: Pooled Table for Imported Measurements
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_MJIMPORT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CCIHT_MJIMPORT table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for General Administration Information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for Measurements
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • MJID : Measurement Number
    Its data type is CHAR (Character String) with field length 30
  • MJCAT : Sampling Type
    Its data type is CHAR (Character String) with field length 3
  • MJSTAT : Status
    Its data type is CHAR (Character String) with field length 5
  • EPTYPE : Agent Type
    Its data type is CHAR (Character String) with field length 10
  • EPID : Agent
    Its data type is CHAR (Character String) with field length 20
  • RECNTMPWA : Reference to Assigned Work Area
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • MJVALFR : Start of Validity of Measurement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MJVALTO : End of Validity of Measurement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MSRBGNDATE : Date of Start of Measurement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MSRBGNTIME : Time of Start of Measurement
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MSRENDDATE : Date of End of Measurement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MSRENDTIME : Time of End of Measurement
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MDURATION : Actual Duration of Measurement
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MPLDURATION : Planned Measurement Duration
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MEXCHANGE : Perform Conversion
    Its data type is CHAR (Character String) with field length 1
  • MSOURCEID : Sampling Location
    Its data type is CHAR (Character String) with field length 3
  • MSOURCENOTE : Description for Sampling Location
    Its data type is CHAR (Character String) with field length 255
  • FIXLOCFLG : Fixed-Location Measurement
    Its data type is CHAR (Character String) with field length 1
  • MPERIOD : Repetition of Measurement in Months
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FLOW : Flow Quantity of Measuring Device
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • FLOWUNIT : Flow Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DVNR : Number of the Measuring Device
    Its data type is CHAR (Character String) with field length 20
  • MDEVTYPE : Measuring Device Type
    Its data type is CHAR (Character String) with field length 3
  • METHOD : Measurement Method
    Its data type is CHAR (Character String) with field length 5
  • MPERSON : Test Person
    Its data type is CHAR (Character String) with field length 10
  • MPERSONGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • MPERSONNAME : Full Name of Person
    Its data type is CHAR (Character String) with field length 80
  • MJNOTE1 : Remarks on Measurement
    Its data type is CHAR (Character String) with field length 72
  • MJNOTEFLG1 : Long Text
    Its data type is CHAR (Character String) with field length 1
  • MJNOTE2 : Remarks on Measurement
    Its data type is CHAR (Character String) with field length 72
  • MJNOTEFLG2 : Long Text
    Its data type is CHAR (Character String) with field length 1
  • RESPIRATOR : Respiratory Protection
    Its data type is CHAR (Character String) with field length 1
  • SAMPLENR : Container or Filter
    Its data type is CHAR (Character String) with field length 30
  • MJCOSTAC : Cost Center for Measurement Project
    Its data type is CHAR (Character String) with field length 10
  • MJCTRAREA : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • RECNTMJ : Reference to Partial Measurement
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • LIMEXCEEDFLG : Reference Value Exceeded
    Its data type is CHAR (Character String) with field length 1
  • STMFLG : Short-Term Sample
    Its data type is CHAR (Character String) with field length 1
  • METCOASTS : Cost of Analysis
    Its data type is CURR (Currency Field) with field length 10
  • METCUKY : Currency Key for Costs
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VOLUME : Total Volume in Liters
    Its data type is FLTP (Floating point number) with field length 16
  • VOLDECIMALS : Decimal Places for a Measured Physical Variable Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MJCOCODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • FLGEXPLOCK : Object Is in Export
    Its data type is CHAR (Character String) with field length 1
  • OPCOND : Operation Status of Work Area/Pattern
    Its data type is CHAR (Character String) with field length 3
  • IMP_DATE : Date of Import
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IMP_TIME : Time of Import
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • ERRORMODE : Indicator: Error or warning in an API function
    Its data type is CHAR (Character String) with field length 1
  • ERRORINFO : Count parameters
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ERRORCLASS : Message Class
    Its data type is CHAR (Character String) with field length 20
  • ERRORPARAM : 30 Characters
    Its data type is CHAR (Character String) with field length 30