SAP ABAP Table RNF18 (IS-H: Invoice Form: Patient Data/Case/Diagnosis)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPAS (Package) Application development patient accounting system

Basic Data

Table Category	INTTAB	Structure
Structure	RNF18	Table Relationship Diagram
Short Description	IS-H: Invoice Form: Patient Data/Case/Diagnosis

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
2	AUFDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
3	AUFZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
4	ENTDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
5	ENTZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
6	AUFOFAKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
7	AUFOPFKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
8	ORGFA	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
9	ORGPF	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
10	AUFBWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
11	AUFBWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
12	ENTBWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
13	ENTBWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
14	ENTOFAKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
15	ENTOPFKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
16	ENTORGFA	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
17	ENTORGPF	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
18	ENTBWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	*
19	CONCATPAT	☐	N_CONC_NAM	CHAR50	CHAR	50	0	Composite Name of a Person
20	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
21	FPEDT	☐	ISH_FPEDT	ISH_FPEDT	DATS	8	0	IS-H: Date of Wound Healing
22	TOB	☐	ISH_TOB		NUMC	3	0	IS-H: Days Without Calculation
23	CONSENT	☐	ISH_CONSENT	XFELD	CHAR	1	0	PKV P301: Einwilligung zur elektronischen Datenübertragung
24	.INCLUDE	☐				0	0	IS-H: Form Layout for Diagnoses at Admission
25	EINDKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
26	EINDKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
27	EINDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
28	EINDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
29	EINDITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
30	EINDLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
31	EINDGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
32	EINDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
33	AUFDKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
34	AUFDKEY	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
35	AUFDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
36	AUFDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
37	AUFDITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
38	AUFDLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
39	AUFDGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
40	AUFDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
41	EINRDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
42	EINRDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
43	EINRDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
44	EINRDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
45	EINRDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
46	AUFRDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
47	AUFRDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
48	AUFRDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
49	AUFRDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
50	AUFRDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
51	EIN2DKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
52	EIN2DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
53	EIN2DIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
54	EIN2DIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
55	EIN2DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
56	EIN2DLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
57	EIN2DGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
58	EIN2DTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
59	AUF2DKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
60	AUF2DKEY	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
61	AUF2DIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
62	AUF2DIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
63	AUF2DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
64	AUF2DLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
65	AUF2DGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
66	AUF2DTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
67	EIN2RDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
68	EIN2RDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
69	EIN2RDKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
70	EIN2RDKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
71	EIN2RDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
72	AUF2RDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
73	AUF2RDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
74	AUF2RDKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
75	AUF2RDKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
76	AUF2RDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
77	.INCLUDE	☐				0	0	IS-H: Form Layout for Diagnoses at Discharge
78	ENTDKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
79	ENTDKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
80	ENTDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
81	ENTDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
82	ENTDITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
83	ENTDLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
84	ENTDGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
85	ENTDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
86	KHDDKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
87	KHDDKEY	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
88	KHDDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
89	KHDDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
90	KHDDITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
91	KHDDLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
92	KHDDGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
93	KHDDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
94	ENTRDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
95	ENTRDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
96	ENTRDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
97	ENTRDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
98	ENTRDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
99	KHDRDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
100	KHDRDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
101	KHDRDIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
102	KHDRDIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
103	KHDRDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
104	ENT2DKAT	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
105	ENT2DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
106	ENT2DIKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
107	ENT2DIKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
108	ENT2DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
109	ENT2DLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
110	ENT2DGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
111	ENT2DTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
112	ENT2RDKAT	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
113	ENT2RDKEY	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
114	ENT2RDKTXT	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
115	ENT2RDKTX2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
116	ENT2RDTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
117	.INCLUDE	☐				0	0	IS-H: Billing structure for surgical procedures
118	ICBWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
119	ICBWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
120	ICBWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
121	ICBWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
122	ICORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	*
123	ICFAKEY	☐	FACHRTY1	ISH_FACHR	CHAR	4	0	IS-H: Specialty acc. to Federal Reg. for Hospitals (Germany)	*
124	ICORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	*
125	ICTARLS	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog	*
126	ICTARLSTXT	☐	TARKTXT1	LEIKTXT	CHAR	40	0	IS-H: First Short Text for Service
127	ICPMK	☐	ICPM_ID	TARID	CHAR	2	0	IS-H: Identification of Surgical Procedure Coding Catalog	*
128	ICPML	☐	ICPM_LS	TARLS	CHAR	10	0	IS-H: Surgical Procedure Code (Service)	*
129	ICPTXT	☐	OP_TEXT	LEIKTXT	CHAR	40	0	IS-H: Short Text for Surgical Procedure Code
130	ICPHC	☐	ICPM_HCODE	XFELD	CHAR	1	0	IS-H: Main Surgical Procedure Code
131	ICDITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
132	ICDKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog
133	ICDKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code
134	ICDKAT_REF	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics
135	ICDKEY_REF	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics
136	ICDIATXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
137	ICDIATXT2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
138	ICDIATXTR1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
139	ICDIATXTR2	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
140	ICANZOP	☐	ISH_ANZOP	NUMC3	NUMC	3	0	IS-H: Number of Additional Surgeries
141	ICDLO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	*
142	ICDGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	*
143	ICD1TYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
144	ICDREFTYP	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
145	.INCLUDE	☐				0	0	IS-H: Patient Master Data (General)
146	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
147	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
148	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
149	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
150	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
151	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
152	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
153	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
154	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
155	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
156	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
157	NAME2	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
158	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
159	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
160	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
161	GLAND	☐	GLAND	LAND1	CHAR	3	0	IS-H: Country of Birth	T005
162	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
163	TODDT	☐	TODDV	RI_DATUM	DATS	8	0	IS-H: Date of Death From
164	TODZT	☐	TODZV	UHRZT	TIMS	6	0	Time of Death From
165	TODDB	☐	TODDB	RI_DATUM	DATS	8	0	Date of Death To
166	TODZB	☐	TODZB	UHRZT	TIMS	6	0	IS-H: Time of Death To
167	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	TN18A
168	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
169	FAMST	☐	RI_FAMST	RI_FAMST	CHAR	1	0	IS-H: Marital Status
170	KONFE	☐	RI_KONFE	RI_KONFE	CHAR	2	0	IS-H: Religion
171	NATIO	☐	RI_NATIO	LAND1	CHAR	3	0	IS-H: Nationality	T005
172	SPRAS	☐	SPRAS_PAT	SPRAS	LANG	1	0	Patient Language	T002
173	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
174	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
175	ORT	☐	ORT01_PAT	TEXT25	CHAR	25	0	IS-H: City where Patient Resides
176	ORT2	☐	ORT02_PAT	TEXT25	CHAR	25	0	Patient District
177	STRAS	☐	STRAS_PAT	STRAS	CHAR	30	0	IS-H: Street and House Number of Patient
178	BLAND	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
179	GEBIE	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
180	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
181	SPEND	☐	SPENKZ	XFELD	CHAR	1	0	IS-H: Organ Donor Indicator
182	SPENT	☐	SPENTEXT	TEXT50	CHAR	50	0	Explanation for Donor Indicator
183	SPELT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
184	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
185	ARCHV	☐	ARCHIV	XFELD	CHAR	1	0	IS-H: Archived Data Indicator
186	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
187	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
188	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
189	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
190	RFPAT	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
191	RFZIF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
192	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
193	AGNUM	☐	AGNUM_PAT	RI_KUNNR	CHAR	10	0	IS-H: Patient's Employer	NGPA
194	AGNAM	☐	AGNAM	TEXT30	CHAR	30	0	IS-H: Employer Name
195	AGLAN	☐	AGLAN	LAND1	CHAR	3	0	IS-H: Employer Country	T005
196	AGPLZ	☐	AGPLZ	PSTLZ	CHAR	10	0	IS-H: Employer Postal Code
197	AGORT	☐	AGORT	TEXT25	CHAR	25	0	IS-H: Employer City
198	AGSTR	☐	AGSTR	STRAS	CHAR	30	0	IS-H: Employer Street
199	AGTEL	☐	AGTEL	TEXT16	CHAR	16	0	IS-H: Employer Telephone Number
200	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
201	ANNA1	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
202	ANVN1	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
203	ANLA1	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
204	ANPL1	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
205	ANOR1	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
206	ANST1	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
207	ANTE1	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
208	ANVV1	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
209	VMKZ1	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
210	ANNA2	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
211	ANVN2	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
212	ANLA2	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
213	ANPL2	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
214	ANOR2	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
215	ANST2	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
216	ANTE2	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
217	ANVV2	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
218	VMKZ2	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
219	KZTXT	☐	TEXT_PAT	TEXT50	CHAR	50	0	IS-H: Comment on Patient
220	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
221	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
222	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
223	HISTK	☐	RI_HISTK	XFELD	CHAR	1	0	Indicator that History Records Are Available
224	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
225	TESTP	☐	TESTP	XFELD	CHAR	1	0	Test Patient Status
226	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
227	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
228	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
229	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
230	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
231	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
232	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
233	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
234	GBORT	☐	ISH_GBORT	TEXT25	CHAR	25	0	IS-H: Patient Birthplace
235	HARNR	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	NGPA
236	EARNR	☐	EARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
237	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
238	RACE	☐	ISH_RACE	ISH_RACE	CHAR	2	0	IS-H: Race	TN17R
239	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
240	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
241	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
242	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
243	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
244	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
245	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
246	ADNN1	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
247	ADON1	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
248	ADNN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
249	ADON2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
250	ANEX1	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
251	ANEX2	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
252	ADRN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
253	ADRO2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
254	INACT	☐	ISH_INACTIVE	XFELD	CHAR	1	0	'Inactive' Indicator
255	USER1	☐	ISH_PATUSER1	ISH_PATUSER1	CHAR	20	0	IS-H: User-Defined Field 1
256	USER2	☐	ISH_PATUSER2	ISH_PATUSER2	CHAR	20	0	IS-H: User-Defined Field 2
257	USER3	☐	ISH_PATUSER3	ISH_PATUSER3	DATS	8	0	IS-H: User-Defined Field 3
258	USER4	☐	ISH_PATUSER4	ISH_PATUSER4	DATS	8	0	IS-H: User-Defined Field 4
259	USER5	☐	ISH_PATUSER5	ISH_PATUSER5	CHAR	50	0	IS-H: User-Defined Field 5
260	USER6	☐	ISH_PATUSER6	ISH_PATUSER6	CHAR	1	0	IS-H: User-Defined Field 6
261	EXTAUFG	☐	EXTAUFG	XFELD	CHAR	1	0	IS-H: Kennzeichen externer Auftraggeber
262	EXTAUFGA	☐	EXTAUFGA	EXTAUFGA	CHAR	2	0	IS-H: EA Externe Auftraggeberart	TNWCHEA16
263	EMPSC	☐	ISH_EMPDAT	RI_DATUM	DATS	8	0	IS-H: Employed Since
264	UNKNOWN_GBDAT	☐	ISH_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Geburtsdatum nicht genau bekannt
265	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNF18	ADNAG	NADR	ADRNR		1	CN
2	RNF18	ADNN1	NADR	ADRNR		1	CN
3	RNF18	ADNN2	NADR	ADRNR		1	CN
4	RNF18	ADRN2	NADR	ADRNR	REF	1	C
5	RNF18	ADRNR	NADR	ADRNR		1	CN
6	RNF18	AGLAN	T005	LAND1
7	RNF18	AGNUM	NGPA	GPART
8	RNF18	ANLA1	T005	LAND1
9	RNF18	ANLA2	T005	LAND1
10	RNF18	ANVV1	TN17B	VERVA
11	RNF18	ANVV2	TN17B	VERVA
12	RNF18	AUFDKAT	TNK00	KATID
13	RNF18	BLAND	T005S	BLAND
14	RNF18	EARNR	NGPA	GPART	REF	1	CN
15	RNF18	EINDKAT	TNK00	KATID
16	RNF18	EINRI	TN01	EINRI
17	RNF18	ENTDKAT	TNK00	KATID
18	RNF18	EXTAUFGA	TNWCHEA16	EXTAUFGA	KEY	1	CN
19	RNF18	GLAND	T005	LAND1
20	RNF18	HARNR	NGPA	GPART	REF	1	CN
21	RNF18	KHDDKAT	TNK00	KATID
22	RNF18	LAND	T005	LAND1
23	RNF18	MANDT	T000	MANDT
24	RNF18	NATIO	T005	LAND1
25	RNF18	PASSTY	TN17D	PASSTY	REF	1	CN
26	RNF18	RACE	TN17R	RACE	REF	1	CN
27	RNF18	SPRAS	T002	SPRAS
28	RNF18	TODUR	TN18A	TODUR
29	RNF18	UARNR	NGPA	GPART	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in