SAP Table NKDI

IS-H: Diagnosis Coding Catalogs

NKDI (IS-H: Diagnosis Coding Catalogs) 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 NKDI to other SAP tables.

NKDI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SPRAS Language Key SPRAS T002 LANG 1 0
DKAT IS-H: Catalog Identification KATID TNK00 CHAR 2 0
DKEY IS-H: Diagnosis Code DIAID CHAR 30 0
REF_DKAT IS-H: Identification Key of Reference Catalog REF_KATID TNK00 CHAR 2 0
REF_DKEY IS-H: Reference Diagnosis Code for Statistics REF_DIAID NKDI CHAR 30 0
DTEXT1 Diagnosis Text DIATXT CHAR 40 0
DTEXT2 Diagnosis Text DIATXT CHAR 40 0
DTEXT3 Diagnosis Text DIATXT CHAR 40 0
DGRPKZ IS-H: "Diagnosis Group" Indicator KZ_DIAGRP CHAR 1 0
X Yes
NULL No
HITLIKZ IS-H: Hit List Indicator ISH_HITLI CHAR 1 0
X Yes
NULL No
GSCHL IS-H: Sex Indicator - Internal GSCHL CHAR 1 0
1 male
2 female
3 unknown
ALTBIS Diagnosis Valid To (Years) N2_ALTBIS NUMC 3 0
ALTVON Diagnosis Valid From (Years) N2_ALTVON NUMC 3 0
STRUKTM Diagnosis Flagged as Generic Header N2_STRUKTM CHAR 1 0
X Yes
NULL No
CLFIND IS-H: User-Defined Indicator for Cst-Spec. Classification ISH_CLFIND CHAR 4 0
STDTEXT Standardized Short Text for Diagnoses DIASTTXT CHAR 150 0
DTYP 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)
ICD10GM_P301 IS-H: DE - Inpatient Use of Diagnosis Code ISH_ICD10GM_P301 CHAR 1 0
P Authorized for Primary Coding
O Authorized only as Asterisk Code Number
Z Authorized only as Exclamation Point Code Number
V Not Authorized for Coding
NULL No Restrictions
ICD10GM_P295 IS-H: DE - Use of Diagnosis Code Paragraph 295 ISH_ICD10GM_P295 CHAR 1 0
P Authorized for Primary Coding
O Authorized only as Asterisk Code Number
Z Authorized only as Exclamation Point Code Number
V Not Authorized for Coding
NULL No Restrictions
/ISHFR/DIATYP IS-H FR: Diagnosis Type /ISHFR/DIATYP CHAR 1 0
0 No Restriction
1 Not Allowed as Department Main Diagnosis
2 Not Allowed as Department Main Diagnosis (ex rsn morbidity)
3 Not Allowed as Department Main Diagnosis (No Group)

NKDI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NKDI DKAT NKDI MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
NKDI DKAT NKDI DKAT TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
NKDI MANDT NKDI MANDT T000 Clients MANDT
NKDI REF_DKAT NKDI REF_DKAT TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
NKDI REF_DKAT NKDI MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
NKDI REF_DKEY NKDI MANDT NKDI IS-H: Diagnosis Coding Catalogs MANDT
NKDI REF_DKEY NKDI SPRAS NKDI IS-H: Diagnosis Coding Catalogs SPRAS
NKDI REF_DKEY NKDI REF_DKAT NKDI IS-H: Diagnosis Coding Catalogs DKAT
NKDI REF_DKEY NKDI REF_DKEY NKDI IS-H: Diagnosis Coding Catalogs DKEY
NKDI SPRAS NKDI SPRAS T002 Language Keys (Component BC-I18) SPRAS