SAP Table BP000 - Business Partner Master (General Data)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
PARTNR X BP_PARTNR_OLD CHAR 3 10 0 Business Partner Number
PARTNR_OLD CHAR10 CHAR 13 10 0 Character Field Length = 10
PARTNER BU_PARTNER CHAR 23 10 0 Business Partner Number
PERSNUMBER AD_PERSNUM CHAR 33 10 0 ADRP Person number
BU_GROUP BU_GROUP CHAR 43 4 0 TB001 Business Partner Grouping
EXTPARTNR BP_EXT_PNR CHAR 47 15 0 External Business Partner ID
CUSTOMER KUNNR CHAR 62 10 0 KNA1 Customer Number
TYPE BP_TYPE_OLD CHAR 72 1 0 Partner category
BP_GROUP BP_GROUP CHAR 73 1 0 BP: Collective Business Partner Indicator
GROUP_ID BP_GRP_ID_OLD CHAR 74 4 0 TPZ2 Business Partner Grouping
NAME1 BP_NAME1 CHAR 78 40 0 Name 1 (surname for persons, otherwise company name)
NAME2 BP_NAME2 CHAR 118 40 0 Name 2 (Continuation of NAME 1)
LANGU LANGU LANG 158 1 0 T002 Language Key
TITLE BP_TITLE_OLD NUMC 159 2 0 TP01 Form of Address (Key)
TITLE_LET BP_TITL_LT NUMC 161 2 0 TP02 Salutation
ADR_REF BP_ADR_REF_OLD CHAR 163 10 0 TP14 Address ID
SORT1 BP_SORT1 CHAR 173 20 0 Sort Field 1
SORT2 BP_SORT2 CHAR 193 20 0 Sort Field 2
SORT_PHON BP_SORT_PH CHAR 213 20 0 OBSOLETE: Sort Field for Phonetic Search
MC_NAME1 BP_MC_NAM1 CHAR 233 25 0 Field NAME1 in Upper Case
MC_NAME2 BP_MC_NAM2 CHAR 258 25 0 Field NAME2 in Upper Case
SOURCE BP_SOURCE CHAR 283 4 0 Source Key of Business Partner Data
CRUSER BP_CRUSER CHAR 287 12 0 Entered by
CRDAT BP_CRDAT DATS 299 8 0 Creation Date
VIP BP_VIP CHAR 307 1 0 Business Partner: VIP Partner
GROUP_D BP_GROUP_D CHAR 308 4 0 TP13 Target Group
DEL_IND BP_DEL_IND CHAR 312 1 0 Deletion Flag
BEGRU BEGRU CHAR 313 4 0 Authorization Group
XTITLE BP_XTITLE CHAR 317 50 0 Text of Form of Address
XTIT_LE BP_XTIT_LE CHAR 367 50 0 Salutation
PAR_REL BP_PAR_REL CHAR 417 1 0 Business Partner Released
NAME_LAST BP_NAMLAST CHAR 418 40 0 Last Name
NAME_FIRST BP_NAMFRST CHAR 458 40 0 First Name
TITLE_AC BP_TITL_AC_OLD CHAR 498 20 0 Academic Title
N_PREFIX BP_PREFIX_OLD CHAR 518 20 0 Name Prefix
N_ADDITION BP_ADDITN_OLD CHAR 538 20 0 Name Affix
NICKNAME BP_NICKNAM CHAR 558 20 0 Known As
SEX BP_SEX_OLD CHAR 578 1 0 Gender of Business Partner
PROFESSION BP_PROFESS_OLD CHAR 579 40 0 Description of Occupation for Business Partner
NATION BP_CNTR_N CHAR 619 3 0 T005 Nationality
STATE BP_CNTR_ST CHAR 622 3 0 T005 Citizenship
BIRTH_DATE BP_BIRTHD DATS 625 8 0 Date of Birth of Business Partner
BIRTH_PLAC BP_BIRTHPL CHAR 633 40 0 Birthplace
BIRTH_NAME BP_BIRTHNA CHAR 673 40 0 Name at Birth
BIRTH_N_AD BP_BIRTH_A CHAR 713 40 0 Name at Birth Affix
DEATH_DATE BP_DEATH_D DATS 753 8 0 Date of Death
MARITAL_ST BP_MARITAL_OLD NUMC 761 2 0 Marital Status
PROPRTY_ST BP_PROPRTY_OLD NUMC 763 2 0 Marital property regime
CHILDREN BP_CHILDRN DEC 765 2 0 Number of Children Belonging to the Business Partner
MEM_HOUSE BP_MEM_HOU DEC 767 2 0 Number of People Living in the Household
INCOME_CUR BP_INC_CUR CUKY 769 5 0 TCURC Currency of Net Income
NET_INCOME BP_NET_INC CURR 774 15 2 Net Annual Income
MO_NET_INC BP_MO_INC CURR 782 15 2 Monthly Net Income of Business Partner
NET_INC_Y BP_N_INC_Y NUMC 790 4 0 Year of Annual Net Income
MO_INC_M BP_M_INC_M NUMC 794 2 0 Calendar Month of Monthly Net Income
MO_INC_Y BP_M_INC_Y NUMC 796 4 0 Year of Monthly Net Income
PERS_NR BP_PERS_NR CHAR 800 15 0 Personnel Number
STAFF_GRP BP_STAFF_G CHAR 815 4 0 TP05 Employee Group
HR_ORG_REF HR_ORG_REF CHAR 819 1 0 HR Org. Link
XUBNAME XUBNAME CHAR 820 12 0 USR02 User Name in User Master Record
STAFF_REF BP_STAFF_R CHAR 832 1 0 Employee
ORG_NAME BP_NAME1 CHAR 833 40 0 Name 1 (surname for persons, otherwise company name)
ORG_NAME2 BP_NAME2 CHAR 873 40 0 Name 2 (Continuation of NAME 1)
CALENDARID BP_CAL_ID CHAR 913 2 0 TFACD Factory calendar
LEGAL_ENTY BP_LEG_ETY_OLD NUMC 915 2 0 TP08 Legal Form of Organization
LEGAL_ORG BP_LEG_ORG_OLD NUMC 917 2 0 TP09 Legal Entity of Organization
BALANCE_FL BP_BAL_FLG CHAR 919 1 0 Balance Sheet Display
FOUND_YEAR BP_FOUND_Y NUMC 920 4 0 Foundation Year of Organization
COMM_REGIS BP_COM_REG CHAR 924 50 0 Entry in Commercial Register
COMM_REG_D BP_COM_R_D DATS 974 8 0 Date of Entry in Commercial Register
CNTRY_COMP BP_CNTR_HD CHAR 982 3 0 T005 Country of Organization's Registered Office
REGIO BP_REGIO_HD CHAR 985 3 0 T005S Region of Registered Office
COMP_HEAD BP_COMP_HD CHAR 988 35 0 Registered Office
LIQUID_DAT BP_LIQUI_D DATS 1023 8 0 Date of Liquidation
COMP_NR BBBNR NUMC 1031 7 0 International location number (part 1)
COMP_NR_AD BBSNR NUMC 1038 5 0 International location number (Part 2)
BUBKZ BUBKZ NUMC 1043 1 0 Check digit for the international location number
IND_SECTOR BP_BRSCH_OLD CHAR 1044 4 0 Industry Keys
MIN_RESERV BP_MIN_RSV CHAR 1048 1 0 Bank Subject to Minimum Reserve Requirement
BAL_SH_CUR BP_BAL_CUR CUKY 1049 5 0 TCURC Balance Sheet Currency
CAP_INCR_A BP_CA_IN_A CURR 1054 15 2 Amount of last capital increase
CAP_INCR_Y BP_CA_IN_Y NUMC 1062 4 0 Year of Last Capital Increase
BANKL BANKK CHAR 1066 15 0 Bank Keys
BANKS BANKS CHAR 1081 3 0 T005 Bank country key
NO_CONV BOOLE_D CHAR 1084 1 0 Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')

398888BP_TR1: Composite note and FAQs about bus partner conversion
687037ERP 2004: No longer poss to maint bus partners in parallel
550854SAP BP: SAP + TR BP standard address type in parallel maint.
861360BP_TR2: Consistency check in RFTBUP10_BP000
858123BP_TR2: Table BP000 is deleted by RFTBUP10_BP000
736512BP_TR2: Update of the business partner conversion 2004
762061BP_TR2: Deactivate consistency check for table BP000
724492BP_DIA: Correspondence language for SAP business partner
656108BP_TR1: Language missing in organizations after conversion
528998Conversion academic titles,... incorrect
700960BP_TR1: Incomplete link between SAP-BP and TR-BP
690288BP_TR1: Commercial register entry is not transferred
608000BAFIN(German Fed.Fin.Sup.Auth.)§24c:Date of birth not filled
547299SAP BP: Address usages (conversion, parallel maint., dialog)
555558Address uses: Different corrections
555138SAP BP: Address uses (dialog and conversion)
541293SAP BP conversion: Data inconsistencies after BP conversion
516569SAP BP conversion phase I: Comparison of the academic title
438486SAP BP: Serious problems after conversion phase II
416954SAP business partner conversn: User name, employee indicator
90300Number ranges in Treasury: overview