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.
- BC-SRV (Basis Services / Communication Interfaces)
- BC-SRV-BP (Use AP-MD-BP* Components)
- BUT000 - BP: General data I
- BC-SRV-BP (Use AP-MD-BP* Components)
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 |
Most searched SAP Basis Components Tables
- Business Partner Tables
- Roles Tables
- Users List Tables
- Transport Requests Tables
- Unit Of Measure Tables
- Partner Functions Tables
- Address Tables
- Authorization Objects Tables
- Background Job Tables
- Exchange Rate Tables
- Idoc Tables
- User Name Tables
- Workflow Tables
- Email Address Tables
- User Groups Tables
- Task List Tables
- Su01 Tables
- Idoc Segment Tables
- Rfc Tables
- Table Name Tables
- Language Tables
- Change Log Tables