TN01 SAP (IS-H: Institutions) Table details

Dictionary Type: Table
Description: IS-H: Institutions




ABAP Code to SELECT data from TN01
Related tables to TN01
Access table TN01




Table field list including key, data, relationships and ABAP select examples

TN01 is a standard SAP Table which is used to store IS-H: Institutions data and is available within R/3 SAP systems depending on the version and release level.

The TN01 table consists of various fields, each holding specific information or linking keys about IS-H: Institutions data available in SAP. These include EINRI (Institution), EINKB (IS-H: Short Text for Institution), EINBZ (Name of Institution), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP TN01 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EINRIInstitution EINRICHAR4ALPHAEINRIEIN
EINKBIS-H: Short Text for Institution EINKBCHAR15TEXT15
EINBZName of Institution EINBZCHAR50TEXT50
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
LANDCountry Key LAND1CHAR3T005LAND1LND
PSTLZIS-H: Postal Code ISH_PLZCHAR10PSTLZ
ORTCity ORT01CHAR25TEXT25
ORT2IS-H: District of the Institution's Address ORT02_EINRCHAR25TEXT25
STRASHouse number and street STRASCHAR30TEXT30
INSTNRIS-H: Institute Indicator INSTNRCHAR10ALPHAINSTNR
TELF1Telephone Number TELFCHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
SPRASIS-H: Language of Institution EINR_SPRASLANG1T002ISOLASPRAS
ARCHIVIS-H: Archived Data Indicator ARCHIVCHAR1XFELD
VKORGIS-H: Sales Organization (Det. Pricing Proc. Pat.Billing) ISH_VKORGCHAR4TVKOVKORGVKO
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
KHNUMIS-H: Hospital Number for German Stats. Regulatory Reqs. ISH_KHNUMCHAR6ISH_KHNUM
PRODKZIS-H: Production Indicator for Institution ISH_PRODCHAR1XFELD
ADRNRIS-H: Address Number ISH_ADRNRCHAR10NADRALPHAISH_ADRNR
ADROBIS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
HCATIS-H: Hospital Type / Category ISH_KARTCHAR2TN18EALPHAISH_KART
EANRIS-H CH: European Article Number (EAN) NWCH_EANRCHAR13CHAR013
ZSRNRIS-H CH: Branch Office Register Number NWCH_ZSRNRCHAR7CHAR07
NIFNRIS-H CH: Physician NIF number NWCH_NIFNRCHAR7CHAR07
OBJIDObject ID for Institution ISH_OBJIDNUMC8Assigned to domainHROBJIDPON
PKV ISH_PKVCHAR1XFELD
ASL_INSTNASL as Insurance Provider ISH_ASL_KOSTRCHAR10Assigned to domainALPHARI_KUNNR
/ISHFR/CO_INSTNRIS-H FR: Legal FINESS Number of Hospital Chain /ISHFR/ISH_CO_INSTNRCHAR10ALPHAINSTNR
/ISHFR/LEGSTIS-H FR: Legal Form /ISHFR/LEGSTCHAR2ALPHA/ISHFR/LEGST
/ISHFR/PRDMIS-H FR: Price Specification /ISHFR/PRDMCHAR2ALPHA/ISHFR/PRDM
/ISHFR/PTIDPublic Treasury ID /ISHFR/ISH_PTIDNUMC6/ISHFR/ISH_PTID
/ISHFR/PTHIDHospital ID /ISHFR/ISH_PTHIDNUMC2/ISHFR/ISH_PTHID
/ISHFR/PTOPublic Treasury Office /ISHFR/ISH_PTONUMC6/ISHFR/ISH_PTO

Key field Non-key field



How do I retrieve data from SAP table TN01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TN01 to SELECT all data from the table
DATA: WA_TN01 TYPE TN01.

SELECT SINGLE *
FROM TN01
INTO CORRESPONDING FIELDS OF WA_TN01
WHERE...

How to access SAP table TN01

Within an ECC or HANA version of SAP you can also view further information about TN01 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!