Menu

SAP Table BUT000

BP: General data I

The table BUT000 (BP: General data I) is a standard table in SAP ERP. It belongs to the package BUPA.

Technical Information

Table BUT000
Short Text BP: General data I
Package BUPA
Table Type Transparent Table

Fields for Table BUT000

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