SAP Table TNKFA

IS-H: Code Specialties

TNKFA (IS-H: Code Specialties) 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 TNKFA to other SAP tables.

TNKFA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FATYP Category of Specialty Key FATYP CHAR 1 0
0 Key According to Federal Regulation for Hospitals 1995
1 Key According to Federal Regulation for Hospitals (Germany)
2 Key According to Federal Statistical Regulatory Requirements
3 Key According to Nursing Staff Regulation
4 AT: Key According to Krazaf
5 Key for Specialties of Physicians
6 NL: Key According to POLIS
7 Key for Specialty of Organizational Units
8 CA: Key for Billing Group According to OHIP
9 Free for User
A Free for User
B Free for User
C Free for User
D Key According to KHStatV for Special Institutions
FACHR Specialty ISH_FACHR CHAR 4 0
FATXT IS-H: Name of Specialty TEXT_KFA CHAR 30 0
INTEN IS-H: Intensive Care INTEN_KZ CHAR 1 0
X Yes
NULL No
SUBSP IS-H SG: Subspecialty Indicator ISH_SUBSPEC CHAR 1 0
X Yes
NULL No
OBSTE IS-H: Indicator for Obstetrics Department ISH_OBSTE CHAR 1 0
X Yes
NULL No
EXTKZ IS-H: Indicator "Can Be Used by External Resource" ISH_EXTKZ CHAR 1 0
X On
NULL Off
UNQCD IS-H: Unique Code for Assigning External Codes ISH_UNQCD CHAR 3 0

TNKFA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TNKFA MANDT TNKFA MANDT T000 Clients MANDT