Menu

SAP Table BP000

Business Partner Master (General Data)

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table BP000 (Business Partner Master (General Data)) is a standard table in SAP ERP. It belongs to the package FBPAR.

Technical Information

Table BP000
Short Text Business Partner Master (General Data)
Package FBPAR
Table Type Transparent Table

Fields for Table BP000

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