SAP ABAP Table ISH_NIRA_DISPLAY (IS-H: Display Structure for Patient-Related IRs)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ISH_NIRA_DISPLAY	Table Relationship Diagram
Short Description	IS-H: Display Structure for Patient-Related IRs

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
3	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
4	.INCLUDE	☐				0	0	IS-H: Insurance Relationship - Case- and Patient-Related
5	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	*
6	PATKZ	☐	ISH_PATKZ	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer Insurance Relationship
7	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	TN16M
8	UNTGR	☐	UNTGR	UNTGR	CHAR	2	0	IS-H: Insurance Subgroup	TN16C
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	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
12	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
13	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
14	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
15	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
16	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
17	VKMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
18	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
19	PCARD	☐	ISH_VK_PKV	XFELD	CHAR	1	0	IS-H: HC smart card - private card indicator (CfP)
20	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
21	VERGE	☐	VERGE	GSCHL	CHAR	1	0	IS-H: Sex of Person Insured
22	VERNN	☐	VERNN	TEXT30	CHAR	30	0	Last Name of Insured Person
23	VERVN	☐	VERVN	TEXT30	CHAR	30	0	First Name of Insured Person
24	VERAN	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	TN17U
25	VERTI	☐	VERTI	TITEL	CHAR	15	0	Title of Insured Person	T535N
26	VERNZ	☐	VERNZ	TITEL	CHAR	15	0	Name Affix of Insured Person	T535N
27	VERVW	☐	VERVW	TITEL	CHAR	15	0	Name Prefix of Insured Person	T535N
28	VERGB	☐	VERGB	RI_DATUM	DATS	8	0	IS-H: Date of Birth of Person Insured
29	VERNA	☐	ISH_NATIO	LAND1	CHAR	3	0	IS-H: Nationality of Person	T005
30	VERSV	☐	VERSV	ISH_SVNUM	CHAR	20	0	Social Insurance Number of Insured Person
31	VERVV	☐	N1HVD	N1HVV	CHAR	1	0	IS-H: Relationship to Main Insured	TNVVA
32	VERGN	☐	VERGN	TEXT30	CHAR	30	0	IS-H: Name at Birth of Person Insured
33	VERSN	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
34	ADNHV	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
35	ADOHV	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
36	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
37	AGNUM	☐	KH_ARBGEB	RI_KUNNR	CHAR	10	0	IS-H: Employer	NGPA
38	AGNAM	☐	VERAGNA	TEXT30	CHAR	30	0	Name of Insured Person's Employer
39	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
40	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
41	SZDEB	☐	SZ_DEBNR	KUNNR	CHAR	10	0	IS-H: Customer Number of Self-Payer in Financial Accounting	*
42	ABREE	☐	ABWREMPF	XFELD	CHAR	1	0	Indicator Whether Alternative Invoice Recipient Exists
43	KZTXT	☐	TEXT_VVP	TEXT50	CHAR	50	0	IS-H: Comment on Patient-Related Insurance Relationship
44	LGTXT	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
45	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
46	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
47	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
48	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
49	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
50	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
51	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
52	VTRTY	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
53	VSCOD	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
54	ADRNR	☐	ISH_CADRNR	CADRNR	CHAR	10	0	IS-H: Number of Address in General Address Management	*
55	CPDKT	☐	ISH_CPDKTO	KUNNR	CHAR	10	0	IS-H: One-Time Account for Alternative Invoice Recipient	*
56	VAL_QUARTER	☐	ISH_VAL_QUARTER_BEGIN		DATS	8	0	IS-H: Validity Quarter Start Date
57	VKZML	☐	ISH_VK_ZML	NUM3	NUMC	3	0	IS-H: Health Insurance Card - Mobile Card Reader License No.
58	VKTITEL	☐	ISH_VK_TIT	TEXT15	CHAR	15	0	IS-H: Healthcare smart card - title
59	VKVNAM	☐	ISH_VK_VNM	TEXT28	CHAR	28	0	Healthcare Smart Card - First Name
60	VKNZU	☐	ISH_VK_NZU	TEXT15	CHAR	15	0	IS-H: Healthcare Smart Card - Name Affix
61	VKNNAM	☐	ISH_VK_NAM	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - last name
62	VKGBDAT	☐	ISH_VK_GBD	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Date of Birth
63	VKSTRAS	☐	ISH_VK_STR	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - street
64	VKLAND	☐	ISH_VK_LAN	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Country
65	VKPLZ	☐	ISH_VK_PLZ	TEXT7	CHAR	7	0	IS-H: Healthcare Smart Card - Postal Code
66	VKORT	☐	ISH_VK_ORT	TEXT23	CHAR	23	0	IS-H: Healthcare Smart Card - City
67	LNCRD	☐	ISH_LNCARD	ISH_LNCARD	NUMC	10	0	Sequence Number of Health Insurance Card
68	LNCRD_PAT	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
69	LNCRD_INS	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
70	VKUNKNOWN_GBDAT	☐	ISH_VK_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Healthcare Smart Card: Exact Birthdate Unknown
71	VERNR_KVK	☐	ISH_VERNR_KVK	CHAR20	CHAR	20	0	Insurance Number PPA Card
72	.INCLUDE	☐				0	0	IS-H Vers.verh. fall- und pat.bezogen (Zusatzfelder CH)
73	MCDKZ	☐	NWCH_MCDKZ	NWCH_MCDKZ	CHAR	1	0	MCD Versandoption
74	.INCLUDE	☐				0	0	IS-H: Insurance Relationship - Patient-Related Data
75	CURNT	☐	ISH_NPIR_CURNT	ISH_ON_OFF	CHAR	1	0	IS-H: Insurance Relationship is Proposal for New Case
76	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
77	.INCLUDE	☐				0	0	IS-H: Insurance Relationship - Case-Related Data
78	WAERS	☐	WAERS_VVH	WAERS	CUKY	5	0	IS-H: Currency in Case-Related Insurance Relationship	TCURC
79	AKTKZ	☐	RI_AKTKZ	CHAR20	CHAR	20	0	IS-H: Number of Case on File with Insurance Provider
80	KKFAL	☐	ISH_KKFAL	ISH_KKFAL	CHAR	12	0	IS-H: Case Number Used by Insurance Provider
81	VBGDT	☐	ISH_VBGDT	RI_DATUM	DATS	8	0	IS-H: Insurance coverage start date
82	PFLZZ	☐	ISH_ZZPFL	XFELD	CHAR	1	0	IS-H: Copayment Obligation Indicator
83	NZZGR	☐	GRKZZ	GRKZZ	CHAR	2	0	Reason for Copayment Waiver	TN22A
84	BTRZZ	☐	ISH_BTRZZ	WERT6	CURR	11	2	IS-H: Amount of Copayment Request
85	VTAGE	☐	ISH_VTAGE	ISH_VTAGE	NUMC	2	0	IS-H: Previous Days
86	VTDAT	☐	ISH_VTDAT	RI_DATUM	DATS	8	0	IS-H: Date of Report on Paid Copayment Days
87	EXTTY	☐	ISH_EXTTY	ISH_EXTTY	CHAR	2	0	IS-H SG: External Contract Scheme
88	TWKTR	☐	ISH_MAINI	XFELD	CHAR	1	0	IS-H: Indicator for Main Insurance Relationship
89	APSTATE	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
90	PAYAM	☐	ISH_PAYAM	WERTV8	CURR	15	2	IS-H: Amount Covered (by Insurance Relationship)
91	KUAUS	☐	NWCH_KUAUS	NWCH_KUAUS	CHAR	1	0	IS-H CH: Disable Case-Related Insurance Verification
92	TPPROC	☐	NWCH_TPP	XFLAG	CHAR	1	0	IS-H CH: Tiers Payant Verfahren
93	REPAP	☐	ISH_REPAP	XFELD	CHAR	1	0	IS-H: Invoice requested as printout
94	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
95	RFLNR	☐	ISH_REFLNR	LFDVV	NUMC	3	0	IS-H: Reference to Sequence Number of Patient-Related IR	NPIR
96	KKFAL_NEW	☐	ISH_KKFAL_NEW	ISH_KKFAL_NEW	CHAR	30	0	Case Number at Insurance Provider (New)
97	CONTRACT_IND	☐	ISH_CONTRACT_INDICATOR_301	ISH_CONTRACT_INDICATOR_301	CHAR	30	0	Vertragskennzeichen für §301
98	LNCRD_E111	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
99	KOUB_COPAYDAYS	☐	ISH_301_KOUB_COPAYDAYS	ISH_301_KOUB_COPAYDAYS	NUMC	2	0	§301 - Zuzahlungsvortage aus Kostenübernahmesatz
100	KOUB_COPD_STAT	☐	ISH_301_KOUB_COPAYDAYS_STATUS	ISH_301_KOUB_COPAYDAYS_STATUS	CHAR	1	0	Status Kostenübernahme/Entlassungsanzeige
101	COP_RECEIPT	☐	ISH_COP_RECEIPT	XFELD	CHAR	1	0	Kennzeichen, ob Patient Nachweis vorgelegt hat
102	SUSPEND_CLAIM	☐	ISH_KV_SUSPEND_CLAIM	XFELD	CHAR	1	0	Eingeschränkter Leistungsanspruch
103	.INCLUDE	☐				0	0	IS-H: Screen fields insurance relationship fin. acct. data
104	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
105	BANKS_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
106	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
107	BANAM	☐	BANAM	TEXT35	CHAR	35	0	IS-H: Name of Bank
108	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
109	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
110	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
111	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
112	ZUAWA_TXT	☐	TEXT1_ZUN	TEXT20	CHAR	20	0	Description of the Sort Key
113	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
114	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
115	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
116	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
117	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
118	BUSAB_MA	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
119	BUSAB_MA2	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
120	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
121	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
122	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
123	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
124	MAHNA_2	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
125	MABER_2	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
126	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
127	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
128	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
129	BEGRF	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
130	BEGRS	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
131	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
132	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
133	IBAN_DATE	☐	IBAN_VALFR	DATUM	DATS	8	0	Validity start of IBAN
134	FRGKZ	☐	ISH_FRGKZ	XFELD	CHAR	1	0	IS-H: Third-Party Payer
135	MARK	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
136	BTFAL	☐	ISH_TLED	CHAR50	CHAR	50	0	IS-H: Indicator for Case-Related Insurance Relationship
137	VVFAL	☐	ISH_FALGEF	XFELD	CHAR	1	0	IS-H: Insurance Maintained for Case
138	ZTAGE	☐	ISH_ZUZTAG	NUMC2	NUMC	2	0	IS-H: Copayment Days
139	RFCPY	☐	ISH_RFCPY		CHAR	132	0	IS-H: Copy of a Case-Related Insurance Relationship
140	PROPO	☐	ISH_PROPO	TEXT132	CHAR	132	0	IS-H: Proposed Insurance Relationship
141	KNAME	☐	ISH_KNAMEL	TEXT100	CHAR	100	0	IS-H: Insurance Provider Name
142	KTNAM	☐	KTNAM	TEXT40	CHAR	40	0	IS-H: Insurance Provider Name
143	KTADR	☐	ISH_KTADR	TEXT60	CHAR	60	0	IS-H: Insurance Provider Address - Long
144	TADDR	☐	ISH_TADDR	CHAR110	CHAR	110	0	IS-H: "Address Data" Pushbutton
145	LANDX	☐	ISH_LANDX	TEXT15	CHAR	15	0	IS-H: Country name
146	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
147	KOSTR_LONG	☐	ISH_KOSTR_LONG	ISH_KOSTR_LO	CHAR	132	0	IS-H: Insurance Provider (Screen Field)
148	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
149	LFDAK	☐	ISH_LFDAK	CHAR10	CHAR	10	0	IS-H: Sequence Number of an Action
150	KUATX	☐	NWCH_KUATX	TEXT40	CHAR	40	0	IS-H CH: KÜ Fallbezogen ausschalten - Langtext
151	INSSZ	☐	ISH_INSDEB	XFELD	CHAR	1	0	IS-H: Specifies Creation of FI Customer
152	SVT_STATUS	☐	NWAT_SVT_LED	CHAR50	CHAR	50	0	IS-H: Status des Versicherungsverhältnisses
153	DA_STATUS	☐	NWCH_DA_LED	CHAR50	CHAR	50	0	Status Deckungsabfrage des Versicherungsverhältnisses

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISH_NIRA_DISPLAY	AGNUM	NGPA	GPART	REF	1	CN
2	ISH_NIRA_DISPLAY	APSTATE	TNC301SA	APSTATE	KEY		CN
3	ISH_NIRA_DISPLAY	BANKS	T005	LAND1
4	ISH_NIRA_DISPLAY	BEGRF	TBRG	BRGRU
5	ISH_NIRA_DISPLAY	BEGRS	TBRG	BRGRU
6	ISH_NIRA_DISPLAY	BUSAB	T001S	BUSAB
7	ISH_NIRA_DISPLAY	BUSAB_MA	T001S	BUSAB
8	ISH_NIRA_DISPLAY	BUSAB_MA2	T001S	BUSAB
9	ISH_NIRA_DISPLAY	FDGRV	T035	GRUPP
10	ISH_NIRA_DISPLAY	HBKID	T012	HBKID
11	ISH_NIRA_DISPLAY	KTOKD	T077D	KTOKD
12	ISH_NIRA_DISPLAY	LGTXT	T002	SPRAS
13	ISH_NIRA_DISPLAY	MABER	T047M	MABER
14	ISH_NIRA_DISPLAY	MABER_2	T047M	MABER
15	ISH_NIRA_DISPLAY	MAHNA	T047A	MAHNA
16	ISH_NIRA_DISPLAY	MAHNA_2	T047A	MAHNA
17	ISH_NIRA_DISPLAY	MGART	TN16M	MGART	REF	1	CN
18	ISH_NIRA_DISPLAY	MGRUP	T047R	MGRUP
19	ISH_NIRA_DISPLAY	NZZGR	TN22A	NZZGR	KEY	1	CN
20	ISH_NIRA_DISPLAY	RFLNR	NPIR	LFDNR	REF	1	CN
21	ISH_NIRA_DISPLAY	TOGRU	T043G	TOGRU
22	ISH_NIRA_DISPLAY	UNTGR	TN16C	UNTGR	REF	1	CN
23	ISH_NIRA_DISPLAY	VERAN	TN17U	ANRDS
24	ISH_NIRA_DISPLAY	VERNA	T005	LAND1	REF	1	CN
25	ISH_NIRA_DISPLAY	VERNZ	T535N	TITEL	REF	1	CN
26	ISH_NIRA_DISPLAY	VERTI	T535N	TITEL
27	ISH_NIRA_DISPLAY	VERVV	TNVVA	VERVA	REF	1	CN
28	ISH_NIRA_DISPLAY	VERVW	T535N	TITEL	REF	1	CN
29	ISH_NIRA_DISPLAY	VTRTY	TN16	VTRTY
30	ISH_NIRA_DISPLAY	WAERS	TCURC	WAERS	REF	C	CN
31	ISH_NIRA_DISPLAY	ZAHLS	T008	ZAHLS
32	ISH_NIRA_DISPLAY	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20131127
SAP Release Created in	472