BP000

Business Partner Master (General Data) | #masterdata | Component: Business Partner
Column Name Description
MANDT FK Client
PARTNR Business Partner Number
Column Name Description
💲 Currency of Net Income (INCOME_CUR):
NET_INCOME Net Annual Income
MO_NET_INC Monthly Net Income of Business Partner
💲 Balance Sheet Currency (BAL_SH_CUR):
CAP_INCR_A Amount of last capital increase
Column Name Description
Column Name Description
CRDAT Creation Date
BIRTH_DATE Date of Birth of Business Partner
DEATH_DATE Date of Death
COMM_REG_D Date of Entry in Commercial Register
LIQUID_DAT Date of Liquidation
Column Name Description
TYPE Partner category Show values
BP_GROUP BP: Collective Business Partner Indicator Show values
DEL_IND Deletion Flag Show values
PAR_REL Business Partner Released Show values
SEX Gender of Business Partner Show values
MO_INC_M Calendar Month of Monthly Net Income Show values
HR_ORG_REF HR Org. Link Show values
STAFF_REF Employee Show values
BALANCE_FL Balance Sheet Display Show values
MIN_RESERV Bank Subject to Minimum Reserve Requirement Show values
NO_CONV Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
PARTNR_OLD Character Field with Length 10 CHAR10
PARTNER Business Partner Number BU_PARTNER
BU_GROUP Business Partner Grouping BU_GROUP
EXTPARTNR External Business Partner ID CHAR15
CUSTOMER Customer Number KUNNR
NAME1 Name 1 (surname for persons, else company name) TEXT40
NAME2 Name 2 (Continuation of NAME 1) TEXT40
SORT1 Sort Field 1 CHAR20
SORT2 Sort Field 2 CHAR20
SORT_PHON Sort Field for Phonetic Search; Obsolete CHAR20
MC_NAME1 Field NAME1 in Upper Case CHAR25
MC_NAME2 Field NAME2 in Upper Case CHAR25
SOURCE Source Key of Business Partner Data BP_SOURCE
CRUSER Entered by SYCHAR12
BEGRU Authorization Group BEGRU
XTITLE Text of Form of Address TEXT50
XTIT_LE Salutation TEXT50
NAME_LAST Last Name TEXT40
NAME_FIRST First Name TEXT40
TITLE_AC Academic Title TEXT20
N_PREFIX Name Prefix TEXT20
N_ADDITION Name Affix TEXT20
NICKNAME Known As TEXT20
PROFESSION Description of Occupation for Business Partner TEXT40
BIRTH_PLAC Birthplace TEXT40
BIRTH_NAME Name at Birth TEXT40
BIRTH_N_AD Name at Birth Affix TEXT40
CHILDREN Number of Children Belonging to the Business Partner DEC2
MEM_HOUSE Number of People Living in the Household DEC2
NET_INC_Y Year of Net Annual Income GJAHR
MO_INC_Y Year of Monthly Net Income GJAHR
PERS_NR Personnel Number CHAR15
ORG_NAME Name 1 (surname for persons, else company name) TEXT40
ORG_NAME2 Name 2 (Continuation of NAME 1) TEXT40
FOUND_YEAR Foundation Year of Organization GJAHR
COMM_REGIS Entry in Commercial Register TEXT50
COMP_HEAD Registered Office TEXT35
COMP_NR International location number (part 1) NUM07
COMP_NR_AD International location number (Part 2) NUM05
BUBKZ Check digit for the international location number NUM01
CAP_INCR_Y Year of Last Capital Increase GJAHR
BANKL Bank Keys BANKK
BANKS Country/Region Key of Bank LAND1
Master Data Relations Join Conditions
Address ID
  • Address ID
  • Client
  • BP000.ADR_REF == TP14.ADR_REF
  • BP000.MANDT == TP14.MANDT
Balance Sheet Currency
  • BP000.MANDT == TCURC.MANDT
  • BP000.BAL_SH_CUR == TCURC.WAERS
Factory calendar BP000.CALENDARID == TFACD.IDENT
Country/Region of Registered Office
  • Country/Region of Registered Office
  • Client
  • BP000.CNTRY_COMP == T005.LAND1
  • BP000.MANDT == T005.MANDT
Target Group
  • BP000.MANDT == TP13.MANDT
  • BP000.GROUP_D == TP13.GROUP_D
Business Partner Grouping
  • BP000.MANDT == TPZ2.MANDT
  • BP000.GROUP_ID == TPZ2.GROUP_ID
Currency of Net Income
  • BP000.MANDT == TCURC.MANDT
  • BP000.INCOME_CUR == TCURC.WAERS
Industry Keys
  • Industry Keys
  • Client
  • BP000.IND_SECTOR == T016.BRSCH
  • BP000.MANDT == T016.MANDT
Language Key BP000.LANGU == T002.SPRAS
Legal Form of Organization
  • BP000.MANDT == TP08.MANDT
  • BP000.LEGAL_ENTY == TP08.LEGAL_ENTY
Legal Entity of Organization
  • BP000.MANDT == TP09.MANDT
  • BP000.LEGAL_ORG == TP09.LEGAL_ORG
Client BP000.MANDT == T000.MANDT
Marital Status
  • BP000.MANDT == TP03.MANDT
  • BP000.MARITAL_ST == TP03.MARITAL_ST
Nationality
  • Nationality
  • Client
  • BP000.NATION == T005.LAND1
  • BP000.MANDT == T005.MANDT
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • BP000.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • BP000.[column in domain "AD_NATION"] == ADRP.NATION
  • BP000.MANDT == ADRP.CLIENT
  • BP000.PERSNUMBER == ADRP.PERSNUMBER
Marital property regime
  • Marital property regime
  • Client
  • BP000.PROPRTY_ST == TP04.PROPRTY_ST
  • BP000.MANDT == TP04.MANDT
Region of Registered Office
  • Country/Region of Registered Office
  • Region of Registered Office
  • BP000.MANDT == T005S.MANDT
  • BP000.CNTRY_COMP == T005S.LAND1
  • BP000.REGIO == T005S.BLAND
Employee Group
  • BP000.MANDT == TP05.MANDT
  • BP000.STAFF_GRP == TP05.STAFF_GRP
Citizenship
  • Citizenship
  • Client
  • BP000.STATE == T005.LAND1
  • BP000.MANDT == T005.MANDT
Form of Address (Key)
  • BP000.MANDT == TP01.MANDT
  • BP000.TITLE == TP01.TITLE
Salutation
  • Salutation
  • Client
  • BP000.TITLE_LET == TP02.TITLE_LET
  • BP000.MANDT == TP02.MANDT
Business Partner: VIP Partner
  • Business Partner: VIP Partner
  • Client
  • BP000.VIP == TVIP.PAVIP
  • BP000.MANDT == TVIP.MANDT
User Name in User Master Record
  • BP000.MANDT == USR02.MANDT
  • BP000.XUBNAME == USR02.BNAME