The BUT000_ACT table in SAP ERP or S/4HANA stores Master Data Consolidation: Best Record Table for BUT000 data. There are total 90 fields in BUT000_ACT table. The Master Data Consolidation: Best Record Table for BUT000 table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT000_ACT table. It is in Master Data Consolidation: Business Partner Data Model (MDC_BP_MODEL) ABAP package and is part of the Business Partner. (CA-MDG-CMP-BP) module.
SAP BUT000_ACT Table Fields
Following is the list of fields that are available in SAP BUT000_ACT table. The primary key fields of the table are CLIENT (Client), PARTNER (Business Partner Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| TYPE | Business Partner Category | BU_TYPE | CHAR (1) | |
| BPKIND | Business Partner Type | BU_BPKIND | TB004 | CHAR (4) |
| BU_GROUP | Business Partner Grouping | BU_GROUP | TB001 | CHAR (4) |
| 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 | TB005 | CHAR (4) |
| TITLE | Form-of-Address Key | AD_TITLE | TSAD3 | CHAR (4) |
| 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) |
| TITLE_LET | Salutation | BU_TITLE_LET | CHAR (50) | |
| BU_LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| 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) | |
| RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | DPR_RATES | CHAR (15) |
| 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 | TB019 | CHAR (2) |
| IND_SECTOR | Industry sector | BU_INDSECT | TB023 | CHAR (10) |
| LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | TB032 | CHAR (2) |
| FOUND_DAT | Date organization founded | BU_FOUND_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 | TSAD2 | CHAR (4) |
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | TSAD2 | CHAR (4) |
| TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | TSAD5 | CHAR (4) |
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | TSAD4 | CHAR (4) |
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | TSAD4 | CHAR (4) |
| 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 | T005N | CHAR (2) |
| NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | T005 | CHAR (3) |
| LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | T002 | LANG (1) |
| 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 | TB027 | CHAR (1) |
| EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR (35) | |
| JOBGR | Occupation/group | BU_JOBGR | TB028 | CHAR (4) |
| NATIO | Nationality | BU_NATIO | T005 | CHAR (3) |
| CNTAX | Obsolete Field | BU_CNTAX | * | CHAR (3) |
| CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | T005 | CHAR (3) |
| 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 | USR02 | CHAR (12) |
| BU_LANGU | Business partner: Language | BU_LANGU | T002 | LANG (1) |
| GENDER | Sex of business partner (person) | BU_SEXID | TB995 | CHAR (1) |
| 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) | |
| BIRTHDT_STATUS | Date of Birth: Status | BU_BIRTHDT_STATUS | CHAR (1) | |
| PARTGRPTYP | Group type | BU_GRPTYP | TB025 | CHAR (4) |
| NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR (40) | |
| NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR (40) | |
| 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) | |
| RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) | |
| SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) |
