1. Home
  2. Resources
  3. SAP Tables
  4. N_VGPAKTR - Generated Table for View

SAP Table N_VGPAKTR

Generated Table for View

N_VGPAKTR (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link N_VGPAKTR to other SAP tables.

N_VGPAKTR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
GPART IS-H: Business Partner GPARTNER CHAR 10 0
INSTN IS-H: Institute Indicator INSTNR CHAR 10 0
NAME1 IS-H: Last Name/ 1st Name GPNAM1 CHAR 35 0
NAM1S IS-H: Standardized Last Name of Business Partner GPNAM1S CHAR 35 0
NAME2 First Name / Second Name GPNAM2 CHAR 35 0
NAM2S Standardized First Name/2nd Name of Business Partner GPNAM2S CHAR 35 0
NAME3 Third Name GPNAM3 CHAR 35 0
KNAME IS-H: Short Name of Business Partner KZNAME CHAR 12 0
NPKZ IS-H: Indicator for Natural Person (for Address Control) NATPERKZ CHAR 1 0
X Yes
NULL No
SPRAS IS-H: Language of Business Partner SPRAS_GP T002 LANG 1 0
ANRED IS-H: Form-of-Address Key RI_ANRDS CHAR 2 0
TITEL IS-H: Title RI_TITEL CHAR 15 0
NAMZU IS-H: Name Affix RI_NAMZU CHAR 15 0
VORSW IS-H: Name Prefix RI_VORSW CHAR 15 0
GSCHL IS-H: Sex Indicator - Internal GSCHL CHAR 1 0
1 male
2 female
3 unknown
LAND IS-H: Country of Business Partner LAND_GP T005 CHAR 3 0
PSTLZ IS-H: Postal Code of Business Partner PSTLZ_GP CHAR 10 0
PFACH IS-H: PO Box of Business Partner PFACH_GP CHAR 10 0
PLZPF IS-H: Postal Code for PO Box of Business Partner PLZPF_GP CHAR 10 0
ORT IS-H: City of Business Partner ORT_GP CHAR 25 0
ORTS Standardized Name of City where Business Partner is Located ORTS_GP CHAR 30 0
ORT2 District of Business Partner ORT2_GP CHAR 25 0
STRAS IS-H: Street Name and Street Number of Business Partner STRASSE_GP CHAR 30 0
LOEGP Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
GPAR IS-H: Text Designating the General Business Partner Function GPART CHAR 1 0
PERS IS-H: Text Designating the EMPLOYEE Function PERS_D CHAR 1 0
KOSTR IS-H: Text Designating the INSURANCE PROVIDER Function KOSTR CHAR 1 0
DEBIT Text Designating the CUSTOMER Function DEBIT CHAR 1 0
ARBTG IS-H: Text Designating the EMPLOYER Function ARBTG CHAR 1 0
KRKHS IS-H: Text Designating the HOSPITAL Function KRKHS CHAR 1 0
KTTYP IS-H: Indicator Denoting Insurance Provider Group GRU_KZ CHAR 1 0
X Yes
NULL No
KTART IS-H: Insurance Provider Type (e.g. Private, Statutory) KOSTR_ART TN18 CHAR 3 0
ZENTR Key Identifying Insurance Provider's Head Office RI_ZENTR NGPA CHAR 10 0
KKSNR IS-H: Number Identifying the Health Insurer KKSNR CHAR 12 0
KVNUM IS-H: Responsible PPA (panel physician association) KVNUM NGPA CHAR 10 0
KONT1 Contact Person, e.g. Inpatient ANPER1 CHAR 30 0
KONT2 Contact Person, e.g. Outpatient ANPER2 CHAR 30 0
KUEVER IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No KUEVER CHAR 1 0
X Yes
NULL No
REBEA IS-H: Manual Invoice Processing is Allowed REBEARB CHAR 1 0
X Yes
NULL No
SAMRE IS-H: Invoice List Output per IP at Invoice Print SAMMELRE CHAR 1 0
X Yes
NULL No
ZWIAB IS-H: Ind. Specifying if Int. Bill. is to be Performed ABR_ZWI CHAR 1 0
X Yes
NULL No
SORTR IS-H: Sort Rules for Billing ABRSORT CHAR 2 0
01 ???
02 ???
03 ???
ABRLS IS-H: Interim Billing for Svces w/o Confirmation of Coverage ABRLEI_ZWI CHAR 1 0
X Yes
NULL No
ENDLS IS-H: Final Billing for Svces w/o Confirmation of Coverage ENDABR_LEI CHAR 1 0
X Yes
NULL No
ENDAB IS-H: Final Billing only if Diagnosis Entered ENDABR_DIA CHAR 1 0
X Yes
NULL No
SEPRE IS-H: Separate Invoice for Companion SEP_RE CHAR 1 0
X Yes
NULL No
ABRTG IS-H: Interim Billing After x Days as of Admission ABR_TAGE NUMC 3 0
000 Number of Days
ABRIN IS-H: Interim Billing Interval (Weeks/Days/Quarter) ABR_INTERV NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
RHYTH IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) RHYT_ENDAB NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
KUEMAH IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No KUEMAH CHAR 1 0
X Yes
NULL No
KUEMF IS-H: Reminder Period for IV Request in Days KUE_MAFRI NUMC 3 0
001 Number of Days
KUEVS IS-H: Send IV Request Only if Diagnosis Is Maintained KUEVERSAND CHAR 1 0
NULL No Diagnosis Required
1 Admission Diagnosis
2 Referral Diagnosis
3 Admission + Referral Diagnosis
4 Admission or Referral Diagnosis
DIADR IS-H: Print Diagnosis on IV Request (Yes/No) DIADRUCK CHAR 1 0
X Yes
NULL No
AAZKZ IS-H: Admission Notif. to Be Printed in Standard Form Print AUFN_ANZ CHAR 1 0
X Yes
NULL No
ENTAZ IS-H: Discharge Notification to Be Created ENTL_ANZ CHAR 1 0
X Yes
NULL No
VKUAN IS-H: Interval for Extending IV Requests VERL_KUEAN NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
KUANZ IS-H: Interval for Creating IV Requests KUEAN_ZTR NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
PFLZZ IS-H: Insurance Provider Requires Copayment KOSTR_ZUZ CHAR 1 0
X Yes
NULL No
WAERS IS-H: Currency of Insurance Provider WAERS_KTR TCURC CUKY 5 0
LOEKT Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
SPVON Blocking Date From (Entry Block) ISH_SPERRV DATS 8 0
SPBIS IS-H: Blocking Date To (Entry Block To) ISH_SPERRB DATS 8 0
KNAMS Standard Short Name for Search KZNAMS CHAR 12 0
KKSVA IS-H: Health Insurer Number as per Healthcare Smart Card CHIPNR CHAR 10 0
ADRNR IS-H: Address Number ISH_ADRNR CHAR 10 0
KSSNM IS-H: HI Search Name From Ins. Provider Master File (PPA) ISH_KSSNAM CHAR 60 0
KSSNS IS-H: Stnd. HI Search Name from Ins. Provider Master File ISH_KSSNAS CHAR 60 0
PNUMB IS-H: External Partner Number ISH_PNUMB CHAR 15 0
PARTNER_GUID IS-H: GUID of Business Partner ISH_PARTNER_GUID RAW 16 0
PSIGN Institution Is Private PRIVATE CHAR 1 0
X Yes
NULL No
BAG NWCH_EHC_BAG NUMC 5 0

N_VGPAKTR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N_VGPAKTR KTART N_VGPAKTR MANDT TN18 IS-H: Insurance Provider Types MANDT
N_VGPAKTR KTART N_VGPAKTR KTART TN18 IS-H: Insurance Provider Types KTART
N_VGPAKTR KVNUM N_VGPAKTR MANDT NGPA IS-H: Business Partners MANDT
N_VGPAKTR KVNUM N_VGPAKTR KVNUM NGPA IS-H: Business Partners GPART
N_VGPAKTR LAND N_VGPAKTR MANDT T005 Countries MANDT
N_VGPAKTR LAND N_VGPAKTR LAND T005 Countries LAND1
N_VGPAKTR MANDT N_VGPAKTR MANDT T000 Clients MANDT
N_VGPAKTR SPRAS N_VGPAKTR SPRAS T002 Language Keys (Component BC-I18) SPRAS
N_VGPAKTR WAERS N_VGPAKTR MANDT TCURC Currency Codes MANDT
N_VGPAKTR WAERS N_VGPAKTR WAERS TCURC Currency Codes WAERS
N_VGPAKTR ZENTR N_VGPAKTR MANDT NGPA IS-H: Business Partners MANDT
N_VGPAKTR ZENTR N_VGPAKTR ZENTR NGPA IS-H: Business Partners GPART