SAP ABAP Table N_VGPAKTR (Generated Table for View)

Basic Data

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

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	T000
2	GPART	☑	GPARTNER	RI_KUNNR	CHAR	10	0	IS-H: Business Partner
3	INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
4	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
5	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
6	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
7	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
8	NAME3	☐	GPNAM3	NAME	CHAR	35	0	Third Name
9	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
10	NPKZ	☐	NATPERKZ	XFELD	CHAR	1	0	IS-H: Indicator for Natural Person (for Address Control)
11	SPRAS	☐	SPRAS_GP	SPRAS	LANG	1	0	IS-H: Language of Business Partner	T002
12	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key
13	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
14	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
15	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
16	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
17	LAND	☐	LAND_GP	LAND1	CHAR	3	0	IS-H: Country of Business Partner	T005
18	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
19	PFACH	☐	PFACH_GP	ISH_PFACH	CHAR	10	0	IS-H: PO Box of Business Partner
20	PLZPF	☐	PLZPF_GP	ISH_PLZPF	CHAR	10	0	IS-H: Postal Code for PO Box of Business Partner
21	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
22	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
23	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
24	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
25	LOEGP	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
26	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
27	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
28	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
29	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
30	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
31	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
32	KTTYP	☐	GRU_KZ	XFELD	CHAR	1	0	IS-H: Indicator Denoting Insurance Provider Group
33	KTART	☐	KOSTR_ART	KOSTR_ART	CHAR	3	0	IS-H: Insurance Provider Type (e.g. Private, Statutory)	TN18
34	ZENTR	☐	RI_ZENTR	RI_KUNNR	CHAR	10	0	Key Identifying Insurance Provider's Head Office	NGPA
35	KKSNR	☐	KKSNR	KKSNUMMER	CHAR	12	0	IS-H: Number Identifying the Health Insurer
36	KVNUM	☐	KVNUM	RI_KUNNR	CHAR	10	0	IS-H: Responsible PPA (panel physician association)	NGPA
37	KONT1	☐	ANPER1	ISH30	CHAR	30	0	IS-H: Contact Person, e.g. Inpatient
38	KONT2	☐	ANPER2	ISH30	CHAR	30	0	IS-H: Contact Person, e.g. Outpatient
39	KUEVER	☐	KUEVER	XFELD	CHAR	1	0	IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No
40	REBEA	☐	REBEARB	ISH01	CHAR	1	0	IS-H: Manual Invoice Processing is Allowed
41	SAMRE	☐	SAMMELRE	ISH01	CHAR	1	0	IS-H: Invoice List Output per IP at Invoice Print
42	ZWIAB	☐	ABR_ZWI	ISH01	CHAR	1	0	IS-H: Ind. Specifying if Int. Bill. is to be Performed
43	SORTR	☐	ABRSORT	ISH_SORT	CHAR	2	0	IS-H: Sort Rules for Billing
44	ABRLS	☐	ABRLEI_ZWI	ISH01	CHAR	1	0	IS-H: Interim Billing for Svces w/o Confirmation of Coverage
45	ENDLS	☐	ENDABR_LEI	ISH01	CHAR	1	0	IS-H: Final Billing for Svces w/o Confirmation of Coverage
46	ENDAB	☐	ENDABR_DIA	ISH01	CHAR	1	0	IS-H: Final Billing only if Diagnosis Entered
47	SEPRE	☐	SEP_RE	ISH01	CHAR	1	0	IS-H: Separate Invoice for Companion
48	ABRTG	☐	ABR_TAGE	ISH_TAGE	NUMC	3	0	IS-H: Interim Billing After x Days as of Admission
49	ABRIN	☐	ABR_INTERV	ISH_INTERV	NUMC	3	0	IS-H: Interim Billing Interval (Weeks/Days/Quarter)
50	RHYTH	☐	RHYT_ENDAB	ISH_INTERV	NUMC	3	0	IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly)
51	KUEMAH	☐	KUEMAH	XFELD	CHAR	1	0	IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No
52	KUEMF	☐	KUE_MAFRI	MAFRI	NUMC	3	0	IS-H: Reminder Period for IV Request in Days
53	KUEVS	☐	KUEVERSAND	KUEVERS	CHAR	1	0	IS-H: Send IV Request Only if Diagnosis Is Maintained
54	DIADR	☐	DIADRUCK	ISH01	CHAR	1	0	IS-H: Print Diagnosis on IV Request (Yes/No)
55	AAZKZ	☐	AUFN_ANZ	ISH01	CHAR	1	0	IS-H: Admission Notif. to Be Printed in Standard Form Print
56	ENTAZ	☐	ENTL_ANZ	ISH01	CHAR	1	0	IS-H: Discharge Notification to Be Created
57	VKUAN	☐	VERL_KUEAN	ISH_INTERV	NUMC	3	0	IS-H: Interval for Extending IV Requests
58	KUANZ	☐	KUEAN_ZTR	ISH_INTERV	NUMC	3	0	IS-H: Interval for Creating IV Requests
59	PFLZZ	☐	KOSTR_ZUZ	ISH01	CHAR	1	0	IS-H: Insurance Provider Requires Copayment
60	WAERS	☐	WAERS_KTR	WAERS	CUKY	5	0	IS-H: Currency of Insurance Provider	TCURC
61	LOEKT	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
62	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
63	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
64	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
65	KKSVA	☐	CHIPNR	CHIPKKSNR	CHAR	10	0	IS-H: Health Insurer Number as per Healthcare Smart Card
66	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number
67	KSSNM	☐	ISH_KSSNAM	TEXT60	CHAR	60	0	IS-H: HI Search Name From Ins. Provider Master File (PPA)
68	KSSNS	☐	ISH_KSSNAS	TEXT60	CHAR	60	0	IS-H: Stnd. HI Search Name from Ins. Provider Master File
69	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
70	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner
71	PSIGN	☐	PRIVATE	XFELD	CHAR	1	0	Institution Is Private
72	BAG	☐	NWCH_EHC_BAG	NWCH_EHC_BAG	NUMC	5	0	BAG Nummer der Versicherung

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VGPAKTR	KTART	TN18	KTART	REF	1	CN
2	N_VGPAKTR	KVNUM	NGPA	GPART	REF	C	CN
3	N_VGPAKTR	LAND	T005	LAND1	REF	1	CN
4	N_VGPAKTR	MANDT	T000	MANDT	KEY	1	CN
5	N_VGPAKTR	SPRAS	T002	SPRAS	REF	1	CN
6	N_VGPAKTR	WAERS	TCURC	WAERS	REF	C	CN
7	N_VGPAKTR	ZENTR	NGPA	GPART	KEY	1	C

History

Last changed by/on	SAP	20130529
SAP Release Created in