SAP ABAP Table JGTGPNR (IS-M: Central Business Partner Table)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JGTGPNR	Table Relationship Diagram
Short Description	IS-M: Central Business Partner Table

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGTGPNR	ADRNR	JGTSADR	ADRNR	REF	1	N
2	JGTGPNR	AGEN_GRU	TJGJ4	AGEN_GRU	KEY	1	CN
3	JGTGPNR	AUFORG	TVBUR	VKBUR	KEY	1	CN
4	JGTGPNR	BEGRU	TBRG	BRGRU
5	JGTGPNR	BERUFSL	TJG05	BERUFSL	REF	C	CN
6	JGTGPNR	BON	TJGJ2	BONITAET	KEY	1	CN
7	JGTGPNR	BRAN1	TBRC	BRACO	REF	C	CN
8	JGTGPNR	BRAN2	TBRC	BRACO	REF	C	CN
9	JGTGPNR	BRAN3	TBRC	BRACO	REF	C	CN
10	JGTGPNR	BRAN4	TBRC	BRACO	REF	C	CN
11	JGTGPNR	BRAN5	TBRC	BRACO	REF	C	CN
12	JGTGPNR	BRSCH	T016	BRSCH	REF	C	CN
13	JGTGPNR	GFORM	TVGF	GFORM	REF	C	CN
14	JGTGPNR	GPHERK	TJG41	GPHERK	REF	C	CN
15	JGTGPNR	GPKLA1	TJG51	GPKLA	REF	C	CN
16	JGTGPNR	GPKLA2	TJG53	GPKLA2	REF	C	CN
17	JGTGPNR	GPKLA3	TJG55	GPKLA3	REF	C	CN
18	JGTGPNR	GPKLA4	TJG57	GPKLA4	REF	C	CN
19	JGTGPNR	GPKLA5	TJG59	GPKLA5	REF	C	CN
20	JGTGPNR	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
21	JGTGPNR	ISPCART	TJGR1	ISPCART	KEY	1	CN
22	JGTGPNR	JFAMST	TJG45	JFAMST	REF	C	CN
23	JGTGPNR	JKTOKD	TJG37	JKTOKD	KEY	1	CN
24	JGTGPNR	KATR1	TVK1	KATR1	REF	C	CN
25	JGTGPNR	KATR10	TVK0	KATR10	REF	C	CN
26	JGTGPNR	KATR2	TVK2	KATR2	REF	C	CN
27	JGTGPNR	KATR3	TVK3	KATR3	REF	C	CN
28	JGTGPNR	KATR4	TVK4	KATR4	REF	C	CN
29	JGTGPNR	KATR5	TVK5	KATR5	REF	C	CN
30	JGTGPNR	KATR6	TVK6	KATR6	REF	C	CN
31	JGTGPNR	KATR7	TVK7	KATR7	REF	C	CN
32	JGTGPNR	KATR8	TVK8	KATR8	REF	C	CN
33	JGTGPNR	KATR9	TVK9	KATR9	REF	C	CN
34	JGTGPNR	KLIM_WAERS	TCURC	WAERS	REF	C	CN
35	JGTGPNR	KUNNR	KNA1	KUNNR	REF	C	1
36	JGTGPNR	LIFNR	LFA1	LIFNR	REF	C	1
37	JGTGPNR	MANDT	T000	MANDT	KEY	1	CN
38	JGTGPNR	RECHZENTNR	TJKW0	RECHZENTNR	KEY	1	CN
39	JGTGPNR	VERLVKORG	TVKO	VKORG	REF	C	CN
40	JGTGPNR	WBZZLSCH	TJK42	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in