1. Home
  2. Resources
  3. SAP Tables
  4. TN01 - IS-H: Institutions

SAP Table TN01

IS-H: Institutions

TN01 (IS-H: Institutions) 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 TN01 to other SAP tables.

TN01 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI CHAR 4 0
EINKB IS-H: Short Text for Institution EINKB CHAR 15 0
EINBZ Name of Institution EINBZ CHAR 50 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
LAND Country Key LAND1 T005 CHAR 3 0
PSTLZ IS-H: Postal Code ISH_PLZ CHAR 10 0
ORT City ORT01 CHAR 25 0
ORT2 IS-H: District of the Institution's Address ORT02_EINR CHAR 25 0
STRAS House number and street STRAS CHAR 30 0
INSTNR IS-H: Institute Indicator INSTNR CHAR 10 0
TELF1 Telephone Number TELF CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
SPRAS IS-H: Language of Institution EINR_SPRAS T002 LANG 1 0
ARCHIV IS-H: Archived Data Indicator ARCHIV CHAR 1 0
X Yes
NULL No
VKORG IS-H: Sales Organization (Det. Pricing Proc. Pat.Billing) ISH_VKORG TVKO CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
KHNUM IS-H: Hospital Number for German Stats. Regulatory Reqs. ISH_KHNUM CHAR 6 0
PRODKZ IS-H: Production Indicator for Institution ISH_PROD CHAR 1 0
X Yes
NULL No
ADRNR IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADROB IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
HCAT IS-H: Hospital Type / Category ISH_KART TN18E CHAR 2 0
EANR IS-H CH: European Article Number (EAN) NWCH_EANR CHAR 13 0
ZSRNR IS-H CH: Branch Office Register Number NWCH_ZSRNR CHAR 7 0
NIFNR IS-H CH: Physician NIF number NWCH_NIFNR CHAR 7 0
OBJID Object ID for Institution ISH_OBJID NUMC 8 0
PKV ISH_PKV CHAR 1 0
X Yes
NULL No
ASL_INSTN ASL as Insurance Provider ISH_ASL_KOSTR CHAR 10 0
/ISHFR/CO_INSTNR IS-H FR: Legal FINESS Number of Hospital Chain /ISHFR/ISH_CO_INSTNR CHAR 10 0
/ISHFR/LEGST IS-H FR: Legal Form /ISHFR/LEGST CHAR 2 0
/ISHFR/PRDM IS-H FR: Price Specification /ISHFR/PRDM CHAR 2 0
/ISHFR/PTID Public Treasury ID /ISHFR/ISH_PTID NUMC 6 0
/ISHFR/PTHID Hospital ID /ISHFR/ISH_PTHID NUMC 2 0
/ISHFR/PTO Public Treasury Office /ISHFR/ISH_PTO NUMC 6 0

TN01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TN01 ADRNR TN01 MANDT NADR IS-H: Addresses (Central Address Management) MANDT
TN01 ADRNR TN01 ADRNR NADR IS-H: Addresses (Central Address Management) ADRNR
TN01 ADRNR TN01 ADROB NADR IS-H: Addresses (Central Address Management) ADROB
TN01 BUKRS TN01 MANDT T001 Company Codes MANDT
TN01 BUKRS TN01 BUKRS T001 Company Codes BUKRS
TN01 GSBER TN01 MANDT TGSB Business Areas MANDT
TN01 GSBER TN01 GSBER TGSB Business Areas GSBER
TN01 HCAT TN01 MANDT TN18E IS-H: Types / Categories of Hospital MANDT
TN01 HCAT TN01 HCAT TN18E IS-H: Types / Categories of Hospital KHART
TN01 LAND TN01 LAND T005 Countries LAND1
TN01 LAND TN01 MANDT T005 Countries MANDT
TN01 MANDT TN01 MANDT T000 Clients MANDT
TN01 SPRAS TN01 SPRAS T002 Language Keys (Component BC-I18) SPRAS
TN01 VKORG TN01 MANDT TVKO Organizational Unit: Sales Organizations MANDT
TN01 VKORG TN01 VKORG TVKO Organizational Unit: Sales Organizations VKORG
TN01 WERKS TN01 MANDT T001W Plants/Branches MANDT
TN01 WERKS TN01 WERKS T001W Plants/Branches WERKS