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

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	ISMAM_TXW_JGTGPNR	Table Relationship Diagram
Short Description	DART IS-M: Central Business Partner Table

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in	471