	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

148 COLUMNS | 2 INDEXES | ERP 6.0 | JGTGPNR TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Master Data
1	ERP EHP7	6.0	JGTGPNR	148	2	IS-M: Central Business Partner Table	Master Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, GPNR, XGPLOE, XGPLOEKZ, XGPSPE, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, JKTOKD, MAILN, BEGRU, BERUFSL, GFORM, BRSCH, BRAN1, BRAN2, BRAN3, BRAN4, BRAN5, JGEBDAT, GESCH, JFAMST, GPHERK, XNATUR, XVERMSACH, XOHNE, XDEBI, KUNNR, FKUNNR, XKREDI, LIFNR, FLIFNR, XMITARB, PERNR, XNOWERB, GPKLA1, GPKLA2, GPKLA3, GPKLA4, GPKLA5, KATR1, KATR2, KATR3, KATR4, KATR5, KATR6, KATR7, KATR8, KATR9, KATR10, XVSRVGES, XVSGLOEV, XVSGLOEKZ, XVSGSPE, XZUST, XZUSTLOEV, XZUSTLOEKZ, XZUSSPE, XVERMPROV, XVERMPROVV, XVERMPROKZ, XVERSPE, XVERB, XVEBLOEV, XVEBSPE, XINKASSO, XINKLOEV, XINKLOEKZ, XINKSPE, XRECHER, XRECHLOEV, XRECHLOEKZ, XRECHSPE, MAILNBETR, XKAHS, XKAHLOEV, XKAHSSPE, XSPEDI, XSPEDLOEV, XSPEDLOEKZ, XSPESPE, XVERTKUN, XVKUNLOEV, XVKUNLOEKZ, XVKUNSPE, XEUW, XEUWLOEV, XEUWLOEKZ, XEUWSPE, XINTERN, XINTLOEV, AUFORG, XINTSPE, XSOZIAL, XSOZLOEV, XSOZSPE, XPOST, XPOSLOEV, XPOSLOEKZ, XPOSSPE, XVERLAG, XVERLLOEV, XVERLSPE, XVERLEIG, VERLVKORG, ISPCVERL, XMEDIAK, XMEDIAKLV, XMEDIAKLKZ, XMEDIAKSP, XINSER, XINSERLV, XINSERLKZ, XINSERSP, XMVERM, XMVERMLV, XMVERMLKZ, XMVERMSP, XAGEN, XAGENLV, XAGENLKZ, XAGENLSP, AGEN_ART, AGEN_STR, AGEN_PLAN, AGEN_GRU, XDUB, GP_DUB, BON, KLIM_EINZ, KLIM_GES, KLIM_WAERS, WBZKUNNR, RECHZENTNR, JWBZKOMART, XWBZFIRMA, WBZZLSCH, REFBELEG, ADRNR, XISPCTEILN, ISPCTEILN, ISPCART, J_SOC_SECU, XHOUSEHOLD, ADDR_CONV FROM JGTGPNR

TOP ERP 6.0 | JGTGPNR COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	GPNR	IS-M: Business Partner Key	nvarchar	10	0	CHAR	(N' ')	No		GPNR	Allow NULL?
3	XGPLOE	IS-M: Deletion Flag for General Business Partner	char	1	0	CHAR	(N' ')	Yes		JXLV_GP	Allow NULL?
4	XGPLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
5	XGPSPE	IS-M/SD: Lock Indicator for General Business Partner	char	1	0	CHAR	(N' ')	Yes		XGPSPE	Allow NULL?
6	ERFUSER	Created By	nvarchar	12	0	CHAR	(N' ')	Yes		ERFUSER	Allow NULL?
7	ERFDATE	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		ERFDATE	Allow NULL?
8	ERFTIME	Time Created	nvarchar	6	0	TIMS	(N'000000')	Yes		ERFTIME	Allow NULL?
9	AENUSER	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		AENUSER	Allow NULL?
10	AENDATE	Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		AENDATE	Allow NULL?
11	AENTIME	Time of Last Change	nvarchar	6	0	TIMS	(N'000000')	Yes		AENTIME	Allow NULL?
12	JKTOKD	IS-M: Business Partner Account Group	nvarchar	4	0	CHAR	(N' ')	Yes	TJG37	JKTOKD	Allow NULL?
13	MAILN	IS-M: Mail Address	nvarchar	12	0	CHAR	(N' ')	Yes		JMAILN	Allow NULL?
14	BEGRU	Authorization Group	nvarchar	4	0	CHAR	(N' ')	Yes	TBRG	BRGRU	Allow NULL?
15	BERUFSL	IS-M: Occupation	nvarchar	8	0	CHAR	(N' ')	Yes	TJG05	BERUFSL	Allow NULL?
16	GFORM	Legal status	nvarchar	2	0	CHAR	(N' ')	Yes	TVGF	GFORM	Allow NULL?
17	BRSCH	Industry key	nvarchar	4	0	CHAR	(N' ')	Yes	T016	BRSCH	Allow NULL?
18	BRAN1	Industry Code 1	nvarchar	10	0	CHAR	(N' ')	Yes	TBRC	BRAN1_D	Allow NULL?
19	BRAN2	Industry code 2	nvarchar	10	0	CHAR	(N' ')	Yes	TBRC	BRAN2	Allow NULL?
20	BRAN3	Industry code 3	nvarchar	10	0	CHAR	(N' ')	Yes	TBRC	BRAN3	Allow NULL?
21	BRAN4	Industry code 4	nvarchar	10	0	CHAR	(N' ')	Yes	TBRC	BRAN4	Allow NULL?
22	BRAN5	Industry code 5	nvarchar	10	0	CHAR	(N' ')	Yes	TBRC	BRAN5	Allow NULL?
23	JGEBDAT	IS-M: Date of Birth of a Business Partner	nvarchar	8	0	DATS	(N'00000000')	Yes		JGEBDAT	Allow NULL?
24	GESCH	IS-M: Gender Key	char	1	0	CHAR	(N' ')	Yes		JGESCHL	Allow NULL?
25	JFAMST	IS-M: Business Partner's Marital Status	char	1	0	CHAR	(N' ')	Yes	TJG45	JFAMST	Allow NULL?
26	GPHERK	IS-M: Business Partner Origin	nvarchar	2	0	CHAR	(N' ')	Yes	TJG41	GPHERK	Allow NULL?
27	XNATUR	IS-M: Natural Person Indicator	char	1	0	CHAR	(N' ')	Yes		XNATUR	Allow NULL?
28	XVERMSACH	IS-M: BP Authorized to Receive Gifts	char	1	0	CHAR	(N' ')	Yes		XVERMSACH	Allow NULL?
29	XOHNE	Indicator: Is the account a one-time account?	char	1	0	CHAR	(N' ')	Yes		XCPDK	Allow NULL?
30	XDEBI	IS-M: Indicator: Customer Exists	char	1	0	CHAR	(N' ')	Yes		JXDEBI	Allow NULL?
31	KUNNR	IS-M: Customer Number in Previous System	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	JKUNNR	Allow NULL?
32	FKUNNR	IS-M: Customer Number in Non-SAP System	nvarchar	10	0	CHAR	(N' ')	Yes	*	JFKUNNR	Allow NULL?
33	XKREDI	IS-M: Indicator: Vendor Exists	char	1	0	CHAR	(N' ')	Yes		XKREDI	Allow NULL?
34	LIFNR	IS-M: Vendor Number in Previous System	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	JLIFNR	Allow NULL?
35	FLIFNR	IS-M: Vendor Number in Non-SAP System	nvarchar	10	0	CHAR	(N' ')	Yes	*	JFLIFNR	Allow NULL?
36	XMITARB	IS-M: Employee Indicator	char	1	0	CHAR	(N' ')	Yes		XMITARB	Allow NULL?
37	PERNR	IS-M: Personnel Number	nvarchar	20	0	CHAR	(N' ')	Yes		JPERNR2	Allow NULL?
38	XNOWERB	IS-M: No Advertising	char	1	0	CHAR	(N' ')	Yes		XNOWERB	Allow NULL?
39	GPKLA1	IS-M: BP Class (Not in Use Yet)	nvarchar	4	0	CHAR	(N' ')	Yes	TJG51	GPKLA	Allow NULL?
40	GPKLA2	IS-M: BP Class 2	nvarchar	4	0	CHAR	(N' ')	Yes	TJG53	GPKLA2	Allow NULL?
41	GPKLA3	IS-M: BP Class 3	nvarchar	4	0	CHAR	(N' ')	Yes	TJG55	GPKLA3	Allow NULL?
42	GPKLA4	IS-M: BP Class 4	nvarchar	4	0	CHAR	(N' ')	Yes	TJG57	GPKLA4	Allow NULL?
43	GPKLA5	IS-M: BP Class 5	nvarchar	4	0	CHAR	(N' ')	Yes	TJG59	GPKLA5	Allow NULL?
44	KATR1	Attribute 1	nvarchar	2	0	CHAR	(N' ')	Yes	TVK1	KATR1	Allow NULL?
45	KATR2	Attribute 2	nvarchar	2	0	CHAR	(N' ')	Yes	TVK2	KATR2	Allow NULL?
46	KATR3	Attribute 3	nvarchar	2	0	CHAR	(N' ')	Yes	TVK3	KATR3	Allow NULL?
47	KATR4	Attribute 4	nvarchar	2	0	CHAR	(N' ')	Yes	TVK4	KATR4	Allow NULL?
48	KATR5	Attribute 5	nvarchar	2	0	CHAR	(N' ')	Yes	TVK5	KATR5	Allow NULL?
49	KATR6	Attribute 6	nvarchar	3	0	CHAR	(N' ')	Yes	TVK6	KATR6	Allow NULL?
50	KATR7	Attribute 7	nvarchar	3	0	CHAR	(N' ')	Yes	TVK7	KATR7	Allow NULL?
51	KATR8	Attribute 8	nvarchar	3	0	CHAR	(N' ')	Yes	TVK8	KATR8	Allow NULL?
52	KATR9	Attribute 9	nvarchar	3	0	CHAR	(N' ')	Yes	TVK9	KATR9	Allow NULL?
53	KATR10	Attribute 10	nvarchar	3	0	CHAR	(N' ')	Yes	TVK0	KATR10	Allow NULL?
54	XVSRVGES	IS-M: Service Company Indicator	char	1	0	CHAR	(N' ')	Yes		XVSRVGES	Allow NULL?
55	XVSGLOEV	IS-M: Deletion Flag for Service Company	char	1	0	CHAR	(N' ')	Yes		JXLV_ZG	Allow NULL?
56	XVSGLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
57	XVSGSPE	IS-M/SD: Lock Indicator for Service Company	char	1	0	CHAR	(N' ')	Yes		XZGSPE	Allow NULL?
58	XZUST	IS-M: Carrier Indicator	char	1	0	CHAR	(N' ')	Yes		XZUST	Allow NULL?
59	XZUSTLOEV	IS-M: Deletion Flag for Carrier	char	1	0	CHAR	(N' ')	Yes		JXLV_ZU	Allow NULL?
60	XZUSTLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
61	XZUSSPE	IS-M/SD: Lock Indicator for Carrier	char	1	0	CHAR	(N' ')	Yes		XZUSPE	Allow NULL?
62	XVERMPROV	IS-M: Sales Agent - Commission Recipient	char	1	0	CHAR	(N' ')	Yes		XVERMPROV	Allow NULL?
63	XVERMPROVV	IS-M: Deletion Flag for Sales Agent/Commission Recipient	char	1	0	CHAR	(N' ')	Yes		JXLV_PV	Allow NULL?
64	XVERMPROKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
65	XVERSPE	IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient	char	1	0	CHAR	(N' ')	Yes		XPVSPE	Allow NULL?
66	XVERB	IS-M: Association Indicator	char	1	0	CHAR	(N' ')	Yes		XVERB	Allow NULL?
67	XVEBLOEV	IS-M: Deletion Flag (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCH	Allow NULL?
68	XVEBSPE	IS-M: Lock Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XSPERR	Allow NULL?
69	XINKASSO	IS-M: Field Collector Indicator	char	1	0	CHAR	(N' ')	Yes		XINKASSO	Allow NULL?
70	XINKLOEV	IS-M: Deletion Flag for Field Collector	char	1	0	CHAR	(N' ')	Yes		JXLV_IK	Allow NULL?
71	XINKLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
72	XINKSPE	IS-M/SD: Lock Indicator for Field Collector	char	1	0	CHAR	(N' ')	Yes		XIKSPE	Allow NULL?
73	XRECHER	IS-M: Researcher Indicator	char	1	0	CHAR	(N' ')	Yes		XRECHER	Allow NULL?
74	XRECHLOEV	IS-M: Deletion Flag for Researcher	char	1	0	CHAR	(N' ')	Yes		JXLV_RC	Allow NULL?
75	XRECHLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
76	XRECHSPE	IS-M/SD: Lock Indicator for Researcher	char	1	0	CHAR	(N' ')	Yes		XRCSPE	Allow NULL?
77	MAILNBETR	IS-M: Mail Address of User in Charge	nvarchar	12	0	CHAR	(N' ')	Yes		JMAILNBETR	Allow NULL?
78	XKAHS	IS-M: Customer Pickup Point Indicator	char	1	0	CHAR	(N' ')	Yes		XKAHS	Allow NULL?
79	XKAHLOEV	IS-M: Deletion Flag (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCH	Allow NULL?
80	XKAHSSPE	IS-M: Lock Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XSPERR	Allow NULL?
81	XSPEDI	IS-M: Forwarding Agent Indicator	char	1	0	CHAR	(N' ')	Yes		XSPEDI	Allow NULL?
82	XSPEDLOEV	IS-M: Deletion Flag for Forwarding Agent	char	1	0	CHAR	(N' ')	Yes		JXLV_SP	Allow NULL?
83	XSPEDLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
84	XSPESPE	IS-M/SD: Lock Indicator for Forwarding Agent	char	1	0	CHAR	(N' ')	Yes		XSPSPE	Allow NULL?
85	XVERTKUN	IS-M: Sales Customer Indicator	char	1	0	CHAR	(N' ')	Yes		XVERTKUN	Allow NULL?
86	XVKUNLOEV	IS-M: Deletion Flag for Sales Customer	char	1	0	CHAR	(N' ')	Yes		JXLV_KU	Allow NULL?
87	XVKUNLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
88	XVKUNSPE	IS-M/SD: Lock Indicator for Sales Customer	char	1	0	CHAR	(N' ')	Yes		XKUSPE	Allow NULL?
89	XEUW	IS-M: Retailer Indicator	char	1	0	CHAR	(N' ')	Yes		XEUW	Allow NULL?
90	XEUWLOEV	IS-M: Deletion Flag for Retailer	char	1	0	CHAR	(N' ')	Yes		JXLV_EW	Allow NULL?
91	XEUWLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
92	XEUWSPE	IS-M/SD: Lock Indicator - Retailer	char	1	0	CHAR	(N' ')	Yes		XEWSPE	Allow NULL?
93	XINTERN	IS-M: Internal Business Partner Indicator	char	1	0	CHAR	(N' ')	Yes		XINTERN	Allow NULL?
94	XINTLOEV	IS-M: Deletion Flag (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCH	Allow NULL?
95	AUFORG	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVBUR	VKBUR	Allow NULL?
96	XINTSPE	IS-M: Lock Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XSPERR	Allow NULL?
97	XSOZIAL	IS-M: Social Facility Indicator	char	1	0	CHAR	(N' ')	Yes		XSOZIAL	Allow NULL?
98	XSOZLOEV	IS-M: Deletion Flag (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCH	Allow NULL?
99	XSOZSPE	IS-M: Lock Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XSPERR	Allow NULL?
100	XPOST	IS-M: Mail Depot Indicator	char	1	0	CHAR	(N' ')	Yes		XPOST	Allow NULL?
101	XPOSLOEV	IS-M: Deletion Flag for Post	char	1	0	CHAR	(N' ')	Yes		JXLV_PO	Allow NULL?
102	XPOSLOEKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
103	XPOSSPE	IS-M/SD: Lock Indicator - Post	char	1	0	CHAR	(N' ')	Yes		XPOSPE	Allow NULL?
104	XVERLAG	IS-M: Publisher Indicator	char	1	0	CHAR	(N' ')	Yes		XVERLAG	Allow NULL?
105	XVERLLOEV	IS-M: Deletion Flag (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCH	Allow NULL?
106	XVERLSPE	IS-M: Lock Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XSPERR	Allow NULL?
107	XVERLEIG	IS-M: Indicator: Owned By Publisher	char	1	0	CHAR	(N' ')	Yes		XVERLEIG	Allow NULL?
108	VERLVKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
109	ISPCVERL	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04	nvarchar	11	0	CHAR	(N' ')	Yes		ISPVERL	Allow NULL?
110	XMEDIAK	IS-M: Media customer	char	1	0	CHAR	(N' ')	Yes		XMEDIAK	Allow NULL?
111	XMEDIAKLV	IS-M: Deletion Flag for Media Customer	char	1	0	CHAR	(N' ')	Yes		XMKLV	Allow NULL?
112	XMEDIAKLKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
113	XMEDIAKSP	IS-M: Lock Indicator for Media Customer	char	1	0	CHAR	(N' ')	Yes		XMKSPE	Allow NULL?
114	XINSER	IS-M: Selection Indicator for Advertiser	char	1	0	CHAR	(N' ')	Yes		XINSERENT	Allow NULL?
115	XINSERLV	IS-M: Advertiser Deletion Flag	char	1	0	CHAR	(N' ')	Yes		XISLV	Allow NULL?
116	XINSERLKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
117	XINSERSP	IS-M: Advertiser Lock Indicator	char	1	0	CHAR	(N' ')	Yes		XISSPE	Allow NULL?
118	XMVERM	IS-M: Media Sales Agent Indicator	char	1	0	CHAR	(N' ')	Yes		XMVERMITTL	Allow NULL?
119	XMVERMLV	IS-M: Deletion Flag for Media Sales Agent	char	1	0	CHAR	(N' ')	Yes		XMVLV	Allow NULL?
120	XMVERMLKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
121	XMVERMSP	IS-M: Lock Indicator for Media Sales Agent	char	1	0	CHAR	(N' ')	Yes		XMVSPE	Allow NULL?
122	XAGEN	IS-M: Agency Indicator	char	1	0	CHAR	(N' ')	Yes		XAGENTUR	Allow NULL?
123	XAGENLV	IS-M: Agency Deletion Flag	char	1	0	CHAR	(N' ')	Yes		XARLV	Allow NULL?
124	XAGENLKZ	IS-M: Deletion Indicator (Role-Specific)	char	1	0	CHAR	(N' ')	Yes		XLOESCHKZ	Allow NULL?
125	XAGENLSP	IS-M: Agency Lock Indicator	char	1	0	CHAR	(N' ')	Yes		XARSPE	Allow NULL?
126	AGEN_ART	IS-M: Creative Boutique Indicator	char	1	0	CHAR	(N' ')	Yes		XAGEN_KREA	Allow NULL?
127	AGEN_STR	IS-M: Distribution Agency Indicator	char	1	0	CHAR	(N' ')	Yes		XAGEN_STR	Allow NULL?
128	AGEN_PLAN	IS-M: Planning Agency Indicator	char	1	0	CHAR	(N' ')	Yes		XAGEN_PLAN	Allow NULL?
129	AGEN_GRU	IS-M: Agency Type	char	1	0	CHAR	(N' ')	Yes	TJGJ4	AGEN_GRUP	Allow NULL?
130	XDUB	IS-M: No Longer Used - Credit Query Indicator	char	1	0	CHAR	(N' ')	Yes		XDUBIOS	Allow NULL?
131	GP_DUB	IS-M: Credit Query Indicator	char	1	0	CHAR	(N' ')	Yes	TJGJ0	JDUBIOS	Allow NULL?
132	BON	IS-M: Creditworthiness Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TJGJ2	JBONITAET	Allow NULL?
133	KLIM_EINZ	IS-M: Individual Credit Limit	decimal	15	2	CURR	((0))	Yes		JKLIMEINZ
134	KLIM_GES	IS-M: Total Credit Limit	decimal	15	2	CURR	((0))	Yes		JKLIMGES
135	KLIM_WAERS	IS-M: Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	JWAERS	Allow NULL?
136	WBZKUNNR	IS-M: WBZ, VDZ Number of WBZ Company	nvarchar	6	0	CHAR	(N' ')	Yes		JWBZKUNNR	Allow NULL?
137	RECHZENTNR	IS-M: WBZ, Computer Center Number	nvarchar	2	0	CHAR	(N' ')	Yes	TJKW0	JWBZRZNR	Allow NULL?
138	JWBZKOMART	IS-M: Communication Type in WBZ Processing	char	1	0	CHAR	(N' ')	Yes		JWBZKOMART	Allow NULL?
139	XWBZFIRMA	IS-M: Business Partner Is WBZ Company	char	1	0	CHAR	(N' ')	Yes		XWBZFIRMA	Allow NULL?
140	WBZZLSCH	Payment Method for Billing Documents to WBZ Company	char	1	0	CHAR	(N' ')	Yes	TJK42	WBZZLSCH	Allow NULL?
141	REFBELEG	IS-M/SD: Reference Document in Legacy System	nvarchar	20	0	CHAR	(N' ')	Yes		REMELD_ISP	Allow NULL?
142	ADRNR	IS-M: Address Number	nvarchar	10	0	CHAR	(N' ')	Yes	JGTSADR	JADRNR	Allow NULL?
143	XISPCTEILN	IS-M: Indicator: Business Partner Is EDI Participant	char	1	0	CHAR	(N' ')	Yes		XISPCTEILN	Allow NULL?
144	ISPCTEILN	IS-M: EDI Participant Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		ISPCTEILN	Allow NULL?
145	ISPCART	IS-M: EDI Participant Type	char	1	0	NUMC	(N'0')	Yes	TJGR1	ISPCART	Allow NULL?
146	J_SOC_SECU	Social Insurance Number	nvarchar	20	0	CHAR	(N' ')	No		J_SOC_SECU	Allow NULL?
147	XHOUSEHOLD	IS-M: Household Indicator	char	1	0	CHAR	(N' ')	Yes		XHOUSEHOLD	Allow NULL?
148	ADDR_CONV	Time-Dependent Business Partner Addresses Converted	char	1	0	CHAR	(N' ')	Yes		ISM_ADDR_CONV	Allow NULL?

TOP ERP 6.0 | JGTGPNR INDEXES

Name	Primary	Unique	Type	Columns
JGTGPNR~0	Yes	Yes	CLUSTERED	GPNR, MANDT
JGTGPNR~K	No	No	NONCLUSTERED	KUNNR

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

148 COLUMNS | 2 INDEXES | ERP 6.0 | JGTGPNR TABLE

TOP ERP 6.0 | JGTGPNR COLUMNS

TOP ERP 6.0 | JGTGPNR INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

148 COLUMNS | 2 INDEXES | ERP 6.0 | JGTGPNR TABLE

TOPERP 6.0 | JGTGPNR COLUMNS

TOPERP 6.0 | JGTGPNR INDEXES

TOP ERP 6.0 | JGTGPNR COLUMNS

TOP ERP 6.0 | JGTGPNR INDEXES