SAP ABAP Table RNDVV_VZUZA (IS-H: Screen Fields Self-Payer IR for Subscreen)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	RNDVV_VZUZA	Table Relationship Diagram
Short Description	IS-H: Screen Fields Self-Payer IR for Subscreen

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

History

Last changed by/on	SAP	20131127
SAP Release Created in