SAP ABAP Table BUT000 (BP: General data I)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SRV-BP (Application Component) Business Partner Foundation
     S_BUPA_GENERAL (Package) SAP Business Partner: Basic Components
Basic Data
Table Category TRANSP    Transparent table 
Transparent table BUT000   Table Relationship Diagram
Short Description BP: General data I    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number  
3 .INCLUDE       0   0   BP: General Data I (Data Fields - External)  
4 .INCLUDE       0   0   CBP: General data (independent of partner cat.)  
5 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Initial Screen  
6 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
7 BPKIND BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
8 BU_GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping TB001
9 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
10 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Data Screens  
11 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
12 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
13 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
14 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
15 XDELE BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
16 XBLCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
17 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group TB037
18 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
19 BU_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
20 CONTACT BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
21 NOT_RELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
22 NOT_LG_COMPETENT BU_NOT_LEG_COMPETENT BOOLE CHAR 1   0   Indicator: Not Legally Competent  
23 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
24 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
25 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
26 .INCLUDE       0   0    
27 .INCLUDE       0   0   CBP: General data (Organization)  
28 .INCLUDE       0   0   CBP: General Data, Organization (CHAR Fields)  
29 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
30 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
31 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
32 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
33 LEGAL_ENTY BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
34 IND_SECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
35 LEGAL_ORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
36 .INCLUDE       0   0   CBP: General Data, Organization (Non CHAR Fields)  
37 FOUND_DAT BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
38 LIQUID_DAT BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
39 LOCATION_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
40 LOCATION_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
41 LOCATION_3 BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
42 .INCLUDE       0   0   CBP: General Data, Person  
43 .INCLUDE       0   0   CBP: General Data, Person (CHAR Fields)  
44 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
45 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
46 NAME_LST2 BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
47 NAME_LAST2 BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
48 NAMEMIDDLE BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
49 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
50 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
51 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
52 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
53 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
54 NAME1_TEXT BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
55 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
56 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
57 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
58 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
59 LANGU_CORR BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
60 XSEXM BU_XSEXM XFELD CHAR 1   0   Selection: Business partner is male  
61 XSEXF BU_XSEXF XFELD CHAR 1   0   Selection: Business partner is female  
62 BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
63 MARST BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
64 EMPLO BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
65 JOBGR BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group TB028
66 NATIO BU_NATIO LAND1 CHAR 3   0   Nationality T005
67 CNTAX BU_CNTAX LAND1 CHAR 3   0   Obsolete Field *
68 CNDSC BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies T005
69 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
70 XSEXU BU_XSEXU XFELD CHAR 1   0   Selection: Sex of business partner is not known  
71 XUBNAME BU_XUBNAME XUBNAME CHAR 12   0   Obsolete Field USR02
72 BU_LANGU BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
73 .INCLUDE       0   0   CBP: General Data, Person (Non CHAR Fields)  
74 BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
75 DEATHDT BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
76 PERNO BU_PERNO PERSONID NUMC 8   0   Personnel Number  
77 CHILDREN BU_CHILDREN NUMC2 NUMC 2   0   Obsolete Field  
78 MEM_HOUSE BU_MEM_HOUSE DEC2 DEC 2   0   Obsolete Field  
79 .INCLUDE       0   0   CBP: General data (group of people)  
80 PARTGRPTYP BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
81 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
82 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
83 .INCLUDE       0   0   BP: General Data I (Data Fields - Internal)  
84 .INCLUDE       0   0   CBP: Internal general data (not dependent on partner cat.)  
85 MC_NAME1 BU_MCNAME1 CHAR35 CHAR 35   0   Search Help Field 1 (Name 1/Last Name)  
86 MC_NAME2 BU_MCNAME2 CHAR35 CHAR 35   0   Search Help Field 2 (Name 2/First Name)  
87 CRUSR BU_CRUSR USNAM CHAR 12   0   User who created the object  
88 CRDAT BU_CRDAT DATUM DATS 8   0   Date on which the object was created  
89 CRTIM BU_CRTIM UZEIT TIMS 6   0   Time at which the object was created  
90 CHUSR BU_CHUSR USNAM CHAR 12   0   Last user to change object  
91 CHDAT BU_CHDAT DATUM DATS 8   0   Date when object was last changed  
92 CHTIM BU_CHTIM UZEIT TIMS 6   0   Time at which object was last changed  
93 PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
94 ADDRCOMM BU_ADDRCOMM AD_ADDRNUM CHAR 10   0   Address Number *
95 TD_SWITCH BU_TD_SWITCH CHAR1 CHAR 1   0   Planned Change Documents for Partner Were Converted  
96 IS_ORG_CENTRE BU_IS_ORG_CENTRE BU_IS_ORG_CENTRE CHAR 1   0   Indicator: Business Partner Is Also an Organizational Center  
97 DB_KEY SYSUUID_X SYSUUID RAW 16   0   UUID in X form (binary)  
98 VALID_FROM BU_BP_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start BUT000 BP Data  
99 VALID_TO BU_BP_VALID_TO TZNTSTMPS DEC 15   0   Validity End BUT000 BP Data  
100 XPCPT BU_XPCPT BU_XPCPT CHAR 1   0   Business Purpose Completed Flag  
101 .INCLU--AP       0   0   Append BUT000: Indicator Natural Person for Taxes  
102 NATPERS BU_NATURAL_PERSON BU_NATURAL_PERSON CHAR 1   0   Business Partner Is a Natural Person Under the Tax Laws  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BUT000 AUGRP TB037 AUGRP REF 1 CN
2 BUT000 BPKIND TB004 BPKIND KEY 1 CN
3 BUT000 BU_GROUP TB001 BU_GROUP REF 1 CN
4 BUT000 BU_LANGU T002 SPRAS REF C CN
5 BUT000 BU_LOGSYS TBDLS LOGSYS 1 CN
6 BUT000 CLIENT T000 MANDT KEY 1 CN
7 BUT000 CNDSC T005 LAND1 REF 1 CN
8 BUT000 IND_SECTOR TB023 IND_SECTOR REF 1 CN
9 BUT000 JOBGR TB028 JOBGR REF 1 CN
10 BUT000 LANGU_CORR T002 SPRAS REF C CN
11 BUT000 LEGAL_ENTY TB019 LEGAL_ENTY KEY 1 CN
12 BUT000 LEGAL_ORG TB032 LEGAL_ORG REF 1 CN
13 BUT000 MARST TB027 MARST 1 CN
14 BUT000 NAMCOUNTRY T005 LAND1 REF C CN
15 BUT000 NAMEFORMAT T005N NAMEFORMAT REF C CN
16 BUT000 NATIO T005 LAND1 1 CN
17 BUT000 PARTGRPTYP TB025 PARTGRPTYP KEY 1 CN
18 BUT000 PREFIX1 TSAD4 PREFIX_KEY    
19 BUT000 PREFIX2 TSAD4 PREFIX_KEY    
20 BUT000 SOURCE TB005 SOURCE KEY 1 CN
21 BUT000 TITLE TSAD3 TITLE REF    
22 BUT000 TITLE_ACA1 TSAD2 TITLE_KEY    
23 BUT000 TITLE_ACA2 TSAD2 TITLE_KEY    
24 BUT000 TITLE_ROYL TSAD5 TITLE_KEY    
25 BUT000 XUBNAME USR02 BNAME KEY 1 CN
History
Last changed by/on SAP  20140117 
SAP Release Created in