SAP ABAP Table ENT7605 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT7605	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster	NVVP
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT7605	AGLAN	T005	LAND1	REF	1	CN
2	ENT7605	AGNUM	NGPA	GPART	REF	1	CN
3	ENT7605	KOSTR	NGPA	GPART	KEY	1	CN
4	ENT7605	MANDT	T000	MANDT	KEY	1	CN
5	ENT7605	PATNR	NPAT	PATNR	KEY	1	CN
6	ENT7605	SZDEB	KNA1	KUNNR	REF	1	N
7	ENT7605	VERLA	T005	LAND1	REF	1	CN
8	ENT7605	VERNA	T005	LAND1	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in