SAP ABAP View VW_VTBFHA (Group of Tables: VTBFHA, VTBFHAZU, VTBFHAPO)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FVVW (Package) Treasury Management: Securities
Basic Data
View Type D Database View 
Database View VW_VTBFHA  
Short Description Group of Tables: VTBFHA, VTBFHAZU, VTBFHAPO    
Root table VTBFHA   Transaction 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VTBFHA VTBFHA
2 VTBFHAZU  
3 VTBFHAPO  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VTBFHA MANDT JL EQ 0 0
2 VTBFHAZU MANDT JR EQ AND 0 0
3 VTBFHA BUKRS JL EQ 0 0
4 VTBFHAZU BUKRS JR EQ AND 0 0
5 VTBFHA RFHA JL EQ 0 0
6 VTBFHAZU RFHA JR EQ AND 0 0
7 VTBFHAZU MANDT JL EQ 0 0
8 VTBFHAPO MANDT JR EQ AND 0 0
9 VTBFHAZU BUKRS JL EQ 0 0
10 VTBFHAPO BUKRS JR EQ AND 0 0
11 VTBFHAZU RFHA JL EQ 0 0
12 VTBFHAPO RFHA JR EQ AND 0 0
13 VTBFHAZU RFHAZU JL EQ 0 0
14 VTBFHAPO RFHAZU JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VTBFHA MANDT   MANDT Client
2 BUKRS VTBFHA BUKRS   BUKRS Company Code
3 RFHA VTBFHA RFHA   TB_RFHA Financial Transaction
4 RFHAZU VTBFHAZU RFHAZU   TB_RFHAZU Transaction activity
5 DCRDAT VTBFHAPO DCRDAT   TB_CRDAT Entered On
6 TCRTIM VTBFHAPO TCRTIM   TB_TCRTIM Entry Time
7 RFHAZB VTBFHAPO RFHAZB   TB_RFHAZB Transaction flow
8 CRUSER_VTBFHA VTBFHA CRUSER   TB_CRUSER Entered by
9 DCRDAT_VTBFHA VTBFHA DCRDAT   TB_DCRDAT Entered On
10 TCRTIM_VTBFHA VTBFHA TCRTIM   TB_TCRTIM Entry Time
11 UPUSER_VTBFHA VTBFHA UPUSER   TB_UPUSER Last Changed by
12 DUPDAT_VTBFHA VTBFHA DUPDAT   TB_DUPDAT Changed on
13 TUPTIM_VTBFHA VTBFHA TUPTIM   TB_TUPTIM Time changed
14 RANTYP_VTBFHA VTBFHA RANTYP   RANTYP Contract Type
15 SANLF VTBFHA SANLF   SANLF Product Category
16 SFGTYP VTBFHA SFGTYP   TB_SFGTYP Transaction Category
17 SGSART_VTBFHA VTBFHA SGSART   VVSART Product Type
18 SFHAART_VTBFHA VTBFHA SFHAART   TB_SFHAART Financial Transaction Type
19 RGATT VTBFHA RGATT   TI_RGATT Class
20 RMAID VTBFHA RMAID   TB_RMAID Master Agreement
21 RFHAZUNR VTBFHA RFHAZUNR   TB_RFHAZUN Number status of activity
22 RFHAZUL VTBFHA RFHAZUL   TB_RFHAZUL Last Active Transaction Activity
23 SAKTIV_VTBFHA VTBFHA SAKTIV   TB_SAKTIV Active Status of Transaction or Activity
24 KONTRH VTBFHA KONTRH   TB_KUNNR_NEW Business Partner Number
25 SROLEXT VTBFHA SROLEXT   CHAR3 3-Byte field
26 RGARANT VTBFHA RGARANT   TB_RGARANT_NEW Guarantor of Financial Transaction
27 RREFKONT_HA VTBFHA RREFKONT   RREFKONT_OBSOLETE Obsolete: Accnt Assignment Ref. in Fin. Assets Management
28 RREFKONT2 VTBFHA RREFKONT2   RREFKONT_OBSOLETE Obsolete: Accnt Assignment Ref. in Fin. Assets Management
29 RPORTB VTBFHA RPORTB   RPORTB Portfolio
30 WGSCHFT VTBFHA WGSCHFT   TB_WGSCHFT Currency of transaction
31 WGSCHFT1 VTBFHA WGSCHFT1   TB_WGSCHF1 Currency of Outgoing Side
32 WGSCHFT2 VTBFHA WGSCHFT2   TB_WGSCHF2 Currency of Incoming Side
33 AMTINPUT VTBFHA AMTINPUT   TB_AMTIN Note field for traded amount forex transactions
34 DBLFZ_VTBFHA VTBFHA DBLFZ   TB_DBLFZ Term Start
35 SKALID VTBFHA SKALID   SKALID Factory calendar
36 SKALID2 VTBFHA SKALID2   SKALID Factory calendar
37 JLIMIT VTBFHA JLIMIT   TB_JLIMIT Limit indicator
38 AKUEND VTBFHA AKUEND   TB_AKUEND Period of Notice
39 SKUEND VTBFHA SKUEND   TB_SKUEND Unit of Period of Notice
40 OBJNR VTBFHA OBJNR   J_OBJNR Object number
41 RLDEPO_VTBFHA VTBFHA RLDEPO   VRLDEPO Securities Account
42 ZUONR_VTBFHA VTBFHA ZUONR   TB_TFPROJ Finance Project
43 DELFZ_VTBFHA VTBFHA DELFZ   TB_DELFZ Term End
44 ABWTYP VTBFHA ABWTYP   TB_ABWTYP Processing Category
45 TBEGRU VTBFHA TBEGRU   TBEGRU Authorization Group
46 VRFHA VTBFHA VRFHA   TB_VORFHA Reference transaction (Rollover/premature settlement)
47 SINCLBE VTBFHA SINCLBE   TB_SINCLBE Calculation Period: Start Inclusive vs. End Inclusive
48 SNPVCAL VTBFHA SNPVCAL   TB_SNPVCAL NPV Calculation
49 SRNDNG VTBFHA SRNDNG   TB_SRNDNG Rounding of Amount from Generated Flows
50 ZUOND VTBFHA ZUOND   TB_ZUOND Assignment
51 REFER VTBFHA REFER   TB_REFER Internal Reference
52 MERKM VTBFHA MERKM   TB_MERKM Characteristics
53 SFRGZUST VTBFHA SFRGZUST   TB_FRGZUST Transaction Release: Release Status
54 RANL_VTBFHA VTBFHA RANL   VVRANLW Security ID Number
55 RCOMVALCL VTBFHA RCOMVALCL   TPM_COM_VAL_CLASS General Valuation Class
56 POSACC VTBFHA POSACC   TPM_POS_ACCOUNT_FUT Futures Account for Listed Options and Futures
57 CRUSER_VTBFHAZU VTBFHAZU CRUSER   TB_CRUSER Entered by
58 DCRDAT_VTBFHAZU VTBFHAZU DCRDAT   TB_DCRDAT Entered On
59 TCRTIM_VTBFHAZU VTBFHAZU TCRTIM   TB_TCRTIM Entry Time
60 UPUSER_VTBFHAZU VTBFHAZU UPUSER   TB_UPUSER Last Changed by
61 DUPDAT_VTBFHAZU VTBFHAZU DUPDAT   TB_DUPDAT Changed on
62 TUPTIM_VTBFHAZU VTBFHAZU TUPTIM   TB_TUPTIM Time changed
63 SGSART_VTBFHAZU VTBFHAZU SGSART   VVSART Product Type
64 SFHAART_VTBFHAZU VTBFHAZU SFHAART   TB_SFHAART Financial Transaction Type
65 SFGZUSTT VTBFHAZU SFGZUSTT   TB_SFGZUTY Transaction Activity Category
66 SFUNKTV VTBFHAZU SFUNKTV   TB_SFUNKTV Transition Function from Directly Preceding Activity
67 SFUNKTL VTBFHAZU SFUNKTL   TB_SFUNKTL Latest function used in editing activity
68 ROFHAZU VTBFHAZU ROFHAZU   TB_ROFHAZU Previous Activity
69 RFHAZUX VTBFHAZU RFHAZUX   TB_RFHAZUX Previous activity, which is supplemented by current activity
70 SAKTIV_VTBFHAZU VTBFHAZU SAKTIV   TB_SAKTIV Active Status of Transaction or Activity
71 SSTOGRD VTBFHAZU SSTOGRD   SSTOGRD Reason for Reversal
72 RDEALER VTBFHAZU RDEALER   RDEALER Trader
73 DVTRAB VTBFHAZU DVTRAB   TB_DVTRAB Contract Conclusion Date
74 TVTRAB VTBFHAZU TVTRAB   TB_TVTRAB Time of contract conclusion
75 GSPPART VTBFHAZU GSPPART   TB_GSPPART Contact Person
76 XAKT VTBFHAZU XAKT   XAKT File Number
77 NORDEXT VTBFHAZU NORDEXT   TB_NORDEXT External Reference
78 DBLFZ_VTBFHAZU VTBFHAZU DBLFZ   TB_DBLFZ Term Start
79 DELFZ_VTBFHAZU VTBFHAZU DELFZ   TB_DELFZ Term End
80 DFIX VTBFHAZU DFIX   TB_DFIX Fixing date
81 SINCLE VTBFHAZU SINCLE   TB_SINCLE End of Term Inclusive Indicator
82 DZSTND VTBFHAZU DZSTND   TB_DZSTND Last activity transition date (e.g. for rollover)
83 SZNSPRO VTBFHAZU SZNSPRO   TB_SZNSPRO Interest Handling with Rollover
84 DZNSSTD VTBFHAZU DZNSSTD   TB_DZNSSTD Payment date for deferred interest
85 KKURS VTBFHAZU KKURS   TB_KKURS Rate of Forex Transaction
86 KKASSA VTBFHAZU KKASSA   TB_KKASSA Spot Rate
87 KSWAP VTBFHAZU KSWAP   TB_KSWAP Swap Rate
88 WLWAERS VTBFHAZU WLWAERS   TB_WLWAERS Leading currency
89 WFWAERS VTBFHAZU WFWAERS   TB_WFWAERS Following Currency
90 LIMITART VTBFHAZU LIMITART   TB_LIMITAR Limit type
91 LIMITDAT VTBFHAZU LIMITDAT   TB_LIMITDA Limit date
92 RKONDGR_VTBFHAZU VTBFHAZU RKONDGR   TB_RKONDGR Direction of Transaction
93 LIWAERS VTBFHAZU LIWAERS   TB_LIWAERS Reference currency for limit
94 KWLIQUI VTBFHAZU KWLIQUI   TX_KWLIQ Liquidity effect for rollover
95 SCONFIRM VTBFHAZU SCONFIRM   TB_CONF Confirmation Status
96 DEXDAT VTBFHAZU DEXDAT   TB_DCONF Confirmation Date
97 UEXNAM VTBFHAZU UEXNAM   TB_UCONF Confirmation Executed By (User Responsible)
98 SRECONFIRM VTBFHAZU SRECONFIRM   TB_RECONF Counterconfirmation
99 DREDAT VTBFHAZU DREDAT   TB_DREDAT Counterconfirmation Date
100 URENAM VTBFHAZU URENAM   TB_URENAM Counterconfirmation Executed by (User Responsible)
101 DORDER VTBFHAZU DORDER   TB_DORDER Order date
102 DANST VTBFHAZU DANST   TB_DANST Reservation date
103 TANST VTBFHAZU TANST   TB_TANST Order time of day
104 SANST VTBFHAZU SANST   TB_SANST Reservation Reason
105 SSPESEN VTBFHAZU SSPESEN   TB_SPESEN Expenses key
106 BUPRCLIM VTBFHAZU BUPRCLIM   TB_BUPRCLIM Limit Price for Unit Quotation
107 SRUNITLIM VTBFHAZU SRUNITLIM   TB_RUNIT Currency unit of rate
108 BPPRCLIM VTBFHAZU BPPRCLIM   TB_BPPRCLIM Limit Price for Percentage Quotation
109 JVERK6B VTBFHAZU JVERK6B   TB_VERK6B Flag for sale from §6b - position
110 PEFFZINS VTBFHAZU PEFFZINS   TB_PYIELD Effective Interest Rate
111 PEFFZCALL VTBFHAZU PEFFZCALL   TB_PYIELDCALL Effective interest rate - termination of issuer
112 SEFFMETH VTBFHAZU SEFFMETH   SEFFMETH Effective Interest Method (Financial Mathematics)
113 CRUSER_VTBFHAPO VTBFHAPO CRUSER   TB_CRUSER Entered by
114 UPUSER_VTBFHAPO VTBFHAPO UPUSER   TB_UPUSER Last Changed by
115 DUPDAT_VTBFHAPO VTBFHAPO DUPDAT   TB_DUPDAT Changed on
116 TUPTIM_VTBFHAPO VTBFHAPO TUPTIM   TB_TUPTIM Time changed
117 RANTYP_VTBFHAPO VTBFHAPO RANTYP   RANTYP Contract Type
118 SFHAZBA VTBFHAPO SFHAZBA   TB_SFHAZBA Flow Type
119 SBKKLAS VTBFHAPO SBKKLAS   TB_SBKKLAS Classification of flows and conditions
120 SBKTYP VTBFHAPO SBKTYP   TB_SBKTYP Category of Flows and Conditions
121 SBERFIMA VTBFHAPO SBERFIMA   SBEWFIMA Calculation category for cash flow calculator
122 SSIGN VTBFHAPO SSIGN   TB_SSIGN Direction of flow
123 SHERKUNFT VTBFHAPO SHERKUNFT   TB_SHERK Display Area of Flow or Condition
124 SABVERF VTBFHAPO SABVERF   TB_SABVERF Procedure to Generate Derived Flows
125 RKONDGR_VTBFHAPO VTBFHAPO RKONDGR   TB_RKONDGR Direction of Transaction
126 RKOND VTBFHAPO RKOND   TB_KOND Condition
127 DGUEL_KP VTBFHAPO DGUEL_KP   DGUEL_KP Condition Item Valid From
128 NSTUFE VTBFHAPO NSTUFE   NSTUFE Level number of condition item for recurring payments
129 SKOART VTBFHAPO SKOART   SKOART Condition Type (Smallest Subdivision of Condition Records)
130 RREFKONT_HAPO VTBFHAPO RREFKONT   RREFKONT_OBSOLETE Obsolete: Accnt Assignment Ref. in Fin. Assets Management
131 SBZVABW VTBFHAPO SBZVABW   TB_SBZVABW Alternative payment details stated in flow
132 RAHABKI VTBFHAPO RAHABKI   TB_RHABKI Short key for own house bank
133 RAHKTID VTBFHAPO RAHKTID   TB_RHKTID Short key for house bank account
134 RPZAHL VTBFHAPO RPZAHL   TB_RPZAHL_NEW Payer/payee
135 RPBANK VTBFHAPO RPBANK   TB_RPBANK Partner bank details
136 SZART VTBFHAPO SZART   TB_SZART Payment transaction
137 ZLSCH VTBFHAPO ZLSCH   DZLSCH Payment method
138 UZAWE VTBFHAPO UZAWE   UZAWE Payment method supplement
139 SPAYRQ VTBFHAPO SPAYRQ   TB_SPAYRQK Generate payment request
140 SPRSNG VTBFHAPO SPRSNG   TB_SPRSNGK Individual payment
141 SPRGRD VTBFHAPO SPRGRD   TB_SPRGRD Determine grouping definition
142 SCSPAY VTBFHAPO SCSPAY   TB_SCSPAY Same direction necessary for joint payment?
143 ZWELS VTBFHAPO ZWELS   DZWELS List of the Payment Methods to be Considered
144 PAYGR VTBFHAPO PAYGR   PAYGR Grouping Field for Automatic Payments
145 SBEWEBE VTBFHAPO SBEWEBE   TB_SBEWEBE Posting Status of Flow
146 SSPRGRD VTBFHAPO SSPRGRD   TB_SSPRGRD Reason Why Flow Is Blocked for Posting
147 SBFREI VTBFHAPO SBFREI   TB_SBFREI Release Given for Flow to Be Posted?
148 SSTORNOBWG VTBFHAPO SSTORNOBWG   TB_SBWGSTO Flow reversal in Treasury
149 PRKEY VTBFHAPO PRKEY   PRQ_KEYNO Key Number for Payment Request
150 BELNR VTBFHAPO BELNR   BELNR_D Accounting Document Number
151 GJAHR VTBFHAPO GJAHR   GJAHR Fiscal Year
152 DBUCHUNG VTBFHAPO DBUCHUNG   BUDAT Posting Date in the Document
153 DFAELL VTBFHAPO DFAELL   TB_DFAELL Due date
154 DZTERM VTBFHAPO DZTERM   TB_DZTERM Payment or Delivery Date
155 BZBETR VTBFHAPO BZBETR   TB_BZBETR Payment amount in payment currency
156 WZBETR VTBFHAPO WZBETR   TB_WZBETR Payment Currency
157 BHWBETR VTBFHAPO BHWBETR   TB_HWBETR Payment Amount in Local Currency
158 KHWKURS VTBFHAPO KHWKURS   TB_KHWKURS Local currency rate
159 ASTUECK VTBFHAPO ASTUECK   TB_ASTUECK No. of Units for Financial Instruments
160 BPRICE VTBFHAPO BPRICE   TB_BPRICE Price per unit
161 WPRICE VTBFHAPO WPRICE   TB_WPRICE Price currency
162 BHWPREIS VTBFHAPO BHWPREIS   TB_HWPREIS Price in local currency
163 BINDEX VTBFHAPO BINDEX   TB_BINDEX Value of a point
164 VVBASIS VTBFHAPO VVBASIS   TB_VVBASIS Price in points
165 PWKURS VTBFHAPO PWKURS   TB_PWKURS Price as percentage quotation
166 PRKKURS VTBFHAPO PRKKURS   TI_PRKUR Currency option premium with price in points
167 BNWHR VTBFHAPO BNWHR   TB_BNWHR Nominal amount
168 RHANDPL VTBFHAPO RHANDPL   VVRHANDPL Exchange
169 SKURSART VTBFHAPO SKURSART   TI_KURSART Rate/Price Type - Treasury Instruments
170 DBERVON VTBFHAPO DBERVON   DBERVON Start of Calculation Period
171 DBERBIS VTBFHAPO DBERBIS   DBERBIS End of Calculation Period
172 ATAGE VTBFHAPO ATAGE   VVATAGE Number of days
173 ABASTAGE VTBFHAPO ABASTAGE   ABASTAGE Number of base days in a calculation period
174 PKOND VTBFHAPO PKOND   PKOND Percentage rate for condition items
175 DPKOND VTBFHAPO DPKOND   VVDPKOND Determination date for percentage rate of condition items
176 DZFEST VTBFHAPO DZFEST   TB_DZFEST Interest rate fixing date
177 SZBMETH VTBFHAPO SZBMETH   SZBMETH Interest Calculation Method
178 BBASIS VTBFHAPO BBASIS   BBASIS Calculation base amount
179 WBASIS VTBFHAPO WBASIS   TB_WBASIS Currency of calculation basis
180 JEXPOZINS VTBFHAPO JEXPOZINS   TB_JZINSRE Exponential Interest Calculation
181 SINCL VTBFHAPO SINCL   VVSINCL Inclusive indicator for beginning and end of a period
182 SINCLBIS VTBFHAPO SINCLBIS   VVSINCLBIS Inclusive Indicator for the End of a Calculation Period
183 SULTBIS VTBFHAPO SULTBIS   VVSULTBIS Month-End Indicator for the End of a Calculation Period
184 SEXCLVON VTBFHAPO SEXCLVON   VVSEXCLVON Exclusive Indicator for the Start of a Calculation Period
185 SULTVON VTBFHAPO SULTVON   VVSULTVON Month-End Indicator for Start of a Calculation Period
186 SAEND VTBFHAPO SAEND   TFM_SAEND Change Indicator for FiMa Flow Records
187 DVALUT VTBFHAPO DVALUT   DVALUT Calculation Date
188 SVINCL VTBFHAPO SVINCL   VVSVINCL Inclusive indicator for value date
189 SVULT VTBFHAPO SVULT   VVSVULT Month-End Indicator for Value Date
190 JSOFVERR VTBFHAPO JSOFVERR   TFMSOFVERR Indicator for Immediate Settlement (Financial Mathematics)
191 DVERRECH VTBFHAPO DVERRECH   VVDVERRECH Settlement date
192 SINCLVERR VTBFHAPO SINCLVERR   VVSINCLVER Inclusive Indicator for Clearing Date
193 SULTVERR VTBFHAPO SULTVERR   VVSULTVERR Month-End Indicator for Clearing Date
194 SSTORNOMAN VTBFHAPO SSTORNOMAN   TB_SBWGSTM Manual reversal of flows posted in FI
195 SSTORNOART VTBFHAPO SSTORNOART   TB_SSTOART Type of manual reversal of flows posted in FI
196 SBWGARTREF VTBFHAPO SBWGARTREF   TB_SBWGREF Referenced flow type
197 SKHWFIX VTBFHAPO SKHWFIX   TB_SKHWFIX Indicator for translation into local currency
198 ZUONR_VTBFHAPO VTBFHAPO ZUONR   DZUONR Assignment number
199 RLDEPO_VTBFHAPO VTBFHAPO RLDEPO   RLDEPO Securities Account
200 RANL_VTBFHAPO VTBFHAPO RANL   VVRANLW Security ID Number
201 RTRBELNR VTBFHAPO RTRBELNR   TPM_DEDOC_RDOCNRINT Internal document number of derivatives document
202 BUPRC VTBFHAPO BUPRC   TB_BUPRC Security Price Without Currency Ref. with Unit Quotation
203 BPPRC VTBFHAPO BPPRC   TB_BPPRC Security Price for Percentage Quotation
204 WBBETR VTBFHAPO WBBETR   TB_WBBETR Currency of Position Amount
205 BBBETR VTBFHAPO BBBETR   TB_BBBETR Amount that Changes the Position
206 WEBETR VTBFHAPO WEBETR   TB_WEBETR Price currency
207 BEBETR VTBFHAPO BEBETR   TB_BEBETR Market Value in Quotation Currency
208 SRUNIT VTBFHAPO SRUNIT   TB_RUNIT Currency unit of rate
209 KZWKURS VTBFHAPO KZWKURS   TB_KZWKURS Payment currency rate
210 KBWKURS VTBFHAPO KBWKURS   TB_KBWKURS Position currency rate
211 WSBETR VTBFHAPO WSBETR   TB_WFROM Currency Key for Currency Conversion: Source Currency
212 DBESTAND VTBFHAPO DBESTAND   TB_DBESTAND Position Value Date
213 SSTCKKZ VTBFHAPO SSTCKKZ   SSTCKKZ Accrued interest method
214 SSTCKTG VTBFHAPO SSTCKTG   SSTCKTG Accrued interest: Daily method
215 SFLAT VTBFHAPO SFLAT   VVSFLAT Indicator 'Traded flat',i.e.no accrued interest calculation
216 SCOUPON VTBFHAPO SCOUPON   VVSCOUPON Coupon ID for interest and accrued interest calculation
217 DCOUPON VTBFHAPO DCOUPON   VVDCOUPON Coupon date of next delivered coupon
218 NOMINAL_ORG_AMT VTBFHAPO NOMINAL_ORG_AMT   TB_BNWHR_ORG Orignal Nominal Amount
219 NOM_FACTOR VTBFHAPO NOM_FACTOR   RDPT_FACTOR_VAL Factor
220 RLDEPO2 VTBFHAPO RLDEPO2   VRLDEPO Securities Account
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in