BP000 SAP (Business Partner Master (General Data)) Table details

Dictionary Type: Table
Description: Business Partner Master (General Data)




ABAP Code to SELECT data from BP000
Related tables to BP000
Access table BP000




Table field list including key, data, relationships and ABAP select examples

BP000 is a standard SAP Table which is used to store Business Partner Master (General Data) data and is available within R/3 SAP systems depending on the version and release level.

The BP000 table consists of various fields, each holding specific information or linking keys about Business Partner Master (General Data) data available in SAP. These include PARTNR (Business Partner Number), PARTNR_OLD (Character Field Length = 10), PARTNER (Business Partner Number), PERSNUMBER (Person number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BP000 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PARTNRBusiness Partner Number BP_PARTNR_OLDCHAR10ALPHABP_PARTNRBPN
PARTNR_OLDCharacter Field Length = 10 CHAR10CHAR10CHAR10
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PERSNUMBERPerson number AD_PERSNUMCHAR10ADRPALPHAAD_PERSNUMCDTADDRESS
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4Assigned to domainBU_GROUPBPP
EXTPARTNRExternal Business Partner ID BP_EXT_PNRCHAR15CHAR15
CUSTOMERCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
TYPEPartner category BP_TYPE_OLDCHAR1BP_TYPE
BP_GROUPBP: Collective Business Partner Indicator BP_GROUPCHAR1XFELD
GROUP_IDBusiness Partner Grouping BP_GRP_ID_OLDCHAR4TPZ2BP_GRP_ID
NAME1Name 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
NAME2Name 2 (Continuation of NAME 1) BP_NAME2CHAR40TEXT40
LANGULanguage Key LANGULANG1T002ISOLASPRAS
TITLEForm of Address (Key) BP_TITLE_OLDNUMC2TP01BP_TITLE
TITLE_LETSalutation BP_TITL_LTNUMC2TP02BP_TITL_LT
ADR_REFAddress ID BP_ADR_REF_OLDCHAR10TP14BP_ADR_REFADK
SORT1Sort Field 1 BP_SORT1CHAR20CHAR20
SORT2Sort Field 2 BP_SORT2CHAR20CHAR20
SORT_PHONSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
MC_NAME1Field NAME1 in Upper Case BP_MC_NAM1CHAR25CHAR25
MC_NAME2Field NAME2 in Upper Case BP_MC_NAM2CHAR25CHAR25
SOURCESource Key of Business Partner Data BP_SOURCECHAR4BP_SOURCE
CRUSEREntered by BP_CRUSERCHAR12SYCHAR12
CRDATCreation Date BP_CRDATDATS8DATUM
VIPBusiness Partner: VIP Partner BP_VIPCHAR1TVIPPAVIP
GROUP_DTarget Group BP_GROUP_DCHAR4TP13BP_GROUP_D
DEL_INDDeletion Flag BP_DEL_INDCHAR1XFELD
BEGRUAuthorization Group BEGRUCHAR4BEGRU
XTITLEText of Form of Address BP_XTITLECHAR50TEXT50
XTIT_LESalutation BP_XTIT_LECHAR50TEXT50
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
NAME_LASTLast Name BP_NAMLASTCHAR40TEXT40
NAME_FIRSTFirst Name BP_NAMFRSTCHAR40TEXT40
TITLE_ACAcademic Title BP_TITL_AC_OLDCHAR20TEXT20
N_PREFIXName Prefix BP_PREFIX_OLDCHAR20TEXT20
N_ADDITIONName Affix BP_ADDITN_OLDCHAR20TEXT20
NICKNAMEKnown As BP_NICKNAMCHAR20TEXT20
SEXGender of Business Partner BP_SEX_OLDCHAR1BP_SEX
PROFESSIONDescription of Occupation for Business Partner BP_PROFESS_OLDCHAR40TEXT40
NATIONNationality BP_CNTR_NCHAR3T005LAND1
STATECitizenship BP_CNTR_STCHAR3T005LAND1
BIRTH_DATEDate of Birth of Business Partner BP_BIRTHDDATS8DATUM
BIRTH_PLACBirthplace BP_BIRTHPLCHAR40TEXT40
BIRTH_NAMEName at Birth BP_BIRTHNACHAR40TEXT40
BIRTH_N_ADName at Birth Affix BP_BIRTH_ACHAR40TEXT40
DEATH_DATEDate of Death BP_DEATH_DDATS8DATUM
MARITAL_STMarital Status BP_MARITAL_OLDNUMC2TP03BP_MARITAL
PROPRTY_STMarital property regime BP_PROPRTY_OLDNUMC2TP04BP_PROPRTY
CHILDRENNumber of Children Belonging to the Business Partner BP_CHILDRNDEC2DEC2
MEM_HOUSENumber of People Living in the Household BP_MEM_HOUDEC2DEC2
INCOME_CURCurrency of Net Income BP_INC_CURCUKY5TCURCWAERS
NET_INCOMENet Annual Income BP_NET_INCCURR15(2) WERTV8
MO_NET_INCMonthly Net Income of Business Partner BP_MO_INCCURR15(2) WERTV8
NET_INC_YYear of Net Annual Income BP_N_INC_YNUMC4GJAHRGJAHR
MO_INC_MCalendar Month of Monthly Net Income BP_M_INC_MNUMC2BP_M_INC_M
MO_INC_YYear of Monthly Net Income BP_M_INC_YNUMC4GJAHRGJAHR
PERS_NRPersonnel Number BP_PERS_NRCHAR15CHAR15
STAFF_GRPEmployee Group BP_STAFF_GCHAR4TP05BP_STAFF_G
HR_ORG_REFHR Org. Link HR_ORG_REFCHAR1XFELD
XUBNAMEUser Name in User Master Record XUBNAMECHAR12USR02XUBNAMEXUS
STAFF_REFEmployee BP_STAFF_RCHAR1XFELD
ORG_NAMEName 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
ORG_NAME2Name 2 (Continuation of NAME 1) BP_NAME2CHAR40TEXT40
CALENDARIDFactory calendar BP_CAL_IDCHAR2TFACDWFCID
LEGAL_ENTYLegal Form of Organization BP_LEG_ETY_OLDNUMC2TP08BP_LEG_ETY
LEGAL_ORGLegal Entity of Organization BP_LEG_ORG_OLDNUMC2TP09BP_LEG_ORG
BALANCE_FLBalance Sheet Display BP_BAL_FLGCHAR1BP_BAL_FLG
FOUND_YEARFoundation Year of Organization BP_FOUND_YNUMC4GJAHRGJAHR
COMM_REGISEntry in Commercial Register BP_COM_REGCHAR50TEXT50
COMM_REG_DDate of Entry in Commercial Register BP_COM_R_DDATS8DATUM
CNTRY_COMPCountry of Organization's Registered Office BP_CNTR_HDCHAR3T005LAND1
REGIORegion of Registered Office BP_REGIO_HDCHAR3T005SREGIO
COMP_HEADRegistered Office BP_COMP_HDCHAR35TEXT35
LIQUID_DATDate of Liquidation BP_LIQUI_DDATS8DATUM
COMP_NRInternational location number (part 1) BBBNRNUMC7NUM07
COMP_NR_ADInternational location number (Part 2) BBSNRNUMC5NUM05
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
IND_SECTORIndustry Keys BP_BRSCH_OLDCHAR4T016BRSCH
MIN_RESERVBank Subject to Minimum Reserve Requirement BP_MIN_RSVCHAR1XFELD
BAL_SH_CURBalance Sheet Currency BP_BAL_CURCUKY5TCURCWAERS
CAP_INCR_AAmount of last capital increase BP_CA_IN_ACURR15(2) WERTV8
CAP_INCR_YYear of Last Capital Increase BP_CA_IN_YNUMC4GJAHRGJAHR
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
.INCLU--AP 0
NO_CONVData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE

Key field Non-key field



How do I retrieve data from SAP table BP000 using ABAP code

The following ABAP code Example will allow you to do a basic selection on BP000 to SELECT all data from the table
DATA: WA_BP000 TYPE BP000.

SELECT SINGLE *
FROM BP000
INTO CORRESPONDING FIELDS OF WA_BP000
WHERE...

How to access SAP table BP000

Within an ECC or HANA version of SAP you can also view further information about BP000 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!