SAP ABAP Table NVVP (IS-H: Patient-related insurance relationship)

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	TRANSP	Transparent table
Transparent table	NVVP	Table Relationship Diagram
Short Description	IS-H: Patient-related insurance relationship

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in