SAP Table JGTGPNR - IS-M: Central Business Partner Table

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
GPNR X GPNR CHAR 3 10 0 JGTGPNR IS-M: Business Partner Key
XGPLOE JXLV_GP CHAR 13 1 0 IS-M: Deletion Flag for General Business Partner
XGPLOEKZ XLOESCHKZ CHAR 14 1 0 IS-M: Deletion Indicator (Role-Specific)
XGPSPE XGPSPE CHAR 15 1 0 IS-M/SD: Lock Indicator for General Business Partner
ERFUSER ERFUSER CHAR 16 12 0 Created By
ERFDATE ERFDATE DATS 28 8 0 Created On
ERFTIME ERFTIME TIMS 36 6 0 Time Created
AENUSER AENUSER CHAR 42 12 0 Last Changed By
AENDATE AENDATE DATS 54 8 0 Date of Last Change
AENTIME AENTIME TIMS 62 6 0 Time of Last Change
JKTOKD JKTOKD CHAR 68 4 0 IS-M: Business Partner Account Group
MAILN JMAILN CHAR 72 12 0 IS-M: Mail Address
BEGRU BRGRU CHAR 84 4 0 Authorization Group
BERUFSL BERUFSL CHAR 88 8 0 IS-M: Occupation
GFORM GFORM CHAR 96 2 0 Legal status
BRSCH BRSCH CHAR 98 4 0 Industry key
BRAN1 BRAN1_D CHAR 102 10 0 Industry Code 1
BRAN2 BRAN2 CHAR 112 10 0 Industry code 2
BRAN3 BRAN3 CHAR 122 10 0 Industry code 3
BRAN4 BRAN4 CHAR 132 10 0 Industry code 4
BRAN5 BRAN5 CHAR 142 10 0 Industry code 5
JGEBDAT JGEBDAT DATS 152 8 0 IS-M: Date of Birth of a Business Partner
GESCH JGESCHL CHAR 160 1 0 IS-M: Gender Key
JFAMST JFAMST CHAR 161 1 0 IS-M: Business Partner's Marital Status
GPHERK GPHERK CHAR 162 2 0 IS-M: Business Partner Origin
XNATUR XNATUR CHAR 164 1 0 IS-M: Natural Person Indicator
XVERMSACH XVERMSACH CHAR 165 1 0 IS-M: BP Authorized to Receive Gifts
XOHNE XCPDK CHAR 166 1 0 Indicator: Is the account a one-time account?
XDEBI JXDEBI CHAR 167 1 0 IS-M: Indicator: Customer Exists
KUNNR JKUNNR CHAR 168 10 0 KNA1 IS-M: Customer Number in Previous System
FKUNNR JFKUNNR CHAR 178 10 0 KNA1 IS-M: Customer Number in Non-SAP System
XKREDI XKREDI CHAR 188 1 0 IS-M: Indicator: Vendor Exists
LIFNR JLIFNR CHAR 189 10 0 LFA1 IS-M: Vendor Number in Previous System
FLIFNR JFLIFNR CHAR 199 10 0 LFA1 IS-M: Vendor Number in Non-SAP System
XMITARB XMITARB CHAR 209 1 0 IS-M: Employee Indicator
PERNR JPERNR2 CHAR 210 20 0 IS-M: Personnel Number
XNOWERB XNOWERB CHAR 230 1 0 IS-M: No Advertising
GPKLA1 GPKLA CHAR 231 4 0 IS-M: BP Class (Not in Use Yet)
GPKLA2 GPKLA2 CHAR 235 4 0 IS-M: BP Class 2
GPKLA3 GPKLA3 CHAR 239 4 0 IS-M: BP Class 3
GPKLA4 GPKLA4 CHAR 243 4 0 IS-M: BP Class 4
GPKLA5 GPKLA5 CHAR 247 4 0 IS-M: BP Class 5
KATR1 KATR1 CHAR 251 2 0 Attribute 1
KATR2 KATR2 CHAR 253 2 0 Attribute 2
KATR3 KATR3 CHAR 255 2 0 Attribute 3
KATR4 KATR4 CHAR 257 2 0 Attribute 4
KATR5 KATR5 CHAR 259 2 0 Attribute 5
KATR6 KATR6 CHAR 261 3 0 Attribute 6
KATR7 KATR7 CHAR 264 3 0 Attribute 7
KATR8 KATR8 CHAR 267 3 0 Attribute 8
KATR9 KATR9 CHAR 270 3 0 Attribute 9
KATR10 KATR10 CHAR 273 3 0 Attribute 10
XVSRVGES XVSRVGES CHAR 276 1 0 IS-M: Service Company Indicator
XVSGLOEV JXLV_ZG CHAR 277 1 0 IS-M: Deletion Flag for Service Company
XVSGLOEKZ XLOESCHKZ CHAR 278 1 0 IS-M: Deletion Indicator (Role-Specific)
XVSGSPE XZGSPE CHAR 279 1 0 IS-M/SD: Lock Indicator for Service Company
XZUST XZUST CHAR 280 1 0 IS-M: Carrier Indicator
XZUSTLOEV JXLV_ZU CHAR 281 1 0 IS-M: Deletion Flag for Carrier
XZUSTLOEKZ XLOESCHKZ CHAR 282 1 0 IS-M: Deletion Indicator (Role-Specific)
XZUSSPE XZUSPE CHAR 283 1 0 IS-M/SD: Lock Indicator for Carrier
XVERMPROV XVERMPROV CHAR 284 1 0 IS-M: Sales Agent - Commission Recipient
XVERMPROVV JXLV_PV CHAR 285 1 0 IS-M: Deletion Flag for Sales Agent/Commission Recipient
XVERMPROKZ XLOESCHKZ CHAR 286 1 0 IS-M: Deletion Indicator (Role-Specific)
XVERSPE XPVSPE CHAR 287 1 0 IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient
XVERB XVERB CHAR 288 1 0 IS-M: Association Indicator
XVEBLOEV XLOESCH CHAR 289 1 0 IS-M: Deletion Flag (Role-Specific)
XVEBSPE XSPERR CHAR 290 1 0 IS-M: Lock Indicator (Role-Specific)
XINKASSO XINKASSO CHAR 291 1 0 IS-M: Field Collector Indicator
XINKLOEV JXLV_IK CHAR 292 1 0 IS-M: Deletion Flag for Field Collector
XINKLOEKZ XLOESCHKZ CHAR 293 1 0 IS-M: Deletion Indicator (Role-Specific)
XINKSPE XIKSPE CHAR 294 1 0 IS-M/SD: Lock Indicator for Field Collector
XRECHER XRECHER CHAR 295 1 0 IS-M: Researcher Indicator
XRECHLOEV JXLV_RC CHAR 296 1 0 IS-M: Deletion Flag for Researcher
XRECHLOEKZ XLOESCHKZ CHAR 297 1 0 IS-M: Deletion Indicator (Role-Specific)
XRECHSPE XRCSPE CHAR 298 1 0 IS-M/SD: Lock Indicator for Researcher
MAILNBETR JMAILNBETR CHAR 299 12 0 IS-M: Mail Address of User in Charge
XKAHS XKAHS CHAR 311 1 0 IS-M: Customer Pickup Point Indicator
XKAHLOEV XLOESCH CHAR 312 1 0 IS-M: Deletion Flag (Role-Specific)
XKAHSSPE XSPERR CHAR 313 1 0 IS-M: Lock Indicator (Role-Specific)
XSPEDI XSPEDI CHAR 314 1 0 IS-M: Forwarding Agent Indicator
XSPEDLOEV JXLV_SP CHAR 315 1 0 IS-M: Deletion Flag for Forwarding Agent
XSPEDLOEKZ XLOESCHKZ CHAR 316 1 0 IS-M: Deletion Indicator (Role-Specific)
XSPESPE XSPSPE CHAR 317 1 0 IS-M/SD: Lock Indicator for Forwarding Agent
XVERTKUN XVERTKUN CHAR 318 1 0 IS-M: Sales Customer Indicator
XVKUNLOEV JXLV_KU CHAR 319 1 0 IS-M: Deletion Flag for Sales Customer
XVKUNLOEKZ XLOESCHKZ CHAR 320 1 0 IS-M: Deletion Indicator (Role-Specific)
XVKUNSPE XKUSPE CHAR 321 1 0 IS-M/SD: Lock Indicator for Sales Customer
XEUW XEUW CHAR 322 1 0 IS-M: Retailer Indicator
XEUWLOEV JXLV_EW CHAR 323 1 0 IS-M: Deletion Flag for Retailer
XEUWLOEKZ XLOESCHKZ CHAR 324 1 0 IS-M: Deletion Indicator (Role-Specific)
XEUWSPE XEWSPE CHAR 325 1 0 IS-M/SD: Lock Indicator - Retailer
XINTERN XINTERN CHAR 326 1 0 IS-M: Internal Business Partner Indicator
XINTLOEV XLOESCH CHAR 327 1 0 IS-M: Deletion Flag (Role-Specific)
AUFORG VKBUR CHAR 328 4 0 TVBUR Sales Office
XINTSPE XSPERR CHAR 332 1 0 IS-M: Lock Indicator (Role-Specific)
XSOZIAL XSOZIAL CHAR 333 1 0 IS-M: Social Facility Indicator
XSOZLOEV XLOESCH CHAR 334 1 0 IS-M: Deletion Flag (Role-Specific)
XSOZSPE XSPERR CHAR 335 1 0 IS-M: Lock Indicator (Role-Specific)
XPOST XPOST CHAR 336 1 0 IS-M: Mail Depot Indicator
XPOSLOEV JXLV_PO CHAR 337 1 0 IS-M: Deletion Flag for Post
XPOSLOEKZ XLOESCHKZ CHAR 338 1 0 IS-M: Deletion Indicator (Role-Specific)
XPOSSPE XPOSPE CHAR 339 1 0 IS-M/SD: Lock Indicator - Post
XVERLAG XVERLAG CHAR 340 1 0 IS-M: Publisher Indicator
XVERLLOEV XLOESCH CHAR 341 1 0 IS-M: Deletion Flag (Role-Specific)
XVERLSPE XSPERR CHAR 342 1 0 IS-M: Lock Indicator (Role-Specific)
XVERLEIG XVERLEIG CHAR 343 1 0 IS-M: Indicator: Owned By Publisher
VERLVKORG VKORG CHAR 344 4 0 TVKO Sales Organization
ISPCVERL ISPVERL CHAR 348 11 0 IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
XMEDIAK XMEDIAK CHAR 359 1 0 IS-M: Media customer
XMEDIAKLV XMKLV CHAR 360 1 0 IS-M: Deletion Flag for Media Customer
XMEDIAKLKZ XLOESCHKZ CHAR 361 1 0 IS-M: Deletion Indicator (Role-Specific)
XMEDIAKSP XMKSPE CHAR 362 1 0 IS-M: Lock Indicator for Media Customer
XINSER XINSERENT CHAR 363 1 0 IS-M: Selection Indicator for Advertiser
XINSERLV XISLV CHAR 364 1 0 IS-M: Advertiser Deletion Flag
XINSERLKZ XLOESCHKZ CHAR 365 1 0 IS-M: Deletion Indicator (Role-Specific)
XINSERSP XISSPE CHAR 366 1 0 IS-M: Advertiser Lock Indicator
XMVERM XMVERMITTL CHAR 367 1 0 IS-M: Media Sales Agent Indicator
XMVERMLV XMVLV CHAR 368 1 0 IS-M: Deletion Flag for Media Sales Agent
XMVERMLKZ XLOESCHKZ CHAR 369 1 0 IS-M: Deletion Indicator (Role-Specific)
XMVERMSP XMVSPE CHAR 370 1 0 IS-M: Lock Indicator for Media Sales Agent
XAGEN XAGENTUR CHAR 371 1 0 IS-M: Agency Indicator
XAGENLV XARLV CHAR 372 1 0 IS-M: Agency Deletion Flag
XAGENLKZ XLOESCHKZ CHAR 373 1 0 IS-M: Deletion Indicator (Role-Specific)
XAGENLSP XARSPE CHAR 374 1 0 IS-M: Agency Lock Indicator
AGEN_ART XAGEN_KREA CHAR 375 1 0 IS-M: Creative Boutique Indicator
AGEN_STR XAGEN_STR CHAR 376 1 0 IS-M: Distribution Agency Indicator
AGEN_PLAN XAGEN_PLAN CHAR 377 1 0 IS-M: Planning Agency Indicator
AGEN_GRU AGEN_GRUP CHAR 378 1 0 IS-M: Agency Type
XDUB XDUBIOS CHAR 379 1 0 IS-M: No Longer Used - Credit Query Indicator
GP_DUB JDUBIOS CHAR 380 1 0 IS-M: Credit Query Indicator
BON JBONITAET CHAR 381 2 0 IS-M: Creditworthiness Indicator
KLIM_EINZ JKLIMEINZ CURR 383 15 2 IS-M: Individual Credit Limit
KLIM_GES JKLIMGES CURR 391 15 2 IS-M: Total Credit Limit
KLIM_WAERS JWAERS CUKY 399 5 0 TCURC IS-M: Currency Key
WBZKUNNR JWBZKUNNR CHAR 404 6 0 IS-M: WBZ, VDZ Number of WBZ Company
RECHZENTNR JWBZRZNR CHAR 410 2 0 IS-M: WBZ, Computer Center Number
JWBZKOMART JWBZKOMART CHAR 412 1 0 IS-M: Communication Type in WBZ Processing
XWBZFIRMA XWBZFIRMA CHAR 413 1 0 IS-M: Business Partner Is WBZ Company
WBZZLSCH WBZZLSCH CHAR 414 1 0 T042E Payment Method for Billing Documents to WBZ Company
REFBELEG REMELD_ISP CHAR 415 20 0 IS-M/SD: Reference Document in Legacy System
ADRNR JADRNR CHAR 435 10 0 IS-M: Address Number
XISPCTEILN XISPCTEILN CHAR 445 1 0 IS-M: Indicator: Business Partner Is EDI Participant
ISPCTEILN ISPCTEILN NUMC 446 8 0 IS-M: EDI Participant Number
ISPCART ISPCART NUMC 454 1 0 IS-M: EDI Participant Type
J_SOC_SECU J_SOC_SECU CHAR 455 20 0 IS-M: Social Insurance Number
XHOUSEHOLD XHOUSEHOLD CHAR 475 1 0 IS-M: Household Indicator

591578 SAP BP: Frequently asked questions