T7EHS00_SRV_DIA SAP table for – Diagnoses for Person

Here we would like to draw your attention to T7EHS00_SRV_DIA 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_SRV_DIA is a SAP standard transp table used for storing Diagnoses for Person related data in SAP. It comes under the package P99Q1.

SAP T7EHS00_SRV_DIA table

Table T7EHS00_SRV_DIA technical data

TableT7EHS00_SRV_DIA
Data storingDiagnoses for Person
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP T7EHS00_SRV_DIA 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_SRV_DIA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • DIAG_NUMBER : Number of Diagnosis of a Person
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • DIAG_CTLG : Diagnosis Catalog
    Its data type is CHAR (Character String) with field length 2
  • DIAG_CODE : Diagnosis Code
    Its data type is CHAR (Character String) with field length 6
  • DIAG_TYPE : Diagnosis Key Category
    Its data type is CHAR (Character String) with field length 1
  • DIAG_ONSETDATE : Start Date of Diagnosed Illness
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIAG_RECDATE : Examination Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIAG_INACTDATE : End Date for Diagnosed Illness
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIAG_SIGNIF : Diagnosis Significance
    Its data type is CHAR (Character String) with field length 1
  • DIAG_PRIMARY : Diagnosis Rating
    Its data type is CHAR (Character String) with field length 1
  • DIAG_SRC : Diagnosis Source
    Its data type is CHAR (Character String) with field length 2
  • DIAG_CHARACT : Cause of Illness
    Its data type is CHAR (Character String) with field length 2
  • DIAG_EFFECT : Effects of Diagnosed Illness
    Its data type is CHAR (Character String) with field length 2
  • DIAG_CATEG : Diagnosis Type
    Its data type is CHAR (Character String) with field length 8
  • DIAG_PHYSICIAN : Physician Responsible for Diagnosis/Test Result
    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_NUMBER : Number of Medical Service
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • 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
  • DIAG_PRESP : Service Provider/Person Responsible
    Its data type is CHAR (Character String) with field length 10
  • DIAG_USRTXT : User-Defined Text Field for Diagnoses
    Its data type is CHAR (Character String) with field length 132
  • DIAG_USRTXTFLG : Long Text Exists for Diagnosis
    Its data type is CHAR (Character String) with field length 1
  • DIAG_CRITICALFLG : Critical Diagnosis
    Its data type is CHAR (Character String) with field length 1