SAP ABAP Table TN01 (IS-H: Institutions)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       NBAS (Package) Appl. development Hospital System master data, catalogs
Basic Data
Table Category TRANSP    Transparent table 
Transparent table TN01   Table Relationship Diagram
Short Description IS-H: Institutions    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution  
3 EINKB EINKB TEXT15 CHAR 15   0   IS-H: Short Text for Institution  
4 EINBZ EINBZ TEXT50 CHAR 50   0   Name of Institution  
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
7 LAND LAND1 LAND1 CHAR 3   0   Country Key T005
8 PSTLZ ISH_PLZ PSTLZ CHAR 10   0   IS-H: Postal Code  
9 ORT ORT01 TEXT25 CHAR 25   0   City  
10 ORT2 ORT02_EINR TEXT25 CHAR 25   0   IS-H: District of the Institution's Address  
11 STRAS STRAS TEXT30 CHAR 30   0   House number and street  
12 INSTNR INSTNR INSTNR CHAR 10   0   IS-H: Institute Indicator  
13 TELF1 TELF TEXT16 CHAR 16   0   Telephone Number  
14 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
15 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
16 SPRAS EINR_SPRAS SPRAS LANG 1   0   IS-H: Language of Institution T002
17 ARCHIV ARCHIV XFELD CHAR 1   0   IS-H: Archived Data Indicator  
18 VKORG ISH_VKORG VKORG CHAR 4   0   IS-H: Sales Organization (Det. Pricing Proc. Pat.Billing) TVKO
19 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
20 KHNUM ISH_KHNUM ISH_KHNUM CHAR 6   0   IS-H: Hospital Number for German Stats. Regulatory Reqs.  
21 PRODKZ ISH_PROD XFELD CHAR 1   0   IS-H: Production Indicator for Institution  
22 ADRNR ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
23 ADROB ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
24 HCAT ISH_KART ISH_KART CHAR 2   0   IS-H: Hospital Type / Category TN18E
25 EANR NWCH_EANR CHAR013 CHAR 13   0   IS-H CH: European Article Number (EAN)  
26 ZSRNR NWCH_ZSRNR CHAR07 CHAR 7   0   IS-H CH: Branch Office Register Number  
27 NIFNR NWCH_NIFNR CHAR07 CHAR 7   0   IS-H CH: Identification of Supplier/Service Provider  
28 PKV ISH_PKV XFELD CHAR 1   0   Kennzeichen: §301-PKV-Modul im Einsatz  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TN01 ADRNR NADR ADRNR 1 CN
2 TN01 BUKRS T001 BUKRS REF 1 CN
3 TN01 GSBER TGSB GSBER REF C CN
4 TN01 HCAT TN18E KHART REF 1 CN
5 TN01 LAND T005 LAND1 KEY 1 CN
6 TN01 MANDT T000 MANDT KEY 1 1
7 TN01 SPRAS T002 SPRAS KEY 1 CN
8 TN01 VKORG TVKO VKORG REF C CN
9 TN01 WERKS T001W WERKS KEY 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in