CCIHT_ERQT SAP table for – EHS: Exposure Assignment – Exposure Amounts

Here we would like to draw your attention to CCIHT_ERQT 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_ERQT is a SAP standard transp table used for storing EHS: Exposure Assignment – Exposure Amounts related data in SAP. It comes under the package CBIH.

SAP CCIHT_ERQT table

Table CCIHT_ERQT technical data

TableCCIHT_ERQT
Data storingEHS: Exposure Assignment – Exposure Amounts
ModuleEHS
Sub ModuleEHS-IHS
SAP PackageCBIH
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCIHT_ERQT 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_ERQT 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: Measurement Structure
  • EPQUANTTYPE : Amount Category
    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
  • EPQUANTSET : Measurement Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • EPQUANTVAL : Measurement Value of Physical Variable
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • 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
  • 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
  • MSRNAM : Person Acting or Responsible
    Its data type is CHAR (Character String) with field length 12
  • MSRNAMFLG : External Person
    Its data type is CHAR (Character String) with field length 1
  • MSRORDNR : Measurement Job Number
    Its data type is CHAR (Character String) with field length 20
  • MSRDESC : Description of Measurement
    Its data type is CHAR (Character String) with field length 132
  • MSRDESCFLG : Indicator for SAPscript Text
    Its data type is CHAR (Character String) with field length 1
  • MSRPROCEDURE : Measurement Method
    Its data type is CHAR (Character String) with field length 21
  • MSRSTAT : Status
    Its data type is CHAR (Character String) with field length 5
  • MSRINITSTAT : Initial Status of an Object
    Its data type is CHAR (Character String) with field length 5
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • MSRNAMGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • RECNTMJ : Reference to Measurement
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • RECNTMP : Reference to Measurement Project
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • PROBANDGRP : Person Group
    Its data type is CHAR (Character String) with field length 1
  • PROBAND : Test Person
    Its data type is CHAR (Character String) with field length 10