BUT000 is a standard Use AP-MD-BP* Components Transparent Table in SAP Basis application, which stores BP: General data I data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BUT000. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BUT000 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 CLIENT Client MANDT X CLNT 3 T000
    2 PARTNER Partner vendor BU_PARTNER X CHAR 10
    3 .INCLUDE 0
    4 .INCLUDE 0
    5 .INCLUDE 0
    6 TYPE Message type: S Success BU_TYPE CHAR 1
    7 BPKIND Business Partner Type BU_BPKIND CHAR 4 TB004
    8 BU_GROUP Business Partner Grouping BU_GROUP CHAR 4 TB001
    9 BPEXT Business Partner Number in External System BU_BPEXT CHAR 20
    10 .INCLUDE 0
    11 BU_SORT1 Search term 1 for business partner BU_SORT1 CHAR 20
    12 BU_SORT2 Search term 2 for business partner BU_SORT2 CHAR 20
    13 SOURCE Origin of Opportunity/Lead BU_SOURCE CHAR 4 TB005
    14 TITLE Title Text AD_TITLE CHAR 4 TSAD3
    15 XDELE Central Archiving Flag BU_XDELE CHAR 1
    16 XBLCK Central Block for Business Partner BU_XBLCK CHAR 1
    17 AUGRP Business Partner Authorization Group BU_AUGRP CHAR 4 TB037
    18 TITLE_LET Salutation BU_TITLE_LET CHAR 50
    19 BU_LOGSYS Logical system LOGSYS CHAR 10 TBDLS
    20 CONTACT Number of contact person BU_CONTACT CHAR 1
    21 NOT_RELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1
    22 NOT_LG_COMPETENT Indicator: Not Legally Competent BU_NOT_LEG_COMPETENT CHAR 1
    23 PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1
    24 .INCLUDE 0
    25 BP_EEW_DUMMY Dummy function in length 1 DUMMY CHAR 1
    26 .INCLUDE 0
    27 .INCLU--AP 0
    28 RATE Cost/Rev. Rate DPR_TV_RATE CHAR 15 DPR_RATES
    29 .INCLUDE 0
    30 .INCLUDE 0
    31 NAME_ORG1 Name 1 of organization BU_NAMEOR1 CHAR 40
    32 NAME_ORG2 Name 2 of organization BU_NAMEOR2 CHAR 40
    33 NAME_ORG3 Name 3 of organization BU_NAMEOR3 CHAR 40
    34 NAME_ORG4 Name 4 of organization BU_NAMEOR4 CHAR 40
    35 LEGAL_ENTY BP: Legal form of organization BU_LEGENTY CHAR 2 TB019
    36 IND_SECTOR Industry sector BU_INDSECT CHAR 10 TB023
    37 LEGAL_ORG Legal Entity of Organization BU_LEGAL_ORG CHAR 2 TB032
    38 .INCLUDE 0
    39 FOUND_DAT Date organization founded BU_FOUND_DAT DATS 8
    40 LIQUID_DAT Liquidation date of organization BU_LIQUID_DAT DATS 8
    41 LOCATION_1 International location number (part 1) BBBNR NUMC 7
    42 LOCATION_2 International location number (Part 2) BBSNR NUMC 5
    43 LOCATION_3 Check digit for the international location number BUBKZ NUMC 1
    44 .INCLUDE 0
    45 .INCLUDE 0
    46 NAME_LAST Last name BU_NAMEP_L CHAR 40
    47 NAME_FIRST First name BU_NAMEP_F CHAR 40
    48 NAME_LST2 Other Last Name of a Person BU_NAMEPL2 CHAR 40
    49 NAME_LAST2 Other Last Name of a Person BU_BIRTHNM CHAR 40
    50 NAMEMIDDLE Middle name or second forename of a person BU_NAMEMID CHAR 40
    51 TITLE_ACA1 Updated information in related user data field AD_TITLE1 CHAR 4 TSAD2
    52 TITLE_ACA2 Updated information in related user data field AD_TITLE2 CHAR 4 TSAD2
    53 TITLE_ROYL Name supplement AD_TITLES CHAR 4 TSAD5
    54 PREFIX1 Updated information in related user data field AD_PREFIX CHAR 4 TSAD4
    55 PREFIX2 Updated information in related user data field AD_PREFIX2 CHAR 4 TSAD4
    56 NAME1_TEXT Full Name BU_NAME1TX CHAR 80
    57 NICKNAME Nick Name BU_NICKNAM CHAR 40
    58 INITIALS Updated information in related user data field AD_INITS CHAR 10
    59 NAMEFORMAT Updated information in related user data field AD_FORMAT CHAR 2 T005N
    60 NAMCOUNTRY Updated information in related user data field AD_NAMCTRY CHAR 3 T005
    61 LANGU_CORR Business Partner: Correspondence Language BU_LANGU_CORR LANG 1 T002
    62 XSEXM Selection: Business partner is male BU_XSEXM CHAR 1
    63 XSEXF Selection: Business partner is female BU_XSEXF CHAR 1
    64 BIRTHPL Birthplace of business partner BU_BIRTHPL CHAR 40
    65 MARST Marital status BU_MARST CHAR 1 TB027
    66 EMPLO Name of Employer of a Natural Person BU_EMPLO CHAR 35
    67 JOBGR Occupation/group BU_JOBGR CHAR 4 TB028
    68 NATIO Nationality BU_NATIO CHAR 3 T005
    69 CNTAX Obsolete Field BU_CNTAX CHAR 3 *
    70 CNDSC Ctry of Origin: Non-Res. Companies BU_CNDSC CHAR 3 T005
    71 PERSNUMBER Person number AD_PERSNUM CHAR 10
    72 XSEXU Selection: Sex of business partner is not known BU_XSEXU CHAR 1
    73 XUBNAME User Name in User Master Record BU_XUBNAME CHAR 12 USR02
    74 BU_LANGU Business partner: Language BU_LANGU LANG 1 T002
    75 .INCLUDE 0
    76 BIRTHDT Date of Birth of Business Partner BU_BIRTHDT DATS 8
    77 DEATHDT Date of death of business partner BU_DEATHDT DATS 8
    78 PERNO Personnel no. BU_PERNO NUMC 8
    79 CHILDREN BU_CHILDREN NUMC 2
    80 MEM_HOUSE Number of People Living in the Household BU_MEM_HOUSE DEC 2
    81 BIRTHDT_STATUS Updated information in related user data field BU_BIRTHDT_STATUS CHAR 1
    82 .INCLUDE 0
    83 PARTGRPTYP Group type BU_GRPTYP CHAR 4 TB025
    84 NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40
    85 NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40
    86 .INCLUDE 0
    87 .INCLUDE 0
    88 MC_NAME1 Matchcode field 1 (name 1/last name) BU_MCNAME1 CHAR 35
    89 MC_NAME2 Matchcode field 2 (name2/first name) BU_MCNAME2 CHAR 35
    90 CRUSR User who created the object BU_CRUSR CHAR 12
    91 CRDAT Date of creation BU_CRDAT DATS 8
    92 CRTIM Session Creation Time BU_CRTIM TIMS 6
    93 CHUSR Last user to change object BU_CHUSR CHAR 12
    94 CHDAT Changed On BU_CHDAT DATS 8
    95 CHTIM Time of Change BU_CHTIM TIMS 6
    96 PARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW 16
    97 ADDRCOMM Address Number BU_ADDRCOMM CHAR 10 *
    98 TD_SWITCH Planned Change Documents for Partner Were Converted BU_TD_SWITCH CHAR 1
    99 IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRE CHAR 1
    100 DB_KEY NodeID SYSUUID_X RAW 16
    101 VALID_FROM User Valid From BU_BP_VALID_FROM DEC 15
    102 VALID_TO User Valid To BU_BP_VALID_TO DEC 15
    103 XPCPT Business Purpose Completed Flag BU_XPCPT CHAR 1
    104 .INCLU--AP 0
    105 NATPERS Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1
    106 .INCLU--AP 0
    107 MILVE Single-Character Flag MILVE CHAR 1
    108 NUC_SEC NUC_SEC CHAR 1
    109 .INCLU--AP 0
    110 PAR_REL Business Partner Released BP_PAR_REL CHAR 1
    111 BP_SORT Phonetic Search Term BP_SORT_PH CHAR 20
    112 .INCLU--AP 0
    113 KBANKS Bank country key BANKS CHAR 3 *
    114 KBANKL Bank Keys BANKK CHAR 15