SAP TABLES | Basis Components | Basis Services / Communication Interfaces | Business Partner Foundation(BC-SRV-BP) SAP BC

BUT000 SAP BP: General data I Table and data







BUT000 is a standard SAP Table which is used to store BP: General data I data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP BUT000 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP BUT000 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
CLIENTMANDTCLNT3 T000Client
PARTNERBU_PARTNERCHAR10 Business Partner NumberALPHA
.INCLUDEBUS000_DAT BP: General Data I (Data Fields - External)
.INCLUDEBUS000A CBP: General data (independent of partner cat.)
.INCLUDEBUS000AINI CBP: General Data (not dep. on Part. Cat.), Initial Screen
TYPEBU_TYPECHAR1 Business partner category
BPKINDBU_BPKINDCHAR4 TB004Business Partner Type
BU_GROUPBU_GROUPCHAR4 TB001Business Partner Grouping
BPEXTBU_BPEXTCHAR20 Business Partner Number in External System
.INCLUDEBUS000ADAT CBP: General Data (not dep. on Part. Cat.), Data Screens
BU_SORT1BU_SORT1CHAR20 Search term 1 for business partner
BU_SORT2BU_SORT2CHAR20 Search term 2 for business partner
SOURCEBU_SOURCECHAR4 TB005Data Origin Types
TITLEAD_TITLECHAR4 TSAD3Form-of-Address Key
XDELEBU_XDELECHAR1 Central Archiving Flag
XBLCKBU_XBLCKCHAR1 Central Block for Business Partner
AUGRPBU_AUGRPCHAR4 TB037Authorization Group
TITLE_LETBU_TITLE_LETCHAR50 Salutation
BU_LOGSYSLOGSYSCHAR10 TBDLSLogical systemALPHA
CONTACTBU_CONTACTCHAR1 Business Partner: Contact Permission
NOT_RELEASEDBU_XNOT_RELEASEDCHAR1 Indicator: Not Released
NOT_LG_COMPETENTBU_NOT_LEG_COMPETENTCHAR1 Indicator: Not Legally Competent
PRINT_MODEBU_PRINT_MODECHAR1 Business Partner Print Format
.INCLUDEINCL_EEW_BUT000 EEW Extension of BUT000 (Contains CI)
BP_EEW_DUMMYDUMMYCHAR1 Dummy function in length 1
.APPENDBBP_ICC_APP_BUSPAR_BR GLO : BP extension for Brazil.
.INCLUDEBBP_ICC_BP_BR Business Partner Enhancement for Brazil
NAPRBU_NATURAL_PERSONCHAR1 Business Partner Is a Natural Person Under the Tax Laws
BBP_IPISPBBP_J_1BINDEQUCHAR1 Tax Split



.APPENDPRP_BUPA_RATE Cost/Revenue Type in Resource Role
RATEDPR_TV_RATECHAR15 DPR_RATESCost Rate/Revenue Rate for Project Costing
.INCLUDEBUS000O CBP: General data (Organization)
.INCLUDEBUS000O_CHAR CBP: General Data, Organization (CHAR Fields)
NAME_ORG1BU_NAMEOR1CHAR40 Name 1 of organization
NAME_ORG2BU_NAMEOR2CHAR40 Name 2 of organization
NAME_ORG3BU_NAMEOR3CHAR40 Name 3 of organization
NAME_ORG4BU_NAMEOR4CHAR40 Name 4 of organization
LEGAL_ENTYBU_LEGENTYCHAR2 TB019BP: Legal form of organization
IND_SECTORBU_INDSECTCHAR10 TB023Industry sector
LEGAL_ORGBU_LEGAL_ORGCHAR2 TB032Legal Entity of Organization
.INCLUDEBUS000O_NCHR CBP: General Data, Organization (Non CHAR Fields)
FOUND_DATBU_FOUND_DATDATS8 Date organization founded
LIQUID_DATBU_LIQUID_DATDATS8 Liquidation date of organization
LOCATION_1BBBNRNUMC7 International location number (part 1)
LOCATION_2BBSNRNUMC5 International location number (Part 2)
LOCATION_3BUBKZNUMC1 Check digit for the international location number
.INCLUDEBUS000N CBP: General Data, Person
.INCLUDEBUS000N_CHAR CBP: General Data, Person (CHAR Fields)
NAME_LASTBU_NAMEP_LCHAR40 Last name of business partner (person)
NAME_FIRSTBU_NAMEP_FCHAR40 First name of business partner (person)
NAME_LST2BU_NAMEPL2CHAR40 Other Last Name of a Person
NAME_LAST2BU_BIRTHNMCHAR40 Name at birth of business partner
NAMEMIDDLEBU_NAMEMIDCHAR40 Middle name or second forename of a person
TITLE_ACA1AD_TITLE1CHAR4 TSAD2Academic Title: Key
TITLE_ACA2AD_TITLE2CHAR4 TSAD2Second academic title (key)
TITLE_ROYLAD_TITLESCHAR4 TSAD5Name supplement, e.g. noble title (key)
PREFIX1AD_PREFIXCHAR4 TSAD4Name Prefix (Key)
PREFIX2AD_PREFIX2CHAR4 TSAD42nd name prefix (key)
NAME1_TEXTBU_NAME1TXCHAR80 Full Name
NICKNAMEBU_NICKNAMCHAR40 Nickname of Business Partner (Person)
INITIALSAD_INITSCHAR10 "Middle Initial" or personal initials
NAMEFORMATAD_FORMATCHAR2 T005NName format
NAMCOUNTRYAD_NAMCTRYCHAR3 T005Country for name format rule
LANGU_CORRBU_LANGU_CORRLANG1 T002Business Partner: Correspondence LanguageISOLA
XSEXMBU_XSEXMCHAR1 Selection: Business partner is male
XSEXFBU_XSEXFCHAR1 Selection: Business partner is female
BIRTHPLBU_BIRTHPLCHAR40 Birthplace of business partner
MARSTBU_MARSTCHAR1 TB027Marital Status of Business Partner
EMPLOBU_EMPLOCHAR35 Name of Employer of a Natural Person
JOBGRBU_JOBGRCHAR4 TB028Occupation/group
NATIOBU_NATIOCHAR3 T005Nationality
CNTAXBU_CNTAXCHAR3
*
Obsolete Field
CNDSCBU_CNDSCCHAR3 T005Ctry of Origin: Non-Res. Companies
PERSNUMBERAD_PERSNUMCHAR10
*
Person numberALPHA
XSEXUBU_XSEXUCHAR1 Selection: Sex of business partner is not known
XUBNAMEBU_XUBNAMECHAR12 USR02Obsolete Field
BU_LANGUBU_LANGULANG1 T002Business partner: LanguageISOLA
.INCLUDEBUS000N_NCHR CBP: General Data, Person (Non CHAR Fields)





BIRTHDTBU_BIRTHDTDATS8 Date of Birth of Business Partner
DEATHDTBU_DEATHDTDATS8 Date of death of business partner
PERNOBU_PERNONUMC8 Personnel Number
CHILDRENBU_CHILDRENNUMC2 Obsolete Field
MEM_HOUSEBU_MEM_HOUSEDEC2 Obsolete Field
.INCLUDEBUS000G CBP: General data (group of people)
PARTGRPTYPBU_GRPTYPCHAR4 TB025Group type
NAME_GRP1BU_NAMEGR1CHAR40 Name 1 (group)
NAME_GRP2BU_NAMEGR2CHAR40 Name 2 (group)
.INCLUDEBUS000_INT BP: General Data I (Data Fields - Internal)
.INCLUDEBUS000AINT CBP: Internal general data (not dependent on partner cat.)
MC_NAME1BU_MCNAME1CHAR35 Search Help Field 1 (Name 1/Last Name)
MC_NAME2BU_MCNAME2CHAR35 Search Help Field 2 (Name 2/First Name)
CRUSRBU_CRUSRCHAR12 User who created the object
CRDATBU_CRDATDATS8 Date on which the object was created
CRTIMBU_CRTIMTIMS6 Time at which the object was created
CHUSRBU_CHUSRCHAR12 Last user to change object
CHDATBU_CHDATDATS8 Date when object was last changed
CHTIMBU_CHTIMTIMS6 Time at which object was last changed
PARTNER_GUIDBU_PARTNER_GUIDRAW16 Business Partner GUID
ADDRCOMMBU_ADDRCOMMCHAR10
*
Address NumberALPHA
TD_SWITCHBU_TD_SWITCHCHAR1 Planned Change Documents for Partner Were Converted
IS_ORG_CENTREBU_IS_ORG_CENTRECHAR1 Indicator: Business Partner Is Also an Organizational Center
DB_KEYSYSUUID_XRAW16 UUID in X form (binary)
VALID_FROMBU_BP_VALID_FROMDEC15 Validity Start BUT000 BP Data
VALID_TOBU_BP_VALID_TODEC15 Validity End BUT000 BP Data
XPCPTBU_XPCPTCHAR1 Business Purpose Completed Flag
.APPENDAPP_BUT000_TAX Append BUT000: Indicator Natural Person for Taxes
NATPERSBU_NATURAL_PERSONCHAR1 Business Partner Is a Natural Person Under the Tax Laws
.APPENDBUT000_TR Obsolete: Business Partner: Treasury Append
PAR_RELBP_PAR_RELCHAR1 Business Partner Released
BP_SORTBP_SORT_PHCHAR20 Sort Field for Phonetic Search; Obsolete
.APPENDIBKK20 Business Partner: Further Data for BCA
KBANKSBANKSCHAR3
*
Bank country key
KBANKLBANKKCHAR15 Bank Keys



Key field
Non-key field

BUT000 relationships with other tables


ICLCCEVENT-Claim Bundle
     ICLCCEVENTZ-Claim Bundle - Postal Code - Assignment
     ICLCCEVENTR-Claim Bundle - Region - Assignment
     ICLCCEVENTL-Claim Bundle - Location Address - Assignment
     TICL001-Claim Bundle Type
     ICLCCEVENTB-Claim Bundle - Participant Occurrence
          BUT000-BP: General Data I
               BUT020-BP: Addresses
                    ADRC-Addresses (Business Address Services)
                         ADR2-Telephone Numbers (Business Address Services)


ICLCLAIM-Claim
     ICLPARTOCC-Participant Occurrence
          BUT000-BP: General Data I
               BUT020-BP: Addresses
               DFKKBPTAXNUM-Tax Numbers for Business Partner
                    ADRC-Addresses (Business Address Services)
                         ADR2-Telephone Numbers (Business Address Services)
     ICLITEMAU-Damaged Vehicle
     ICLSUBCL-Subclaim


BUT000-BP: General data I
     BUT100-BP: Roles
     BUT020-BP: Addresses
     BUT0BK-BP: Bank details
     REBP_OBJREL (OBJREL)-Business Partner-Object Relationship (VIBPOBJREL)
          REBP_OBJREL_X (OBJREL_X)-Business Partner-Object Relationship and Add.Field
          RECN_CONTRACT (CONTRACT)-Real Estate Contract
          REBD_BUSINESS_ENTITY (BUSENTITY)-Business Entity (from VIOB01)
          REBD_BUILDING (BUILDING)-Building (from VIOB03)
          REBD_PROPERTY (PROPERTY)-Property (from VIOB02)
          REBD_RENTAL_OBJECT (RENTALOBJECT)-Rental Object (VIMI01)
          ADRC-Addresses (Business Address Services)


BUT000-Business Partner, General
     UKMBP_CMS-Business Partner, Credit Data
          UKMBP_CMS_SGM-Credit Segment