SAP ABAP Table N_VGPAPER (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VGPAPER	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	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
4	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
5	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
6	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
7	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
8	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
9	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
10	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
11	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
12	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
13	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
14	ARZT	☐	ARZT	XFELD	CHAR	1	0	IS-H: Indicator that Person Is Physician
15	MAKZ	☐	MAKZ_D	XFELD	CHAR	1	0	Is-H: Person is Employee
16	RPPKZ	☐	RPPKZ	XFELD	CHAR	1	0	IS-H: Personal Data Originates in HR System
17	PFLEG	☐	PFLEG	XFELD	CHAR	1	0	IS-H: Indicator that Person is Nurse
18	BARZT	☐	BARZT	XFELD	CHAR	1	0	IS-H: Indicator that Person is External Physician
19	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
20	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
21	LOEGP	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
22	LOEPE	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
23	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
24	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
25	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
26	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
27	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
28	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
29	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
30	ARZTN	☐	ARZTNR	ARZTNR	CHAR	12	0	IS-H: Identifier for a Physician
31	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
32	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number
33	EXPNR	☐	ISH_PERNR	ISH_PERNR	CHAR	10	0	IS-H: External Personnel Number
34	KVZUL	☐	KV_ZULASS	XFELD	CHAR	1	0	IS-H: Physician Has External Accreditation
35	LIQBE	☐	LIQ_BERECH	XFELD	CHAR	1	0	IS-H: Indicator that physician has internal accreditation
36	NIFNR	☐	ISH_NIFNR	ARZTNR	CHAR	12	0	IS-H CH: NIF number
37	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
38	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner
39	FIXLANR	☐	ISH_LANR_FIX		CHAR	7	0	Fixer Anteil der lebenslangen Arztnummer (Stellen 1-7)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VGPAPER	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in