Follow us on LinkedIn for your next SAP project

SAP Table JGTGPNR

IS-M: Central Business Partner Table

JGTGPNR (IS-M: Central Business Partner Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JGTGPNR to other SAP tables.

JGTGPNR table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
GPNR
IS-M: Business Partner Key
GPNR
CHAR
10 0
XGPLOE
IS-M: Deletion Flag for General Business Partner
JXLV_GP
CHAR
1 0
XGPLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XGPSPE
IS-M/SD: Lock Indicator for General Business Partner
XGPSPE
CHAR
1 0
ERFUSER
Created By
ERFUSER
CHAR
12 0
ERFDATE
Created On
ERFDATE
DATS
8 0
ERFTIME
Time Created
ERFTIME
TIMS
6 0
AENUSER
Last Changed By
AENUSER
CHAR
12 0
AENDATE
Date of Last Change
AENDATE
DATS
8 0
AENTIME
Time of Last Change
AENTIME
TIMS
6 0
JKTOKD
IS-M: Business Partner Account Group
JKTOKD TJG37
CHAR
4 0
MAILN
IS-M: Mail Address
JMAILN
CHAR
12 0
BEGRU
Authorization Group
BRGRU TBRG
CHAR
4 0
BERUFSL
IS-M: Occupation
BERUFSL TJG05
CHAR
8 0
GFORM
Legal status
GFORM TVGF
CHAR
2 0
BRSCH
Industry key
BRSCH T016
CHAR
4 0
BRAN1
Industry Code 1
BRAN1_D TBRC
CHAR
10 0
BRAN2
Industry code 2
BRAN2 TBRC
CHAR
10 0
BRAN3
Industry code 3
BRAN3 TBRC
CHAR
10 0
BRAN4
Industry code 4
BRAN4 TBRC
CHAR
10 0
BRAN5
Industry code 5
BRAN5 TBRC
CHAR
10 0
JGEBDAT
IS-M: Date of Birth of a Business Partner
JGEBDAT
DATS
8 0
GESCH
IS-M: Gender Key
JGESCHL
CHAR
1 0
JFAMST
IS-M: Business Partner's Marital Status
JFAMST TJG45
CHAR
1 0
GPHERK
IS-M: Business Partner Origin
GPHERK TJG41
CHAR
2 0
XNATUR
IS-M: Natural Person Indicator
XNATUR
CHAR
1 0
XVERMSACH
IS-M: BP Authorized to Receive Gifts
XVERMSACH
CHAR
1 0
XOHNE
Indicator: Is the account a one-time account?
XCPDK
CHAR
1 0
XDEBI
IS-M: Indicator: Customer Exists
JXDEBI
CHAR
1 0
KUNNR
IS-M: Customer Number in Previous System
JKUNNR KNA1
CHAR
10 0
FKUNNR
IS-M: Customer Number in Non-SAP System
JFKUNNR
CHAR
10 0
XKREDI
IS-M: Indicator: Vendor Exists
XKREDI
CHAR
1 0
LIFNR
IS-M: Vendor Number in Previous System
JLIFNR LFA1
CHAR
10 0
FLIFNR
IS-M: Vendor Number in Non-SAP System
JFLIFNR
CHAR
10 0
XMITARB
IS-M: Employee Indicator
XMITARB
CHAR
1 0
PERNR
IS-M: Personnel Number
JPERNR2
CHAR
20 0
XNOWERB
IS-M: No Advertising
XNOWERB
CHAR
1 0
GPKLA1
IS-M: BP Class (Not in Use Yet)
GPKLA TJG51
CHAR
4 0
GPKLA2
IS-M: BP Class 2
GPKLA2 TJG53
CHAR
4 0
GPKLA3
IS-M: BP Class 3
GPKLA3 TJG55
CHAR
4 0
GPKLA4
IS-M: BP Class 4
GPKLA4 TJG57
CHAR
4 0
GPKLA5
IS-M: BP Class 5
GPKLA5 TJG59
CHAR
4 0
KATR1
Attribute 1
KATR1 TVK1
CHAR
2 0
KATR2
Attribute 2
KATR2 TVK2
CHAR
2 0
KATR3
Attribute 3
KATR3 TVK3
CHAR
2 0
KATR4
Attribute 4
KATR4 TVK4
CHAR
2 0
KATR5
Attribute 5
KATR5 TVK5
CHAR
2 0
KATR6
Attribute 6
KATR6 TVK6
CHAR
3 0
KATR7
Attribute 7
KATR7 TVK7
CHAR
3 0
KATR8
Attribute 8
KATR8 TVK8
CHAR
3 0
KATR9
Attribute 9
KATR9 TVK9
CHAR
3 0
KATR10
Attribute 10
KATR10 TVK0
CHAR
3 0
XVSRVGES
IS-M: Service Company Indicator
XVSRVGES
CHAR
1 0
XVSGLOEV
IS-M: Deletion Flag for Service Company
JXLV_ZG
CHAR
1 0
XVSGLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XVSGSPE
IS-M/SD: Lock Indicator for Service Company
XZGSPE
CHAR
1 0
XZUST
IS-M: Carrier Indicator
XZUST
CHAR
1 0
XZUSTLOEV
IS-M: Deletion Flag for Carrier
JXLV_ZU
CHAR
1 0
XZUSTLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XZUSSPE
IS-M/SD: Lock Indicator for Carrier
XZUSPE
CHAR
1 0
XVERMPROV
IS-M: Sales Agent - Commission Recipient
XVERMPROV
CHAR
1 0
XVERMPROVV
IS-M: Deletion Flag for Sales Agent/Commission Recipient
JXLV_PV
CHAR
1 0
XVERMPROKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XVERSPE
IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient
XPVSPE
CHAR
1 0
XVERB
IS-M: Association Indicator
XVERB
CHAR
1 0
XVEBLOEV
IS-M: Deletion Flag (Role-Specific)
XLOESCH
CHAR
1 0
XVEBSPE
IS-M: Lock Indicator (Role-Specific)
XSPERR
CHAR
1 0
XINKASSO
IS-M: Field Collector Indicator
XINKASSO
CHAR
1 0
XINKLOEV
IS-M: Deletion Flag for Field Collector
JXLV_IK
CHAR
1 0
XINKLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XINKSPE
IS-M/SD: Lock Indicator for Field Collector
XIKSPE
CHAR
1 0
XRECHER
IS-M: Researcher Indicator
XRECHER
CHAR
1 0
XRECHLOEV
IS-M: Deletion Flag for Researcher
JXLV_RC
CHAR
1 0
XRECHLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XRECHSPE
IS-M/SD: Lock Indicator for Researcher
XRCSPE
CHAR
1 0
MAILNBETR
IS-M: Mail Address of User in Charge
JMAILNBETR
CHAR
12 0
XKAHS
IS-M: Customer Pickup Point Indicator
XKAHS
CHAR
1 0
XKAHLOEV
IS-M: Deletion Flag (Role-Specific)
XLOESCH
CHAR
1 0
XKAHSSPE
IS-M: Lock Indicator (Role-Specific)
XSPERR
CHAR
1 0
XSPEDI
IS-M: Forwarding Agent Indicator
XSPEDI
CHAR
1 0
XSPEDLOEV
IS-M: Deletion Flag for Forwarding Agent
JXLV_SP
CHAR
1 0
XSPEDLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XSPESPE
IS-M/SD: Lock Indicator for Forwarding Agent
XSPSPE
CHAR
1 0
XVERTKUN
IS-M: Sales Customer Indicator
XVERTKUN
CHAR
1 0
XVKUNLOEV
IS-M: Deletion Flag for Sales Customer
JXLV_KU
CHAR
1 0
XVKUNLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XVKUNSPE
IS-M/SD: Lock Indicator for Sales Customer
XKUSPE
CHAR
1 0
XEUW
IS-M: Retailer Indicator
XEUW
CHAR
1 0
XEUWLOEV
IS-M: Deletion Flag for Retailer
JXLV_EW
CHAR
1 0
XEUWLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XEUWSPE
IS-M/SD: Lock Indicator - Retailer
XEWSPE
CHAR
1 0
XINTERN
IS-M: Internal Business Partner Indicator
XINTERN
CHAR
1 0
XINTLOEV
IS-M: Deletion Flag (Role-Specific)
XLOESCH
CHAR
1 0
AUFORG
Sales Office
VKBUR TVBUR
CHAR
4 0
XINTSPE
IS-M: Lock Indicator (Role-Specific)
XSPERR
CHAR
1 0
XSOZIAL
IS-M: Social Facility Indicator
XSOZIAL
CHAR
1 0
XSOZLOEV
IS-M: Deletion Flag (Role-Specific)
XLOESCH
CHAR
1 0
XSOZSPE
IS-M: Lock Indicator (Role-Specific)
XSPERR
CHAR
1 0
XPOST
IS-M: Mail Depot Indicator
XPOST
CHAR
1 0
XPOSLOEV
IS-M: Deletion Flag for Post
JXLV_PO
CHAR
1 0
XPOSLOEKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XPOSSPE
IS-M/SD: Lock Indicator - Post
XPOSPE
CHAR
1 0
XVERLAG
IS-M: Publisher Indicator
XVERLAG
CHAR
1 0
XVERLLOEV
IS-M: Deletion Flag (Role-Specific)
XLOESCH
CHAR
1 0
XVERLSPE
IS-M: Lock Indicator (Role-Specific)
XSPERR
CHAR
1 0
XVERLEIG
IS-M: Indicator: Owned By Publisher
XVERLEIG
CHAR
1 0
VERLVKORG
Sales Organization
VKORG TVKO
CHAR
4 0
ISPCVERL
IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
ISPVERL
CHAR
11 0
XMEDIAK
IS-M: Media customer
XMEDIAK
CHAR
1 0
XMEDIAKLV
IS-M: Deletion Flag for Media Customer
XMKLV
CHAR
1 0
XMEDIAKLKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XMEDIAKSP
IS-M: Lock Indicator for Media Customer
XMKSPE
CHAR
1 0
XINSER
IS-M: Selection Indicator for Advertiser
XINSERENT
CHAR
1 0
XINSERLV
IS-M: Advertiser Deletion Flag
XISLV
CHAR
1 0
XINSERLKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XINSERSP
IS-M: Advertiser Lock Indicator
XISSPE
CHAR
1 0
XMVERM
IS-M: Media Sales Agent Indicator
XMVERMITTL
CHAR
1 0
XMVERMLV
IS-M: Deletion Flag for Media Sales Agent
XMVLV
CHAR
1 0
XMVERMLKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XMVERMSP
IS-M: Lock Indicator for Media Sales Agent
XMVSPE
CHAR
1 0
XAGEN
IS-M: Agency Indicator
XAGENTUR
CHAR
1 0
XAGENLV
IS-M: Agency Deletion Flag
XARLV
CHAR
1 0
XAGENLKZ
IS-M: Deletion Indicator (Role-Specific)
XLOESCHKZ
CHAR
1 0
XAGENLSP
IS-M: Agency Lock Indicator
XARSPE
CHAR
1 0
AGEN_ART
IS-M: Creative Boutique Indicator
XAGEN_KREA
CHAR
1 0
AGEN_STR
IS-M: Distribution Agency Indicator
XAGEN_STR
CHAR
1 0
AGEN_PLAN
IS-M: Planning Agency Indicator
XAGEN_PLAN
CHAR
1 0
AGEN_GRU
IS-M: Agency Type
AGEN_GRUP TJGJ4
CHAR
1 0
XDUB
IS-M: No Longer Used - Credit Query Indicator
XDUBIOS
CHAR
1 0
GP_DUB
IS-M: Credit Query Indicator
JDUBIOS TJGJ0
CHAR
1 0
BON
IS-M: Creditworthiness Indicator
JBONITAET TJGJ2
CHAR
2 0
KLIM_EINZ
IS-M: Individual Credit Limit
JKLIMEINZ
CURR
15 2
KLIM_GES
IS-M: Total Credit Limit
JKLIMGES
CURR
15 2
KLIM_WAERS
IS-M: Currency Key
JWAERS TCURC
CUKY
5 0
WBZKUNNR
IS-M: WBZ, VDZ Number of WBZ Company
JWBZKUNNR
CHAR
6 0
RECHZENTNR
IS-M: WBZ, Computer Center Number
JWBZRZNR TJKW0
CHAR
2 0
JWBZKOMART
IS-M: Communication Type in WBZ Processing
JWBZKOMART
CHAR
1 0
XWBZFIRMA
IS-M: Business Partner Is WBZ Company
XWBZFIRMA
CHAR
1 0
WBZZLSCH
Payment Method for Billing Documents to WBZ Company
WBZZLSCH TJK42
CHAR
1 0
REFBELEG
IS-M/SD: Reference Document in Legacy System
REMELD_ISP
CHAR
20 0
ADRNR
IS-M: Address Number
JADRNR JGTSADR
CHAR
10 0
XISPCTEILN
IS-M: Indicator: Business Partner Is EDI Participant
XISPCTEILN
CHAR
1 0
ISPCTEILN
IS-M: EDI Participant Number
ISPCTEILN
NUMC
8 0
ISPCART
IS-M: EDI Participant Type
ISPCART TJGR1
NUMC
1 0
J_SOC_SECU
Social Insurance Number
J_SOC_SECU
CHAR
20 0
XHOUSEHOLD
IS-M: Household Indicator
XHOUSEHOLD
CHAR
1 0
ADDR_CONV
Time-Dependent Business Partner Addresses Converted
ISM_ADDR_CONV
CHAR
1 0

JGTGPNR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JGTGPNR ADRNR JGTGPNR MANDT JGTSADR
IS-M: Extended Address Management
MANDT
JGTGPNR ADRNR JGTGPNR ADRNR JGTSADR
IS-M: Extended Address Management
ADRNR
JGTGPNR AGEN_GRU JGTGPNR MANDT TJGJ4
IS-M/SD: Indicator for Agency Type
MANDT
JGTGPNR AGEN_GRU JGTGPNR AGEN_GRU TJGJ4
IS-M/SD: Indicator for Agency Type
AGEN_GRU
JGTGPNR AUFORG JGTGPNR MANDT TVBUR
Organizational Unit: Sales Offices
MANDT
JGTGPNR AUFORG JGTGPNR AUFORG TVBUR
Organizational Unit: Sales Offices
VKBUR
JGTGPNR BEGRU JGTGPNR MANDT TBRG
Authorization groups
MANDT
JGTGPNR BEGRU * TBRG
Authorization groups
BROBJ
JGTGPNR BEGRU JGTGPNR BEGRU TBRG
Authorization groups
BRGRU
JGTGPNR BERUFSL JGTGPNR MANDT TJG05
IS-M/SD: Occupations
MANDT
JGTGPNR BERUFSL JGTGPNR BERUFSL TJG05
IS-M/SD: Occupations
BERUFSL
JGTGPNR BON JGTGPNR MANDT TJGJ2
IS-M/SD: Credit Query Indicator
MANDT
JGTGPNR BON JGTGPNR BON TJGJ2
IS-M/SD: Credit Query Indicator
BONITAET
JGTGPNR BRAN1 JGTGPNR MANDT TBRC
Industry Code (Customer Master)
MANDT
JGTGPNR BRAN1 JGTGPNR BRAN1 TBRC
Industry Code (Customer Master)
BRACO
JGTGPNR BRAN2 JGTGPNR MANDT TBRC
Industry Code (Customer Master)
MANDT
JGTGPNR BRAN2 JGTGPNR BRAN2 TBRC
Industry Code (Customer Master)
BRACO
JGTGPNR BRAN3 JGTGPNR MANDT TBRC
Industry Code (Customer Master)
MANDT
JGTGPNR BRAN3 JGTGPNR BRAN3 TBRC
Industry Code (Customer Master)
BRACO
JGTGPNR BRAN4 JGTGPNR BRAN4 TBRC
Industry Code (Customer Master)
BRACO
JGTGPNR BRAN4 JGTGPNR MANDT TBRC
Industry Code (Customer Master)
MANDT
JGTGPNR BRAN5 JGTGPNR MANDT TBRC
Industry Code (Customer Master)
MANDT
JGTGPNR BRAN5 JGTGPNR BRAN5 TBRC
Industry Code (Customer Master)
BRACO
JGTGPNR BRSCH JGTGPNR MANDT T016
Industries
MANDT
JGTGPNR BRSCH JGTGPNR BRSCH T016
Industries
BRSCH
JGTGPNR GFORM JGTGPNR MANDT TVGF
Legal Status (Customer Master)
MANDT
JGTGPNR GFORM JGTGPNR GFORM TVGF
Legal Status (Customer Master)
GFORM
JGTGPNR GPHERK JGTGPNR MANDT TJG41
IS-M/SD: Business Partner Origin
MANDT
JGTGPNR GPHERK JGTGPNR GPHERK TJG41
IS-M/SD: Business Partner Origin
GPHERK
JGTGPNR GPKLA1 JGTGPNR MANDT TJG51
IS-M: BP Classes
MANDT
JGTGPNR GPKLA1 JGTGPNR GPKLA1 TJG51
IS-M: BP Classes
GPKLA
JGTGPNR GPKLA2 JGTGPNR MANDT TJG53
IS-M: BP Class 2
MANDT
JGTGPNR GPKLA2 JGTGPNR GPKLA2 TJG53
IS-M: BP Class 2
GPKLA2
JGTGPNR GPKLA3 JGTGPNR MANDT TJG55
IS-M: BP Class 3
MANDT
JGTGPNR GPKLA3 JGTGPNR GPKLA3 TJG55
IS-M: BP Class 3
GPKLA3
JGTGPNR GPKLA4 JGTGPNR MANDT TJG57
IS-M: BP Class 4
MANDT
JGTGPNR GPKLA4 JGTGPNR GPKLA4 TJG57
IS-M: BP Class 4
GPKLA4
JGTGPNR GPKLA5 JGTGPNR MANDT TJG59
IS-M: BP Class 5
MANDT
JGTGPNR GPKLA5 JGTGPNR GPKLA5 TJG59
IS-M: BP Class 5
GPKLA5
JGTGPNR GP_DUB JGTGPNR GP_DUB TJGJ0
IS-M/SD: Credit Query Indicator
DUBIOS
JGTGPNR GP_DUB JGTGPNR MANDT TJGJ0
IS-M/SD: Credit Query Indicator
MANDT
JGTGPNR ISPCART JGTGPNR MANDT TJGR1
IS-M: EDI Participant Type
MANDT
JGTGPNR ISPCART JGTGPNR ISPCART TJGR1
IS-M: EDI Participant Type
ISPCART
JGTGPNR JFAMST JGTGPNR MANDT TJG45
IS-M/SD: Marital Status
MANDT
JGTGPNR JFAMST JGTGPNR JFAMST TJG45
IS-M/SD: Marital Status
JFAMST
JGTGPNR JKTOKD JGTGPNR JKTOKD TJG37
IS-M/SD: Business Partner Account Groups
JKTOKD
JGTGPNR JKTOKD JGTGPNR MANDT TJG37
IS-M/SD: Business Partner Account Groups
MANDT
JGTGPNR KATR1 JGTGPNR MANDT TVK1
Attribute 1 (customer master)
MANDT
JGTGPNR KATR1 JGTGPNR KATR1 TVK1
Attribute 1 (customer master)
KATR1
JGTGPNR KATR10 JGTGPNR MANDT TVK0
Attribute 10 (customer master)
MANDT
JGTGPNR KATR10 JGTGPNR KATR10 TVK0
Attribute 10 (customer master)
KATR10
JGTGPNR KATR2 JGTGPNR KATR2 TVK2
Attribute 2 (customer master)
KATR2
JGTGPNR KATR2 JGTGPNR MANDT TVK2
Attribute 2 (customer master)
MANDT
JGTGPNR KATR3 JGTGPNR MANDT TVK3
Attribute 3 (customer master)
MANDT
JGTGPNR KATR3 JGTGPNR KATR3 TVK3
Attribute 3 (customer master)
KATR3
JGTGPNR KATR4 JGTGPNR MANDT TVK4
Attribute 4 (customer master)
MANDT
JGTGPNR KATR4 JGTGPNR KATR4 TVK4
Attribute 4 (customer master)
KATR4
JGTGPNR KATR5 JGTGPNR KATR5 TVK5
Attribute 5 (customer master)
KATR5
JGTGPNR KATR5 JGTGPNR MANDT TVK5
Attribute 5 (customer master)
MANDT
JGTGPNR KATR6 JGTGPNR MANDT TVK6
Attribute 6 (customer master)
MANDT
JGTGPNR KATR6 JGTGPNR KATR6 TVK6
Attribute 6 (customer master)
KATR6
JGTGPNR KATR7 JGTGPNR MANDT TVK7
Attribute 7 (customer master)
MANDT
JGTGPNR KATR7 JGTGPNR KATR7 TVK7
Attribute 7 (customer master)
KATR7
JGTGPNR KATR8 JGTGPNR MANDT TVK8
Attribute 8 (customer master)
MANDT
JGTGPNR KATR8 JGTGPNR KATR8 TVK8
Attribute 8 (customer master)
KATR8
JGTGPNR KATR9 JGTGPNR MANDT TVK9
Attribute 9 (customer master)
MANDT
JGTGPNR KATR9 JGTGPNR KATR9 TVK9
Attribute 9 (customer master)
KATR9
JGTGPNR KLIM_WAERS JGTGPNR MANDT TCURC
Currency Codes
MANDT
JGTGPNR KLIM_WAERS JGTGPNR KLIM_WAERS TCURC
Currency Codes
WAERS
JGTGPNR KUNNR JGTGPNR MANDT KNA1
General Data in Customer Master
MANDT
JGTGPNR KUNNR JGTGPNR KUNNR KNA1
General Data in Customer Master
KUNNR
JGTGPNR LIFNR JGTGPNR MANDT LFA1
Vendor Master (General Section)
MANDT
JGTGPNR LIFNR JGTGPNR LIFNR LFA1
Vendor Master (General Section)
LIFNR
JGTGPNR MANDT JGTGPNR MANDT T000
Clients
MANDT
JGTGPNR RECHZENTNR JGTGPNR RECHZENTNR TJKW0
IS-M/SD: WBZ, Computer Center
RECHZENTNR
JGTGPNR RECHZENTNR JGTGPNR MANDT TJKW0
IS-M/SD: WBZ, Computer Center
MANDT
JGTGPNR VERLVKORG JGTGPNR VERLVKORG TVKO
Organizational Unit: Sales Organizations
VKORG
JGTGPNR VERLVKORG JGTGPNR MANDT TVKO
Organizational Unit: Sales Organizations
MANDT
JGTGPNR WBZZLSCH SYST MANDT TJK42
IS-M/SD: Allowed Payment Methods for Incoming Payments
MANDT
JGTGPNR WBZZLSCH T001 LAND1 TJK42
IS-M/SD: Allowed Payment Methods for Incoming Payments
LAND1
JGTGPNR WBZZLSCH JGTGPNR WBZZLSCH TJK42
IS-M/SD: Allowed Payment Methods for Incoming Payments
ZLSCH