SAP Table BP001
FS-Specific Attributes; Organization
BP001 (FS-Specific Attributes; Organization) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BP001 to other SAP tables.
Source: BP001 (FS-Specific Attributes; Organization)
BP001 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| TITLE_LET | Salutation | BP_TITL_LT | TP02 | NUMC | 2 | 0 | ||||||||||||||||||||||||||
| GROUP_D | Target Group | BP_GROUP_D | TP13 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| VIP | Business Partner Is VIP | BP_VIP_PARTNER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| BP_SORT | Phonetic Search Term | BP_PHONSTRING | CHAR | 80 | 0 | |||||||||||||||||||||||||||
| SORT_PHON | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | 0 | |||||||||||||||||||||||||||
| VBUND | Company ID of trading partner | RASSC | T880 | CHAR | 6 | 0 | ||||||||||||||||||||||||||
| COUNTRY_REP | Country for Reporting | BP_CNTR_REP | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| CALENDARID | Factory calendar | BP_CAL_ID | TFACD | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| CNTRY_COMP | Country of Organization's Registered Office | BP_CNTR_HD | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| REGIO | Region of Registered Office | BP_REGIO_HD | T005S | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| COMP_HEAD | Registered Office | BP_COMP_HD | CHAR | 35 | 0 | |||||||||||||||||||||||||||
| MIN_RESERV | Bank Subject to Minimum Reserve Requirement | BP_MIN_RSV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| BAL_SH_CUR | Balance Sheet Currency | BP_BAL_CUR | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||
| CAP_INCR_A | Amount of last capital increase | BP_CA_IN_A | CURR | 15 | 2 | |||||||||||||||||||||||||||
| CAP_INCR_Y | Year of Last Capital Increase | BP_CA_IN_Y | NUMC | 4 | 0 | |||||||||||||||||||||||||||
| BALANCE_FL | Balance Sheet Display | BP_BAL_FLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| BANKL | Bank Keys | BANKK | CHAR | 15 | 0 | |||||||||||||||||||||||||||
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| STATE | Citizenship | BP_CNTR_ST | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| PROPRTY_ST | Marital property regime | BP_PROPRTY_OLD | TP04 | NUMC | 2 | 0 | ||||||||||||||||||||||||||
| INCOME_CUR | Currency of Net Income | BP_INC_CUR | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||
| CHILDREN | Number of Children Belonging to the Business Partner | BP_CHILDRN | DEC | 2 | 0 | |||||||||||||||||||||||||||
| MEM_HOUSE | Number of People Living in the Household | BP_MEM_HOU | DEC | 2 | 0 | |||||||||||||||||||||||||||
| NET_INCOME | Net Annual Income | BP_NET_INC | CURR | 15 | 2 | |||||||||||||||||||||||||||
| MO_NET_INC | Monthly Net Income of Business Partner | BP_MO_INC | CURR | 15 | 2 | |||||||||||||||||||||||||||
| NET_INC_Y | Year of Net Annual Income | BP_N_INC_Y | NUMC | 4 | 0 | |||||||||||||||||||||||||||
| MO_INC_M | Calendar Month of Monthly Net Income | BP_M_INC_M | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
| MO_INC_Y | Year of Monthly Net Income | BP_M_INC_Y | NUMC | 4 | 0 | |||||||||||||||||||||||||||
| PERS_NR | Personnel Number | BP_PERS_NR | CHAR | 15 | 0 | |||||||||||||||||||||||||||
| STAFF_GRP | Employee Group | BP_STAFF_G | TP05 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| HR_ORG_REF | HR Org. Link | HR_ORG_REF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XUBNAME | User Name in User Master Record | BP_XUBNAME | USR02 | CHAR | 12 | 0 | ||||||||||||||||||||||||||
| STAFF_REF | Employee | BP_STAFF_R | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| DYING_PLACE | Name of Place of Death of Natural Person | BP_DYING_PLACE | CHAR | 40 | 0 | |||||||||||||||||||||||||||
| BANK_DEL_D | Termination Date for Business Relations with the Bank | BP_BANK_DEL_D | DATS | 8 | 0 | |||||||||||||||||||||||||||
| UNW_CUSTOMER | Undesirable Customer | BP_UNW_CUSTOMER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| UNW_REASON | Reason for Undesirability | BP_UNW_REASON | TP18 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| UNW_REMARK | Comment on Undesirability | BP_UNW_REMARK | CHAR | 35 | 0 | |||||||||||||||||||||||||||
| ADRKIND | Address Type | BU_ADRKIND | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| LAST_CUST_CONT | Date of Last Customer Contact | BP_LAST_CUST_CONTACT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| MAX_FILE_SIZE | Maximum Size for Ordering File | BP_BCA_DTE_CARD_MAX_FILE_SIZE | INT4 | 10 | 0 | |||||||||||||||||||||||||||
| GROUP_FEATURE | Grouping Character | BP_GROUP_FEATURE | TP24 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
BP001 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BP001 | BAL_SH_CUR | BP001 | BAL_SH_CUR | TCURC | Currency Codes | WAERS |
| BP001 | BAL_SH_CUR | BP001 | CLIENT | TCURC | Currency Codes | MANDT |
| BP001 | BANKS | BP001 | BANKS | T005 | Countries | LAND1 |
| BP001 | BANKS | BP001 | CLIENT | T005 | Countries | MANDT |
| BP001 | CALENDARID | BP001 | CALENDARID | TFACD | Factory calendar definition | IDENT |
| BP001 | CLIENT | BP001 | CLIENT | T000 | Clients | MANDT |
| BP001 | CNTRY_COMP | BP001 | CNTRY_COMP | T005 | Countries | LAND1 |
| BP001 | CNTRY_COMP | * | T005 | Countries | MANDT | |
| BP001 | COUNTRY_REP | BP001 | COUNTRY_REP | T005 | Countries | LAND1 |
| BP001 | COUNTRY_REP | * | T005 | Countries | MANDT | |
| BP001 | GROUP_D | BP001 | GROUP_D | TP13 | Business Partner: Partner Grouping (Target Group) | GROUP_D |
| BP001 | GROUP_D | * | TP13 | Business Partner: Partner Grouping (Target Group) | MANDT | |
| BP001 | GROUP_FEATURE | BP001 | GROUP_FEATURE | TP24 | BP: Partner Grouping Characteristics | GROUP_FEATURE |
| BP001 | GROUP_FEATURE | BP001 | CLIENT | TP24 | BP: Partner Grouping Characteristics | MANDT |
| BP001 | INCOME_CUR | BP001 | INCOME_CUR | TCURC | Currency Codes | WAERS |
| BP001 | INCOME_CUR | BP001 | CLIENT | TCURC | Currency Codes | MANDT |
| BP001 | PROPRTY_ST | * | TP04 | Business Partner: Marital Property Regime | MANDT | |
| BP001 | PROPRTY_ST | BP001 | PROPRTY_ST | TP04 | Business Partner: Marital Property Regime | PROPRTY_ST |
| BP001 | REGIO | BP001 | CNTRY_COMP | T005S | Taxes: Region (Province) Key | LAND1 |
| BP001 | REGIO | BP001 | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| BP001 | REGIO | * | T005S | Taxes: Region (Province) Key | MANDT | |
| BP001 | STAFF_GRP | * | TP05 | Business partner: Employee group | MANDT | |
| BP001 | STAFF_GRP | BP001 | STAFF_GRP | TP05 | Business partner: Employee group | STAFF_GRP |
| BP001 | STATE | * | T005 | Countries | MANDT | |
| BP001 | STATE | BP001 | STATE | T005 | Countries | LAND1 |
| BP001 | TITLE_LET | BP001 | TITLE_LET | TP02 | Business partner: Salutation | TITLE_LET |
| BP001 | TITLE_LET | * | TP02 | Business partner: Salutation | MANDT | |
| BP001 | UNW_REASON | SYST | MANDT | TP18 | Business Partner: Reason for Client being Undesirable | MANDT |
| BP001 | UNW_REASON | BP001 | UNW_REASON | TP18 | Business Partner: Reason for Client being Undesirable | UNW_REASON |
| BP001 | VBUND | BP001 | VBUND | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| BP001 | VBUND | SYST | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
| BP001 | XUBNAME | BP001 | XUBNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| BP001 | XUBNAME | * | USR02 | Logon Data (Kernel-Side Use) | MANDT | |
