SAP Table NFKL

IS-H: Case classification

NFKL (IS-H: Case classification) 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 NFKL to other SAP tables.

NFKL 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
KLFTYP IS-H: Classification Category KLFTYP TNKTY CHAR 2 0
KLFART IS-H: Classification Type KLFART TNKLA CHAR 2 0
FKLEDT IS-H: Validity End Date of Classification FKLEDT DATS 8 0
FKLEZT IS-H: Validity End Time of Classification FKLEZT TIMS 6 0
FKLBDT IS-H: Validity Start Date of Classification FKLBDT DATS 8 0
FKLBZT IS-H: Validity Start Time of Classification FKLBZT TIMS 6 0
KLFART_INT IS-H: IS-H-Internal Key for Case Classification Type KLFART_INT CHAR 2 0
01 Adults
02 Premature Infants/Newborns/Infants
03 Children
04 School Children/Adolescents
10 Chief Physician Choice
11 External Physician Choice
12 Workers Compensation Therapy
20 Healthy Newborn
21 Sick Newborn
30 Main Department and External Midwife
31 External Operating Surgeon
32 External Operating Surgeon and External Anesthetist
33 External Operating Surgeon and External Midwife
34 Ext. Operating Surgeon and Ext. Anesthetist and Ext. Midwife
35 External Physician with Fee Contract
40 General Accomodation Class
41 Special Class Private Room
42 Special Class Semi-Private Room
45 Industrial Accident
50 Accommodation
51 General Class
52 Semi-Private Class
53 Private Class
54 Intensive Care Category
99 Other
55 Special Class Two-Bed Room
60 Statutory Accommodation
61 Complex Psychotherapy
62 Complex Psychosomatic Psychotherapy
71 Level of Care (GIR) 1
72 Level of Care (GIR) 2
73 Level of Care (GIR) 3
74 Level of Care (GIR) 4
75 Level of Care (GIR) 5
76 Level of Care (GIR) 6
PGRA IS-H: Classification with Regard to "General Nursing Care" PGRA CHAR 5 0
0 No Service
1 Basic Services
2 Additional Services
3 Special Services
4 Complex Services
PGRS IS-H: Classification with Regard to "Special Nursing Care" PGRS CHAR 5 0
0 No Service
1 Basic Services
2 Additional Services
3 Special Services
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 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
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No

NFKL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NFKL EINRI NFKL EINRI TN01 IS-H: Institutions EINRI
NFKL EINRI NFKL MANDT TN01 IS-H: Institutions MANDT
NFKL FALNR NFKL MANDT NFAL IS-H: Cases MANDT
NFKL FALNR NFKL EINRI NFAL IS-H: Cases EINRI
NFKL FALNR NFKL FALNR NFAL IS-H: Cases FALNR
NFKL KLFART NFKL MANDT TNKLA IS-H: Classification Types for Case Classific. Categories MANDT
NFKL KLFART NFKL KLFTYP TNKLA IS-H: Classification Types for Case Classific. Categories KLFTYP
NFKL KLFART NFKL KLFART TNKLA IS-H: Classification Types for Case Classific. Categories KLFART
NFKL KLFTYP NFKL KLFTYP TNKTY IS-H: Case Classification Categories KLFTYP
NFKL KLFTYP NFKL MANDT TNKTY IS-H: Case Classification Categories MANDT
NFKL MANDT NFKL MANDT T000 Clients MANDT