T7EHS00_SERVICE SAP table for – Medical Service (Main Table)

Here we would like to draw your attention to T7EHS00_SERVICE 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_SERVICE is a SAP standard transp table used for storing Medical Service (Main Table) related data in SAP. It comes under the package P99Q1.

SAP T7EHS00_SERVICE table

Table T7EHS00_SERVICE technical data

TableT7EHS00_SERVICE
Data storingMedical Service (Main Table)
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP T7EHS00_SERVICE 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_SERVICE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SRV_NUMBER : Number of Medical Service
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • PERNR : Personnel number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • HEALTHCENTRE : Health Center
    Its data type is CHAR (Character String) with field length 10
  • SRV_TYPE : Appointment Type of Medical Service
    Its data type is CHAR (Character String) with field length 1
  • SRV_STATUS : Status of Medical Service
    Its data type is CHAR (Character String) with field length 1
  • SRV_REVIEW : Check Criterion
    Its data type is CHAR (Character String) with field length 1
  • SRV_INFOPERS : Person Informed About Examination Results
    Its data type is CHAR (Character String) with field length 1
  • SRV_OPENDATE : Date on Which a Medical Service Was Opened
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRV_SIGNOFFDATE : Sign-Off Date of Examination Cycle
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRV_CLOSUREDATE : Service Closed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRV_FOLLOWUP : Follow-Up Activity for Medical Service
    Its data type is CHAR (Character String) with field length 3
  • SRV_DECIND : Service Refused
    Its data type is CHAR (Character String) with field length 1
  • SRV_REVFLAG : Reopen Service
    Its data type is CHAR (Character String) with field length 1
  • SRV_REVDATE : Date Reopened
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRV_INVITPRI : Invitation to Examination Sent
    Its data type is CHAR (Character String) with field length 1
  • SRV_PHYSICIAN : Physician Responsible
    Its data type is CHAR (Character String) with field length 10
  • PHYSFLAG : Internal/External Person
    Its data type is CHAR (Character String) with field length 1
  • SRV_DURA : Duration of Consultation in Minutes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • COST_INT : Internal 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
  • DURATION_INT : Internal Duration
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • COST_EXT : External Costs
    Its data type is CURR (Currency Field) with field length 15
  • WAEHR_EXT : Costs Currency
    Its data type is CUKY (Currency key for a currency field) 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
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRV_PRESP : Service Provider/Person Responsible
    Its data type is CHAR (Character String) with field length 10
  • RECNTOBJ : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTNTOBJ : Sequential Number of the Change State
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • REFOBJ : Reference Object
    Its data type is CHAR (Character String) with field length 3