CCIHT_MJVA SAP table for – EHS: Measured Values

Here we would like to draw your attention to CCIHT_MJVA 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_MJVA is a SAP standard transp table used for storing EHS: Measured Values related data in SAP. It comes under the package CBIH.

SAP CCIHT_MJVA table

Table CCIHT_MJVA technical data

TableCCIHT_MJVA
Data storingEHS: Measured Values
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_MJVA 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_MJVA 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
  • RECNTMJ : Reference to Measurement
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • FIELDNAME : Field name
    Its data type is CHAR (Character String) with field length 30
  • POSNR : Measured Values
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • 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
  • REFEPTYPE : Reference Agent Type
    Its data type is CHAR (Character String) with field length 10
  • REFEPID : Reference Agent
    Its data type is CHAR (Character String) with field length 20
  • BDETLIMITFLG : Degree of Detectability
    Its data type is CHAR (Character String) with field length 1
  • HQVALORIGINAL : Measured Value from Analysis Lab
    Its data type is CHAR (Character String) with field length 30
  • HQVALFLOAT : Measured Physical Variable Value (FLOAT)
    Its data type is FLTP (Floating point number) with field length 16
  • HQVALDECIMALS : Decimal Places for a Measured Physical Variable Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • EPQUNIT : Unit of Measurement for Exposure Amount
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DETTYPE : Determination Type
    Its data type is CHAR (Character String) with field length 3
  • LTTYPE : Measured Value/Reference Value Category
    Its data type is CHAR (Character String) with field length 3
  • QTTYPE : Amount Category
    Its data type is CHAR (Character String) with field length 3
  • HAZLIMFLOAT : Floating-Point Value of Exposure Reference Value
    Its data type is FLTP (Floating point number) with field length 16
  • HAZLIMUNIT : Exposure Reference Value Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HAZLIMDECIMALS : Decimal Places for a Measured Physical Variable Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MVNOTE : Remarks on Measured Value
    Its data type is CHAR (Character String) with field length 72
  • FLG_FR_LABOR : Value Taken from Analysis Lab
    Its data type is CHAR (Character String) with field length 1
  • FLG_COMPUTED : Concentration Calculated
    Its data type is CHAR (Character String) with field length 1
  • UNITORIGINAL : Unit of Original Analysis Value
    Its data type is CHAR (Character String) with field length 10
  • HQVALORGUNIT : Unit of Analysis Value Recognized and Accepted by System
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • APPL_AREA : Application Area of Reference Value
    Its data type is CHAR (Character String) with field length 30
  • LEGALLIST : Regulatory List
    Its data type is CHAR (Character String) with field length 10
  • STMFACTOR : Overrun Factor for Short-Time Values
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • LIMEXCEEDFLG : Reference Value Exceeded
    Its data type is CHAR (Character String) with field length 1
  • HAZLIM_RECN : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20