1. Home
  2. Resources
  3. SAP Tables
  4. BPFTB_ALL_DI - Business partner: Treasury data in CBP

SAP Table BPFTB_ALL_DI

Business partner: Treasury data in CBP

BPFTB_ALL_DI (Business partner: Treasury data in CBP) 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 BPFTB_ALL_DI to other SAP tables.

BPFTB_ALL_DI table fields

Field Data element Checktable Datatype Length Decimals
TITLE_LET_TR Salutation (Key) BP_TITL_LT_DI CHAR 2 0
GROUP_D Target Group BP_GROUP_D TP13 CHAR 4 0
PAR_REL Business Partner Released BP_PAR_REL CHAR 1 0
NULL Released
X Not released
VIP Business partner: VIP partner VIP_FS TVIP_FS CHAR 1 0
SORT_PHON Sort Field for Phonetic Search; Obsolete BP_SORT_PH CHAR 20 0
VBUND_DI Company ID of trading partner RASSC CHAR 6 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
X Yes
NULL No
BAL_SH_CUR Balance Sheet Currency BP_BAL_CUR_DI CHAR 5 0
CAP_INCR_A Amount of Last Capital Increase BP_CA_IN_A_DI CHAR 21 0
CAP_INCR_Y Year of Last Capital Increase BP_CA_IN_Y_DI CHAR 4 0
BALANCE_FL Balance Sheet Display BP_BAL_FLG CHAR 1 0
0 Not consolidated
1 Consolidated
2 Not associated
3 Associated
BANKL_TR Bank Keys BANKK CHAR 15 0
BANKS_TR Bank country key BANKS CHAR 3 0
STATE Citizenship BP_CNTR_ST T005 CHAR 3 0
PROPRTY_ST Marital Property Regime BP_PROPRTY_OLD_DI CHAR 2 0
INCOME_CUR Currency of Net Income BP_INC_CUR_DI CHAR 5 0
CHILDREN_TR Number of Children Belonging to the Business Partner BP_CHILDRN_DI CHAR 2 0
MEM_HOUSE_TR Number of People Living in the Household BP_MEM_HOU_DI CHAR 2 0
NET_INCOME Net Annual Income BP_NET_INC_DI CHAR 21 0
MO_NET_INC Monthly net income of business partner BP_MO_INC_DI CHAR 21 0
NET_INC_Y Year of Net Annual Income BP_N_INC_Y_DI CHAR 4 0
MO_INC_M Month of Monthly Net Income BP_M_INC_M_DI CHAR 2 0
MO_INC_Y Year of monthly net income BP_M_INC_Y_DI CHAR 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
X Yes
NULL No
XUBNAME_TR User Name in User Master Record XUBNAME USR02 CHAR 12 0
STAFF_REF Employee BP_STAFF_R CHAR 1 0
X Yes
NULL No
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_DI CHAR 8 0
UNW_CUSTOMER Undesirable Customer BP_UNW_CUSTOMER CHAR 1 0
X Yes
NULL No
UNW_REASON Reason for Undesirability BP_UNW_REASON 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_DI CHAR 8 0
GROUP_FEATURE Grouping Character BP_GROUP_FEATURE CHAR 10 0
CHIND_ED Change category BU_CHIND CHAR 1 0
U Update
I Insert
D Delete
M Modify
EMPL_SINCE Employed from EMPL_DATE_DI CHAR 8 0
EMPL_UNTIL Employed Until BP_EMP_UNT_DI CHAR 8 0
EMPLOYMENT Employment status BP_EMPLOYM_DI CHAR 2 0
EMP_SECTOR_ZGP Industry sector BU_INDSECT CHAR 10 0
EMPLOYER Employer EMPLOYER CHAR 35 0
JOBGR_ZGP Occupation/group BU_JOBGR CHAR 4 0
CHIND_BY Change category BU_CHIND CHAR 1 0
U Update
I Insert
D Delete
M Modify
BUSINESS_Y Fiscal Year BP_BUSIN_Y_DI CHAR 4 0
BAL_SH_CUR_BY Balance Sheet Currency BP_BAL_CUR_DI CHAR 5 0
GEN_MEET_D Date of Annual Stockholders Meeting BP_GE_ME_D_DI CHAR 8 0
BU_Y_BEGIN Fiscal Year Start Date BP_B_Y_BEG_DI CHAR 8 0
BU_Y_END Fiscal Year End Date BP_B_Y_END_DI CHAR 8 0
ANNUAL_ACC Year-End Closing BP_ANN_ACC CHAR 1 0
X Yes
NULL No
ANNU_ACC_D Year-End Closing Date for Fiscal Year BP_A_ACC_D_DI CHAR 8 0
CONS_FST_D Date of Consolidated Financial Statements of Group Company BP_C_FST_D_DI CHAR 8 0
CAPI_STOCK Amount of Authorized Capital Stock for Company BP_CAP_STK_DI CHAR 21 0
SHAR_STOCK Amount of Issued Stock Capital for Company BP_SHA_STK_DI CHAR 21 0
PRSH_STOCK Amount of Participation Certificates Outstanding for Company BP_PRS_STK_DI CHAR 21 0
EQUITY Amount of Equity Capital for Company BP_EQUITY_DI CHAR 21 0
GROSS_AMNT Gross Premium BP_GROSS_A_DI CHAR 21 0
NET_AMOUNT Net Premium BP_NET_A_DI CHAR 21 0
TURNOVER Amount of Annual Sales for Company BP_TURNOVR_DI CHAR 21 0
NET_INCOME_BY Amount of Annual Net Income/Net Loss for Company BP_NET_IN_DI CHAR 21 0
DIV_DIS_AM Dividend/Profit Distribution Amount for Company BP_DIV_DIS_DI CHAR 21 0
DEBTS_FACT Debt Ratio in Years BP_DEBTS_F_DI CHAR 7 0
DIS_PROFIT Amount of Annual Profit/Loss for Organization BP_PROFIT_DI CHAR 21 0
BAL_AMOUNT Amount of Balance Sheet Total for Company BP_BAL_AMT_DI CHAR 21 0
CAP_RES Amount of Capital Reserve for Company BP_CAP_RESERV_DI CHAR 21 0
REV_RES_LEG Amount of Legal Revenue Reserves for Company BP_REVENUE_RESERV_LEG_DI CHAR 21 0
REV_RES_OWN_SHR Revenue Reserves for Own Stock BP_REVENUE_RESERV_OWN_SHARE_DI CHAR 21 0
REV_RES_BY_LAWS Amount of Statutory Revenue Reserve for Company BP_REVENUE_RESERV_BY_LAWS_DI CHAR 21 0
REV_RES_OTHERS Amount of Other Revenue Reserves for Company BP_REVENUE_RESERV_OTHERS_DI CHAR 21 0
FORW_PROFIT_LOSS Amount of Profit/Loss Carried Forward for Company BP_FORWARD_PROFIT_LOSS_DI CHAR 21 0
LIABILIT_SECOND Amount of Subordinated Liabilities for Company BP_LIABILIT_SECOND_DI CHAR 21 0
RET_TOT_CAP_EMPL Return on Total Capital Employed for Company in Percent BP_RETURN_TOTAL_CAP_EMPL_DI CHAR 6 0
REDUC_LONG_TERM Debt Clearance Period in Years BP_REDUC_LONG_TERM_DI CHAR 6 0
COEFF_FINANCE Financing Coefficient for Company in Percent BP_COEFF_FINANCE_DI CHAR 6 0
EQUITY_CAPIT Equity Ratio of Company in Percent BP_EQUITY_CAPIT_DI CHAR 6 0
DE_OATH Affidavit BP_DE_OATH CHAR 1 0
X Yes
NULL No
DE_OA_D Date of affidavit BP_DE_OA_D_DI CHAR 8 0
BANKRUP Launch Bankruptcy Proceedings BP_BANKRUP CHAR 1 0
X Yes
NULL No
BNKRY_D Date of bankruptcy proceedings BP_BNKRY_D_DI CHAR 8 0
FORECLO Foreclosure BP_FORECLO CHAR 1 0
X Yes
NULL No
FORCL_D Date of foreclosure BP_FORCL_D_DI CHAR 8 0
SOLVNCY Credit Standing BP_SOLVNCY CHAR 1 0
0 VIP - Preferable Credit Standing
1 Very Good
2 Good
3 Satisfactory
4 Sufficient
5 Poor
6 Unsatisfactory
SOL_INS Institute Providing Credit Standing Information BP_SOL_INS CHAR 4 0
SOL_INF Status of Credit Standing Information BP_SOL_INF CHAR 1 0
0 Positive
1 Negative
2 Requested
3 Information Agreed
4 information Refused
NULL None
SOL_TXT Additional Credit Standing Information BP_SOL_TXT CHAR 50 0
SOL_I_D Date of Credit Standing Information BP_SOL_I_D_DI CHAR 8 0
RATING Rating BP_RATING CHAR 3 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
TAX_RES Tax Non-Resident Indicator BP_TAX_RES CHAR 1 0
X Yes
NULL No
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STCEG VAT Registration Number STCEG CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
COUNTRY_TR Country Key LAND1 CHAR 3 0
REGION_TR Region (State, Province, County) REGIO CHAR 3 0
FISKN Account number of the master record with the fiscal address FISKN_D CHAR 10 0
NRESIDT Non-Resident According to Paragraph 4 AWG BP_NRESIDT CHAR 1 0
X Yes
NULL No
NRESI_D Start of Non-Residency According to Paragraph 4 AWG BP_NRESI_D_DI CHAR 8 0
KWG_RLV Recipient of Multimillion Loan According to Paragraph 14 GBA BP_KWG_RLV CHAR 1 0
X Yes
NULL No
KWG_NR Borrower Number for Reporting a Loan According to GBA BP_KWG_NR CHAR 8 0
KWG_ENR Borrower Entity Number Used to Report Loan acc. to GBA BP_KWG_ENR CHAR 8 0
KWG_CRE Credit Standing Review According to Paragraph 18 GBA BP_KWG_CRE_DI CHAR 2 0
KWG_CRE_D Date of Credit Standing Review According to Paragraph 18 GBA BP_KWG_CRE_D_DI CHAR 8 0
KWG_ORG Loan to Manager According to Paragraph 15 German Banking Act BP_KWG_ORG_DI CHAR 2 0
COMP_RE Organization Relationship BP_COMP_RE CHAR 1 0
1 Affiliated Company
2 Shareholding
3 Other
4 Holding
XID_AT (OeNB) Ident Number VVXID_AT_FS CHAR 11 0
SZG_AT Target Group According to OeNB VVSZG_AT_FS TD05_AT_FS CHAR 2 0
SID_AT Assign (OeNB) Ident Number VVSID_AT_FS CHAR 1 0
0 No
1 Yes
SINLZ_AT Institute Number According to OeNB VVSINLZ_AT CHAR 7 0
SINME_AT Institute Subject to Austrian Reg. Reporting Requirements VVSINME_AT CHAR 1 0
X Yes
NULL No
GID_AT Group ID VVGID_AT CHAR 15 0
GIDTYPE_AT Group Assignment Category VVGIDTYPE_AT CHAR 1 0
I Internal ID
E OeNB ID
GNAME_AT Group Name VVGNAME_AT CHAR 50 0
ENT_REPO Legal Entity for Business Partner BP_ENTITY_REPORT CHAR 2 0
01 Fed. Rep. Germany, States, Local Govmts and Loc. Authorities
02 Partner States, Reg. Govmt, Local Authorities in EC/EEA (0%)
03 International Organizations with FRG as Full Member
04 Other Regional Governmnts, Local Authorities in EC/EEA (20%)
05 Public Credit Institution
06 Private Credit Institution
07 Private Companies (Except Credit Institutions)
08 Other
ENT_QUOT Business Partner Acc. to Para. 4, Sec. 2 of Asset Regulation BP_ENTITY_QUOTA CHAR 1 0
1 Business Partner According to Paragraph 4, Section 1
2 Business Partner According to Paragraph 4, Section 2, No. 1
3 Business Partner According to Paragraph 4, Section 2, No. 2
4 Business Partner According to Paragraph 4, Section 4
5 Business Partner According to Paragraph 4, Section 3
DEB_GROU Debtor Group According to German Law (BerVersV, Template 5) BP_DEBTOR_GROUP CHAR 1 0
1 Corporations and Institutions Under Public Law
2 Companies Under Private Law
3 Employees
4 Other Persons
BUS_PURP Category of Business Purpose BP_BUSINESS_PURPOSE CHAR 2 0
01 Reinsurance Company
02 Primary Insurance Company
03 Pension Fund
04 Real Estate Company
05 Credit Institute
06 Public-Private Partnership (PPP)
RISK_GROUP Risk Group BP_RISK_GROUP CHAR 1 0
0 No Risk Group
1 Credits Without Discernible Risk
2 Credits with Increased, Latent Risk
3 Value-Adjusted Credits
CLASSIFICATION_D Date of Risk Grouping BP_CLASSIFICATION_D_DI CHAR 8 0
COMBINE_TIE Group Affiliation Exists BP_COMBINE_TIE CHAR 1 0
X Yes
NULL No
MFI Monetary Financial Institution BP_MFI CHAR 1 0
X Yes
NULL No
KWG_REL Obligation to Submit to Credit Standing Review - Para.18 GBA BP_KWG_REL CHAR 1 0
X Yes
NULL No
L_CREDIT_CHECK Large-Scale Loan Monitoring According to Paragraph 13b GBA BP_LARGE_CREDIT_CHECK CHAR 1 0
X Yes
NULL No
CREDITING_RELIEF Crediting Relief in Accordance with Paragraph 13/3 GBA BP_CREDITING_RELIEF CHAR 1 0
X Yes
NULL No
PAR1_ABS1_REL Authorized Acc. to Para. 2(1)18b of German Asset Regulation BP_PAR1_BAFIN CHAR 1 0
X Yes
NULL No
COUNTRY_KEY Numeric Code for German Federal Bank Country Indicator BP_LZB_COUNTRY_KEY CHAR 4 0
KWG_ORG_BUKRS Loan to Manager According to Paragraph 15 German Banking Act BP_KWG_ORG_DI CHAR 2 0
BAL_SH Balance Sheet Display BP_BAL_SH CHAR 1 0
0 Not consolidated
1 Consolidated
2 Not associated
3 Associated
COMP_RE_BUKRS Company Relationship in Company Code BP_CCOM_RE CHAR 1 0
1 Affiliated Company
2 Shareholding
3 Other
4 Holding
LIABIL_RISK Type of Liability Risk BP_LIABIL_RISC CHAR 2 0
1 Guarantee
2 Bank Comfort Letter
3 Loss-Sharing Agreement
4 Numeric
A Letters
LIABIL_RISK_AMNT Amount of Liability Risk BP_RISK_AMNT_DI CHAR 22 0
LIABIL_RISK_CURR Currency of Liability Risk Amount BP_RISK_CURR_DI CHAR 5 0
LIABIL_RISK_FROM Valid from Date for Liability Risk BP_LRISK_FROM_DI CHAR 10 0
LIABIL_RISK_TO Valid to Date for Liability Risk BP_LRISK_TO_DI CHAR 10 0
PART_CO Partner-Company Code Allocation BP_PART_CO CHAR 4 0
VEND_EX Indicator: Vendor Exists for Partner BP_VEND_EX CHAR 1 0
X Yes
NULL No
SGRP1 Group Key 1 (Freely-Definable - 3 Figure Number) VVGRP_1_DI CHAR 3 0
SGRP2 Group Key 2 (Freely-Definable - 3 Figure Number) VVGRP_2_DI CHAR 3 0
SGRP3 Group Key 3 (Freely-Definable - 3 Figure Number) VVGRP_3_DI CHAR 3 0
SGRP4 Group key 4 (freely-definable - 3 figure number) VVGRP_4_DI CHAR 3 0
SGRP5 Group key 5 (freely-definable - 3 figure number) VVGRP_5_DI CHAR 3 0
SGRP6 Group key 6 (freely-definable - 3 figure number) VVGRP_6_DI CHAR 3 0
SGRP7 Group key 7 (freely-definable - 3 figure number) VVGRP_7_DI CHAR 3 0
SGRP8 Group key 8 (freely-definable - 3 figure number) VVGRP_8_DI CHAR 3 0
SGRP9 Group key 9 (freely-definable - 3 figure number) VVGRP_9_DI CHAR 3 0
SGRP10 Group key 10 (freely-definable - 3 figure number) VVGRP10_DI CHAR 3 0
SGRP11 Group key 11 (freely-definable - 3 figure number) VVGRP11_DI CHAR 3 0
SFRT1 User-defined text (freely definable - 35 character text) VVFREI_1 CHAR 35 0
SFRT2 User-defined text (freely definable - 35 character text) VVFREI_2 CHAR 35 0
SFRT3 User-defined text (freely definable - 35 character text) VVFREI_3 CHAR 35 0
SFRT4 User-defined text (freely definable - 35 character text) VVFREI_4 CHAR 35 0
SFRT5 User-defined text (freely definable - 35 character text) VVFREI_5 CHAR 35 0
SFRT6 User-defined text (freely definable - 35 character text) VVFREI_6 CHAR 35 0
SFRT7 User-defined text (freely definable - 35 character text) VVFREI_7 CHAR 35 0
SFRT8 User-defined text (freely definable - 35 character text) VVFREI_8 CHAR 35 0
CHIND_SI3 Change category BU_CHIND CHAR 1 0
U Update
I Insert
D Delete
M Modify
RANTYP_A3 Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
SANLF_A3 Product Category SANLF_DI CHAR 3 0
SGSART_A3 Product Type VVSART CHAR 3 0
SFHAART_A3 Financial Transaction Type TB_SFHAART CHAR 3 0
AUTHOR Authorization indicator for Treasury product TB_AUTHOR CHAR 1 0
X Yes
NULL No

BPFTB_ALL_DI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BPFTB_ALL_DI CALENDARID BPFTB_ALL_DI CALENDARID TFACD Factory calendar definition IDENT
BPFTB_ALL_DI CNTRY_COMP * T005 Countries MANDT
BPFTB_ALL_DI CNTRY_COMP BPFTB_ALL_DI CNTRY_COMP T005 Countries LAND1
BPFTB_ALL_DI GROUP_D * TP13 Business Partner: Partner Grouping (Target Group) MANDT
BPFTB_ALL_DI GROUP_D BPFTB_ALL_DI GROUP_D TP13 Business Partner: Partner Grouping (Target Group) GROUP_D
BPFTB_ALL_DI REGIO * T005S Taxes: Region (Province) Key MANDT
BPFTB_ALL_DI REGIO BPFTB_ALL_DI CNTRY_COMP T005S Taxes: Region (Province) Key LAND1
BPFTB_ALL_DI REGIO BPFTB_ALL_DI REGIO T005S Taxes: Region (Province) Key BLAND
BPFTB_ALL_DI STAFF_GRP * TP05 Business partner: Employee group MANDT
BPFTB_ALL_DI STAFF_GRP BPFTB_ALL_DI STAFF_GRP TP05 Business partner: Employee group STAFF_GRP
BPFTB_ALL_DI STATE BPFTB_ALL_DI STATE T005 Countries LAND1
BPFTB_ALL_DI STATE * T005 Countries MANDT
BPFTB_ALL_DI SZG_AT BPFTB_ALL_DI SZG_AT TD05_AT_FS IS-IS: �NB-Target groups SZG_AT
BPFTB_ALL_DI SZG_AT SYST MANDT TD05_AT_FS IS-IS: �NB-Target groups MANDT
BPFTB_ALL_DI VIP SYST MANDT TVIP_FS Contact Person: VIP Indicator MANDT
BPFTB_ALL_DI VIP BPFTB_ALL_DI VIP TVIP_FS Contact Person: VIP Indicator PAVIP
BPFTB_ALL_DI XUBNAME_TR * USR02 Logon Data (Kernel-Side Use) MANDT
BPFTB_ALL_DI XUBNAME_TR BPFTB_ALL_DI XUBNAME_TR USR02 Logon Data (Kernel-Side Use) BNAME