| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TNPEPP | IS-H: PEPP Billing Parameters for Psychiatry/Psychosomatics | 6 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| TOPBasic Data |
| 2 | NORG | IS-H: Organizational Units | 19 | FACHR | Specialty According to Federal Regulation for Hospitals | nvarchar | 4 | 0 | | |
| 3 | NPEF | IS-H: Persons - Assignment to Specialties | 4 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| 4 | NPER | IS-H: Persons | 25 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| 5 | TNCDF4 | IS-H: DRG Coding and Grouping System Payer Determination | 5 | FACHR | Specialty for Organizational Unit | nvarchar | 4 | 0 | | |
| 6 | TNKFA | IS-H: Code Specialties | 3 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| 7 | TNKFO | IS-H: Specialty-to-Organizational Unit Assignment | 3 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| TOPClinical System |
| 8 | N1PRFAL | IS-H*MED: PATREG: Fälle | 24 | FACHR | IS-H: Organizasyon birimi için uzmanlik alani | nvarchar | 4 | 0 | | |
| 9 | N2DOCFAL | IS-H*MED: Case Data for Archived Documents | 59 | FACHR | Specialty for Organizational Unit | nvarchar | 4 | 0 | | |
| TOPHospital Structure |
| 10 | HRT6084 | Table Part Infotype 6084 | 5 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| TOPPatient Accounting |
| 11 | NVBRP | IS-H: Billing document item data | 77 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| TOPPatient Management |
| 12 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 23 | FACHR | Specialty for Physicians | nvarchar | 4 | 0 | | |
| 13 | NBEW | IS-H: Movements for Case | 69 | FACHR | Specialty for Physicians | nvarchar | 4 | 0 | | |
| 14 | NFAL | IS-H: Cases | 59 | FACHR | Specialty for Organizational Unit | nvarchar | 4 | 0 | | |
| 15 | NTPGP | IS-H: Day program items (possible appointments) | 16 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| TOPPersonnel Administration |
| 16 | T517Y | Specialty validation table | 2 | FACHR | Branch of study | nvarchar | 5 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 17 | /ISHFR/TNGAPH | IS-H FR: Supplements (Header Data) | 4 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| 18 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 4 | FACHR | Specialty | nvarchar | 4 | 0 | | |
| 19 | NBQS_FACHR | BQS: Assignment of Specialty to Specialty Categories | 3 | FACHR | Specialty According to Federal Regulation for Hospitals | nvarchar | 4 | 0 | | |
| 20 | NLPORTAL_DOC | Portal medizinische brief | 3 | FACHR | IS-H: Fachrichtung | nvarchar | 4 | 0 | | |
| 21 | NLVERZF_002 | Konversion SAP Facharzt nach VEKTIS Sorge arzt | 4 | FACHR | IS-H: Specialisme | nvarchar | 4 | 0 | | |
| 22 | NLVERZF_011 | Konversion leistungcode SAP nach leistungcode VEKTIS | 4 | FACHR | IS-H: Specialisme | nvarchar | 4 | 0 | | |
| 23 | NNLEPB2 | ISH NL: EPB Facharzt die mitmachen in EPB | 3 | FACHR | IS-H: Specialisme | nvarchar | 4 | 0 | | |
| 24 | NNLREF | Interne Referenz | 5 | FACHR | Fachrichtung nach Bundespflegesatzverordnung | nvarchar | 4 | 0 | | |
| 25 | TNLDBC_TRDBC4 | IS-H NL: Dummy DBC pro ausfuhrend arzt | 3 | FACHR | IS-H: Specialisme | nvarchar | 4 | 0 | | |
| 26 | TNLGGZ_PARAM | Geisteskrankheit parameter tabelle | 9 | FACHR | IS-H: Fachrichtung | nvarchar | 4 | 0 | | |
