SAP Table

BUT000 BP: General data I

SAP table BUT000 has 2 primary key fields being CLIENT,PARTNER.

/ Fields

BUT000 columns.

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

BUT000 foreign keys.

Table Field Check Table Description Check Field
BUT000 BPKIND TB004 BP types BPKIND
BUT000 BU_GROUP TB001 BP groupings MANDT
BUT000 BU_GROUP TB001 BP groupings BU_GROUP
BUT000 BU_LANGU T002 Language Keys (Component BC-I18) SPRAS
BUT000 BU_LOGSYS TBDLS Logical system LOGSYS
BUT000 CLIENT T000 Clients MANDT
BUT000 CNDSC T005 Countries MANDT
BUT000 CNDSC T005 Countries LAND1
BUT000 GENDER TB995 BP Gender GENDER
BUT000 JOBGR TB028 Occupations JOBGR
BUT000 LANGU_CORR T002 Language Keys (Component BC-I18) SPRAS
BUT000 LEGAL_ENTY TB019 BP legal forms LEGAL_ENTY
BUT000 LEGAL_ORG TB032 BP Legal Entity LEGAL_ORG
BUT000 MARST TB027 BP marital status MARST
BUT000 NAMCOUNTRY T005 Countries MANDT
BUT000 NAMCOUNTRY T005 Countries LAND1
BUT000 NAMEFORMAT T005N Name formats MANDT
BUT000 NAMEFORMAT T005N Name formats LAND1
BUT000 NAMEFORMAT T005N Name formats NAMEFORMAT
BUT000 NATIO T005 Countries MANDT
BUT000 NATIO T005 Countries LAND1
BUT000 PARTGRPTYP TB025 BP group types PARTGRPTYP
BUT000 PREFIX1 TSAD4 Name Prefixes (Business Address Services) CLIENT
BUT000 PREFIX1 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
BUT000 PREFIX2 TSAD4 Name Prefixes (Business Address Services) CLIENT
BUT000 PREFIX2 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
BUT000 SOURCE TB005 BP data sources SOURCE
BUT000 TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
BUT000 TITLE_ACA1 TSAD2 Academic Title (Business Address Services) CLIENT
BUT000 TITLE_ACA1 TSAD2 Academic Title (Business Address Services) TITLE_KEY
BUT000 TITLE_ACA2 TSAD2 Academic Title (Business Address Services) CLIENT
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 TSAD5 Name Suffixes/Title (Key) (Business Address Services) TITLE_KEY
BUT000 XUBNAME USR02 Logon Data (Kernel-Side Use) BNAME
Back to SAP tables