Menu

SAP Table BUT000

BP: General data I

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

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