SAP Table BPFTB_ALL_DI (Business partner: Treasury data in CBP)

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

BPFTB_ALL_DI foreign key relationships

Table Field Check Table Check Field
0 BPFTB_ALL_DI CNTRY_COMP T005 Countries MANDT
0 BPFTB_ALL_DI CNTRY_COMP T005 Countries LAND1
1 BPFTB_ALL_DI GROUP_D TP13 Business Partner: Partner Grouping (Target Group) MANDT
1 BPFTB_ALL_DI GROUP_D TP13 Business Partner: Partner Grouping (Target Group) GROUP_D
0 BPFTB_ALL_DI REGIO T005S Taxes: Region (Province) Key LAND1
1 BPFTB_ALL_DI STAFF_GRP TP05 Business partner: Employee group MANDT
1 BPFTB_ALL_DI STAFF_GRP TP05 Business partner: Employee group STAFF_GRP
0 BPFTB_ALL_DI STATE T005 Countries MANDT
0 BPFTB_ALL_DI STATE T005 Countries LAND1
1 BPFTB_ALL_DI SZG_AT TD05_AT_FS IS-IS: ÖNB-Target groups MANDT
1 BPFTB_ALL_DI SZG_AT TD05_AT_FS IS-IS: ÖNB-Target groups SZG_AT
0 BPFTB_ALL_DI VIP TVIP_FS Contact Person: VIP Indicator MANDT
1 BPFTB_ALL_DI XUBNAME_TR USR02 Logon Data (Kernel-Side Use) BNAME