1. Home
  2. Resources
  3. SAP Tables
  4. BUT000 - BP: General data I

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
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
1 Person
2 Organization
3 Group
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
X Yes
NULL No
XBLCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
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
1 Allowed
2 Disallowed
3 Check Permission
NOT_RELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
NOT_LG_COMPETENT Indicator: Not Legally Competent BU_NOT_LEG_COMPETENT CHAR 1 0
X TRUE
NULL FALSE
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
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
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
BBP_IPISP Tax Split BBP_J_1BINDEQU CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
XSEXF Selection: Business partner is female BU_XSEXF CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
NULL BP Is Not an Organizational Center
1 BP Is Also an Organizational Center - BP Existed First
2 BP Is Also an Organizational Center - Org.Cent.Existed First
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
X True
NULL False
NATPERS Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
PAR_REL Business Partner Released BP_PAR_REL CHAR 1 0
NULL Released
X Not released
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