T7EHS00_PROT SAP table for – Health Surveillance Protocols

Here we would like to draw your attention to T7EHS00_PROT table in SAP. As we know it is being mainly used with the SAP EHS-HEA (Occupational Health in EHS) component which is coming under EHS module (Environment, Health and Safety). T7EHS00_PROT is a SAP standard transp table used for storing Health Surveillance Protocols related data in SAP. It comes under the package P99Q1.

SAP T7EHS00_PROT table

Table T7EHS00_PROT technical data

TableT7EHS00_PROT
Data storingHealth Surveillance Protocols
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP T7EHS00_PROT 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 T7EHS00_PROT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PGROUP : Health Surveillance Protocol Category
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PNUMBER : Protocol Number
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POWNER : Protocol Owner
    Its data type is CHAR (Character String) with field length 20
  • LTEXT : Long Text Exists
    Its data type is CHAR (Character String) with field length 1
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • REGULATORY : Regulatory Protocol
    Its data type is CHAR (Character String) with field length 1
  • MANDATORY : Mandatory Examination
    Its data type is CHAR (Character String) with field length 1
  • SCHEDNR : Health Surveillance Protocol Type
    Its data type is CHAR (Character String) with field length 1
  • LTA_TRIGGER : Long-Term Average Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • NRT_TRIGGER : Nonroutine Task
    Its data type is CHAR (Character String) with field length 1
  • AND_LTA_TRIGGER : Additional Long-Term Average Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • ER_RAT_TRIG : Short-Time Exposure Rating
    Its data type is CHAR (Character String) with field length 1
  • ER_RAT_FREQ_TRIG : Exposure Frequency Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • SKINEXPFREQ_TRIG : Skin Absorption Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • SKINEFFFREQ_TRIG : Skin Exposure Effects Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • INGESTFREQ_TRIG : Ingestion Effects Trigger Level
    Its data type is CHAR (Character String) with field length 1
  • ALWAYS_CHECK : Check Assignment of Protocol Manually
    Its data type is CHAR (Character String) with field length 1
  • COST_INT : Internal Costs
    Its data type is CURR (Currency Field) with field length 15
  • COST_EXT : External Costs
    Its data type is CURR (Currency Field) with field length 15
  • WAEHR_INT : Costs Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WAEHR_EXT : Costs Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DURATION_INT : Internal Duration
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • DURATION_EXT : External Duration
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • STATUS : Object Status
    Its data type is CHAR (Character String) with field length 1
  • ACTIV_INACTIVE : New Input Values
    Its data type is CHAR (Character String) with field length 1
  • FREQ_FULL_RV_EX : Frequency Reference Values Exceeded
    Its data type is CHAR (Character String) with field length 1
  • FREQ_ACT_LEV_EX : Frequency Trigger Levels Exceeded
    Its data type is CHAR (Character String) with field length 1
  • AGE_FROM : Age Restriction: Age from
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AGE_TO : Age Restriction: Age to
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CANCER_RELATED : Indicator for Cancer Screening
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : EHS: Structure for Administration Fields
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • CRDTIMESTAMP : Creation Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • UPDTIMESTAMP : Time of Last Change
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • GENDER : Gender Key
    Its data type is CHAR (Character String) with field length 1
  • REASON_COMB : Link Triggering Causes with AND
    Its data type is CHAR (Character String) with field length 1