SAP ABAP Table N_VGPADEB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VGPADEB	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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
5	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
6	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
7	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
8	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
9	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
10	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
11	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
12	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
13	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
14	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
15	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
16	RFDEB	☐	RF_KUNNR	KUNNR	CHAR	10	0	Customer Number of FI Customer
17	LOEGP	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
18	LOEDE	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
19	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
20	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
21	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
22	PFACH	☐	PFACH_GP	ISH_PFACH	CHAR	10	0	IS-H: PO Box of Business Partner
23	PLZPF	☐	PLZPF_GP	ISH_PLZPF	CHAR	10	0	IS-H: Postal Code for PO Box of Business Partner
24	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
25	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
26	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
27	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
28	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
29	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number
30	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
31	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VGPADEB	BUKRS	T001	BUKRS	KEY	1	CN
2	N_VGPADEB	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in