BP000
Business Partner Master (General Data)Explore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table BP000.
SAP table BP000 has 2 primary key fields: MANDT,PARTNR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
BP000 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||
| Key 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 | ||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
| 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 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| BP000 | ADR_REF | TP14 | Business Partner: Address ID | MANDT |
| BP000 | ADR_REF | TP14 | Business Partner: Address ID | ADR_REF |
| BP000 | BAL_SH_CUR | TCURC | Currency Codes | MANDT |
| BP000 | BAL_SH_CUR | TCURC | Currency Codes | WAERS |
| BP000 | CNTRY_COMP | T005 | Countries | MANDT |
| BP000 | CNTRY_COMP | T005 | Countries | LAND1 |
| BP000 | GROUP_D | TP13 | Business Partner: Partner Grouping (Target Group) | MANDT |
| BP000 | GROUP_D | TP13 | Business Partner: Partner Grouping (Target Group) | GROUP_D |
| BP000 | GROUP_ID | TPZ2 | Business Partner: Customizing BP Grouping | MANDT |
| BP000 | GROUP_ID | TPZ2 | Business Partner: Customizing BP Grouping | GROUP_ID |
| BP000 | INCOME_CUR | TCURC | Currency Codes | MANDT |
| BP000 | INCOME_CUR | TCURC | Currency Codes | WAERS |
| BP000 | IND_SECTOR | T016 | Industries | BRSCH |
| BP000 | LEGAL_ENTY | TP08 | Business Partner: Legal Form | MANDT |
| BP000 | LEGAL_ENTY | TP08 | Business Partner: Legal Form | LEGAL_ENTY |
| BP000 | LEGAL_ORG | TP09 | Business Partner: Legal Entity | MANDT |
| BP000 | LEGAL_ORG | TP09 | Business Partner: Legal Entity | LEGAL_ORG |
| BP000 | MANDT | T000 | Clients | MANDT |
| BP000 | MARITAL_ST | TP03 | Business partner: Marital status | MANDT |
| BP000 | NATION | T005 | Countries | MANDT |
| BP000 | NATION | T005 | Countries | LAND1 |
| BP000 | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| BP000 | PERSNUMBER | ADRP | Persons (Business Address Services) | DATE_FROM |
| BP000 | PERSNUMBER | ADRP | Persons (Business Address Services) | NATION |
| BP000 | PROPRTY_ST | TP04 | Business Partner: Marital Property Regime | MANDT |
| BP000 | REGIO | T005S | Taxes: Region (Province) Key | LAND1 |
| BP000 | STAFF_GRP | TP05 | Business partner: Employee group | MANDT |
| BP000 | STAFF_GRP | TP05 | Business partner: Employee group | STAFF_GRP |
| BP000 | STATE | T005 | Countries | MANDT |
| BP000 | STATE | T005 | Countries | LAND1 |
| BP000 | TITLE | TP01 | Business Partner: Form of Address | MANDT |
| BP000 | TITLE | TP01 | Business Partner: Form of Address | TITLE |
| BP000 | TITLE_LET | TP02 | Business partner: Salutation | MANDT |
| BP000 | VIP | TVIP | Contact Person: VIP Indicator | MANDT |
| BP000 | VIP | TVIP | Contact Person: VIP Indicator | PAVIP |
| BP000 | XUBNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |