Sunday, May 19, 2024
Search by table name, fields

BUT000: BP: General data I

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.

EDITOR PICKS

POPULAR POSTS

POPULAR CATEGORY

© 2014-2021 www.saplearners.com.All rights reserved. SAPLearners.COM is not affiliated with SAP SE or any of its subsidiaries.