SAP ABAP View N_VGPAKTR (IS-H: DB view containing only guarantors from NGPA and NKTR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NBAS (Package) Appl. development Hospital System master data, catalogs

Basic Data

View Type	D	Database View
Database View	N_VGPAKTR
Short Description	IS-H: DB view containing only guarantors from NGPA and NKTR
Root table	NGPA	IS-H: Business Partners

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NGPA	NGPA
2	NKTR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NGPA	MANDT	JL	EQ				0	0
2	NKTR	MANDT	JR	EQ			AND	0	0
3	NGPA	GPART	JL	EQ				0	0
4	NKTR	KOSTR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in