T7EHS00_SRV_DIA SAP (Diagnoses for Person) Table details

Dictionary Type: Table
Description: Diagnoses for Person




ABAP Code to SELECT data from T7EHS00_SRV_DIA
Related tables to T7EHS00_SRV_DIA
Access table T7EHS00_SRV_DIA




Table field list including key, data, relationships and ABAP select examples

T7EHS00_SRV_DIA is a standard SAP Table which is used to store Diagnoses for Person data and is available within R/3 SAP systems depending on the version and release level.

The T7EHS00_SRV_DIA table consists of various fields, each holding specific information or linking keys about Diagnoses for Person data available in SAP. These include PERNR (Personnel number), DIAG_NUMBER (Number of Diagnosis of a Person), DIAG_CTLG (Diagnosis Catalog), DIAG_CODE (Diagnosis Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP T7EHS00_SRV_DIA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PERNRPersonnel number EHS00_PERNRNUMC8EHS00_PERNR
DIAG_NUMBERNumber of Diagnosis of a Person EHS00_DIANUMBERNUMC3NUMC03
DIAG_CTLGDiagnosis Catalog EHS00_DIAG_CATCHAR2T7EHS00_DIAGKTCHAR02EHS00DIAGCTLG
DIAG_CODEDiagnosis Code EHS00_DIAGN_CODECHAR6T7EHS00_DIAGSLDIAGCEHS00_DIAGN_CODE
DIAG_TYPEDiagnosis Key Category EHS00_DIAGN_TYPECHAR1T7EHS00_DIAGNTYCHAR01
DIAG_ONSETDATEStart Date of Diagnosed Illness EHS00_DIA_STRDATEDATS8DATUM
DIAG_RECDATEExamination Date EHS00_SRV_EXADATEDATS8DATUM
DIAG_INACTDATEEnd Date for Diagnosed Illness EHS00_DIA_RESDATEDATS8DATUM
DIAG_SIGNIFDiagnosis Significance EHS00_DIA_SIGNIFCHAR1XFLAG
DIAG_PRIMARYDiagnosis Rating EHS00_DIA_PRIMCHAR1T7EHS00_DIA_PRICHAR01
DIAG_SRCDiagnosis Source EHS00_DIA_SRCCHAR2T7EHS00_DIA_SRCCHAR02
DIAG_CHARACTCause of Illness EHS00_DIA_CHARCHAR2T7EHS00_DIA_CHACHAR02
DIAG_EFFECTEffects of Diagnosed Illness EHS00_DIA_EFFECTCHAR2T7EHS00_DIA_EFFCHAR02
DIAG_CATEGDiagnosis Type EHS00_DIA_CATEGCHAR8T7EHS00_DIA_CATCHAR08
DIAG_PHYSICIANPhysician Responsible for Diagnosis/Test Result EHS00_DIA_PHYSNRCHAR10Assigned to domainALPHABU_PARTNER
PHYSFLAGInternal/External Person EHS00_INEXFLAGCHAR1EHS00_INEXFLAG
SRV_NUMBERNumber of Medical Service EHS00_SRVNUMBERNUMC12NUMC12EHS00SERVNO
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
AEDTMChanged on AEDTMDATS8DATUM
DIAG_PRESPService Provider/Person Responsible EHS00_PRESPCHAR10ALPHAEHS00_PARNR
DIAG_USRTXTUser-Defined Text Field for Diagnoses EHS00E_DIAG_USRTXTCHAR132TEXT132
DIAG_USRTXTFLGLong Text Exists for Diagnosis EHS00E_DIAG_USRTXTFLGCHAR1ESDFLAG
DIAG_CRITICALFLGCritical Diagnosis EHS00E_DIAG_CRITICALFLGCHAR1ESDFLAG

Key field Non-key field



How do I retrieve data from SAP table T7EHS00_SRV_DIA using ABAP code

The following ABAP code Example will allow you to do a basic selection on T7EHS00_SRV_DIA to SELECT all data from the table
DATA: WA_T7EHS00_SRV_DIA TYPE T7EHS00_SRV_DIA.

SELECT SINGLE *
FROM T7EHS00_SRV_DIA
INTO CORRESPONDING FIELDS OF WA_T7EHS00_SRV_DIA
WHERE...

How to access SAP table T7EHS00_SRV_DIA

Within an ECC or HANA version of SAP you can also view further information about T7EHS00_SRV_DIA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!