SAP Table BP000
Business Partner Master (General Data)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 | ||