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
⤷ 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 |