BUT000 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores BP: General data I data. There are total 94 fields in the table. The BUT000 table can be found in the SAP Business Partner: Basic Components (S_BUPA_GENERAL) package and is part of the Business Partner Foundation (BC-SRV-BP) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
BUT000 Table Fields
The following is the list of fields that are available in SAP BUT000 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| PARTNER | Business Partner Number | BU_PARTNER | BU_PARTNER | CHAR | 10 | |
| TYPE | Business Partner Category | BU_TYPE | BU_TYPE | CHAR | 1 | |
| BPKIND | Business Partner Type | BU_BPKIND | BU_KIND | TB004 | CHAR | 4 |
| BU_GROUP | Business Partner Grouping | BU_GROUP | BU_GROUP | TB001 | CHAR | 4 |
| BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR20 | CHAR | 20 | |
| BU_SORT1 | Search Term 1 for Business Partner | BU_SORT1 | BU_SORT1 | CHAR | 20 | |
| BU_SORT2 | Search Term 2 for Business Partner | BU_SORT2 | BU_SORT1 | CHAR | 20 | |
| SOURCE | Data Origin Types | BU_SOURCE | BU_SOURCE | TB005 | CHAR | 4 |
| TITLE | Form-of-Address Key | AD_TITLE | AD_TITLE | TSAD3 | CHAR | 4 |
| XDELE | Central Archiving Flag | BU_XDELE | XFELD | CHAR | 1 | |
| XBLCK | Central Block for Business Partner | BU_XBLCK | XFELD | CHAR | 1 | |
| AUGRP | Authorization Group | BU_AUGRP | BU_AUGRP | TB037 | CHAR | 4 |
| TITLE_LET | Salutation | BU_TITLE_LET | TEXT50 | CHAR | 50 | |
| BU_LOGSYS | Logical system | LOGSYS | LOGSYS | TBDLS | CHAR | 10 |
| CONTACT | Business Partner: Contact Permission | BU_CONTACT | BU_CONTACT | CHAR | 1 | |
| NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | XFELD | CHAR | 1 | |
| NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | BOOLE | CHAR | 1 | |
| PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | BU_PRINT_MODE | CHAR | 1 | |
| BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | DUMMY | CHAR | 1 | |
| RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | DPR_RATE_TYPE | DPR_RATES | CHAR | 15 |
| NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | BU_NAME | CHAR | 40 | |
| NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | BU_NAME | CHAR | 40 | |
| NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | BU_NAME | CHAR | 40 | |
| NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | BU_NAME | CHAR | 40 | |
| LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | BU_LEGENTY | TB019 | CHAR | 2 |
| IND_SECTOR | Industry sector | BU_INDSECT | BU_INDSECT | TB023 | CHAR | 10 |
| LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | BU_LEGAL_ORG | TB032 | CHAR | 2 |
| FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATUM | DATS | 8 | |
| LOCATION_1 | International location number (part 1) | BBBNR | NUM07 | NUMC | 7 | |
| LOCATION_2 | International location number (Part 2) | BBSNR | NUM05 | NUMC | 5 | |
| LOCATION_3 | Check digit for the international location number | BUBKZ | NUM01 | NUMC | 1 | |
| NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | BU_NAME | CHAR | 40 | |
| NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | BU_NAME | CHAR | 40 | |
| NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | BU_NAME | CHAR | 40 | |
| NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | BU_NAME | CHAR | 40 | |
| NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | BU_NAME | CHAR | 40 | |
| TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | AD_TITLE1 | TSAD2 | CHAR | 4 |
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | AD_TITLE1 | TSAD2 | CHAR | 4 |
| TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | AD_TITLES | TSAD5 | CHAR | 4 |
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | AD_PREFIX | TSAD4 | CHAR | 4 |
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | AD_PREFIX | TSAD4 | CHAR | 4 |
| NAME1_TEXT | Full Name | BU_NAME1TX | TEXT80 | CHAR | 80 | |
| NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | BU_NAME | CHAR | 40 | |
| INITIALS | Middle Initial or personal initials | AD_INITS | CHAR10 | CHAR | 10 | |
| NAMEFORMAT | Name format | AD_FORMAT | AD_NAMFORM | T005N | CHAR | 2 |
| NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | LAND1 | T005 | CHAR | 3 |
| LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | SPRAS | T002 | LANG | 1 |
| XSEXM | Selection: Business partner is male | BU_XSEXM | XFELD | CHAR | 1 | |
| XSEXF | Selection: Business partner is female | BU_XSEXF | XFELD | CHAR | 1 | |
| BIRTHPL | Birthplace of business partner | BU_BIRTHPL | TEXT40 | CHAR | 40 | |
| MARST | Marital Status of Business Partner | BU_MARST | BU_MARST | TB027 | CHAR | 1 |
| EMPLO | Name of Employer of a Natural Person | BU_EMPLO | BU_EMPLO | CHAR | 35 | |
| JOBGR | Occupation/group | BU_JOBGR | BU_JOBGR | TB028 | CHAR | 4 |
| NATIO | Nationality | BU_NATIO | LAND1 | T005 | CHAR | 3 |
| CNTAX | Obsolete Field | BU_CNTAX | LAND1 | * | CHAR | 3 |
| CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | LAND1 | T005 | CHAR | 3 |
| PERSNUMBER | Person Number | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | |
| XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | XFELD | CHAR | 1 | |
| XUBNAME | Obsolete Field | BU_XUBNAME | XUBNAME | USR02 | CHAR | 12 |
| BU_LANGU | Business partner: Language | BU_LANGU | SPRAS | T002 | LANG | 1 |
| GENDER | Sex of business partner (person) | BU_SEXID | BU_SEXID | TB995 | CHAR | 1 |
| BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATUM | DATS | 8 | |
| DEATHDT | Date of death of business partner | BU_DEATHDT | DATUM | DATS | 8 | |
| PERNO | Personnel Number | BU_PERNO | PERSONID | NUMC | 8 | |
| CHILDREN | Obsolete Field | BU_CHILDREN | NUMC2 | NUMC | 2 | |
| MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC2 | DEC | 2 | |
| BIRTHDT_STATUS | Date of Birth: Status | BU_BIRTHDT_STATUS | BU_BIRTHDT_STATUS | CHAR | 1 | |
| PARTGRPTYP | Group type | BU_GRPTYP | BU_GRPTYP | TB025 | CHAR | 4 |
| NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | BU_NAME | CHAR | 40 | |
| NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | BU_NAME | CHAR | 40 | |
| MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR35 | CHAR | 35 | |
| MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR35 | CHAR | 35 | |
| CRUSR | User who created the object | BU_CRUSR | USNAM | CHAR | 12 | |
| CRDAT | Date on which the object was created | BU_CRDAT | DATUM | DATS | 8 | |
| CRTIM | Time at which the object was created | BU_CRTIM | UZEIT | TIMS | 6 | |
| CHUSR | Last user to change object | BU_CHUSR | USNAM | CHAR | 12 | |
| CHDAT | Date when object was last changed | BU_CHDAT | DATUM | DATS | 8 | |
| CHTIM | Time at which object was last changed | BU_CHTIM | UZEIT | TIMS | 6 | |
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | SYSUUID | RAW | 16 | |
| ADDRCOMM | Address Number | BU_ADDRCOMM | AD_ADDRNUM | * | CHAR | 10 |
| TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR1 | CHAR | 1 | |
| IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | BU_IS_ORG_CENTRE | CHAR | 1 | |
| DB_KEY | UUID in X form (binary) | SYSUUID_X | SYSUUID | RAW | 16 | |
| VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | TZNTSTMPS | DEC | 15 | |
| VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | TZNTSTMPS | DEC | 15 | |
| XPCPT | Business Purpose Completed Flag | BU_XPCPT | BU_XPCPT | CHAR | 1 | |
| NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | BU_NATURAL_PERSON | CHAR | 1 | |
| MILVE | ID for mainly military use | MILVE | XFELD | CHAR | 1 | |
| NUC_SEC | Nuclear Sector (Indicator) | NUC_SEC | XCHAR | CHAR | 1 | |
| PAR_REL | Business Partner Released | BP_PAR_REL | BP_PAR_REL | CHAR | 1 | |
| BP_SORT | Sort Field for Phonetic Search | BP_SORT_PH | CHAR20 | CHAR | 20 | |
| KBANKS | Bank country key | BANKS | LAND1 | * | CHAR | 3 |
| KBANKL | Bank Keys | BANKK | BANKK | CHAR | 15 |
Availability
The SAP HANA table BUT000 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for BUT000 table
We’re updating the content all the time, so check back regularly.
