SAP ABAP Table FTRS_VTBFHAPO (Structure for Financial Transaction Flows (Without Key))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FTA (Package) R/3 appl. development for Treasury money,forex,forward gen
Basic Data
Table Category INTTAB    Structure 
Structure FTRS_VTBFHAPO   Table Relationship Diagram
Short Description Structure for Financial Transaction Flows (Without Key)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 CRUSER TB_CRUSER SYCHAR12 CHAR 12   0   Entered by  
2 UPUSER TB_UPUSER SYCHAR12 CHAR 12   0   Last Changed by  
3 DUPDAT TB_DUPDAT DATUM DATS 8   0   Changed on  
4 TUPTIM TB_TUPTIM UZEIT TIMS 6   0   Time changed  
5 RANTYP RANTYP RANTYP CHAR 1   0   Contract Type  
6 SFHAZBA TB_SFHAZBA SBEWART CHAR 4   0   Flow Type TZB0A
7 SBKKLAS TB_SBKKLAS T_SBKKLAS CHAR 1   0   Classification of flows and conditions  
8 SBKTYP TB_SBKTYP T_SBKTYP CHAR 2   0   Category of Flows and Conditions AT07
9 SBERFIMA SBEWFIMA SBEWFIMA CHAR 4   0   Calculation category for cash flow calculator AT40
10 SSIGN TB_SSIGN T_SSIGN CHAR 1   0   Direction of flow  
11 SHERKUNFT TB_SHERK T_XFELD04 CHAR 4   0   Display Area of Flow or Condition  
12 SABVERF TB_SABVERF T_SABVERF CHAR 5   0   Procedure to Generate Derived Flows AT22
13 RKONDGR TB_RKONDGR T_RKONDGR NUMC 1   0   Direction of Transaction  
14 RKOND TB_KOND T_KOND NUMC 4   0   Condition  
15 DGUEL_KP DGUEL_KP DATUM DATS 8   0   Condition Item Valid From  
16 NSTUFE NSTUFE NUMC2 NUMC 2   0   Level number of condition item for recurring payments  
17 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) TZK01
18 RREFKONT RREFKONT_OBSOLETE USTRU CHAR 8   0   Obsolete: Accnt Assignment Ref. in Fin. Assets Management T037S
19 SBZVABW TB_SBZVABW XFELD CHAR 1   0   Alternative payment details stated in flow  
20 RAHABKI TB_RHABKI HBKID CHAR 5   0   Short key for own house bank T012
21 RAHKTID TB_RHKTID HKTID CHAR 5   0   Short key for house bank account T012K
22 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee *
23 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
24 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
25 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
26 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
27 SPAYRQ TB_SPAYRQK XFELD CHAR 1   0   Generate payment request  
28 SPRSNG TB_SPRSNGK XFELD CHAR 1   0   Individual payment  
29 SPRGRD TB_SPRGRD T_SPRGRD CHAR 1   0   Determine grouping definition  
30 SCSPAY TB_SCSPAY XFELD CHAR 1   0   Same direction necessary for joint payment?  
31 ZWELS DZWELS ZWELS CHAR 10   0   List of the Payment Methods to be Considered  
32 PAYGR PAYGR CHAR20 CHAR 20   0   Grouping Field for Automatic Payments  
33 SBEWEBE TB_SBEWEBE T_SBEWEBE CHAR 1   0   Posting Status of Flow  
34 SSPRGRD TB_SSPRGRD T_SSPRGRD NUMC 1   0   Reason Why Flow Is Blocked for Posting  
35 SBFREI TB_SBFREI XFELD CHAR 1   0   Release Given for Flow to Be Posted?  
36 SSTORNOBWG TB_SBWGSTO XFELD CHAR 1   0   Flow reversal in Treasury  
37 PRKEY PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
38 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
39 BELNR2 TB_BELNR2 BELNR CHAR 10   0   Doc. no. of a second accounting doc. for currency swap  
40 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
41 DBUCHUNG BUDAT DATUM DATS 8   0   Posting Date in the Document  
42 DFAELL TB_DFAELL DATUM DATS 8   0   Due date  
43 DZTERM TB_DZTERM DATUM DATS 8   0   Payment or Delivery Date  
44 BZBETR TB_BZBETR WERTV7 CURR 13   2   Payment amount in payment currency  
45 WZBETR TB_WZBETR WAERS CUKY 5   0   Payment Currency TCURC
46 BHWBETR TB_HWBETR WERTV7 CURR 13   2   Payment Amount in Local Currency  
47 KHWKURS TB_KHWKURS UKURS DEC 9   5   Local currency rate  
48 ASTUECK TB_ASTUECK ASTUECK DEC 15   5   No. of Units for Financial Instruments  
49 BPRICE TB_BPRICE WERTV7 CURR 13   2   Price per unit  
50 WPRICE TB_WPRICE WAERS CUKY 5   0   Price currency TCURC
51 BHWPREIS TB_HWPREIS WERTV7 CURR 13   2   Price in local currency  
52 BINDEX TB_BINDEX BWHR CURR 13   2   Value of a point  
53 VVBASIS TB_VVBASIS T_PKTKUR DEC 11   6   Price in points  
54 PWKURS TB_PWKURS DEC3_7 DEC 10   7   Price as percentage quotation  
55 PRKKURS TI_PRKUR TB_KKURS DEC 13   9   Currency option premium with price in points  
56 BNWHR TB_BNWHR WERTV7 CURR 13   2   Nominal amount  
57 RHANDPL VVRHANDPL VVRHANDPL CHAR 10   0   Exchange TWH01
58 SKURSART TI_KURSART VVSKURSART CHAR 2   0   Rate/Price Type - Treasury Instruments TW56
59 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
60 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
61 ATAGE VVATAGE INT6 NUMC 6   0   Number of days  
62 ABASTAGE ABASTAGE INT6 NUMC 6   0   Number of base days in a calculation period  
63 PKOND PKOND DECV3_7 DEC 10   7   Percentage rate for condition items  
64 DPKOND VVDPKOND DATUM DATS 8   0   Determination date for percentage rate of condition items  
65 DZFEST TB_DZFEST DATUM DATS 8   0   Interest rate fixing date  
66 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
67 SKALIDWT TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
68 BBASIS BBASIS WERTV7 CURR 13   2   Calculation base amount  
69 WBASIS TB_WBASIS WAERS CUKY 5   0   Currency of calculation basis TCURC
70 JEXPOZINS TB_JZINSRE XFELD CHAR 1   0   Exponential Interest Calculation  
71 SINCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
72 SINCLBIS VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
73 SULTBIS VVSULTBIS VVSULT CHAR 1   0   Month-End Indicator for the End of a Calculation Period  
74 SEXCLVON VVSEXCLVON VVSEXCLVON NUMC 1   0   Exclusive Indicator for the Start of a Calculation Period  
75 SULTVON VVSULTVON VVSULT CHAR 1   0   Month-End Indicator for Start of a Calculation Period  
76 SAEND TFM_SAEND TFM_SAEND NUMC 1   0   Change Indicator for FiMa Flow Records  
77 DVALUT DVALUT DATUM DATS 8   0   Calculation Date  
78 SVINCL VVSVINCL VVSINCL NUMC 1   0   Inclusive indicator for value date  
79 SVULT VVSVULT VVSULT CHAR 1   0   Month-End Indicator for Value Date  
80 JSOFVERR TFMSOFVERR TFMSOFVERR CHAR 1   0   Indicator for Immediate Settlement (Financial Mathematics)  
81 DVERRECH VVDVERRECH DATUM DATS 8   0   Settlement date  
82 SINCLVERR VVSINCLVER VVSINCLVER NUMC 1   0   Inclusive Indicator for Clearing Date  
83 SULTVERR VVSULTVERR VVSULT CHAR 1   0   Month-End Indicator for Clearing Date  
84 SSTORNOMAN TB_SBWGSTM T_SBWGSTM CHAR 1   0   Manual reversal of flows posted in FI  
85 SSTORNOART TB_SSTOART T_SSTOART CHAR 2   0   Type of manual reversal of flows posted in FI AT90
86 SBWGARTREF TB_SBWGREF SBEWART CHAR 4   0   Referenced flow type TZB0A
87 SKHWFIX TB_SKHWFIX T_SKHWFIX CHAR 1   0   Indicator for translation into local currency  
88 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
89 RLDEPO RLDEPO RLDEPO CHAR 10   0   Securities Account *
90 RANL VVRANLW WP_RANL CHAR 13   0   Security ID Number *
91 RTRBELNR TPM_DEDOC_RDOCNRINT TPM_DEDOC_RDOCNRINT CHAR 15   0   Internal document number of derivatives document  
92 BUPRC TB_BUPRC VVPKTKUR DEC 15   6   Security Price Without Currency Ref. with Unit Quotation  
93 BPPRC TB_BPPRC VVPKTKUR DEC 15   6   Security Price for Percentage Quotation  
94 WBBETR TB_WBBETR WAERS CUKY 5   0   Currency of Position Amount *
95 BBBETR TB_BBBETR WERTV7 CURR 13   2   Amount that Changes the Position  
96 WEBETR TB_WEBETR WAERS CUKY 5   0   Price currency *
97 BEBETR TB_BEBETR WERTV7 CURR 13   2   Market Value in Quotation Currency  
98 SRUNIT TB_RUNIT VVSRUNIT CHAR 5   0   Currency unit of rate TZUNI
99 KZWKURS TB_KZWKURS UKURS DEC 9   5   Payment currency rate  
100 KBWKURS TB_KBWKURS UKURS DEC 9   5   Position currency rate  
101 WSBETR TB_WFROM WAERS CUKY 5   0   Currency Key for Currency Conversion: Source Currency *
102 DBESTAND TB_DBESTAND DATUM DATS 8   0   Position Value Date  
103 SSTCKKZ SSTCKKZ SSTCKKZ CHAR 1   0   Accrued interest method  
104 SSTCKTG SSTCKTG SZBMETH CHAR 1   0   Accrued interest: Daily method  
105 SFLAT VVSFLAT XFELD CHAR 1   0   Indicator 'Traded flat',i.e.no accrued interest calculation  
106 SCOUPON VVSCOUPON VVSCOUPON CHAR 1   0   Coupon ID for interest and accrued interest calculation  
107 DCOUPON VVDCOUPON DATUM DATS 8   0   Coupon date of next delivered coupon  
108 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
109 INDEX_VALUE TIDX_INDEX_VALUE_NO_RATIO TIDX_INDEX_VALUE_NO_RATIO DEC 18   12   Index Value (Independent of Basis)  
110 SBASIS SBASIS VVSBASIS CHAR 4   0   Calculation base indicator *
111 REGI_STATE TB_IRA_REGISTRATION_STATE T_IRA_REGISTRATION_STATE CHAR 2   0   Status of Interest Rate Adjustment  
112 RPCODE RPCODE RPCODE CHAR 20   0   Repetitive Code *
113 RP_TEXT RPCODE_TEXT XTEXT50 CHAR 50   0   Reference Text for Repetitive Code  
114 HEDGE_ID TPM_HEDGE_ID   CHAR 10   0   Identification for Hedging Relationship  
115 DBPERIOD VVDBPERIOD DATUM DATS 8   0   Period start  
116 SPAEXCL TFMSPAEXCL TFMSPAEXCL NUMC 1   0   Exclusive Indicator for Start Date of a Period  
117 SPAULT TFMSPAULT VVSULT CHAR 1   0   Month-End Indicator for Start Date of a Period  
118 DEPERIOD VVDEPERIOD DATUM DATS 8   0   Period End  
119 SPEINCL TFMSPEINCL TFMSPEINCL NUMC 1   0   Inclusive Indicator for End Date of a Period  
120 SPEULT TFMSPEULT VVSULT CHAR 1   0   Month-End Indicator for End of a Period  
121 AMMRHY AMMRHY NUMC03 NUMC 3   0   Frequency in months  
122 PPAYMENT TFM_PPAYMENT TFM_PPAYMENT DEC 11   7   Payment Rate  
123 AMMRHYZV TFM_AMMRHYZV TFM_AMMRHYZV NUMC 2   0   Interest Settlement Frequency for Exponential Interest Calc.  
124 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
125 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
126 BDIRTY TB_BDIRTY WERTV7 CURR 13   2   Dirty Price  
127 BAMOUNTCOMP TB_AMOUNTCOMP WERTV7 CURR 13   2   Amount to be Capitalized  
128 NOMINAL_ORG_AMT TB_BNWHR_ORG WERTV7 CURR 13   2   Orignal Nominal Amount  
129 NOM_FACTOR RDPT_FACTOR_VAL   DEC 12   9   Factor  
130 RLDEPO2 VRLDEPO RLDEPO CHAR 10   0   Securities Account *
131 INDEX_PRICE TB_INDEX_PRICE CHAR1 CHAR 1   0   Indicator for Security Price Including Index Value  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTRS_VTBFHAPO LANDL T005 LAND1    
2 FTRS_VTBFHAPO LZBKZ T015L LZBKZ    
3 FTRS_VTBFHAPO RAHABKI T012 HBKID KEY 1 CN
4 FTRS_VTBFHAPO RAHKTID T012K HKTID KEY 1 CN
5 FTRS_VTBFHAPO RHANDPL TWH01 RHANDPL KEY 1 CN
6 FTRS_VTBFHAPO RREFKONT T037S RREFKONT KEY 1 CN
7 FTRS_VTBFHAPO SABVERF AT22 SABVERF C CN
8 FTRS_VTBFHAPO SBERFIMA AT40 SBERFIMA    
9 FTRS_VTBFHAPO SBKTYP AT07 SBKTYP KEY 1 CN
10 FTRS_VTBFHAPO SBWGARTREF TZB0A SBEWART REF C CN
11 FTRS_VTBFHAPO SFHAZBA TZB0A SBEWART KEY 1 CN
12 FTRS_VTBFHAPO SKOART TZK01 SKOART KEY 1 CN
13 FTRS_VTBFHAPO SKURSART TW56 SKURSART KEY 1 CN
14 FTRS_VTBFHAPO SRUNIT TZUNI SRUNIT    
15 FTRS_VTBFHAPO SSTORNOART AT90 SSTORNOART KEY 1 CN
16 FTRS_VTBFHAPO UZAWE T042F UZAWE KEY 1 CN
17 FTRS_VTBFHAPO WBASIS TCURC WAERS KEY 1 CN
18 FTRS_VTBFHAPO WPRICE TCURC WAERS KEY 1 CN
19 FTRS_VTBFHAPO WZBETR TCURC WAERS KEY 1 CN
20 FTRS_VTBFHAPO ZLSCH T042Z ZLSCH KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 462_10