SAP ABAP Table V_TN01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TN01	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
7	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
8	GTEXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
9	KOKFI	☐	KOKFI	KOKFI	CHAR	1	0	Allocation Indicator
10	LAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	PSTLZ	☐	ISH_PLZ	PSTLZ	CHAR	10	0	IS-H: Postal Code
12	ORT	☐	ORT01	TEXT25	CHAR	25	0	City
13	ORT2	☐	ORT02_EINR	TEXT25	CHAR	25	0	IS-H: District of the Institution's Address
14	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
15	INSTNR	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
16	TELF1	☐	TELF	TEXT16	CHAR	16	0	Telephone Number
17	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
18	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
19	SPRAS	☐	EINR_SPRAS	SPRAS	LANG	1	0	IS-H: Language of Institution	T002
20	ARCHIV	☐	ARCHIV	XFELD	CHAR	1	0	IS-H: Archived Data Indicator
21	VKORG	☐	ISH_VKORG	VKORG	CHAR	4	0	IS-H: Sales Organization (Det. Pricing Proc. Pat.Billing)	TVKO
22	VTEXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
23	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
24	KHNUM	☐	ISH_KHNUM	ISH_KHNUM	CHAR	6	0	IS-H: Hospital Number for German Stats. Regulatory Reqs.
25	PRODKZ	☐	ISH_PROD	XFELD	CHAR	1	0	IS-H: Production Indicator for Institution
26	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
27	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
28	HCAT	☐	ISH_KART	ISH_KART	CHAR	2	0	IS-H: Hospital Type / Category	TN18E
29	EANR	☐	NWCH_EANR	CHAR013	CHAR	13	0	IS-H CH: European Article Number (EAN)
30	ZSRNR	☐	NWCH_ZSRNR	CHAR07	CHAR	7	0	IS-H CH: Branch Office Register Number
31	ARTTX	☐	ISH_KARTTXT	ISH_CHAR40	CHAR	40	0	IS-H: Description of hospital type
32	NIFNR	☐	NWCH_NIFNR	CHAR07	CHAR	7	0	IS-H CH: Identification of Supplier/Service Provider
33	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	V_TN01	ADRNR	NADR	ADRNR		1	CN
2	V_TN01	BUKRS	T001	BUKRS	REF	1	CN
3	V_TN01	GSBER	TGSB	GSBER	REF	C	CN
4	V_TN01	HCAT	TN18E	KHART	REF	1	CN
5	V_TN01	LAND	T005	LAND1	KEY	1	CN
6	V_TN01	MANDT	T000	MANDT	KEY	1	1
7	V_TN01	SPRAS	T002	SPRAS	KEY	1	CN
8	V_TN01	VKORG	TVKO	VKORG	REF	C	CN
9	V_TN01	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in