SAP table BP001 (FS-Specific Attributes; Organization)

SAP table BP001 has 2 primary key fields being CLIENT,PARTNER.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
TITLE_LET Salutation NUMC 2 0 TP02 BP_TITL_LT
GROUP_D Target Group CHAR 4 0 TP13 BP_GROUP_D
PAR_REL Business Partner Released CHAR 1 0 BP_PAR_REL
Released
X Not released
VIP Business Partner Is VIP CHAR 1 0 BP_VIP_PARTNER
BP_SORT Phonetic Search Term CHAR 80 0 BP_PHONSTRING
SORT_PHON Sort Field for Phonetic Search; Obsolete CHAR 20 0 BP_SORT_PH
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
COUNTRY_REP Country/Region for Reporting CHAR 3 0 T005 BP_CNTR_REP
CALENDARID Factory calendar CHAR 2 0 TFACD BP_CAL_ID
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
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
BALANCE_FL Balance Sheet Display CHAR 1 0 BP_BAL_FLG
0 Not consolidated
1 Consolidated
2 Not associated
3 Associated
BANKL Bank Keys CHAR 15 0 BANKK
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
STATE Citizenship CHAR 3 0 T005 BP_CNTR_ST
PROPRTY_ST Marital property regime NUMC 2 0 TP04 BP_PROPRTY_OLD
INCOME_CUR Currency of Net Income CUKY 5 0 TCURC BP_INC_CUR
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
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
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
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 BP_XUBNAME
STAFF_REF Employee CHAR 1 0 BP_STAFF_R
DYING_PLACE Name of Place of Death of Natural Person CHAR 40 0 BP_DYING_PLACE
BANK_DEL_D Termination Date for Business Relations with the Bank DATS 8 0 BP_BANK_DEL_D
UNW_CUSTOMER Undesirable Customer CHAR 1 0 BP_UNW_CUSTOMER
UNW_REASON Reason for Undesirability CHAR 2 0 TP18 BP_UNW_REASON
UNW_REMARK Comment on Undesirability CHAR 35 0 BP_UNW_REMARK
ADRKIND Address Type CHAR 10 0 * BU_ADRKIND
LAST_CUST_CONT Date of Last Customer Contact DATS 8 0 BP_LAST_CUST_CONTACT
MAX_FILE_SIZE Maximum Size for Ordering File INT4 10 0 BP_BCA_DTE_CARD_MAX_FILE_SIZE
GROUP_FEATURE Grouping Character CHAR 10 0 TP24 BP_GROUP_FEATURE

BP001 foreign key relationships

Table Field Check Table Check Field
0 BP001 BAL_SH_CUR TCURC Currency Codes MANDT
0 BP001 BAL_SH_CUR TCURC Currency Codes WAERS
1 BP001 BANKS T005 Countries MANDT
1 BP001 BANKS T005 Countries LAND1
0 BP001 CLIENT T000 Clients MANDT
1 BP001 CNTRY_COMP T005 Countries MANDT
1 BP001 CNTRY_COMP T005 Countries LAND1
0 BP001 COUNTRY_REP T005 Countries MANDT
0 BP001 COUNTRY_REP T005 Countries LAND1
1 BP001 GROUP_D TP13 Business Partner: Partner Grouping (Target Group) MANDT
1 BP001 GROUP_D TP13 Business Partner: Partner Grouping (Target Group) GROUP_D
0 BP001 GROUP_FEATURE TP24 BP: Partner Grouping Characteristics GROUP_FEATURE
1 BP001 INCOME_CUR TCURC Currency Codes MANDT
1 BP001 INCOME_CUR TCURC Currency Codes WAERS
0 BP001 PROPRTY_ST TP04 Business Partner: Marital Property Regime MANDT
1 BP001 REGIO T005S Taxes: Region (Province) Key LAND1
0 BP001 STAFF_GRP TP05 Business partner: Employee group MANDT
0 BP001 STAFF_GRP TP05 Business partner: Employee group STAFF_GRP
1 BP001 STATE T005 Countries MANDT
1 BP001 STATE T005 Countries LAND1
0 BP001 TITLE_LET TP02 Business partner: Salutation MANDT
1 BP001 UNW_REASON TP18 Business Partner: Reason for Client being Undesirable MANDT
1 BP001 UNW_REASON TP18 Business Partner: Reason for Client being Undesirable UNW_REASON
0 BP001 VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 BP001 VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 BP001 XUBNAME USR02 Logon Data (Kernel-Side Use) BNAME