1. Home
  2. Resources
  3. SAP Tables
  4. BUS000 - BP: General Data I (Read)

SAP Table BUS000

BP: General Data I (Read)

BUS000 (BP: General Data I (Read)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUS000 to other SAP tables.

BUS000 table fields

Field Data element Checktable Datatype Length Decimals
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
TYPE Business partner category BU_TYPE CHAR 1 0
1 Person
2 Organization
3 Group
BPKIND Business Partner Type BU_BPKIND TB004 CHAR 4 0
BU_GROUP Business Partner Grouping BU_GROUP TB001 CHAR 4 0
BPEXT Business Partner Number in External System BU_BPEXT CHAR 20 0
BU_SORT1 Search term 1 for business partner BU_SORT1 CHAR 20 0
BU_SORT2 Search term 2 for business partner BU_SORT2 CHAR 20 0
SOURCE Data Origin Types BU_SOURCE TB005 CHAR 4 0
TITLE Form-of-Address Key AD_TITLE TSAD3 CHAR 4 0
XDELE Central Archiving Flag BU_XDELE CHAR 1 0
X Yes
NULL No
XBLCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
AUGRP Authorization Group BU_AUGRP CHAR 4 0
TITLE_LET Salutation BU_TITLE_LET CHAR 50 0
BU_LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
CONTACT Business Partner: Contact Permission BU_CONTACT CHAR 1 0
1 Allowed
2 Disallowed
3 Check Permission
NOT_RELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
NOT_LG_COMPETENT Indicator: Not Legally Competent BU_NOT_LEG_COMPETENT CHAR 1 0
X TRUE
NULL FALSE
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
BP_EEW_DUMMY Dummy function in length 1 DUMMY CHAR 1 0
NAPR Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
BBP_IPISP Tax Split BBP_J_1BINDEQU CHAR 1 0
X Yes
NULL No
RATE Cost Rate/Revenue Rate for Project Costing DPR_TV_RATE DPR_RATES CHAR 15 0
NAME_ORG1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME_ORG2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME_ORG3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME_ORG4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LEGAL_ENTY BP: Legal form of organization BU_LEGENTY TB019 CHAR 2 0
IND_SECTOR Industry sector BU_INDSECT TB023 CHAR 10 0
LEGAL_ORG Legal Entity of Organization BU_LEGAL_ORG TB032 CHAR 2 0
FOUND_DAT Date organization founded BU_FOUND_DAT DATS 8 0
LIQUID_DAT Liquidation date of organization BU_LIQUID_DAT DATS 8 0
LOCATION_1 International location number (part 1) BBBNR NUMC 7 0
LOCATION_2 International location number (Part 2) BBSNR NUMC 5 0
LOCATION_3 Check digit for the international location number BUBKZ NUMC 1 0
NAME_LAST Last name of business partner (person) BU_NAMEP_L CHAR 40 0
NAME_FIRST First name of business partner (person) BU_NAMEP_F CHAR 40 0
NAME_LST2 Other Last Name of a Person BU_NAMEPL2 CHAR 40 0
NAME_LAST2 Name at birth of business partner BU_BIRTHNM CHAR 40 0
NAMEMIDDLE Middle name or second forename of a person BU_NAMEMID CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 TSAD2 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 TSAD2 CHAR 4 0
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES TSAD5 CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX TSAD4 CHAR 4 0
PREFIX2 2nd name prefix (key) AD_PREFIX2 TSAD4 CHAR 4 0
NAME1_TEXT Full Name BU_NAME1TX CHAR 80 0
NICKNAME Nickname of Business Partner (Person) BU_NICKNAM CHAR 40 0
INITIALS "Middle Initial" or personal initials AD_INITS CHAR 10 0
NAMEFORMAT Name format AD_FORMAT T005N CHAR 2 0
NAMCOUNTRY Country for name format rule AD_NAMCTRY T005 CHAR 3 0
LANGU_CORR Business Partner: Correspondence Language BU_LANGU_CORR T002 LANG 1 0
XSEXM Selection: Business partner is male BU_XSEXM CHAR 1 0
X Yes
NULL No
XSEXF Selection: Business partner is female BU_XSEXF CHAR 1 0
X Yes
NULL No
BIRTHPL Birthplace of business partner BU_BIRTHPL CHAR 40 0
MARST Marital Status of Business Partner BU_MARST TB027 CHAR 1 0
EMPLO Name of Employer of a Natural Person BU_EMPLO CHAR 35 0
JOBGR Occupation/group BU_JOBGR TB028 CHAR 4 0
NATIO Nationality BU_NATIO T005 CHAR 3 0
CNTAX Obsolete Field BU_CNTAX CHAR 3 0
CNDSC Ctry of Origin: Non-Res. Companies BU_CNDSC T005 CHAR 3 0
PERSNUMBER Person number AD_PERSNUM CHAR 10 0
XSEXU Selection: Sex of business partner is not known BU_XSEXU CHAR 1 0
X Yes
NULL No
XUBNAME Obsolete Field BU_XUBNAME USR02 CHAR 12 0
BU_LANGU Business partner: Language BU_LANGU T002 LANG 1 0
BIRTHDT Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
DEATHDT Date of death of business partner BU_DEATHDT DATS 8 0
PERNO Personnel Number BU_PERNO NUMC 8 0
CHILDREN Obsolete Field BU_CHILDREN NUMC 2 0
MEM_HOUSE Obsolete Field BU_MEM_HOUSE DEC 2 0
PARTGRPTYP Group type BU_GRPTYP TB025 CHAR 4 0
NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0

BUS000 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUS000 BPKIND BUS000 BPKIND TB004 BP types BPKIND
BUS000 BPKIND SYST MANDT TB004 BP types CLIENT
BUS000 BU_GROUP BUT000 CLIENT TB001 BP groupings MANDT
BUS000 BU_GROUP BUS000 BU_GROUP TB001 BP groupings BU_GROUP
BUS000 BU_LANGU BUS000 BU_LANGU T002 Language Keys (Component BC-I18) SPRAS
BUS000 BU_LOGSYS BUS000 BU_LOGSYS TBDLS Logical system LOGSYS
BUS000 CNDSC SYST MANDT T005 Countries MANDT
BUS000 CNDSC BUS000 CNDSC T005 Countries LAND1
BUS000 IND_SECTOR BUS000 IND_SECTOR TB023 BP industries (Obsolete ==> TB038A) IND_SECTOR
BUS000 IND_SECTOR SYST MANDT TB023 BP industries (Obsolete ==> TB038A) CLIENT
BUS000 JOBGR SYST MANDT TB028 Occupations CLIENT
BUS000 JOBGR BUS000 JOBGR TB028 Occupations JOBGR
BUS000 LANGU_CORR BUS000 LANGU_CORR T002 Language Keys (Component BC-I18) SPRAS
BUS000 LEGAL_ENTY SY MANDT TB019 BP legal forms CLIENT
BUS000 LEGAL_ENTY BUS000 LEGAL_ENTY TB019 BP legal forms LEGAL_ENTY
BUS000 LEGAL_ORG SYST MANDT TB032 BP Legal Entity CLIENT
BUS000 LEGAL_ORG BUS000 LEGAL_ORG TB032 BP Legal Entity LEGAL_ORG
BUS000 MARST SYST MANDT TB027 BP marital status CLIENT
BUS000 MARST BUS000 MARST TB027 BP marital status MARST
BUS000 NAMCOUNTRY SYST MANDT T005 Countries MANDT
BUS000 NAMCOUNTRY BUS000 NAMCOUNTRY T005 Countries LAND1
BUS000 NAMEFORMAT BUS000 NAMCOUNTRY T005N Name formats LAND1
BUS000 NAMEFORMAT BUS000 NAMEFORMAT T005N Name formats NAMEFORMAT
BUS000 NAMEFORMAT SYST MANDT T005N Name formats MANDT
BUS000 NATIO * T005 Countries MANDT
BUS000 NATIO BUS000 NATIO T005 Countries LAND1
BUS000 PARTGRPTYP SY MANDT TB025 BP group types CLIENT
BUS000 PARTGRPTYP BUS000 PARTGRPTYP TB025 BP group types PARTGRPTYP
BUS000 PREFIX1 * TSAD4 Name Prefixes (Business Address Services) CLIENT
BUS000 PREFIX1 BUS000 PREFIX1 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
BUS000 PREFIX2 * TSAD4 Name Prefixes (Business Address Services) CLIENT
BUS000 PREFIX2 BUS000 PREFIX2 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
BUS000 RATE SYST MANDT DPR_RATES Customizing: Cost/Revenue Rates for Project Roles CLIENT
BUS000 RATE BUS000 RATE DPR_RATES Customizing: Cost/Revenue Rates for Project Roles RATE
BUS000 SOURCE SY MANDT TB005 BP data sources CLIENT
BUS000 SOURCE BUS000 SOURCE TB005 BP data sources SOURCE
BUS000 TITLE * TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
BUS000 TITLE BUS000 TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
BUS000 TITLE_ACA1 * TSAD2 Academic Title (Business Address Services) CLIENT
BUS000 TITLE_ACA1 BUS000 TITLE_ACA1 TSAD2 Academic Title (Business Address Services) TITLE_KEY
BUS000 TITLE_ACA2 * TSAD2 Academic Title (Business Address Services) CLIENT
BUS000 TITLE_ACA2 BUS000 TITLE_ACA2 TSAD2 Academic Title (Business Address Services) TITLE_KEY
BUS000 TITLE_ROYL BUS000 TITLE_ROYL TSAD5 Name Suffixes/Title (Key) (Business Address Services) TITLE_KEY
BUS000 TITLE_ROYL * TSAD5 Name Suffixes/Title (Key) (Business Address Services) CLIENT
BUS000 XUBNAME * USR02 Logon Data (Kernel-Side Use) MANDT
BUS000 XUBNAME BUS000 XUBNAME USR02 Logon Data (Kernel-Side Use) BNAME