SAP Table BUT000
BP: General data I
BUT000 (BP: General data I) 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 BUT000 to other SAP tables.
BUT000 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CLIENT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PARTNER
Business Partner Number
|
BU_PARTNER |
CHAR
|
10 | 0 | ||||||||||
|
TYPE
Business partner category
|
BU_TYPE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BPKIND
Business Partner Type
|
BU_BPKIND | TB004 |
CHAR
|
4 | 0 | |||||||||
|
BU_GROUP
Business Partner Grouping
|
BU_GROUP | TB001 |
CHAR
|
4 | 0 | |||||||||
|
BPEXT
Business Partner Number in External System
|
BU_BPEXT |
CHAR
|
20 | 0 | ||||||||||
|
BU_SORT1
Search term 1 for business partner
|
BU_SORT1 |
CHAR
|
20 | 0 | ||||||||||
|
BU_SORT2
Search term 2 for business partner
|
BU_SORT2 |
CHAR
|
20 | 0 | ||||||||||
|
SOURCE
Data Origin Types
|
BU_SOURCE | TB005 |
CHAR
|
4 | 0 | |||||||||
|
TITLE
Form-of-Address Key
|
AD_TITLE | TSAD3 |
CHAR
|
4 | 0 | |||||||||
|
XDELE
Central Archiving Flag
|
BU_XDELE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XBLCK
Central Block for Business Partner
|
BU_XBLCK |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
AUGRP
Authorization Group
|
BU_AUGRP | TB037 |
CHAR
|
4 | 0 | |||||||||
|
TITLE_LET
Salutation
|
BU_TITLE_LET |
CHAR
|
50 | 0 | ||||||||||
|
BU_LOGSYS
Logical system
|
LOGSYS | TBDLS |
CHAR
|
10 | 0 | |||||||||
|
CONTACT
Business Partner: Contact Permission
|
BU_CONTACT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
NOT_RELEASED
Indicator: Not Released
|
BU_XNOT_RELEASED |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
NOT_LG_COMPETENT
Indicator: Not Legally Competent
|
BU_NOT_LEG_COMPETENT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PRINT_MODE
Business Partner Print Format
|
BU_PRINT_MODE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BP_EEW_DUMMY
Dummy function in length 1
|
DUMMY |
CHAR
|
1 | 0 | ||||||||||
|
NAPR
Business Partner Is a Natural Person Under the Tax Laws
|
BU_NATURAL_PERSON |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BBP_IPISP
Tax Split
|
BBP_J_1BINDEQU |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
RATE
Cost Rate/Revenue Rate for Project Costing
|
DPR_TV_RATE | DPR_RATES |
CHAR
|
15 | 0 | |||||||||
|
NAME_ORG1
Name 1 of organization
|
BU_NAMEOR1 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_ORG2
Name 2 of organization
|
BU_NAMEOR2 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_ORG3
Name 3 of organization
|
BU_NAMEOR3 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_ORG4
Name 4 of organization
|
BU_NAMEOR4 |
CHAR
|
40 | 0 | ||||||||||
|
LEGAL_ENTY
BP: Legal form of organization
|
BU_LEGENTY | TB019 |
CHAR
|
2 | 0 | |||||||||
|
IND_SECTOR
Industry sector
|
BU_INDSECT | TB023 |
CHAR
|
10 | 0 | |||||||||
|
LEGAL_ORG
Legal Entity of Organization
|
BU_LEGAL_ORG | TB032 |
CHAR
|
2 | 0 | |||||||||
|
FOUND_DAT
Date organization founded
|
BU_FOUND_DAT |
DATS
|
8 | 0 | ||||||||||
|
LIQUID_DAT
Liquidation date of organization
|
BU_LIQUID_DAT |
DATS
|
8 | 0 | ||||||||||
|
LOCATION_1
International location number (part 1)
|
BBBNR |
NUMC
|
7 | 0 | ||||||||||
|
LOCATION_2
International location number (Part 2)
|
BBSNR |
NUMC
|
5 | 0 | ||||||||||
|
LOCATION_3
Check digit for the international location number
|
BUBKZ |
NUMC
|
1 | 0 | ||||||||||
|
NAME_LAST
Last name of business partner (person)
|
BU_NAMEP_L |
CHAR
|
40 | 0 | ||||||||||
|
NAME_FIRST
First name of business partner (person)
|
BU_NAMEP_F |
CHAR
|
40 | 0 | ||||||||||
|
NAME_LST2
Other Last Name of a Person
|
BU_NAMEPL2 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_LAST2
Name at birth of business partner
|
BU_BIRTHNM |
CHAR
|
40 | 0 | ||||||||||
|
NAMEMIDDLE
Middle name or second forename of a person
|
BU_NAMEMID |
CHAR
|
40 | 0 | ||||||||||
|
TITLE_ACA1
Academic Title: Key
|
AD_TITLE1 | TSAD2 |
CHAR
|
4 | 0 | |||||||||
|
TITLE_ACA2
Second academic title (key)
|
AD_TITLE2 | TSAD2 |
CHAR
|
4 | 0 | |||||||||
|
TITLE_ROYL
Name supplement, e.g. noble title (key)
|
AD_TITLES | TSAD5 |
CHAR
|
4 | 0 | |||||||||
|
PREFIX1
Name Prefix (Key)
|
AD_PREFIX | TSAD4 |
CHAR
|
4 | 0 | |||||||||
|
PREFIX2
2nd name prefix (key)
|
AD_PREFIX2 | TSAD4 |
CHAR
|
4 | 0 | |||||||||
|
NAME1_TEXT
Full Name
|
BU_NAME1TX |
CHAR
|
80 | 0 | ||||||||||
|
NICKNAME
Nickname of Business Partner (Person)
|
BU_NICKNAM |
CHAR
|
40 | 0 | ||||||||||
|
INITIALS
"Middle Initial" or personal initials
|
AD_INITS |
CHAR
|
10 | 0 | ||||||||||
|
NAMEFORMAT
Name format
|
AD_FORMAT | T005N |
CHAR
|
2 | 0 | |||||||||
|
NAMCOUNTRY
Country for name format rule
|
AD_NAMCTRY | T005 |
CHAR
|
3 | 0 | |||||||||
|
LANGU_CORR
Business Partner: Correspondence Language
|
BU_LANGU_CORR | T002 |
LANG
|
1 | 0 | |||||||||
|
XSEXM
Selection: Business partner is male
|
BU_XSEXM |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSEXF
Selection: Business partner is female
|
BU_XSEXF |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BIRTHPL
Birthplace of business partner
|
BU_BIRTHPL |
CHAR
|
40 | 0 | ||||||||||
|
MARST
Marital Status of Business Partner
|
BU_MARST | TB027 |
CHAR
|
1 | 0 | |||||||||
|
EMPLO
Name of Employer of a Natural Person
|
BU_EMPLO |
CHAR
|
35 | 0 | ||||||||||
|
JOBGR
Occupation/group
|
BU_JOBGR | TB028 |
CHAR
|
4 | 0 | |||||||||
|
NATIO
Nationality
|
BU_NATIO | T005 |
CHAR
|
3 | 0 | |||||||||
|
CNTAX
Obsolete Field
|
BU_CNTAX |
CHAR
|
3 | 0 | ||||||||||
|
CNDSC
Ctry of Origin: Non-Res. Companies
|
BU_CNDSC | T005 |
CHAR
|
3 | 0 | |||||||||
|
PERSNUMBER
Person number
|
AD_PERSNUM |
CHAR
|
10 | 0 | ||||||||||
|
XSEXU
Selection: Sex of business partner is not known
|
BU_XSEXU |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XUBNAME
Obsolete Field
|
BU_XUBNAME | USR02 |
CHAR
|
12 | 0 | |||||||||
|
BU_LANGU
Business partner: Language
|
BU_LANGU | T002 |
LANG
|
1 | 0 | |||||||||
|
BIRTHDT
Date of Birth of Business Partner
|
BU_BIRTHDT |
DATS
|
8 | 0 | ||||||||||
|
DEATHDT
Date of death of business partner
|
BU_DEATHDT |
DATS
|
8 | 0 | ||||||||||
|
PERNO
Personnel Number
|
BU_PERNO |
NUMC
|
8 | 0 | ||||||||||
|
CHILDREN
Obsolete Field
|
BU_CHILDREN |
NUMC
|
2 | 0 | ||||||||||
|
MEM_HOUSE
Obsolete Field
|
BU_MEM_HOUSE |
DEC
|
2 | 0 | ||||||||||
|
PARTGRPTYP
Group type
|
BU_GRPTYP | TB025 |
CHAR
|
4 | 0 | |||||||||
|
NAME_GRP1
Name 1 (group)
|
BU_NAMEGR1 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_GRP2
Name 2 (group)
|
BU_NAMEGR2 |
CHAR
|
40 | 0 | ||||||||||
|
MC_NAME1
Search Help Field 1 (Name 1/Last Name)
|
BU_MCNAME1 |
CHAR
|
35 | 0 | ||||||||||
|
MC_NAME2
Search Help Field 2 (Name 2/First Name)
|
BU_MCNAME2 |
CHAR
|
35 | 0 | ||||||||||
|
CRUSR
User who created the object
|
BU_CRUSR |
CHAR
|
12 | 0 | ||||||||||
|
CRDAT
Date on which the object was created
|
BU_CRDAT |
DATS
|
8 | 0 | ||||||||||
|
CRTIM
Time at which the object was created
|
BU_CRTIM |
TIMS
|
6 | 0 | ||||||||||
|
CHUSR
Last user to change object
|
BU_CHUSR |
CHAR
|
12 | 0 | ||||||||||
|
CHDAT
Date when object was last changed
|
BU_CHDAT |
DATS
|
8 | 0 | ||||||||||
|
CHTIM
Time at which object was last changed
|
BU_CHTIM |
TIMS
|
6 | 0 | ||||||||||
|
PARTNER_GUID
Business Partner GUID
|
BU_PARTNER_GUID |
RAW
|
16 | 0 | ||||||||||
|
ADDRCOMM
Address Number
|
BU_ADDRCOMM |
CHAR
|
10 | 0 | ||||||||||
|
TD_SWITCH
Planned Change Documents for Partner Were Converted
|
BU_TD_SWITCH |
CHAR
|
1 | 0 | ||||||||||
|
IS_ORG_CENTRE
Indicator: Business Partner Is Also an Organizational Center
|
BU_IS_ORG_CENTRE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
DB_KEY
UUID in X form (binary)
|
SYSUUID_X |
RAW
|
16 | 0 | ||||||||||
|
VALID_FROM
Validity Start BUT000 BP Data
|
BU_BP_VALID_FROM |
DEC
|
15 | 0 | ||||||||||
|
VALID_TO
Validity End BUT000 BP Data
|
BU_BP_VALID_TO |
DEC
|
15 | 0 | ||||||||||
|
XPCPT
Business Purpose Completed Flag
|
BU_XPCPT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
NATPERS
Business Partner Is a Natural Person Under the Tax Laws
|
BU_NATURAL_PERSON |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PAR_REL
Business Partner Released
|
BP_PAR_REL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BP_SORT
Sort Field for Phonetic Search; Obsolete
|
BP_SORT_PH |
CHAR
|
20 | 0 | ||||||||||
|
KBANKS
Bank country key
|
BANKS |
CHAR
|
3 | 0 | ||||||||||
|
KBANKL
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||||
BUT000 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| BUT000 | AUGRP | BUT000 | CLIENT |
TB037
Authorization Groups
|
CLIENT |
| BUT000 | AUGRP | 'BUPA' |
TB037
Authorization Groups
|
AUOBJ | |
| BUT000 | AUGRP | BUT000 | AUGRP |
TB037
Authorization Groups
|
AUGRP |
| BUT000 | BPKIND | SYST | MANDT |
TB004
BP types
|
CLIENT |
| BUT000 | BPKIND | BUT000 | BPKIND |
TB004
BP types
|
BPKIND |
| BUT000 | BU_GROUP | BUT000 | CLIENT |
TB001
BP groupings
|
MANDT |
| BUT000 | BU_GROUP | BUT000 | BU_GROUP |
TB001
BP groupings
|
BU_GROUP |
| BUT000 | BU_LANGU | BUT000 | BU_LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| BUT000 | BU_LOGSYS | BUT000 | BU_LOGSYS |
TBDLS
Logical system
|
LOGSYS |
| BUT000 | CLIENT | BUT000 | CLIENT |
T000
Clients
|
MANDT |
| BUT000 | CNDSC | BUT000 | CNDSC |
T005
Countries
|
LAND1 |
| BUT000 | CNDSC | SYST | MANDT |
T005
Countries
|
MANDT |
| BUT000 | IND_SECTOR | SYST | MANDT |
TB023
BP industries (Obsolete ==> TB038A)
|
CLIENT |
| BUT000 | IND_SECTOR | BUT000 | IND_SECTOR |
TB023
BP industries (Obsolete ==> TB038A)
|
IND_SECTOR |
| BUT000 | JOBGR | SYST | MANDT |
TB028
Occupations
|
CLIENT |
| BUT000 | JOBGR | BUT000 | JOBGR |
TB028
Occupations
|
JOBGR |
| BUT000 | LANGU_CORR | BUT000 | LANGU_CORR |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| BUT000 | LEGAL_ENTY | SY | MANDT |
TB019
BP legal forms
|
CLIENT |
| BUT000 | LEGAL_ENTY | BUT000 | LEGAL_ENTY |
TB019
BP legal forms
|
LEGAL_ENTY |
| BUT000 | LEGAL_ORG | SYST | MANDT |
TB032
BP Legal Entity
|
CLIENT |
| BUT000 | LEGAL_ORG | BUT000 | LEGAL_ORG |
TB032
BP Legal Entity
|
LEGAL_ORG |
| BUT000 | MARST | BUT000 | MARST |
TB027
BP marital status
|
MARST |
| BUT000 | MARST | SYST | MANDT |
TB027
BP marital status
|
CLIENT |
| BUT000 | NAMCOUNTRY | SYST | MANDT |
T005
Countries
|
MANDT |
| BUT000 | NAMCOUNTRY | BUT000 | NAMCOUNTRY |
T005
Countries
|
LAND1 |
| BUT000 | NAMEFORMAT | SYST | MANDT |
T005N
Name formats
|
MANDT |
| BUT000 | NAMEFORMAT | BUT000 | NAMCOUNTRY |
T005N
Name formats
|
LAND1 |
| BUT000 | NAMEFORMAT | BUT000 | NAMEFORMAT |
T005N
Name formats
|
NAMEFORMAT |
| BUT000 | NATIO | * |
T005
Countries
|
MANDT | |
| BUT000 | NATIO | BUT000 | NATIO |
T005
Countries
|
LAND1 |
| BUT000 | PARTGRPTYP | SY | MANDT |
TB025
BP group types
|
CLIENT |
| BUT000 | PARTGRPTYP | BUT000 | PARTGRPTYP |
TB025
BP group types
|
PARTGRPTYP |
| BUT000 | PREFIX1 | BUT000 | PREFIX1 |
TSAD4
Name Prefixes (Business Address Services)
|
PREFIX_KEY |
| BUT000 | PREFIX1 | * |
TSAD4
Name Prefixes (Business Address Services)
|
CLIENT | |
| BUT000 | PREFIX2 | * |
TSAD4
Name Prefixes (Business Address Services)
|
CLIENT | |
| BUT000 | PREFIX2 | BUT000 | PREFIX2 |
TSAD4
Name Prefixes (Business Address Services)
|
PREFIX_KEY |
| BUT000 | RATE | SYST | MANDT |
DPR_RATES
Customizing: Cost/Revenue Rates for Project Roles
|
CLIENT |
| BUT000 | RATE | BUT000 | RATE |
DPR_RATES
Customizing: Cost/Revenue Rates for Project Roles
|
RATE |
| BUT000 | SOURCE | BUT000 | CLIENT |
TB005
BP data sources
|
CLIENT |
| BUT000 | SOURCE | BUT000 | SOURCE |
TB005
BP data sources
|
SOURCE |
| BUT000 | TITLE | * |
TSAD3
Forms of Address (Key) (Business Address Services)
|
CLIENT | |
| BUT000 | TITLE | BUT000 | TITLE |
TSAD3
Forms of Address (Key) (Business Address Services)
|
TITLE |
| BUT000 | TITLE_ACA1 | * |
TSAD2
Academic Title (Business Address Services)
|
CLIENT | |
| BUT000 | TITLE_ACA1 | BUT000 | TITLE_ACA1 |
TSAD2
Academic Title (Business Address Services)
|
TITLE_KEY |
| BUT000 | TITLE_ACA2 | * |
TSAD2
Academic Title (Business Address Services)
|
CLIENT | |
| BUT000 | TITLE_ACA2 | BUT000 | TITLE_ACA2 |
TSAD2
Academic Title (Business Address Services)
|
TITLE_KEY |
| BUT000 | TITLE_ROYL | * |
TSAD5
Name Suffixes/Title (Key) (Business Address Services)
|
CLIENT | |
| BUT000 | TITLE_ROYL | BUT000 | TITLE_ROYL |
TSAD5
Name Suffixes/Title (Key) (Business Address Services)
|
TITLE_KEY |
| BUT000 | XUBNAME | * |
USR02
Logon Data (Kernel-Side Use)
|
MANDT | |
| BUT000 | XUBNAME | BUT000 | XUBNAME |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| BUT000 | ZZCNTID | BUT000 | CLIENT | ZTB001 | CLIENT |
| BUT000 | ZZCNTID | BUT000 | ZZCNTID | ZTB001 | CNTID |