SAP ABAP Table RNBADI_PAI_INS (IS-H: PAI BAdI Structure 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	INTTAB	Structure
Structure	RNBADI_PAI_INS	Table Relationship Diagram
Short Description	IS-H: PAI BAdI Structure Insurance Relationships

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	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
2	PATKZ	☐	ISH_PATKZ	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer Insurance Relationship
3	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	*
4	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	*
5	UNTGR	☐	UNTGR	UNTGR	CHAR	2	0	IS-H: Insurance Subgroup	*
6	VERAB	☐	BEGDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Insurance Relationship
7	VERBI	☐	ENDDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-to Date of Insurance Relationship
8	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
9	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
10	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
11	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
12	BTRZZ	☐	ISH_BTRZZ	WERT6	CURR	11	2	IS-H: Amount of Copayment Request
13	NZZGR	☐	GRKZZ	GRKZZ	CHAR	2	0	Reason for Copayment Waiver	*
14	VTAGE	☐	ISH_VTAGE	ISH_VTAGE	NUMC	2	0	IS-H: Previous Days
15	VTDAT	☐	ISH_VTDAT	RI_DATUM	DATS	8	0	IS-H: Date of Report on Paid Copayment Days
16	SZDEB	☐	SZ_DEBNR	KUNNR	CHAR	10	0	IS-H: Customer Number of Self-Payer in Financial Accounting	*
17	TEXT_VVF	☐	TLINETAB		TTYP	0	0
18	AKTKZ	☐	RI_AKTKZ	CHAR20	CHAR	20	0	IS-H: Number of Case on File with Insurance Provider
19	WAERS	☐	WAERS_VVH	WAERS	CUKY	5	0	IS-H: Currency in Case-Related Insurance Relationship	*
20	EXTTY	☐	ISH_EXTTY	ISH_EXTTY	CHAR	2	0	IS-H SG: External Contract Scheme
21	TWKTR	☐	ISH_MAINI	XFELD	CHAR	1	0	IS-H: Indicator for Main Insurance Relationship
22	PAYAM	☐	ISH_PAYAM	WERTV8	CURR	15	2	IS-H: Amount Covered (by Insurance Relationship)
23	KKFAL	☐	ISH_KKFAL	ISH_KKFAL	CHAR	12	0	IS-H: Case Number Used by Insurance Provider
24	KUAUS	☐	NWCH_KUAUS	NWCH_KUAUS	CHAR	1	0	IS-H CH: Disable Case-Related Insurance Verification
25	VBGDT	☐	ISH_VBGDT	RI_DATUM	DATS	8	0	IS-H: Insurance coverage start date
26	PFLZZ	☐	ISH_ZZPFL	XFELD	CHAR	1	0	IS-H: Copayment Obligation Indicator
27	TPPROC	☐	NWCH_TPP	XFLAG	CHAR	1	0	IS-H CH: Tiers Payant Verfahren
28	VERAN	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
29	VERNN	☐	VERNN	TEXT30	CHAR	30	0	Last Name of Insured Person
30	VERTI	☐	VERTI	TITEL	CHAR	15	0	Title of Insured Person	*
31	VERVN	☐	VERVN	TEXT30	CHAR	30	0	First Name of Insured Person
32	VERNZ	☐	VERNZ	TITEL	CHAR	15	0	Name Affix of Insured Person	*
33	VERGB	☐	VERGB	RI_DATUM	DATS	8	0	IS-H: Date of Birth of Person Insured
34	VERVW	☐	VERVW	TITEL	CHAR	15	0	Name Prefix of Insured Person	*
35	VERNA	☐	ISH_NATIO	LAND1	CHAR	3	0	IS-H: Nationality of Person	*
36	VERSV	☐	VERSV	ISH_SVNUM	CHAR	20	0	Social Insurance Number of Insured Person
37	VERVV	☐	N1HVD	N1HVV	CHAR	1	0	IS-H: Relationship to Main Insured	*
38	.INCLU-VER	☐				0	0	IS-H: Attribute Fields Address
39	PSTLZVER	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
40	LANDVER	☐	ISH_LAND	LAND1	CHAR	3	0	IS-H: Country	*
41	REGIOVER	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	*
42	ORTVER	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
43	ORT2VER	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
44	STRASVER	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
45	STRAZVER	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
46	EINZGVER	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
47	PSTLPVER	☐	ISH_PSTLZP	PSTLZ	CHAR	10	0	IS-H: Postal Code of P.O. Box
48	PFACHVER	☐	ISH_POBOX	ISH_PFACH	CHAR	10	0	IS-H: Post Office Box
49	LANPFVER	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	*
50	ORTPFVER	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
51	PSTLFVER	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
52	TELNOVER	☐	RNADR_TELEPHONE_TAB		TTYP	0	0
53	FAXNRVER	☐	ISH_FAXNR	CHAR30	CHAR	30	0	Fax Number
54	FAXXTVER	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
55	TEXNRVER	☐	ISH_TELETX	TEXT30	CHAR	30	0	IS-H: Telex Number
56	BUILDVER	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
57	FLOORVER	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
58	ROOMVER	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
59	EMAILVER	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
60	AGNUM	☐	KH_ARBGEB	RI_KUNNR	CHAR	10	0	IS-H: Employer	*
61	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
62	AGNAM	☐	VERAGNA	TEXT30	CHAR	30	0	Name of Insured Person's Employer
63	.INCLU-AG	☐				0	0	IS-H: Attribute Fields Address
64	PSTLZAG	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
65	LANDAG	☐	ISH_LAND	LAND1	CHAR	3	0	IS-H: Country	*
66	REGIOAG	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	*
67	ORTAG	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
68	ORT2AG	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
69	STRASAG	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
70	STRAZAG	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
71	EINZGAG	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
72	PSTLPAG	☐	ISH_PSTLZP	PSTLZ	CHAR	10	0	IS-H: Postal Code of P.O. Box
73	PFACHAG	☐	ISH_POBOX	ISH_PFACH	CHAR	10	0	IS-H: Post Office Box
74	LANPFAG	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	*
75	ORTPFAG	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
76	PSTLFAG	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
77	TELNOAG	☐	RNADR_TELEPHONE_TAB		TTYP	0	0
78	FAXNRAG	☐	ISH_FAXNR	CHAR30	CHAR	30	0	Fax Number
79	FAXXTAG	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
80	TEXNRAG	☐	ISH_TELETX	TEXT30	CHAR	30	0	IS-H: Telex Number
81	BUILDAG	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
82	FLOORAG	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
83	ROOMAG	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
84	EMAILAG	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
85	ADRNR	☐	ISH_CADRNR	CADRNR	CHAR	10	0	IS-H: Number of Address in General Address Management	*
86	CPDKT	☐	ISH_CPDKTO	KUNNR	CHAR	10	0	IS-H: One-Time Account for Alternative Invoice Recipient	*
87	VERGN	☐	VERGN	TEXT30	CHAR	30	0	IS-H: Name at Birth of Person Insured
88	VERSN	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
89	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
90	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
91	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
92	VKMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
93	APSTATE	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	*
94	PCARD	☐	ISH_VK_PKV	XFELD	CHAR	1	0	IS-H: HC smart card - private card indicator (CfP)
95	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
96	VERGE	☐	VERGE	GSCHL	CHAR	1	0	IS-H: Sex of Person Insured
97	ABREE	☐	ABWREMPF	XFELD	CHAR	1	0	Indicator Whether Alternative Invoice Recipient Exists
98	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
99	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
100	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
101	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
102	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
103	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
104	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
105	VTRTY	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	*
106	VSCOD	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
107	REPAP	☐	ISH_REPAP	XFELD	CHAR	1	0	IS-H: Invoice requested as printout
108	RFLNR	☐	ISH_REFLNR	LFDVV	NUMC	3	0	IS-H: Reference to Sequence Number of Patient-Related IR
109	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
110	VKTITEL	☐	ISH_VK_TIT	TEXT15	CHAR	15	0	IS-H: Healthcare smart card - title
111	VKVNAM	☐	ISH_VK_VNM	TEXT28	CHAR	28	0	Healthcare Smart Card - First Name
112	VKNZU	☐	ISH_VK_NZU	TEXT15	CHAR	15	0	IS-H: Healthcare Smart Card - Name Affix
113	VKNNAM	☐	ISH_VK_NAM	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - last name
114	VKGBDAT	☐	ISH_VK_GBD	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Date of Birth
115	VKSTRAS	☐	ISH_VK_STR	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - street
116	VKLAND	☐	ISH_VK_LAN	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Country
117	VKPLZ	☐	ISH_VK_PLZ	TEXT7	CHAR	7	0	IS-H: Healthcare Smart Card - Postal Code
118	VKORT	☐	ISH_VK_ORT	TEXT23	CHAR	23	0	IS-H: Healthcare Smart Card - City

History

Last changed by/on	SAP	20130529
SAP Release Created in