SAP BP000 Business Partner Master (General Data) Table data and field list

BP000 is a standard SAP Table which is used to store Business Partner Master (General Data) data in SAP systems, such as SAP R/3, S/4HANA, 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. .

BP000 table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BP000 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

Key field

Non-key field

< BOS_V_ASMD - Generated Table for View BP000_ADR - Business partner address >

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).

Related SAP tables and the relationships to BP000

    BP000 - Business Partner Master (General Data)
        BP011 - Business Parnter Master (Employment Data)
        BP1060 - Business Partner: CoCd Control Data
        BP2000 - BP: Business Partner - Business Partner Relation
        BP3000 - BP: Additional Data (from Darwin BP)
        BPDMAHN - BP Structure: Dunning Data (Company Code)
        BPDKNA1 - BP: Business Partner-Relevant Fields in KNA1
        BPDKNB1 - BP: Business Partner-Relevant Fields in KNB1
        BPDBANK - BP Structure: Business Partner Bank Details
        VTBSTC1 - Payment Connection Components for Standing Instr.
        VTBSTA1 - Payment Connection Assignment as Standing Instr.
        VTBSTA2 - Standing Instructions for Correspondence
        BP021 - Business Partner Master (Fiscal Year Information)
        VTBSTA3 - Standing Instructions for Business Partners
        VTBSTA4 - Standing Instructions for Business Partners
        BP030 - BP: Business Partner - Address
        BP1000 - BP: Business Partner - Role
        BP1010 - BP: Credit Standing Data
        BP1020 - BP: Business Partner - Fiscal Data
        BP1030 - BP: Business Partner - Reporting Data
        BP1040 - Business partner: Reporting data in company code
        BP1050 - Business Partner: General Control Data

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
    VIGBSTD - Real Estate Register of Land Register
        VIGBFLS - Parcels of Land for Property
        VIGBZAB - Appreciation/Depreciation in Real Estate Register
    VIGBA1 - Section 1 of Land Register
    VIGBA2 - Section 2 of Land Register
        VIGB2A - Changes in Section 2 of Land Register
    VIGBA3 - Section 3 of Land Register
        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
        BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-Dependent Adjustment Data
        BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Settl.: Assign RUs to part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship between Real Estate objs and SAP-PM
        VZSORT - Sort Values for Object

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (Plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
    VIGBSTD - Real Estate Register of Land Register
        VIGBFLS - Parcels of Land for Property
        VIGBZAB - Appreciation/Depreciation in Real Estate Register
    VIGBA1 - Section 1 of Land Register
    VIGBA2 - Section 2 of Land Register
        VIGB2A - Changes in Section 2 of Land Register
    VIGBA3 - Section 3 of Land Register
        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
        BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-dependent Adjustment Data
        BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Stt. Assign RUs to No. of Part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship Between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship Between Real Estate Objs and SAP-PM
        VZSORT - Sort Values for Object