SAP table BP000 (Business Partner Master (General Data))

SAP table BP000 has 2 primary key fields being MANDT,PARTNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PARTNR Business Partner Number CHAR 10 0 BP_PARTNR_OLD
PARTNR_OLD Character Field with Length 10 CHAR 10 0 CHAR10
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
PERSNUMBER Person Number CHAR 10 0 ADRP AD_PERSNUM
BU_GROUP Business Partner Grouping CHAR 4 0 * BU_GROUP
EXTPARTNR External Business Partner ID CHAR 15 0 BP_EXT_PNR
CUSTOMER Customer Number CHAR 10 0 KUNNR
TYPE Partner category CHAR 1 0 BP_TYPE_OLD
BP_GROUP BP: Collective Business Partner Indicator CHAR 1 0 BP_GROUP
GROUP_ID Business Partner Grouping CHAR 4 0 TPZ2 BP_GRP_ID_OLD
NAME1 Name 1 (surname for persons, else company name) CHAR 40 0 BP_NAME1
NAME2 Name 2 (Continuation of NAME 1) CHAR 40 0 BP_NAME2
LANGU Language Key LANG 1 0 T002 LANGU
TITLE Form of Address (Key) NUMC 2 0 TP01 BP_TITLE_OLD
TITLE_LET Salutation NUMC 2 0 TP02 BP_TITL_LT
ADR_REF Address ID CHAR 10 0 TP14 BP_ADR_REF_OLD
SORT1 Sort Field 1 CHAR 20 0 BP_SORT1
SORT2 Sort Field 2 CHAR 20 0 BP_SORT2
SORT_PHON Sort Field for Phonetic Search; Obsolete CHAR 20 0 BP_SORT_PH
MC_NAME1 Field NAME1 in Upper Case CHAR 25 0 BP_MC_NAM1
MC_NAME2 Field NAME2 in Upper Case CHAR 25 0 BP_MC_NAM2
SOURCE Source Key of Business Partner Data CHAR 4 0 BP_SOURCE
CRUSER Entered by CHAR 12 0 BP_CRUSER
CRDAT Creation Date DATS 8 0 BP_CRDAT
VIP Business Partner: VIP Partner CHAR 1 0 TVIP BP_VIP
GROUP_D Target Group CHAR 4 0 TP13 BP_GROUP_D
DEL_IND Deletion Flag CHAR 1 0 BP_DEL_IND
BEGRU Authorization Group CHAR 4 0 BEGRU
XTITLE Text of Form of Address CHAR 50 0 BP_XTITLE
XTIT_LE Salutation CHAR 50 0 BP_XTIT_LE
PAR_REL Business Partner Released CHAR 1 0 BP_PAR_REL
Released
X Not released
NAME_LAST Last Name CHAR 40 0 BP_NAMLAST
NAME_FIRST First Name CHAR 40 0 BP_NAMFRST
TITLE_AC Academic Title CHAR 20 0 BP_TITL_AC_OLD
N_PREFIX Name Prefix CHAR 20 0 BP_PREFIX_OLD
N_ADDITION Name Affix CHAR 20 0 BP_ADDITN_OLD
NICKNAME Known As CHAR 20 0 BP_NICKNAM
SEX Gender of Business Partner CHAR 1 0 BP_SEX_OLD
PROFESSION Description of Occupation for Business Partner CHAR 40 0 BP_PROFESS_OLD
NATION Nationality CHAR 3 0 T005 BP_CNTR_N
STATE Citizenship CHAR 3 0 T005 BP_CNTR_ST
BIRTH_DATE Date of Birth of Business Partner DATS 8 0 BP_BIRTHD
BIRTH_PLAC Birthplace CHAR 40 0 BP_BIRTHPL
BIRTH_NAME Name at Birth CHAR 40 0 BP_BIRTHNA
BIRTH_N_AD Name at Birth Affix CHAR 40 0 BP_BIRTH_A
DEATH_DATE Date of Death DATS 8 0 BP_DEATH_D
MARITAL_ST Marital Status NUMC 2 0 TP03 BP_MARITAL_OLD
PROPRTY_ST Marital property regime NUMC 2 0 TP04 BP_PROPRTY_OLD
CHILDREN Number of Children Belonging to the Business Partner DEC 2 0 BP_CHILDRN
MEM_HOUSE Number of People Living in the Household DEC 2 0 BP_MEM_HOU
INCOME_CUR Currency of Net Income CUKY 5 0 TCURC BP_INC_CUR
NET_INCOME Net Annual Income CURR 15 2 BP_NET_INC
MO_NET_INC Monthly Net Income of Business Partner CURR 15 2 BP_MO_INC
NET_INC_Y Year of Net Annual Income NUMC 4 0 BP_N_INC_Y
MO_INC_M Calendar Month of Monthly Net Income NUMC 2 0 BP_M_INC_M
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
MO_INC_Y Year of Monthly Net Income NUMC 4 0 BP_M_INC_Y
PERS_NR Personnel Number CHAR 15 0 BP_PERS_NR
STAFF_GRP Employee Group CHAR 4 0 TP05 BP_STAFF_G
HR_ORG_REF HR Org. Link CHAR 1 0 HR_ORG_REF
XUBNAME User Name in User Master Record CHAR 12 0 USR02 XUBNAME
STAFF_REF Employee CHAR 1 0 BP_STAFF_R
ORG_NAME Name 1 (surname for persons, else company name) CHAR 40 0 BP_NAME1
ORG_NAME2 Name 2 (Continuation of NAME 1) CHAR 40 0 BP_NAME2
CALENDARID Factory calendar CHAR 2 0 TFACD BP_CAL_ID
LEGAL_ENTY Legal Form of Organization NUMC 2 0 TP08 BP_LEG_ETY_OLD
LEGAL_ORG Legal Entity of Organization NUMC 2 0 TP09 BP_LEG_ORG_OLD
BALANCE_FL Balance Sheet Display CHAR 1 0 BP_BAL_FLG
0 Not consolidated
1 Consolidated
2 Not associated
3 Associated
FOUND_YEAR Foundation Year of Organization NUMC 4 0 BP_FOUND_Y
COMM_REGIS Entry in Commercial Register CHAR 50 0 BP_COM_REG
COMM_REG_D Date of Entry in Commercial Register DATS 8 0 BP_COM_R_D
CNTRY_COMP Country/Region of Registered Office CHAR 3 0 T005 BP_CNTR_HD
REGIO Region of Registered Office CHAR 3 0 T005S BP_REGIO_HD
COMP_HEAD Registered Office CHAR 35 0 BP_COMP_HD
LIQUID_DAT Date of Liquidation DATS 8 0 BP_LIQUI_D
COMP_NR International location number (part 1) NUMC 7 0 BBBNR
COMP_NR_AD International location number (Part 2) NUMC 5 0 BBSNR
BUBKZ Check digit for the international location number NUMC 1 0 BUBKZ
IND_SECTOR Industry Keys CHAR 4 0 T016 BP_BRSCH_OLD
MIN_RESERV Bank Subject to Minimum Reserve Requirement CHAR 1 0 BP_MIN_RSV
BAL_SH_CUR Balance Sheet Currency CUKY 5 0 TCURC BP_BAL_CUR
CAP_INCR_A Amount of last capital increase CURR 15 2 BP_CA_IN_A
CAP_INCR_Y Year of Last Capital Increase NUMC 4 0 BP_CA_IN_Y
BANKL Bank Keys CHAR 15 0 BANKK
BANKS Country/Region Key of Bank CHAR 3 0 * BANKS
NO_CONV Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') CHAR 1 0 BOOLE_D

BP000 foreign key relationships

Table Field Check Table Check Field
0 BP000 ADR_REF TP14 Business Partner: Address ID MANDT
0 BP000 ADR_REF TP14 Business Partner: Address ID ADR_REF
1 BP000 BAL_SH_CUR TCURC Currency Codes MANDT
1 BP000 BAL_SH_CUR TCURC Currency Codes WAERS
0 BP000 CNTRY_COMP T005 Countries MANDT
0 BP000 CNTRY_COMP T005 Countries LAND1
1 BP000 GROUP_D TP13 Business Partner: Partner Grouping (Target Group) MANDT
1 BP000 GROUP_D TP13 Business Partner: Partner Grouping (Target Group) GROUP_D
0 BP000 GROUP_ID TPZ2 Business Partner: Customizing BP Grouping MANDT
0 BP000 GROUP_ID TPZ2 Business Partner: Customizing BP Grouping GROUP_ID
1 BP000 INCOME_CUR TCURC Currency Codes MANDT
1 BP000 INCOME_CUR TCURC Currency Codes WAERS
0 BP000 IND_SECTOR T016 Industries BRSCH
1 BP000 LEGAL_ENTY TP08 Business Partner: Legal Form MANDT
1 BP000 LEGAL_ENTY TP08 Business Partner: Legal Form LEGAL_ENTY
0 BP000 LEGAL_ORG TP09 Business Partner: Legal Entity MANDT
0 BP000 LEGAL_ORG TP09 Business Partner: Legal Entity LEGAL_ORG
1 BP000 MANDT T000 Clients MANDT
0 BP000 MARITAL_ST TP03 Business partner: Marital status MANDT
1 BP000 NATION T005 Countries MANDT
1 BP000 NATION T005 Countries LAND1
0 BP000 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
0 BP000 PERSNUMBER ADRP Persons (Business Address Services) DATE_FROM
0 BP000 PERSNUMBER ADRP Persons (Business Address Services) NATION
1 BP000 PROPRTY_ST TP04 Business Partner: Marital Property Regime MANDT
0 BP000 REGIO T005S Taxes: Region (Province) Key LAND1
1 BP000 STAFF_GRP TP05 Business partner: Employee group MANDT
1 BP000 STAFF_GRP TP05 Business partner: Employee group STAFF_GRP
0 BP000 STATE T005 Countries MANDT
0 BP000 STATE T005 Countries LAND1
1 BP000 TITLE TP01 Business Partner: Form of Address MANDT
1 BP000 TITLE TP01 Business Partner: Form of Address TITLE
0 BP000 TITLE_LET TP02 Business partner: Salutation MANDT
1 BP000 VIP TVIP Contact Person: VIP Indicator MANDT
1 BP000 VIP TVIP Contact Person: VIP Indicator PAVIP
0 BP000 XUBNAME USR02 Logon Data (Kernel-Side Use) BNAME