T7EHS00_DIAGSL SAP table for – Diagnosis Key

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

SAP T7EHS00_DIAGSL table

Table T7EHS00_DIAGSL technical data

TableT7EHS00_DIAGSL
Data storingDiagnosis Key
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP T7EHS00_DIAGSL 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_DIAGSL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DIAGN_CTLG : Diagnosis Catalog
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DIAGN_CODE : Diagnosis Code
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DIAGN_TYPE : Diagnosis Key Category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DIAGN_GROUP : Diagnosis Group
    Its data type is CHAR (Character String) with field length 1
  • DIAGN_PRIO : Diagnosis Priority
    Its data type is CHAR (Character String) with field length 1
  • LUSER : User Name
    Its data type is CHAR (Character String) with field length 12
  • LDATE : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8