SAP ABAP Table NVVF (IS-H: Case-Related Insurance Relationships)

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	NVVF	Table Relationship Diagram
Short Description	IS-H: Case-Related Insurance Relationships

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	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	FALNR	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
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	AKTKZ	☐	RI_AKTKZ	CHAR20	CHAR	20	0	IS-H: Number of Case on File with Insurance Provider
7	PFLZZ	☐	ISH_ZZPFL	XFELD	CHAR	1	0	IS-H: Copayment Obligation Indicator
8	NZZGR	☐	GRKZZ	GRKZZ	CHAR	2	0	Reason for Copayment Waiver	TN22A
9	BTRZZ	☐	ISH_BTRZZ	WERT6	CURR	11	2	IS-H: Amount of Copayment Request
10	KZTXT	☐	TEXT_VVF	TEXT50	CHAR	50	0	IS-H: Comment on Case-Related Insurance Relationship
11	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
12	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
13	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
14	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
15	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
16	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
17	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
18	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
19	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
20	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
21	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
22	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
23	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
24	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
25	VTRTY	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
26	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
27	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
28	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
29	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
30	VKMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
31	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
32	KKFAL	☐	ISH_KKFAL	ISH_KKFAL	CHAR	12	0	IS-H: Case Number Used by Insurance Provider
33	VBGDT	☐	ISH_VBGDT	RI_DATUM	DATS	8	0	IS-H: Insurance coverage start date
34	REPAP	☐	ISH_REPAP	XFELD	CHAR	1	0	IS-H: Invoice requested as printout
35	VTAGE	☐	ISH_VTAGE	ISH_VTAGE	NUMC	2	0	IS-H: Previous Days
36	VTDAT	☐	ISH_VTDAT	RI_DATUM	DATS	8	0	IS-H: Date of Report on Paid Copayment Days
37	ADRNR	☐	ISH_CADRNR	CADRNR	CHAR	10	0	IS-H: Number of Address in General Address Management	*
38	CPDKT	☐	ISH_CPDKTO	KUNNR	CHAR	10	0	IS-H: One-Time Account for Alternative Invoice Recipient	*
39	STREA	☐	ISH_STRGRA	XFELD	CHAR	1	0	IS-H: Address Entered with General Address Management
40	PAYAM	☐	ISH_PAYAM	WERTV8	CURR	15	2	IS-H: Amount Covered (by Insurance Relationship)
41	WAERS	☐	WAERS_VVH	WAERS	CUKY	5	0	IS-H: Currency in Case-Related Insurance Relationship	TCURC
42	EXTTY	☐	ISH_EXTTY	ISH_EXTTY	CHAR	2	0	IS-H SG: External Contract Scheme
43	TWKTR	☐	ISH_MAINI	XFELD	CHAR	1	0	IS-H: Indicator for Main Insurance Relationship
44	APSTATE	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
45	KUAUS	☐	NWCH_KUAUS	NWCH_KUAUS	CHAR	1	0	IS-H CH: Disable Case-Related Insurance Verification
46	TPPROC	☐	NWCH_TPP	XFLAG	CHAR	1	0	IS-H CH: Tiers Payant Verfahren
47	VCODE	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
48	KKFAL_NEW	☐	ISH_KKFAL_NEW	ISH_KKFAL_NEW	CHAR	30	0	Case Number at Insurance Provider (New)
49	CONTRACT_IND	☐	ISH_CONTRACT_INDICATOR_301	ISH_CONTRACT_INDICATOR_301	CHAR	30	0	Vertragskennzeichen für §301

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NVVF	APSTATE	TNC301SA	APSTATE	REF	1	CN
2	NVVF	EINRI	TN01	EINRI	KEY	1	N
3	NVVF	FALNR	NFAL	FALNR	KEY	1	CN
4	NVVF	KOSTR	NGPA	GPART	KEY	1	CN
5	NVVF	MANDT	T000	MANDT	KEY	1	CN
6	NVVF	NZZGR	TN22A	NZZGR	KEY	1	CN
7	NVVF	VTRTY	TN16	VTRTY	REF	C	CN
8	NVVF	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in