1. Home
  2. Resources
  3. SAP Tables
  4. NDIA - IS-H: Diagnoses

SAP Table NDIA

IS-H: Diagnoses

NDIA (IS-H: Diagnoses) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NDIA to other SAP tables.

NDIA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
FALNR IS-H: Case Number FALNR NFAL CHAR 10 0
LFDNR IS-H: Sequence Number of Diagnosis LFDDIA NUMC 3 0
LFDBEW IS-H: Sequence Number of Movement LFDBEW NUMC 5 0
BELNR IS-H: Document Number of IV Document/Treatment Certificate KS_BELNR NKSK CHAR 10 0
DKAT1 IS-H: Identification Key of Diagnosis Coding Catalog DIAKAT TNK00 CHAR 2 0
DKEY1 IS-H: Diagnosis Code DIAID NKDI CHAR 30 0
DKAT2 IS-H: Identification Key of Diagnosis Coding Catalog DIAKAT TNK00 CHAR 2 0
DKEY2 IS-H: Diagnosis Code DIAID NKDI CHAR 30 0
DKAT_REF IS-H: Catalog ID of Reference Catalog for Statistics REF_DIAKAT TNK00 CHAR 2 0
DKEY_REF IS-H: Reference Diagnosis Code for Statistics REF_DIAID NKDI CHAR 30 0
DITXT Free Text for Diagnosis ISH_DITEXT CHAR 50 0
DILTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
DIADT IS-H: Date on which Diagnosis Was Created DIADT DATS 8 0
DIAZT IS-H: Time at which Diagnosis Created DIAZT TIMS 6 0
DIAPE IS-H: Identification of Diagnosing Person DIA_PERS NGPA CHAR 10 0
ANZOP IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis ANZOP NUMC 2 0
EWDIA IS-H: Referral Diagnosis Indicator KZ_EINWD CHAR 1 0
X Yes
NULL No
BHDIA IS-H: Treatment Diagnosis Indicator KZ_BEHLD CHAR 1 0
X Yes
NULL No
AFDIA IS-H: Admission Diagnosis Indicator KZ_AUFND CHAR 1 0
X Yes
NULL No
ENDIA IS-H: "Discharge Diagnosis" Indicator KZ_ENTLD CHAR 1 0
X Yes
NULL No
FHDIA IS-H: "Department Main Diagnosis" Indicator KZ_FAHPD CHAR 1 0
X Yes
NULL No
KHDIA IS-H: Hospital Main Diagnosis Indicator KZ_KHHPD CHAR 1 0
X Yes
NULL No
OPDIA IS-H: Surgery Diagnosis Indicator KZ_OPERD CHAR 1 0
X Yes
NULL No
SPERR Blocking Indicator RI_SPERR CHAR 1 0
X Yes
NULL No
KZTXT IS-H: Comment on Diagnosis TEXT_DIA CHAR 50 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
DIASI IS-H: Diagnostic Certainty DIASI CHAR 1 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
STDAT Date of Cancellation STORN_DAT DATS 8 0
ARDIA Working Diagnosis Indicator N2_KZARDIA CHAR 1 0
X Yes
NULL No
PODIA Preoperative Diagnosis Indicator N2_KZPODIA CHAR 1 0
X Yes
NULL No
TUDIA IS-H: Cause of Death Indicator N2_KZTUDIA CHAR 1 0
X Yes
NULL No
DIABZ Diagnosis Reference N2_DIABZ CHAR 1 0
X Yes
NULL No
DIAPR Medical Secondary Diagnosis Indicator N2_DIAPR TN26B CHAR 1 0
DIAGW Diagnostic Certainty N2_DIASI TN26C CHAR 2 0
DIAZS Diagnostic Suppl. N2_DIAZS TN26D CHAR 2 0
DIALO IS-H: Localization of Diagnosis N2_DIALO TN26E CHAR 2 0
EXTID Internal Identifier of the Diagnosis Coding Tool N2_EXTID CHAR 8 0
DIAFP Flat Rate per Case N2_DIAFP CHAR 8 0
REFKY Reference Code of Diagnosis from External System DIA_REFKEY CHAR 20 0
DRG_DIA_SEQNO IS-H: Consecutive Numbering of DRG Diagnosis ISH_DRG_DIA_NB NUMC 6 0
DRG_CATEGORY IS-H: Category of DRG Diagnosis (Principal, Secondary) ISH_DRG_DIA_CATEGORY CHAR 1 0
P Principal Diagnosis
S Secondary Diagnosis
NULL No DRG Diagnosis
DRG_CC IS-H: Comorbidity and Complication (DRG Diagnosis) ISH_DRG_DIA_CC CHAR 1 0
X On
NULL Off
DRG_RELVANT IS-H: Used to Determine DRG ISH_DRG_DIA_RELEVANT CHAR 1 0
X On
NULL Off
DTYP1 Type for ICD-10 Diagnoses ISH_ICD10_DIATYP CHAR 1 0
* Asterisk Diagnosis
! Supplementary Diagnosis
+ Dagger Diagnosis
NULL Non-Classified Diagnosis
# Pound Sign Code (AT)
M Morphology Diagnosis (SG)
DTYP2 Type for ICD-10 Diagnoses ISH_ICD10_DIATYP CHAR 1 0
* Asterisk Diagnosis
! Supplementary Diagnosis
+ Dagger Diagnosis
NULL Non-Classified Diagnosis
# Pound Sign Code (AT)
M Morphology Diagnosis (SG)
DTYP_REF Type for ICD-10 Diagnoses ISH_ICD10_DIATYP CHAR 1 0
* Asterisk Diagnosis
! Supplementary Diagnosis
+ Dagger Diagnosis
NULL Non-Classified Diagnosis
# Pound Sign Code (AT)
M Morphology Diagnosis (SG)
ALTERN_DIATXT IS-H: Alternative Diagnosis Text (from External System) ISH_ALTERN_DIATXT CHAR 132 0
TCODE IS-H: Report Control: Transaction Code for Application ISH_TCODE CHAR 20 0
DIA_LINK IS-H: Link to Another Diagnosis ISH_DIA_LINK NUMC 3 0
CCL IS-H: Complication Level of Diagnoses (for DRGs) ISH_CCL NUMC 3 0
000 No Severity
001 Minor Severity
002 Moderate Severity
003 Major Severity
004 Catastrophic Severity
TIMESTAMP Timestamp in Short Form (YYYYMMDDhhmmss) ISH_TIMESTAMP DEC 15 0
DIAG_EXCF ISH_DIA_EXCEPTION_FACTS CHAR 240 0
/ISHFR/FHDIAKZ IS-H FR: Associated Department Main Diagnosis /ISHFR/FHDIAKZ CHAR 1 0
QUALF Diagnosis Qualifier ISH_DIA_QUALF CHAR 5 0
DRG_IMPACT Impact of Diagnosis on DRG Determination ISH_DIA_DRG_IMPACT CHAR 2 0

NDIA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NDIA BELNR NDIA MANDT NKSK IS-H: Insurance verification/certificate - Header data MANDT
NDIA BELNR NDIA BELNR NKSK IS-H: Insurance verification/certificate - Header data BELNR
NDIA DIAGW NDIA EINRI TN26C IS-H: Diagnostic Certainty EINRI
NDIA DIAGW NDIA DIAGW TN26C IS-H: Diagnostic Certainty DIASI
NDIA DIAGW NDIA MANDT TN26C IS-H: Diagnostic Certainty MANDT
NDIA DIALO NDIA MANDT TN26E IS-H: Definition of Medical Localizations MANDT
NDIA DIALO NDIA EINRI TN26E IS-H: Definition of Medical Localizations EINRI
NDIA DIALO NDIA DIALO TN26E IS-H: Definition of Medical Localizations DIALO
NDIA DIAPE NDIA DIAPE NGPA IS-H: Business Partners GPART
NDIA DIAPE NDIA MANDT NGPA IS-H: Business Partners MANDT
NDIA DIAPR NDIA MANDT TN26B IS-H*MED: Diagnosis Priority MANDT
NDIA DIAPR NDIA EINRI TN26B IS-H*MED: Diagnosis Priority EINRI
NDIA DIAPR NDIA DIAPR TN26B IS-H*MED: Diagnosis Priority DIAPR
NDIA DIAZS NDIA MANDT TN26D IS-H*MED: Diagnostic Supplement MANDT
NDIA DIAZS NDIA EINRI TN26D IS-H*MED: Diagnostic Supplement EINRI
NDIA DIAZS NDIA DIAZS TN26D IS-H*MED: Diagnostic Supplement DIAZS
NDIA DKAT1 NDIA MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
NDIA DKAT1 NDIA DKAT1 TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
NDIA DKAT2 NDIA MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
NDIA DKAT2 NDIA DKAT2 TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
NDIA DKAT_REF NDIA MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
NDIA DKAT_REF NDIA DKAT_REF TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
NDIA DKEY1 NDIA MANDT NKDI IS-H: Diagnosis Coding Catalogs MANDT
NDIA DKEY1 SY LANGU NKDI IS-H: Diagnosis Coding Catalogs SPRAS
NDIA DKEY1 NDIA DKAT1 NKDI IS-H: Diagnosis Coding Catalogs DKAT
NDIA DKEY1 NDIA DKEY1 NKDI IS-H: Diagnosis Coding Catalogs DKEY
NDIA DKEY2 SY LANGU NKDI IS-H: Diagnosis Coding Catalogs SPRAS
NDIA DKEY2 NDIA DKAT2 NKDI IS-H: Diagnosis Coding Catalogs DKAT
NDIA DKEY2 NDIA DKEY2 NKDI IS-H: Diagnosis Coding Catalogs DKEY
NDIA DKEY2 NDIA MANDT NKDI IS-H: Diagnosis Coding Catalogs MANDT
NDIA DKEY_REF NDIA DKAT_REF NKDI IS-H: Diagnosis Coding Catalogs DKAT
NDIA DKEY_REF NDIA DKEY_REF NKDI IS-H: Diagnosis Coding Catalogs DKEY
NDIA DKEY_REF NDIA MANDT NKDI IS-H: Diagnosis Coding Catalogs MANDT
NDIA DKEY_REF SY LANGU NKDI IS-H: Diagnosis Coding Catalogs SPRAS
NDIA EINRI NDIA MANDT TN01 IS-H: Institutions MANDT
NDIA EINRI NDIA EINRI TN01 IS-H: Institutions EINRI
NDIA FALNR NDIA MANDT NFAL IS-H: Cases MANDT
NDIA FALNR NDIA EINRI NFAL IS-H: Cases EINRI
NDIA FALNR NDIA FALNR NFAL IS-H: Cases FALNR
NDIA MANDT NDIA MANDT T000 Clients MANDT