SAP ABAP Table VNVVP (VNVVP)

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	VNVVP	Table Relationship Diagram
Short Description

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-related insurance relationship
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
4	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
5	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	NGPA
6	SELKZ	☐	SELBZ_KZ	SELBZ_KZ	CHAR	1	0	IS-H: Indicator for self-payer/copayer ins.relation.
7	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	*
8	UNTGR	☐	UNTGR	UNTGR	CHAR	2	0	IS-H: Insurance Subgroup	*
9	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
10	VERAB	☐	BEGDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Insurance Relationship
11	VERBI	☐	ENDDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-to Date of Insurance Relationship
12	VERGE	☐	VERGE	GSCHL	CHAR	1	0	IS-H: Sex of Person Insured
13	VERNN	☐	VERNN	TEXT30	CHAR	30	0	Last Name of Insured Person
14	VERVN	☐	VERVN	TEXT30	CHAR	30	0	First Name of Insured Person
15	VERAN	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
16	VERTI	☐	VERTI	TITEL	CHAR	15	0	Title of Insured Person	*
17	VERNZ	☐	VERNZ	TITEL	CHAR	15	0	Name Affix of Insured Person	*
18	VERVW	☐	VERVW	TITEL	CHAR	15	0	Name Prefix of Insured Person	*
19	VERGB	☐	VERGB	RI_DATUM	DATS	8	0	IS-H: Date of Birth of Person Insured
20	VERLA	☐	VERLA	LAND1	CHAR	3	0	Country of Insured Person	T005
21	VERNA	☐	ISH_NATIO	LAND1	CHAR	3	0	IS-H: Nationality of Person	T005
22	VERPL	☐	VERPLZ	PSTLZ	CHAR	10	0	Postal Code of Insured Person
23	VEROR	☐	VERORT	TEXT25	CHAR	25	0	City where Insured Person Resides
24	VERST	☐	VERST	STRAS	CHAR	30	0	Street and House Number of Insured Person
25	VERTE	☐	VERTE_D	TEXT16	CHAR	16	0	Telephone Number of Insured Person
26	VERSV	☐	VERSV	ISH_SVNUM	CHAR	20	0	Social Insurance Number of Insured Person
27	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
28	AGNUM	☐	KH_ARBGEB	RI_KUNNR	CHAR	10	0	IS-H: Employer	NGPA
29	AGNAM	☐	VERAGNA	TEXT30	CHAR	30	0	Name of Insured Person's Employer
30	AGLAN	☐	VERAGLA	LAND1	CHAR	3	0	Country of Insured Person's Employer	T005
31	AGPLZ	☐	VERAGPLZ	PSTLZ	CHAR	10	0	Postal Code of Insured Person's Employer
32	AGORT	☐	VERAGORT	TEXT25	CHAR	25	0	IS-H: City of Insured's Employer
33	AGSTR	☐	VERAGSTR	STRAS	CHAR	30	0	IS-H: Street and Number of Insured's Employer
34	AGTEL	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
35	SZDEB	☐	SZ_DEBNR	KUNNR	CHAR	10	0	IS-H: Customer Number of Self-Payer in Financial Accounting	KNA1
36	KZTXT	☐	TEXT_VVP	TEXT50	CHAR	50	0	IS-H: Comment on Patient-Related Insurance Relationship
37	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
38	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
39	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
40	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
41	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
42	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
43	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
44	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
45	ABREE	☐	ABWREMPF	XFELD	CHAR	1	0	Indicator Whether Alternative Invoice Recipient Exists
46	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
47	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
48	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
49	RANGP	☐	ISH_RANGP	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Patient-Rel. Insurance Relationship
50	KVMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
51	VTRTY	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	*
52	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
53	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
54	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
55	VERVV	☐	N1HVD	N1HVV	CHAR	1	0	IS-H: Relationship to Main Insured	TNVVA
56	ADNHV	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
57	ADOHV	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
58	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
59	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
60	VERGN	☐	VERGN	TEXT30	CHAR	30	0	IS-H: Name at Birth of Person Insured
61	VERSN	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
62	VCODE	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
63	XPRA	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
64	.INCLUDE	☐				0	0	Structures for generating change document update programs
65	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VNVVP	ADNAG	NADR	ADRNR
2	VNVVP	ADNHV	NADR	ADRNR	REF	1	CN
3	VNVVP	AGLAN	T005	LAND1
4	VNVVP	AGNUM	NGPA	GPART
5	VNVVP	KOSTR	NGPA	GPART
6	VNVVP	MANDT	T000	MANDT
7	VNVVP	PATNR	NPAT	PATNR
8	VNVVP	SZDEB	KNA1	KUNNR
9	VNVVP	VERLA	T005	LAND1
10	VNVVP	VERNA	T005	LAND1
11	VNVVP	VERVV	TNVVA	VERVA	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in