SAP ABAP Table JGVGPKLASS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVGPKLASS	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	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
3	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
4	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
5	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
6	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
7	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
8	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
9	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
10	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
11	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
12	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
13	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
14	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
15	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
16	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
17	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
18	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
19	XVSRVGES	☐	XVSRVGES	XFELD	CHAR	1	0	IS-M: Service Company Indicator
20	XZUST	☐	XZUST	XFELD	CHAR	1	0	IS-M: Carrier Indicator
21	XVERMPROV	☐	XVERMPROV	XFELD	CHAR	1	0	IS-M: Sales Agent - Commission Recipient
22	XVERB	☐	XVERB	XFELD	CHAR	1	0	IS-M: Association Indicator
23	XINKASSO	☐	XINKASSO	XFELD	CHAR	1	0	IS-M: Field Collector Indicator
24	XRECHER	☐	XRECHER	XFELD	CHAR	1	0	IS-M: Researcher Indicator
25	XSPEDI	☐	XSPEDI	XFELD	CHAR	1	0	IS-M: Forwarding Agent Indicator
26	XVERTKUN	☐	XVERTKUN	XFELD	CHAR	1	0	IS-M: Sales Customer Indicator
27	XEUW	☐	XEUW	XFELD	CHAR	1	0	IS-M: Retailer Indicator
28	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
29	XSOZIAL	☐	XSOZIAL	XFELD	CHAR	1	0	IS-M: Social Facility Indicator
30	XPOST	☐	XPOST	XFELD	CHAR	1	0	IS-M: Mail Depot Indicator
31	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
32	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
33	ERFUSER_GP	☐	ERFUSER	USNAM	CHAR	12	0	Created By
34	ERFDATE_GP	☐	ERFDATE	DATUM	DATS	8	0	Created On
35	AENUSER_GP	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
36	AENDATE_GP	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
37	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
38	ERFUSER_AD	☐	ERFUSER	USNAM	CHAR	12	0	Created By
39	ERFDATE_AD	☐	ERFDATE	DATUM	DATS	8	0	Created On
40	AENUSER_AD	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
41	AENDATE_AD	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
42	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
43	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
44	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
45	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
46	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
47	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
48	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
49	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
50	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
51	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
52	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
53	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
54	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
55	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
56	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
57	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
58	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
59	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
60	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
61	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
62	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
63	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
64	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
65	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
66	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
67	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
68	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
69	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
70	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
71	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
72	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
73	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
74	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
75	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
76	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
77	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
78	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
79	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
80	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
81	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
82	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
83	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
84	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
85	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
86	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
87	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
88	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
89	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
90	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
91	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
92	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
93	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
94	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
95	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
96	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
97	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
98	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
99	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
100	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
101	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
102	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
103	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
104	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
105	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
106	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
107	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
108	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVGPKLASS	ADRNR	JGTSADR	ADRNR	REF	1	N
2	JGVGPKLASS	ANRED	TJG43	JANRED	REF	C	CN
3	JGVGPKLASS	BEABLS_REF	JRTBEABST	BEABLST	REF	C	CN
4	JGVGPKLASS	BERUFSL	TJG05	BERUFSL	REF	C	CN
5	JGVGPKLASS	BRAN1	TBRC	BRACO	REF	C	CN
6	JGVGPKLASS	BRAN2	TBRC	BRACO	REF	C	CN
7	JGVGPKLASS	BRAN3	TBRC	BRACO	REF	C	CN
8	JGVGPKLASS	BRAN4	TBRC	BRACO	REF	C	CN
9	JGVGPKLASS	BRAN5	TBRC	BRACO	REF	C	CN
10	JGVGPKLASS	BRSCH	T016	BRSCH	REF	C	CN
11	JGVGPKLASS	CITYC	T005G	CITYC	REF	C	CN
12	JGVGPKLASS	COUNC	T005E	COUNC	REF	C	CN
13	JGVGPKLASS	GFORM	TVGF	GFORM	REF	C	CN
14	JGVGPKLASS	GPHERK	TJG41	GPHERK	KEY	1	CN
15	JGVGPKLASS	JFAMST	TJG45	JFAMST	REF	C	CN
16	JGVGPKLASS	JPARVW_REF	TJG39	JPARVW	REF	C	CN
17	JGVGPKLASS	KUNNR	KNA1	KUNNR	REF	C	1
18	JGVGPKLASS	LAND1	T005	LAND1	REF	C	CN
19	JGVGPKLASS	MANDT	T000	MANDT	KEY	1	CN
20	JGVGPKLASS	NAMZU	T535N	TITEL
21	JGVGPKLASS	NIELS	TNLS	NIELS	REF	C	CN
22	JGVGPKLASS	POSNR_REF	JKAP	POSNR	REF	C	CN
23	JGVGPKLASS	REGIO	T005S	BLAND	REF	C	CN
24	JGVGPKLASS	SPRAS	T002	SPRAS	REF	C	CN
25	JGVGPKLASS	TITEL	T535N	TITEL
26	JGVGPKLASS	VBELN_REF	JKAK	VBELN	REF	C	CN
27	JGVGPKLASS	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in