BPFTB_ALL_DI SAP (Business partner: Treasury data in CBP) Structure details

Dictionary Type: Structure
Description: Business partner: Treasury data in CBP




ABAP Code to SELECT data from BPFTB_ALL_DI
Related tables to BPFTB_ALL_DI
Access table BPFTB_ALL_DI




Structure field list including key, data, relationships and ABAP select examples

BPFTB_ALL_DI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Business partner: Treasury data in CBP" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BPFTB_ALL_DI TYPE BPFTB_ALL_DI.

The BPFTB_ALL_DI table consists of various fields, each holding specific information or linking keys about Business partner: Treasury data in CBP data available in SAP. These include TITLE_LET_TR (Salutation (Key)), GROUP_D (Target Group), PAR_REL (Business Partner Released), VIP (Business partner: VIP partner).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP BPFTB_ALL_DI structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TITLE_LET_TRSalutation (Key) BP_TITL_LT_DICHAR2Assigned to domainCHAR2
GROUP_DTarget Group BP_GROUP_DCHAR4TP13BP_GROUP_D
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
VIPBusiness partner: VIP partner VIP_FSCHAR1TVIP_FSVIP_FS
SORT_PHONSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
VBUND_DICompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
CALENDARIDFactory calendar BP_CAL_IDCHAR2TFACDWFCID
CNTRY_COMPCountry of Organization's Registered Office BP_CNTR_HDCHAR3T005LAND1
REGIORegion of Registered Office BP_REGIO_HDCHAR3T005SREGIO
COMP_HEADRegistered Office BP_COMP_HDCHAR35TEXT35
MIN_RESERVBank Subject to Minimum Reserve Requirement BP_MIN_RSVCHAR1XFELD
BAL_SH_CURBalance Sheet Currency BP_BAL_CUR_DICHAR5Assigned to domainCHAR5
CAP_INCR_AAmount of Last Capital Increase BP_CA_IN_A_DICHAR21CHAR21
CAP_INCR_YYear of Last Capital Increase BP_CA_IN_Y_DICHAR4CHAR4
BALANCE_FLBalance Sheet Display BP_BAL_FLGCHAR1BP_BAL_FLG
BANKL_TRBank Keys BANKKCHAR15BANKKBNK
BANKS_TRBank country key BANKSCHAR3Assigned to domainLAND1BKL
STATECitizenship BP_CNTR_STCHAR3T005LAND1
PROPRTY_STMarital Property Regime BP_PROPRTY_OLD_DICHAR2Assigned to domainCHAR2
INCOME_CURCurrency of Net Income BP_INC_CUR_DICHAR5Assigned to domainCHAR5
CHILDREN_TRNumber of Children Belonging to the Business Partner BP_CHILDRN_DICHAR2CHAR2
MEM_HOUSE_TRNumber of People Living in the Household BP_MEM_HOU_DICHAR2CHAR2
NET_INCOMENet Annual Income BP_NET_INC_DICHAR21CHAR21
MO_NET_INCMonthly net income of business partner BP_MO_INC_DICHAR21CHAR21
NET_INC_YYear of Net Annual Income BP_N_INC_Y_DICHAR4CHAR4
MO_INC_MMonth of Monthly Net Income BP_M_INC_M_DICHAR2CHAR2
MO_INC_YYear of monthly net income BP_M_INC_Y_DICHAR4CHAR4
PERS_NRPersonnel Number BP_PERS_NRCHAR15CHAR15
STAFF_GRPEmployee Group BP_STAFF_GCHAR4TP05BP_STAFF_G
HR_ORG_REFHR Org. Link HR_ORG_REFCHAR1XFELD
XUBNAME_TRUser Name in User Master Record XUBNAMECHAR12USR02XUBNAMEXUS
STAFF_REFEmployee BP_STAFF_RCHAR1XFELD
DYING_PLACEName of Place of Death of Natural Person BP_DYING_PLACECHAR40BP_DYING_PLACE
BANK_DEL_DTermination Date for Business Relations with the Bank BP_BANK_DEL_D_DICHAR8CHAR8
UNW_CUSTOMERUndesirable Customer BP_UNW_CUSTOMERCHAR1XFELD
UNW_REASONReason for Undesirability BP_UNW_REASONCHAR2Assigned to domainBP_UNW_REASON
UNW_REMARKComment on Undesirability BP_UNW_REMARKCHAR35TEXT35
ADRKINDAddress Type BU_ADRKINDCHAR10Assigned to domainBU_ADRKIND
LAST_CUST_CONTDate of Last Customer Contact BP_LAST_CUST_CONTACT_DICHAR8CHAR8
.INCLU--AP 0
GROUP_FEATUREGrouping Character BP_GROUP_FEATURECHAR10Assigned to domainBP_GROUP_FEATUREBP_GROUP_FEATURE
CHIND_EDChange category BU_CHINDCHAR1BU_CHIND
EMPL_SINCEEmployed from EMPL_DATE_DICHAR8CHAR8
EMPL_UNTILEmployed Until BP_EMP_UNT_DICHAR8CHAR8
EMPLOYMENTEmployment status BP_EMPLOYM_DICHAR2CHAR2
EMP_SECTOR_ZGPIndustry sector BU_INDSECTCHAR10Assigned to domainBU_INDSECTH_TB023
EMPLOYEREmployer EMPLOYERCHAR35TEXT35
JOBGR_ZGPOccupation/group BU_JOBGRCHAR4Assigned to domainBU_JOBGR
CHIND_BYChange category BU_CHINDCHAR1BU_CHIND
BUSINESS_YFiscal Year BP_BUSIN_Y_DICHAR4CHAR4
BAL_SH_CUR_BYBalance Sheet Currency BP_BAL_CUR_DICHAR5CHAR5
GEN_MEET_DDate of Annual Stockholders Meeting BP_GE_ME_D_DICHAR8CHAR8
BU_Y_BEGINFiscal Year Start Date BP_B_Y_BEG_DICHAR8CHAR8
BU_Y_ENDFiscal Year End Date BP_B_Y_END_DICHAR8CHAR8
ANNUAL_ACCYear-End Closing BP_ANN_ACCCHAR1XFELD
ANNU_ACC_DYear-End Closing Date for Fiscal Year BP_A_ACC_D_DICHAR8CHAR8
CONS_FST_DDate of Consolidated Financial Statements of Group Company BP_C_FST_D_DICHAR8CHAR8
CAPI_STOCKAmount of Authorized Capital Stock for Company BP_CAP_STK_DICHAR21CHAR21
SHAR_STOCKAmount of Issued Stock Capital for Company BP_SHA_STK_DICHAR21CHAR21
PRSH_STOCKAmount of Participation Certificates Outstanding for Company BP_PRS_STK_DICHAR21CHAR21
EQUITYAmount of Equity Capital for Company BP_EQUITY_DICHAR21CHAR21
GROSS_AMNTGross Premium BP_GROSS_A_DICHAR21CHAR21
NET_AMOUNTNet Premium BP_NET_A_DICHAR21CHAR21
TURNOVERAmount of Annual Sales for Company BP_TURNOVR_DICHAR21CHAR21
NET_INCOME_BYAmount of Annual Net Income/Net Loss for Company BP_NET_IN_DICHAR21CHAR21
DIV_DIS_AMDividend/Profit Distribution Amount for Company BP_DIV_DIS_DICHAR21CHAR21
DEBTS_FACTDebt Ratio in Years BP_DEBTS_F_DICHAR7CHAR7
DIS_PROFITAmount of Annual Profit/Loss for Organization BP_PROFIT_DICHAR21CHAR21
BAL_AMOUNTAmount of Balance Sheet Total for Company BP_BAL_AMT_DICHAR21CHAR21
CAP_RESAmount of Capital Reserve for Company BP_CAP_RESERV_DICHAR21CHAR21
REV_RES_LEGAmount of Legal Revenue Reserves for Company BP_REVENUE_RESERV_LEG_DICHAR21CHAR21
REV_RES_OWN_SHRRevenue Reserves for Own Stock BP_REVENUE_RESERV_OWN_SHARE_DICHAR21CHAR21
REV_RES_BY_LAWSAmount of Statutory Revenue Reserve for Company BP_REVENUE_RESERV_BY_LAWS_DICHAR21CHAR21
REV_RES_OTHERSAmount of Other Revenue Reserves for Company BP_REVENUE_RESERV_OTHERS_DICHAR21CHAR21
FORW_PROFIT_LOSSAmount of Profit/Loss Carried Forward for Company BP_FORWARD_PROFIT_LOSS_DICHAR21CHAR21
LIABILIT_SECONDAmount of Subordinated Liabilities for Company BP_LIABILIT_SECOND_DICHAR21CHAR21
RET_TOT_CAP_EMPLReturn on Total Capital Employed for Company in Percent BP_RETURN_TOTAL_CAP_EMPL_DICHAR6CHAR6
REDUC_LONG_TERMDebt Clearance Period in Years BP_REDUC_LONG_TERM_DICHAR6CHAR6
COEFF_FINANCEFinancing Coefficient for Company in Percent BP_COEFF_FINANCE_DICHAR6CHAR6
EQUITY_CAPITEquity Ratio of Company in Percent BP_EQUITY_CAPIT_DICHAR6CHAR6
DE_OATHAffidavit BP_DE_OATHCHAR1XFELD
DE_OA_DDate of affidavit BP_DE_OA_D_DICHAR8CHAR8
BANKRUPLaunch Bankruptcy Proceedings BP_BANKRUPCHAR1XFELD
BNKRY_DDate of bankruptcy proceedings BP_BNKRY_D_DICHAR8CHAR8
FORECLOForeclosure BP_FORECLOCHAR1XFELD
FORCL_DDate of foreclosure BP_FORCL_D_DICHAR8CHAR8
SOLVNCYCredit Standing BP_SOLVNCYCHAR1BP_SOLVNCY
SOL_INSInstitute Providing Credit Standing Information BP_SOL_INSCHAR4Assigned to domainBP_SOL_INS
SOL_INFStatus of Credit Standing Information BP_SOL_INFCHAR1BP_SOL_INF
SOL_TXTAdditional Credit Standing Information BP_SOL_TXTCHAR50TEXT50
SOL_I_DDate of Credit Standing Information BP_SOL_I_D_DICHAR8CHAR8
RATINGRating BP_RATINGCHAR3Assigned to domainBP_RATING
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
TAX_RESTax Non-Resident Indicator BP_TAX_RESCHAR1XFELD
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
STCEGVAT Registration Number STCEGCHAR20STCEG
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
COUNTRY_TRCountry Key LAND1CHAR3Assigned to domainLAND1LND
REGION_TRSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10Assigned to domainALPHAKUNNR
NRESIDTNon-Resident According to Paragraph 4 AWG BP_NRESIDTCHAR1XFELD
NRESI_DStart of Non-Residency According to Paragraph 4 AWG BP_NRESI_D_DICHAR8CHAR8
KWG_RLVRecipient of Multimillion Loan According to Paragraph 14 GBA BP_KWG_RLVCHAR1XFELD
KWG_NRBorrower Number for Reporting a Loan According to GBA BP_KWG_NRCHAR8CHAR8
KWG_ENRBorrower Entity Number Used to Report Loan acc. to GBA BP_KWG_ENRCHAR8CHAR8
KWG_CRECredit Standing Review According to Paragraph 18 GBA BP_KWG_CRE_DICHAR2CHAR2
KWG_CRE_DDate of Credit Standing Review According to Paragraph 18 GBA BP_KWG_CRE_D_DICHAR8CHAR8
KWG_ORGLoan to Manager According to Paragraph 15 German Banking Act BP_KWG_ORG_DICHAR2CHAR2
COMP_REOrganization Relationship BP_COMP_RECHAR1BP_COMP_RE
XID_AT(OeNB) Ident Number VVXID_AT_FSCHAR11VVXID_AT_FS
SZG_ATTarget Group According to OeNB VVSZG_AT_FSCHAR2TD05_AT_FSVVSZG_AT_FS
SID_ATAssign (OeNB) Ident Number VVSID_AT_FSCHAR1BP_JANEI
SINLZ_ATInstitute Number According to OeNB VVSINLZ_ATCHAR7VVSINLZ_AT
SINME_ATInstitute Subject to Austrian Reg. Reporting Requirements VVSINME_ATCHAR1XFELD
GID_ATGroup ID VVGID_ATCHAR15
GIDTYPE_ATGroup Assignment Category VVGIDTYPE_ATCHAR1VVGIDTYPE_AT
GNAME_ATGroup Name VVGNAME_ATCHAR50TEXT50
ENT_REPOLegal Entity for Business Partner BP_ENTITY_REPORTCHAR2BP_ENTITY_REPORT
ENT_QUOTBusiness Partner Acc. to Para. 4, Sec. 2 of Asset Regulation BP_ENTITY_QUOTACHAR1BP_ENTITY_QUOTA
DEB_GROUDebtor Group According to German Law (BerVersV, Template 5) BP_DEBTOR_GROUPCHAR1BP_DEBTOR_GROUP
BUS_PURPCategory of Business Purpose BP_BUSINESS_PURPOSECHAR2BP_BUSINESS_PURPOSE
RISK_GROUPRisk Group BP_RISK_GROUPCHAR1BP_RISK_GROUP
CLASSIFICATION_DDate of Risk Grouping BP_CLASSIFICATION_D_DICHAR8CHAR8
COMBINE_TIEGroup Affiliation Exists BP_COMBINE_TIECHAR1XFELD
MFIMonetary Financial Institution BP_MFICHAR1XFELD
KWG_RELObligation to Submit to Credit Standing Review - Para.18 GBA BP_KWG_RELCHAR1XFELD
L_CREDIT_CHECKLarge-Scale Loan Monitoring According to Paragraph 13b GBA BP_LARGE_CREDIT_CHECKCHAR1XFELD
CREDITING_RELIEFCrediting Relief in Accordance with Paragraph 13/3 GBA BP_CREDITING_RELIEFCHAR1XFELD
PAR1_ABS1_RELAuthorized Acc. to Para. 2(1)18b of German Asset Regulation BP_PAR1_BAFINCHAR1XFELD
COUNTRY_KEYNumeric Code for German Federal Bank Country Indicator BP_LZB_COUNTRY_KEYCHAR4Assigned to domainBP_LZB_COUNTRY_KEY
KWG_ORG_BUKRSLoan to Manager According to Paragraph 15 German Banking Act BP_KWG_ORG_DICHAR2CHAR2
BAL_SHBalance Sheet Display BP_BAL_SHCHAR1BP_BAL_SH
COMP_RE_BUKRSCompany Relationship in Company Code BP_CCOM_RECHAR1BP_COMP_RE
.INCLU--AP 0
LIABIL_RISKType of Liability Risk BP_LIABIL_RISCCHAR2BP_LIABIL_RISC
LIABIL_RISK_AMNTAmount of Liability Risk BP_RISK_AMNT_DICHAR22CHAR22
LIABIL_RISK_CURRCurrency of Liability Risk Amount BP_RISK_CURR_DICHAR5CHAR5
LIABIL_RISK_FROMValid from Date for Liability Risk BP_LRISK_FROM_DICHAR10CHAR10
LIABIL_RISK_TOValid to Date for Liability Risk BP_LRISK_TO_DICHAR10CHAR10
PART_COPartner-Company Code Allocation BP_PART_COCHAR4Assigned to domainBUKRS
VEND_EXIndicator: Vendor Exists for Partner BP_VEND_EXCHAR1XFELD
SGRP1Group Key 1 (Freely-Definable - 3 Figure Number) VVGRP_1_DICHAR3CHAR3
SGRP2Group Key 2 (Freely-Definable - 3 Figure Number) VVGRP_2_DICHAR3CHAR3
SGRP3Group Key 3 (Freely-Definable - 3 Figure Number) VVGRP_3_DICHAR3CHAR3
SGRP4Group key 4 (freely-definable - 3 figure number) VVGRP_4_DICHAR3CHAR3
SGRP5Group key 5 (freely-definable - 3 figure number) VVGRP_5_DICHAR3CHAR3
SGRP6Group key 6 (freely-definable - 3 figure number) VVGRP_6_DICHAR3CHAR3
SGRP7Group key 7 (freely-definable - 3 figure number) VVGRP_7_DICHAR3CHAR3
SGRP8Group key 8 (freely-definable - 3 figure number) VVGRP_8_DICHAR3CHAR3
SGRP9Group key 9 (freely-definable - 3 figure number) VVGRP_9_DICHAR3CHAR3
SGRP10Group key 10 (freely-definable - 3 figure number) VVGRP10_DICHAR3CHAR3
SGRP11Group key 11 (freely-definable - 3 figure number) VVGRP11_DICHAR3CHAR3
SFRT1User-defined text (freely definable - 35 character text) VVFREI_1CHAR35TEXT35
SFRT2User-defined text (freely definable - 35 character text) VVFREI_2CHAR35TEXT35
SFRT3User-defined text (freely definable - 35 character text) VVFREI_3CHAR35TEXT35
SFRT4User-defined text (freely definable - 35 character text) VVFREI_4CHAR35TEXT35
SFRT5User-defined text (freely definable - 35 character text) VVFREI_5CHAR35TEXT35
SFRT6User-defined text (freely definable - 35 character text) VVFREI_6CHAR35TEXT35
SFRT7User-defined text (freely definable - 35 character text) VVFREI_7CHAR35TEXT35
SFRT8User-defined text (freely definable - 35 character text) VVFREI_8CHAR35TEXT35
CHIND_SI3Change category BU_CHINDCHAR1BU_CHIND
RANTYP_A3Contract Type RANTYPCHAR1RANTYP
SANLF_A3Product Category SANLF_DICHAR3CHAR3
SGSART_A3Product Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SFHAART_A3Financial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
AUTHORAuthorization indicator for Treasury product TB_AUTHORCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure BPFTB_ALL_DI using ABAP code?

As BPFTB_ALL_DI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BPFTB_ALL_DI as there is no data to select.

How to access SAP table BPFTB_ALL_DI

Within an ECC or HANA version of SAP you can also view further information about BPFTB_ALL_DI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!