SAP Table BUT000 - BP: General data I

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
PARTNER X BU_PARTNER CHAR 3 10 0 Business Partner Number
TYPE BU_TYPE CHAR 13 1 0 Business partner category
BPKIND BU_BPKIND CHAR 14 4 0 TB004 Business Partner Type
BU_GROUP BU_GROUP CHAR 18 4 0 TB001 Business Partner Grouping
BPEXT BU_BPEXT CHAR 22 20 0 Business Partner Number in External System
BU_SORT1 BU_SORT1 CHAR 42 20 0 Search term 1 for business partner
BU_SORT2 BU_SORT2 CHAR 62 20 0 Search term 2 for business partner
SOURCE BU_SOURCE CHAR 82 4 0 Data Origin Types
TITLE AD_TITLE CHAR 86 4 0 TSAD3 Form-of-Address Key
XDELE BU_XDELE CHAR 90 1 0 Central Archiving Flag
XBLCK BU_XBLCK CHAR 91 1 0 Central Block for Business Partner
AUGRP BU_AUGRP CHAR 92 4 0 Authorization Group
TITLE_LET BU_TITLE_LET CHAR 96 50 0 Salutation
BU_LOGSYS LOGSYS CHAR 146 10 0 Logical system
CONTACT BU_CONTACT CHAR 156 1 0 Business Partner: Contact Permission
NOT_RELEASED BU_XNOT_RELEASED CHAR 157 1 0 Indicator: Not Released
PRINT_MODE BU_PRINT_MODE CHAR 158 1 0 Business Partner Print Format
BP_EEW_DUMMY DUMMY CHAR 159 1 0 Dummy function in length 1
NAME_ORG1 BU_NAMEOR1 CHAR 179 40 0 Name 1 of organization
NAME_ORG2 BU_NAMEOR2 CHAR 219 40 0 Name 2 of organization
NAME_ORG3 BU_NAMEOR3 CHAR 259 40 0 Name 3 of organization
NAME_ORG4 BU_NAMEOR4 CHAR 299 40 0 Name 4 of organization
LEGAL_ENTY BU_LEGENTY CHAR 339 2 0 TB019 BP: Legal form of organization
IND_SECTOR BU_INDSECT CHAR 341 10 0 TB023 Industry sector
LEGAL_ORG BU_LEGAL_ORG CHAR 351 2 0 TB032 Legal Entity of Organization
FOUND_DAT BU_FOUND_DAT DATS 353 8 0 Date organization founded
LIQUID_DAT BU_LIQUID_DAT CHAR 361 1 0 Liquidation date of organization
LOCATION_1 BBBNR NUMC 369 7 0 International location number (part 1)
LOCATION_2 BBSNR NUMC 376 5 0 International location number (Part 2)
LOCATION_3 BUBKZ NUMC 381 1 0 Check digit for the international location number
NAME_LAST BU_NAMEP_L CHAR 382 40 0 Last name of business partner (person)
NAME_FIRST BU_NAMEP_F CHAR 422 40 0 First name of business partner (person)
NAME_LST2 BU_NAMEPL2 CHAR 462 40 0 Other Last Name of a Person
NAME_LAST2 BU_BIRTHNM CHAR 502 40 0 Name at birth of business partner
NAMEMIDDLE BU_NAMEMID CHAR 542 40 0 Middle name or second forename of a person
TITLE_ACA1 AD_TITLE1 CHAR 582 4 0 Academic Title: Key
TITLE_ACA2 AD_TITLE2 CHAR 586 4 0 Second academic title (key)
TITLE_ROYL AD_TITLES CHAR 590 4 0 Name supplement, e.g. noble title (key)
PREFIX1 AD_PREFIX CHAR 594 4 0 Name Prefix (Key)
PREFIX2 AD_PREFIX2 CHAR 598 4 0 2nd name prefix (key)
NAME1_TEXT BU_NAME1TX CHAR 602 80 0 Full Name
NICKNAME BU_NICKNAM CHAR 682 40 0 Nickname of Business Partner (Person)
INITIALS AD_INITS CHAR 722 10 0 "Middle Initial" or personal initials
NAMEFORMAT AD_FORMAT CHAR 732 2 0 T005N Name format
NAMCOUNTRY AD_NAMCTRY CHAR 734 3 0 T005 Country for name format rule
LANGU_CORR BU_LANGU_CORR LANG 737 1 0 T002 Business Partner: Correspondence Language
XSEXM BU_XSEXM CHAR 738 1 0 Selection: Business partner is male
XSEXF BU_XSEXF CHAR 739 1 0 Selection: Business partner is female
BIRTHPL BU_BIRTHPL CHAR 740 40 0 Birthplace of business partner
MARST BU_MARST CHAR 780 1 0 TB027 Marital Status of Business Partner
EMPLO BU_EMPLO CHAR 781 35 0 Employer of business partner
JOBGR BU_JOBGR CHAR 816 4 0 TB028 Occupation/group
NATIO BU_NATIO CHAR 820 3 0 T005 Nationality
CNTAX BU_CNTAX CHAR 823 3 0 T005 Obsolete Field
CNDSC BU_CNDSC CHAR 826 3 0 T005 Ctry of Origin: Non-Res. Companies
PERSNUMBER AD_PERSNUM CHAR 829 10 0 ADRP Person number
XSEXU BU_XSEXU CHAR 839 1 0 Selection: Sex of business partner is not known
XUBNAME BU_XUBNAME CHAR 840 12 0 USR02 Obsolete Field
BU_LANGU BU_LANGU LANG 852 1 0 T002 Business partner: Language
BIRTHDT BU_BIRTHDT DATS 853 8 0 Date of birth of business partner
DEATHDT BU_DEATHDT DATS 861 8 0 Date of death of business partner
PERNO BU_PERNO NUMC 869 8 0 Personnel Number
CHILDREN BU_CHILDREN NUMC 877 2 0 Obsolete Field
MEM_HOUSE BU_MEM_HOUSE DEC 879 2 0 Obsolete Field
PARTGRPTYP BU_GRPTYP CHAR 881 4 0 Group type
NAME_GRP1 BU_NAMEGR1 CHAR 885 40 0 Name 1 (group)
NAME_GRP2 BU_NAMEGR2 CHAR 925 40 0 Name 2 (group)
MC_NAME1 BU_MCNAME1 CHAR 965 35 0 Search Help Field 1 (Name 1/Last Name)
MC_NAME2 BU_MCNAME2 CHAR 1000 35 0 Search Help Field 2 (Name 2/First Name)
CRUSR BU_CRUSR CHAR 1035 12 0 User who created the object
CRDAT BU_CRDAT DATS 1047 8 0 Date on which the object was created
CRTIM BU_CRTIM TIMS 1055 6 0 Time at which the object was created
CHUSR BU_CHUSR CHAR 1061 12 0 Last user to change object
CHDAT BU_CHDAT DATS 1073 8 0 Date on which the object was last changed
CHTIM BU_CHTIM TIMS 1081 6 0 Time at which object was last changed
PARTNER_GUID BU_PARTNER_GUID RAW 1087 16 0 Business Partner GUID
ADDRCOMM BU_ADDRCOMM CHAR 1103 10 0 Address Number
TD_SWITCH BU_TD_SWITCH CHAR 1113 1 0 Planned Change Documents for Partner Were Converted
VALID_FROM BU_BP_VALID_FROM DEC 1114 15 0 Validity Start BUT000 BP Data
VALID_TO BU_BP_VALID_TO DEC 1122 15 0 Validity End BUT000 BP Data
NATPERS BU_NATURAL_PERSON CHAR 1130 1 0 Business Partner Is a Natural Person Under the Tax Laws
PAR_REL BP_PAR_REL CHAR 1131 1 0 Business Partner Released
BP_SORT BP_SORT_PH CHAR 1132 20 0 OBSOLETE: Sort Field for Phonetic Search
KBANKS BANKS CHAR 1152 3 0 T005 Bank country key
KBANKL BANKK CHAR 1155 15 0 Bank Keys

910735Log texts settings and functions
893900Report for inconsistencies b/w BUT000 & relationships
949259BP_ALL: Time-dep. general data in EA-FINSERV not permitted
1610170Validity range variable table not cleared
1609080Incorrect validity range variables are passed in BP tables
1606772Incorrect valid range variables are passed in BP tables
1600858Wrong attributes is passed in the BUT020 table of BP
1228662Upgrade: Time dependency business partner, conversion
1024253Matchcode regeneration in Unicode systems
675800SRM business partner customer enhancement: Fields/Tables
785802PPOMA_BBP: 'Defective' users in EBP
1386310Creating SRM business partner field extensions
848384DB2-z/OS: Inconsistent fields with DDIC type RAW/LRAW/VARC
1358188Correspondence Inbound process
1105558BP_CVI: Migration report from Note 851445 terminates
398888BP_TR1: Composite note and FAQs about bus partner conversion
584279Conversion of appends into a Customizing Include
591578 SAP BP: Frequently asked questions
810634Business partner data: Activation of time dependency
935152AM 885 when assigning a Type 3 address (contact person)
536414CRM 3.0/3.1 SAP Composite Note: Middleware reorganization
918510Time dependency of the business partner as of SRM_SERVER 550
704989Upload requests are not supported by BUAG_MAIN
946391Search help "Customer by real estate contract" without hits
722264SAP-BP: Able to change address in the SAP business partner
887348SRMSUS: FAQ for error analysis and logging OSS tickets
864222Composite SAP note on the data exchange of EEW enhancements
672960User-defined fields 2
821235Customer enhancement for maintaining BP causes errors
803647 CRM BP: Change Pointer for CRM-BP BAPIs
595442Poor performance for 'Partner by Address' search help
724492BP_DIA: Correspondence language for SAP business partner
656108BP_TR1: Language missing in organizations after conversion
645872BP_TR1: Conversion of form of addr:Corr report for tab. ADRC
717831BP_ADU: Various corrections for report RFSBPBUT021
689957BP_TR2: Correction report adjustment for table ADRC
622812SAP BP conversion: RFTBUP01 BP creation no GUID generated
700960BP_TR1: Incomplete link between SAP-BP and TR-BP
694481Name change is not transferred to short text
611471Initial load of BUPA_MAIN from R/3 deletes data in the CRM
599593Collective Note for Upgrade Reports for 30SP15 / 3.1SP05
652224GP relationships: Delta update reads entire BUT000
625797Name of organization not replicated correction report
619140Direct input: Adress memory inconsistent
602039BAFin(German Fed.Fin.Sup.Auth.)§24c:Date of birth not filled
569962Data exchange enhancement with CI include
529920KNA1 fields not contained in CRM BP data model
452349Filter delta download BUPA_MAIN / BUPA_REL
516507SAP BP: Business partner not locked with parallel address ch
513052 SAP-BP: BAPI_BUPA_SEARCH: Search for postal code & MC_NAME1
505638Performance during intersection and check for duplicates
457532Industry of the 4.6C BP is not transferred to CRM
166833IS-U/CCS: Notes on inst. & prod. system operation