SAP ABAP Table RNDVV (IS-H: Screen fields insurance relationship)

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	RNDVV	Table Relationship Diagram
Short Description	IS-H: Screen fields insurance relationship

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	SOLFD	☐	ISH_SOLFD	NUMC05	NUMC	5	0	IS-H: General Sort Field Internal Assignment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
4	.INCLUDE	☐				0	0	IS-H: Screen fields insurance relationship overview
5	MARK	☐	RI_MARK	XFELD	CHAR	1	0	IS-H: Checkbox to Select a Row
6	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	NGPA
7	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
8	VKOST	☐	ISH_VKOSTR	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Insured with Ins. Provider
9	VZUZA	☐	ISH_VZUZAH	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer/Copayer Ins. Relatshp
10	KNAME	☐	ISH_KNAMEL	TEXT100	CHAR	100	0	IS-H: Insurance Provider Name
11	KTNAM	☐	KTNAM	TEXT40	CHAR	40	0	IS-H: Insurance Provider Name
12	KTADR	☐	KTADR	TEXT40	CHAR	40	0	IS-H: Insurance Provider Address
13	VERAB	☐	ISH_BGVVP	RI_DATUM	DATS	8	0	IS-H: Date Insurance Comes into Effect
14	VERBI	☐	ISH_ENVVP	RI_DATUM	DATS	8	0	IS-H: Date Insurance Expires
15	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
16	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	TN16M
17	MTEXT	☐	MITART_TXT	MITART_TXT	CHAR	20	0	IS-H: Text for Type of Coverage
18	VFALL	☐	ISH_FALGEF	XFELD	CHAR	1	0	IS-H: Insurance Maintained for Case
19	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
20	RANGC	☐	ISH_RANG	ISH_RANG	CHAR	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
21	CLDES	☐	ISH_CLDES	ISH_CLDES	CHAR	30	0	IS-H NL: Nursing Day Class Identifier
22	RANGP	☐	ISH_RANGP	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Patient-Rel. Insurance Relationship
23	RANGQ	☐	ISH_RANG	ISH_RANG	CHAR	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
24	PFLZZ	☐	ISH_ZZPFL	XFELD	CHAR	1	0	IS-H: Copayment Obligation Indicator
25	BTRZZ	☐	ISH_BTRZZ	WERT6	CURR	11	2	IS-H: Amount of Copayment Request
26	NZZGR	☐	GRKZZ	GRKZZ	CHAR	2	0	Reason for Copayment Waiver	TN22A
27	NZZTX	☐	GRKZT	TEXT30	CHAR	30	0	IS-H: Text Explaining why Copayment Is Waived
28	POAKT	☐	AKT_POS	ISH_POS	NUMC	3	0	IS-H: Current Item Number
29	POGES	☐	GES_POS	ISH_POS	NUMC	3	0	IS-H: Number of Total Items
30	VTAGE	☐	ISH_VTAGE	ISH_VTAGE	NUMC	2	0	IS-H: Previous Days
31	ZTAGE	☐	ISH_ZUZTAG	NUMC2	NUMC	2	0	IS-H: Copayment Days
32	VTTYP	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
33	.INCLUDE	☐				0	0	IS-H: Screen Fields Insurance Relationships Detail Screen
34	UNTGR	☐	UNTGR	UNTGR	CHAR	2	0	IS-H: Insurance Subgroup	TN16C
35	UGTXT	☐	ISH_UGTXT	TEXT40	CHAR	40	0	IS-H: Name of Insurance Subgroup
36	SZDEB	☐	SZ_DEBNR	KUNNR	CHAR	10	0	IS-H: Customer Number of Self-Payer in Financial Accounting	*
37	INSSZ	☐	ISH_INSDEB	XFELD	CHAR	1	0	IS-H: Specifies Creation of FI Customer
38	NUMKZ	☐			CHAR	1	0
39	KTXTP	☐	TEXT_VVP	TEXT50	CHAR	50	0	IS-H: Comment on Patient-Related Insurance Relationship
40	LTXTP	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
41	LTXP3	☐	ISH_LGTX03	ISH_ICON	CHAR	30	0	Screen Field for Displaying Dynamic Icon
42	KTXTF	☐	TEXT_VVF	TEXT50	CHAR	50	0	IS-H: Comment on Case-Related Insurance Relationship
43	LTXTF	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
44	LTXF3	☐	ISH_LGTX03	ISH_ICON	CHAR	30	0	Screen Field for Displaying Dynamic Icon
45	AKTKZ	☐	RI_AKTKZ	CHAR20	CHAR	20	0	IS-H: Number of Case on File with Insurance Provider
46	TFALL	☐	ISH_TFALL	TEXT50	CHAR	50	0	IS-H: Create/Delete/Cancel Case-Related Insurance Reltnship
47	VTYPP	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
48	VTYTP	☐	VTR_KTEXT	TEXT15	CHAR	15	0	IS-H: Short Text for Contract Scheme
49	VTYPF	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
50	VTYTF	☐	VTR_KTEXT	TEXT15	CHAR	15	0	IS-H: Short Text for Contract Scheme
51	VERNP	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
52	VERNF	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
53	WAERS	☐	WAERS_VVH	WAERS	CUKY	5	0	IS-H: Currency in Case-Related Insurance Relationship	TCURC
54	EXTTY	☐	ISH_EXTTY	ISH_EXTTY	CHAR	2	0	IS-H SG: External Contract Scheme
55	ETTXT	☐	ISH_EXTTYPTXT	TEXT40	CHAR	40	0	IS-H: Description of External Contract Scheme
56	TWKTR	☐	ISH_MAINI	XFELD	CHAR	1	0	IS-H: Indicator for Main Insurance Relationship
57	PAYAM	☐	ISH_PAYAM	WERTV8	CURR	15	2	IS-H: Amount Covered (by Insurance Relationship)
58	APSTATE	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
59	APSTX	☐	N_ASTEXT	TEXT40	CHAR	40	0	IS-H: Text for Application Status
60	KKFAL	☐	ISH_KKFAL	ISH_KKFAL	CHAR	12	0	IS-H: Case Number Used by Insurance Provider
61	KUAUS	☐	NWCH_KUAUS	NWCH_KUAUS	CHAR	1	0	IS-H CH: Disable Case-Related Insurance Verification
62	KUATX	☐			CHAR	40	0
63	TPPROC	☐	NWCH_TPP	XFLAG	CHAR	1	0	IS-H CH: Tiers Payant Verfahren
64	.INCLUDE	☐				0	0	IS-H: Screen fields insurance relationship main person insrd
65	VERAN	☐	VERANREX	TEXT5	CHAR	5	0	IS-H: Form-of-Address Short Text of Person Insured
66	VERNN	☐	VERNN	TEXT30	CHAR	30	0	Last Name of Insured Person
67	VERTI	☐	VERTI	TITEL	CHAR	15	0	Title of Insured Person	*
68	VERVN	☐	VERVN	TEXT30	CHAR	30	0	First Name of Insured Person
69	VERNZ	☐	VERNZ	TITEL	CHAR	15	0	Name Affix of Insured Person	*
70	VERGB	☐	VERGB	RI_DATUM	DATS	8	0	IS-H: Date of Birth of Person Insured
71	VERVW	☐	VERVW	TITEL	CHAR	15	0	Name Prefix of Insured Person	*
72	VERST	☐	VERST	STRAS	CHAR	30	0	Street and House Number of Insured Person
73	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	*
74	GSCHLTXT	☐	TEXT_GES	TEXT10	CHAR	10	0	IS-H: Sex Specification - User-Specific
75	VERPL	☐	VERPLZ	PSTLZ	CHAR	10	0	Postal Code of Insured Person
76	VEROR	☐	VERORT	TEXT25	CHAR	25	0	City where Insured Person Resides
77	VERTE	☐	VERTE_D	TEXT16	CHAR	16	0	Telephone Number of Insured Person
78	VERLA	☐	VERLA	LAND1	CHAR	3	0	Country of Insured Person	T005
79	LANDTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
80	VERNA	☐	ISH_NATIO	LAND1	CHAR	3	0	IS-H: Nationality of Person	T005
81	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
82	VERSV	☐	VERSV	ISH_SVNUM	CHAR	20	0	Social Insurance Number of Insured Person
83	VERVV	☐	N1HVD	N1HVV	CHAR	1	0	IS-H: Relationship to Main Insured	TNVVA
84	VERVV_TXT	☐	TEXT_VER	TEXT15	CHAR	15	0	IS-H: Text for Relationship
85	AGNUM	☐	KH_ARBGEB	RI_KUNNR	CHAR	10	0	IS-H: Employer	*
86	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
87	AGNAM	☐	VERAGNA	TEXT30	CHAR	30	0	Name of Insured Person's Employer
88	AGSTR	☐	VERAGSTR	STRAS	CHAR	30	0	IS-H: Street and Number of Insured's Employer
89	AGPLZ	☐	VERAGPLZ	PSTLZ	CHAR	10	0	Postal Code of Insured Person's Employer
90	AGORT	☐	VERAGORT	TEXT25	CHAR	25	0	IS-H: City of Insured's Employer
91	AGLAN	☐	VERAGLA	LAND1	CHAR	3	0	Country of Insured Person's Employer	T005
92	AGLANTXT	☐	ISH_ALTXT	TEXT15	CHAR	15	0	IS-H: Text for Employer's Country
93	AGTEL	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
94	ADRNR	☐	ISH_CADRNR	CADRNR	CHAR	10	0	IS-H: Number of Address in General Address Management	*
95	CPDKT	☐	ISH_CPDKTO	KUNNR	CHAR	10	0	IS-H: One-Time Account for Alternative Invoice Recipient	*
96	STREA	☐	ISH_STRGRA	XFELD	CHAR	1	0	IS-H: Address Entered with General Address Management
97	ADNHV	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
98	ADOHV	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
99	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
100	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
101	VERGN	☐	VERGN	TEXT30	CHAR	30	0	IS-H: Name at Birth of Person Insured
102	VERSN	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
103	.INCLUDE	☐				0	0	IS-H: Screen fields ins. relationship HC smart card data
104	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
105	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
106	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
107	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
108	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
109	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
110	VKMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
111	VKVNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
112	VCODE	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
113	KVKRD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
114	KVDAT_P	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
115	VCEND_P	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
116	VKVST_P	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
117	VKVSE_P	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
118	VKNRA_P	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
119	VKNUM_P	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
120	VKMAN_P	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
121	VKVNR_P	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
122	VCODE_P	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
123	KVDAT_F	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
124	VCEND_F	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
125	VKVST_F	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
126	VKVSE_F	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
127	VKNRA_F	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
128	VKNUM_F	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
129	VKMAN_F	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
130	VKVNR_F	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
131	VCODE_F	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
132	.INCLUDE	☐				0	0	IS-H: Screen fields insurance relationship fin. acct. data
133	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
134	BANKS_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
135	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
136	BANAM	☐	BANAM	TEXT35	CHAR	35	0	IS-H: Name of Bank
137	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
138	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
139	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
140	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
141	ZUAWA_TXT	☐	TEXT1_ZUN	TEXT20	CHAR	20	0	Description of the Sort Key
142	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
143	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
144	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
145	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
146	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
147	BUSAB_MA	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
148	BUSAB_MA2	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
149	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
150	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
151	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
152	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
153	MAHNA_2	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
154	MABER_2	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
155	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
156	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
157	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
158	BEGRF	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
159	BEGRS	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
160	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
161	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
162	IBAN_DATE	☐	IBAN_VALFR	DATUM	DATS	8	0	Validity start of IBAN

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNDVV	ADNAG	NADR	ADRNR	REF	1	CN
2	RNDVV	ADNHV	NADR	ADRNR	REF	1	CN
3	RNDVV	AGLAN	T005	LAND1
4	RNDVV	APSTATE	TNC301SA	APSTATE	REF	1	CN
5	RNDVV	BANKS	T005	LAND1
6	RNDVV	BEGRF	TBRG	BRGRU
7	RNDVV	BEGRS	TBRG	BRGRU
8	RNDVV	BUSAB	T001S	BUSAB
9	RNDVV	BUSAB_MA	T001S	BUSAB
10	RNDVV	BUSAB_MA2	T001S	BUSAB
11	RNDVV	EINRI	TN01	EINRI
12	RNDVV	FDGRV	T035	GRUPP
13	RNDVV	HBKID	T012	HBKID
14	RNDVV	KOSTR	NGPA	GPART
15	RNDVV	KTOKD	T077D	KTOKD
16	RNDVV	MABER	T047M	MABER
17	RNDVV	MABER_2	T047M	MABER
18	RNDVV	MAHNA	T047A	MAHNA
19	RNDVV	MAHNA_2	T047A	MAHNA
20	RNDVV	MANDT	T000	MANDT
21	RNDVV	MGART	TN16M	MGART
22	RNDVV	MGRUP	T047R	MGRUP
23	RNDVV	NZZGR	TN22A	NZZGR
24	RNDVV	TOGRU	T043G	TOGRU
25	RNDVV	UNTGR	TN16C	UNTGR	KEY	1	CN
26	RNDVV	VERLA	T005	LAND1
27	RNDVV	VERNA	T005	LAND1
28	RNDVV	VERVV	TNVVA	VERVA	REF	1	CN
29	RNDVV	VTTYP	TN16	VTRTY
30	RNDVV	VTYPF	TN16	VTRTY
31	RNDVV	VTYPP	TN16	VTRTY
32	RNDVV	WAERS	TCURC	WAERS	REF	C	CN
33	RNDVV	ZAHLS	T008	ZAHLS
34	RNDVV	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20131127
SAP Release Created in