BUT000 is a standard Use AP-MD-BP* Components Transparent Table in SAP Basis application, which stores BP: General data I data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, 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 — Meta Data

Description: BP: General data I
Main Category: Basis
Sub Category: Use AP-MD-BP* Components
Table type: Transparent Table (TRANSP)

BUT000 — Table Structure, Fields(Columns) and Definitions

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

SAP Help, Wiki Resources, and Forum Discussions on BUT000

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
ADRC Addresses (Business Address Services) Basis - Address Management/Business Address
BUT020 BP: Addresses Basis - Use AP-MD-BP* Components
BUT100 BP: Roles Basis - Use AP-MD-BP* Components
BUT050 BP relationships/role definitions: General data Basis - Use AP-MD-BP* Components
CRMD_ORDERADM_H Business Transaction Cross Application - General Application Functions
ADR6 E-Mail Addresses (Business Address Services) Basis - Address Management/Business Address
BUT051 BP Relationship: Contact Person Relationship Basis - Use AP-MD-BP* Components

Transaction Codes for SAP Table BUT000

TCODE Description Functional Area
EEWB Easy Enhancement Workbench Cross Application - EEW Services
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE16 Data Browser Basis - Workbench Utilities
SE37 ABAP Function Modules Basis - Function Builder
SE38 ABAP Editor Basis - ABAP Editor
BBP_PD Document Display (EBP) SRM - Enterprise Buyer
SU01 User Maintenance Basis - User and Authorization Management

ABAP Reports for SAP Table BUT000

ABAP REPORT Description Functional Area
BBP_PD Document Display (Procurement Framework) SRM - Enterprise Buyer
CRM_ORDER_READ Test program for function module CRM_ORDER_READ CRM - Business Transactions
BUPA_TEST_DELETE Delete Business Partners App. Platform - SAP Business Partner
BBP_VENDOR_SYNC Program BBP_VENDOR_SYNC SRM - Enterprise Buyer
HRALXSYNC Object Synchronization and Repair Cross Application - Cross-Application Objects in HR
CRM_ORDER_MAINTAIN Test program for function module CRM_ORDER_MAINTAIN CRM - Business Transactions
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
CRM_MKTLIST_BADI Constants ELM: Business Add-Ins CRM - External List Management

BW Datasources for SAP Table BUT000

BW DATASOURCE Description Functional Area
0BPARTNER_ATTR SAP BP: BW Extraction Central Data -
0BPARTNER_TEXT SAP BP: DataSource for Business Partner Texts -
0BP_DEF_ADDRESS_ATTR SAP BP: BP Standard Address Extraction -
0BP_RELATIONS_ATTR BP: Relationships -
0WBS_ELEMT_ATTR Work Breakdown Structure Element (WBS Element) Project Systems - Project System
0CUSTOMER_ATTR Customer Number Logistics - Logistics - General
0ORGUNIT_ATTR Organizational Unit -
0FI_AR_3 Customers: Line Items FI - Accounts Receivable

Authorization Objects for SAP Table BUT000

AUTHORIZATION OBJECT Description Functional Area
B_BUPA_GRP Business Partner: Authorization Groups
CMS_CAG Authorization object for CAG
B_BUPA_RLT Business Partner: BP Roles
CMS_RBL Authorization object for receivable in CMS
S_ADMI_FCD System Authorizations
F_KNA1_GRP Customer: Account Group Authorization
CRMCONFMOD Configuration Mode