SAP ABAP Table RNADRPAT (IS-H: Structure with address data for patients)

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	INTTAB	Structure
Structure	RNADRPAT	Table Relationship Diagram
Short Description	IS-H: Structure with address data for patients

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	.INCLUDE	☐				0	0	IS-H: Patient Master Data (General)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
6	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
7	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
8	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
9	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
10	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
11	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
12	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
13	NAME2	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
14	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
15	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
16	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
17	GLAND	☐	GLAND	LAND1	CHAR	3	0	IS-H: Country of Birth	T005
18	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
19	TODDT	☐	TODDV	RI_DATUM	DATS	8	0	IS-H: Date of Death From
20	TODZT	☐	TODZV	UHRZT	TIMS	6	0	Time of Death From
21	TODDB	☐	TODDB	RI_DATUM	DATS	8	0	Date of Death To
22	TODZB	☐	TODZB	UHRZT	TIMS	6	0	IS-H: Time of Death To
23	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	TN18A
24	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
25	FAMST	☐	RI_FAMST	RI_FAMST	CHAR	1	0	IS-H: Marital Status
26	KONFE	☐	RI_KONFE	RI_KONFE	CHAR	2	0	IS-H: Religion
27	NATIO	☐	RI_NATIO	LAND1	CHAR	3	0	IS-H: Nationality	T005
28	SPRAS	☐	SPRAS_PAT	SPRAS	LANG	1	0	Patient Language	T002
29	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
30	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
31	ORT	☐	ORT01_PAT	TEXT25	CHAR	25	0	IS-H: City where Patient Resides
32	ORT2	☐	ORT02_PAT	TEXT25	CHAR	25	0	Patient District
33	STRAS	☐	STRAS_PAT	STRAS	CHAR	30	0	IS-H: Street and House Number of Patient
34	BLAND	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
35	GEBIE	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
36	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
37	SPEND	☐	SPENKZ	XFELD	CHAR	1	0	IS-H: Organ Donor Indicator
38	SPENT	☐	SPENTEXT	TEXT50	CHAR	50	0	Explanation for Donor Indicator
39	SPELT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
40	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
41	ARCHV	☐	ARCHIV	XFELD	CHAR	1	0	IS-H: Archived Data Indicator
42	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
43	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
44	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
45	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
46	RFPAT	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
47	RFZIF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
48	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
49	AGNUM	☐	AGNUM_PAT	RI_KUNNR	CHAR	10	0	IS-H: Patient's Employer	NGPA
50	AGNAM	☐	AGNAM	TEXT30	CHAR	30	0	IS-H: Employer Name
51	AGLAN	☐	AGLAN	LAND1	CHAR	3	0	IS-H: Employer Country	T005
52	AGPLZ	☐	AGPLZ	PSTLZ	CHAR	10	0	IS-H: Employer Postal Code
53	AGORT	☐	AGORT	TEXT25	CHAR	25	0	IS-H: Employer City
54	AGSTR	☐	AGSTR	STRAS	CHAR	30	0	IS-H: Employer Street
55	AGTEL	☐	AGTEL	TEXT16	CHAR	16	0	IS-H: Employer Telephone Number
56	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
57	ANNA1	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
58	ANVN1	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
59	ANLA1	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
60	ANPL1	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
61	ANOR1	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
62	ANST1	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
63	ANTE1	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
64	ANVV1	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
65	VMKZ1	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
66	ANNA2	☐	NNAME_ANG	TEXT30	CHAR	30	0	IS-H: Last Name of Person to Be Contacted
67	ANVN2	☐	VNAME_ANG	TEXT30	CHAR	30	0	IS-H: First Name of Person to Be Contacted
68	ANLA2	☐	LAND_ANG	LAND1	CHAR	3	0	Country of the Person to Be Contacted	T005
69	ANPL2	☐	PSTLZ_ANG	PSTLZ	CHAR	10	0	IS-H: Postal Code
70	ANOR2	☐	ORT01_ANG	TEXT25	CHAR	25	0	IS-H: City where Person to Be Contacted Resides
71	ANST2	☐	STRAS_ANG	STRAS	CHAR	30	0	IS-H: Street and House Number of Person to Be Contacted
72	ANTE2	☐	TELF_ANG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Person to Be Contacted
73	ANVV2	☐	VERWVH	VERWVH	CHAR	1	0	IS-H: Relationship	TN17B
74	VMKZ2	☐	VORMUND	XFELD	CHAR	1	0	IS-H: Legal Representative
75	KZTXT	☐	TEXT_PAT	TEXT50	CHAR	50	0	IS-H: Comment on Patient
76	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
77	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
78	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
79	HISTK	☐	RI_HISTK	XFELD	CHAR	1	0	Indicator that History Records Are Available
80	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
81	TESTP	☐	TESTP	XFELD	CHAR	1	0	Test Patient Status
82	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
83	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
84	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
85	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
86	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
87	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
88	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
89	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
90	GBORT	☐	ISH_GBORT	TEXT25	CHAR	25	0	IS-H: Patient Birthplace
91	HARNR	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	NGPA
92	EARNR	☐	EARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
93	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
94	RACE	☐	ISH_RACE	ISH_RACE	CHAR	2	0	IS-H: Race	TN17R
95	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
96	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
97	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
98	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
99	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
100	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
101	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
102	ADNN1	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
103	ADON1	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
104	ADNN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
105	ADON2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
106	ANEX1	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
107	ANEX2	☐	EXTNR_ANG	EXT_PATNR	CHAR	20	0	IS-H: External Identification of Next of Kin/Assoc. Party
108	ADRN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
109	ADRO2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
110	INACT	☐	ISH_INACTIVE	XFELD	CHAR	1	0	'Inactive' Indicator
111	USER1	☐	ISH_PATUSER1	ISH_PATUSER1	CHAR	20	0	IS-H: User-Defined Field 1
112	USER2	☐	ISH_PATUSER2	ISH_PATUSER2	CHAR	20	0	IS-H: User-Defined Field 2
113	USER3	☐	ISH_PATUSER3	ISH_PATUSER3	DATS	8	0	IS-H: User-Defined Field 3
114	USER4	☐	ISH_PATUSER4	ISH_PATUSER4	DATS	8	0	IS-H: User-Defined Field 4
115	USER5	☐	ISH_PATUSER5	ISH_PATUSER5	CHAR	50	0	IS-H: User-Defined Field 5
116	USER6	☐	ISH_PATUSER6	ISH_PATUSER6	CHAR	1	0	IS-H: User-Defined Field 6
117	EXTAUFG	☐	EXTAUFG	XFELD	CHAR	1	0	IS-H: Kennzeichen externer Auftraggeber
118	EXTAUFGA	☐	EXTAUFGA	EXTAUFGA	CHAR	2	0	IS-H: EA Externe Auftraggeberart	TNWCHEA16
119	EMPSC	☐	ISH_EMPDAT	RI_DATUM	DATS	8	0	IS-H: Employed Since
120	UNKNOWN_GBDAT	☐	ISH_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Geburtsdatum nicht genau bekannt
121	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)
122	.INCLU-ADR	☐				0	0	IS-H: Addresses (Central Address Management)
123	MANDTADR	☐	MANDT	MANDT	CLNT	3	0	Client	T000
124	ADRNRADR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
125	ADROBADR	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
126	PSTLZADR	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
127	LANDADR	☐	ISH_LAND	LAND1	CHAR	3	0	IS-H: Country	T005
128	REGIOADR	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
129	ORTADR	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
130	ORT2ADR	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
131	STRASADR	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
132	STRAZADR	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
133	EINZGADR	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
134	PSTLPADR	☐	ISH_PSTLZP	PSTLZ	CHAR	10	0	IS-H: Postal Code of P.O. Box
135	PFACHADR	☐	ISH_POBOX	ISH_PFACH	CHAR	10	0	IS-H: Post Office Box
136	LANPFADR	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	T005
137	ORTPFADR	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
138	PSTLFADR	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
139	TELNRADR	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
140	TELXTADR	☐	ISH_TELEXT	CHAR10	CHAR	10	0	Telephone Number - Extension
141	FAXNRADR	☐	ISH_FAXNR	CHAR30	CHAR	30	0	Fax Number
142	FAXXTADR	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
143	TEXNRADR	☐	ISH_TELETX	TEXT30	CHAR	30	0	IS-H: Telex Number
144	BUILDADR	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
145	FLOORADR	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
146	ROOMADR	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
147	STORTADR	☐	ISH_STCITY	CHAR40	CHAR	40	0	Standardized City Name
148	STOTTADR	☐	ISH_STCIT2	CHAR40	CHAR	40	0	Standardized District
149	STSTRADR	☐	ISH_STSTR	CHAR40	CHAR	40	0	Standardized Street
150	STSTZADR	☐	ISH_STSTRZ	CHAR40	CHAR	40	0	IS-H: Standardized Street Supplement
151	STORPADR	☐	ISH_STCITP	CHAR40	CHAR	40	0	Standardized City Name of P.O. Box
152	TELKZADR	☐	ISH_WTELKZ	XFELD	CHAR	1	0	IS-H: Indicator that More Tel. Nos. Exist for Address
153	EMAILADR	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in