SAP ABAP Table VTB_SFHAPO (Forwards: Financial Transaction Flows)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTT (Package) R/3 application development for Treasury forward trading

Basic Data

Table Category	INTTAB	Structure
Structure	VTB_SFHAPO	Table Relationship Diagram
Short Description	Forwards: Financial Transaction Flows

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	.INCLUDE	☐				0	0	Transaction Flow
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
5	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
6	DCRDAT	☐	TB_CRDAT	DATUM	DATS	8	0	Entered On
7	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	RFHAZB	☐	TB_RFHAZB	T_RFHAZB	NUMC	4	0	Transaction flow
9	.INCLUDE	☐				0	0	Structure for Financial Transaction Flows (Without Key)
10	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
11	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
12	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
13	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
14	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
15	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
16	SBKKLAS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
17	SBKTYP	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	*
18	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
19	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
20	SHERKUNFT	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
21	SABVERF	☐	TB_SABVERF	T_SABVERF	CHAR	5	0	Procedure to Generate Derived Flows	*
22	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
23	RKOND	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
24	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
25	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
26	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
27	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	*
28	SBZVABW	☐	TB_SBZVABW	XFELD	CHAR	1	0	Alternative payment details stated in flow
29	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
30	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
31	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
32	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
33	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
34	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
35	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
36	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
37	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
38	SPRGRD	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
39	SCSPAY	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
40	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
41	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
42	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
43	SSPRGRD	☐	TB_SSPRGRD	T_SSPRGRD	NUMC	1	0	Reason Why Flow Is Blocked for Posting
44	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
45	SSTORNOBWG	☐	TB_SBWGSTO	XFELD	CHAR	1	0	Flow reversal in Treasury
46	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
47	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
48	BELNR2	☐	TB_BELNR2	BELNR	CHAR	10	0	Doc. no. of a second accounting doc. for currency swap
49	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
50	DBUCHUNG	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
51	DFAELL	☐	TB_DFAELL	DATUM	DATS	8	0	Due date
52	DZTERM	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
53	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
54	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
55	BHWBETR	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
56	KHWKURS	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
57	ASTUECK	☐	TB_ASTUECK	ASTUECK	DEC	15	5	No. of Units for Financial Instruments
58	BPRICE	☐	TB_BPRICE	WERTV7	CURR	13	2	Price per unit
59	WPRICE	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
60	BHWPREIS	☐	TB_HWPREIS	WERTV7	CURR	13	2	Price in local currency
61	BINDEX	☐	TB_BINDEX	BWHR	CURR	13	2	Value of a point
62	VVBASIS	☐	TB_VVBASIS	T_PKTKUR	DEC	11	6	Price in points
63	PWKURS	☐	TB_PWKURS	DEC3_7	DEC	10	7	Price as percentage quotation
64	PRKKURS	☐	TI_PRKUR	TB_KKURS	DEC	13	9	Currency option premium with price in points
65	BNWHR	☐	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
66	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
67	SKURSART	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
68	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
69	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
70	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
71	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
72	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
73	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
74	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
75	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
76	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
77	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
78	WBASIS	☐	TB_WBASIS	WAERS	CUKY	5	0	Currency of calculation basis	TCURC
79	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
80	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
81	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
82	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
83	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
84	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
85	SAEND	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
86	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
87	SVINCL	☐	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
88	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
89	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
90	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
91	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
92	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
93	SSTORNOMAN	☐	TB_SBWGSTM	T_SBWGSTM	CHAR	1	0	Manual reversal of flows posted in FI
94	SSTORNOART	☐	TB_SSTOART	T_SSTOART	CHAR	2	0	Type of manual reversal of flows posted in FI	*
95	SBWGARTREF	☐	TB_SBWGREF	SBEWART	CHAR	4	0	Referenced flow type	*
96	SKHWFIX	☐	TB_SKHWFIX	T_SKHWFIX	CHAR	1	0	Indicator for translation into local currency
97	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
98	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
99	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
100	RTRBELNR	☐	TPM_DEDOC_RDOCNRINT	TPM_DEDOC_RDOCNRINT	CHAR	15	0	Internal document number of derivatives document
101	BUPRC	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
102	BPPRC	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
103	WBBETR	☐	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount	*
104	BBBETR	☐	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
105	WEBETR	☐	TB_WEBETR	WAERS	CUKY	5	0	Price currency	*
106	BEBETR	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
107	SRUNIT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
108	KZWKURS	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
109	KBWKURS	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
110	WSBETR	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
111	DBESTAND	☐	TB_DBESTAND	DATUM	DATS	8	0	Position Value Date
112	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
113	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
114	SFLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
115	SCOUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
116	DCOUPON	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
117	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
118	INDEX_VALUE	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
119	SBASIS	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
120	REGI_STATE	☐	TB_IRA_REGISTRATION_STATE	T_IRA_REGISTRATION_STATE	CHAR	2	0	Status of Interest Rate Adjustment
121	RPCODE	☐	RPCODE	RPCODE	CHAR	20	0	Repetitive Code	*
122	RP_TEXT	☐	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
123	HEDGE_ID	☐	TPM_HEDGE_ID		CHAR	10	0	Identification for Hedging Relationship
124	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
125	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
126	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
127	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
128	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
129	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
130	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
131	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
132	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
133	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
134	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
135	BDIRTY	☐	TB_BDIRTY	WERTV7	CURR	13	2	Dirty Price
136	BAMOUNTCOMP	☐	TB_AMOUNTCOMP	WERTV7	CURR	13	2	Amount to be Capitalized
137	NOMINAL_ORG_AMT	☐	TB_BNWHR_ORG	WERTV7	CURR	13	2	Orignal Nominal Amount
138	NOM_FACTOR	☐	RDPT_FACTOR_VAL		DEC	12	9	Factor
139	RLDEPO2	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
140	INDEX_PRICE	☐	TB_INDEX_PRICE	CHAR1	CHAR	1	0	Indicator for Security Price Including Index Value
141	.INCLUDE	☐				0	0	Forward: Screen Fields for Flows
142	XZTERM	☐	TM_XZTERM	T_XDATUM	CHAR	10	0	Payment date
143	XZBETR	☐	TB_XPAYM_AMT_ZW	T_XBETRG18	CHAR	18	0	Payment Amount in Payment Currency as Text Field
144	DBESTANDX	☐	TB_XDBESTANDB	T_XDATUM	CHAR	10	0	Position Date of Bond as Underlying of a Forward
145	DVALUTX	☐	TB_DVALUTX	T_XDATUM	CHAR	10	0	Calculation date
146	BMARGIN	☐	TB_MARGIN_AMT	WERTV7	CURR	13	2	Margin Amount in Nominal Currency
147	XNWHR	☐	TB_XNOM_FW	T_XBETRG18	CHAR	18	0	Nominal Amount in Issue Currency
148	XBSPOT	☐	TB_XSPOT_FW	T_XBETRG18	CHAR	18	0	Spot Price Amount in Issue Currency
149	BSPOT	☐	TB_SPOT_FW	WERTV7	CURR	13	2	Spot Price Amount in Issue Currency
150	SPOTRATE	☐	TB_SPOTRATE	DEC3_7	DEC	10	7	Spot Rate in Percentage
151	BFORW	☐	TB_FORW_FW	WERTV7	CURR	13	2	Forward Price in Issue Currency
152	WHWBETR	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
153	XBBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
154	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
155	SSELECTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
156	XPRICE	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
157	XSTORNOART	☐	TB_XSTOART	TEXT30	CHAR	30	0	Name of manual reversal type for posted flows
158	XKALIDWT	☐	TB_XKALIDWT	TEXT60	CHAR	60	0	Name of interest rate calendar
159	XINCL	☐	VVXINCL	XFELD	CHAR	1	0	Indicator date inclusive
160	KZWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
161	KZWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
162	KHWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
163	KHWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
164	KBWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
165	KBWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
166	XHBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
167	XEBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
168	XFLG_DEALFLOW	☐	XFELD	XFELD	CHAR	1	0	Checkbox
169	WZBETR_NEW	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
170	SRUNIT_NEW	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
171	DEFECT_RATE	☐	DEFECTRATE	DECV3_7	DEC	10	7	Negative interest rate
172	DEFECT_RATE_NEW	☐	DEFECTRATE	DECV3_7	DEC	10	7	Negative interest rate
173	ZUONR_NEW	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
174	INDEX_VALUE_P	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
175	INDEX_VALUE_U	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
176	.INCLUDE	☐				0	0	Fields for Repo Flow
177	SFHAZBA_R	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
178	XBEWART_R	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
179	BPPRC_R	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
180	BUPRC_R	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
181	SRUNIT_R	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
182	DBESTANDX_R	☐	TB_XDBESTANDB	T_XDATUM	CHAR	10	0	Position Date of Bond as Underlying of a Forward
183	DBESTAND_R	☐	TB_DBESTAND	DATUM	DATS	8	0	Position Value Date
184	DVALUTX_R	☐	TB_DVALUTX	T_XDATUM	CHAR	10	0	Calculation date
185	DVALUT_R	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
186	XZTERM_R	☐	TB_XZTERM	T_XDATUM	CHAR	10	0	Payment or Delivery Date
187	DZTERM_R	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
188	XEBETR_R	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
189	BEBETR_R	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
190	WEBETR_R	☐	TB_WEBETR	WAERS	CUKY	5	0	Price currency	*
191	XZBETR_R	☐	TB_XZBETR	T_XBETR	CHAR	18	0	Payment amount
192	BZBETR_R	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
193	WZBETR_R	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
194	XHBETR_R	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
195	BHWBETR_R	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
196	WHWBETR_R	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
197	XBBETR_R	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
198	BBBETR_R	☐	TB_BBBETR	WERTV7	CURR	13	2	Amount that Changes the Position
199	WBBETR_R	☐	TB_WBBETR	WAERS	CUKY	5	0	Currency of Position Amount	*
200	KZWKURS_R	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
201	KZWKURS_FROM_R	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
202	KZWKURS_TO_R	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
203	KHWKURS_R	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
204	KHWKURS_FROM_R	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
205	KHWKURS_TO_R	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
206	KBWKURS_R	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
207	KBWKURS_FROM_R	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
208	KBWKURS_TO_R	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
209	SBKTYP_R	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	*
210	SSIGN_R	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
211	SHERKUNFT_R	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
212	ASTUECK_R	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
213	XNWHR_R	☐	TB_XNOM_FW	T_XBETRG18	CHAR	18	0	Nominal Amount in Issue Currency
214	BNWHR_R	☐	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
215	SBKKLAS_R	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
216	SBERFIMA_R	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
217	RFHAZU_R	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
218	RFHAZB_R	☐	TB_RFHAZB	T_RFHAZB	NUMC	4	0	Transaction flow
219	DCRDAT_R	☐	TB_CRDAT	DATUM	DATS	8	0	Entered On
220	TCRTIM_R	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
221	CRUSER_R	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
222	UPUSER_R	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
223	DUPDAT_R	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
224	TUPTIM_R	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
225	RANTYP_R	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
226	SABVERF_R	☐	TB_SABVERF	T_SABVERF	CHAR	5	0	Procedure to Generate Derived Flows	*
227	RKONDGR_R	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
228	RKOND_R	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
229	DGUEL_KP_R	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
230	NSTUFE_R	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
231	SKOART_R	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
232	RREFKONT_R	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	*
233	SBZVABW_R	☐	TB_SBZVABW	XFELD	CHAR	1	0	Alternative payment details stated in flow
234	RAHABKI_R	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
235	RAHKTID_R	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
236	RPZAHL_R	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
237	RPBANK_R	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
238	SZART_R	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
239	ZLSCH_R	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
240	UZAWE_R	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
241	SPAYRQ_R	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
242	SPRSNG_R	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
243	SPRGRD_R	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
244	SCSPAY_R	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
245	ZWELS_R	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
246	PAYGR_R	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
247	SBEWEBE_R	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
248	SSPRGRD_R	☐	TB_SSPRGRD	T_SSPRGRD	NUMC	1	0	Reason Why Flow Is Blocked for Posting
249	SBFREI_R	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
250	SSTORNOBWG_R	☐	TB_SBWGSTO	XFELD	CHAR	1	0	Flow reversal in Treasury
251	PRKEY_R	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
252	BELNR_R	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
253	BELNR2_R	☐	TB_BELNR2	BELNR	CHAR	10	0	Doc. no. of a second accounting doc. for currency swap
254	GJAHR_R	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
255	DBUCHUNG_R	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
256	DFAELL_R	☐	TB_DFAELL	DATUM	DATS	8	0	Due date
257	BPRICE_R	☐	TB_BPRICE	WERTV7	CURR	13	2	Price per unit
258	WPRICE_R	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
259	BHWPREIS_R	☐	TB_HWPREIS	WERTV7	CURR	13	2	Price in local currency
260	BINDEX_R	☐	TB_BINDEX	BWHR	CURR	13	2	Value of a point
261	VVBASIS_R	☐	TB_VVBASIS	T_PKTKUR	DEC	11	6	Price in points
262	PWKURS_R	☐	TB_PWKURS	DEC3_7	DEC	10	7	Price as percentage quotation
263	PRKKURS_R	☐	TI_PRKUR	TB_KKURS	DEC	13	9	Currency option premium with price in points
264	RHANDPL_R	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
265	SKURSART_R	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
266	DBERVON_R	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
267	DBERBIS_R	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
268	ATAGE_R	☐	VVATAGE	INT6	NUMC	6	0	Number of days
269	ABASTAGE_R	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
270	PKOND_R	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
271	DPKOND_R	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
272	DZFEST_R	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
273	SZBMETH_R	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
274	SKALIDWT_R	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
275	BBASIS_R	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
276	WBASIS_R	☐	TB_WBASIS	WAERS	CUKY	5	0	Currency of calculation basis	*
277	JEXPOZINS_R	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
278	SINCL_R	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
279	SINCLBIS_R	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
280	SULTBIS_R	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
281	SEXCLVON_R	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
282	SULTVON_R	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
283	SAEND_R	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
284	SVINCL_R	☐	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
285	SVULT_R	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
286	JSOFVERR_R	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
287	DVERRECH_R	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
288	SINCLVERR_R	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
289	SULTVERR_R	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
290	SSTORNOMAN_R	☐	TB_SBWGSTM	T_SBWGSTM	CHAR	1	0	Manual reversal of flows posted in FI
291	SSTORNOART_R	☐	TB_SSTOART	T_SSTOART	CHAR	2	0	Type of manual reversal of flows posted in FI	*
292	SBWGARTREF_R	☐	TB_SBWGREF	SBEWART	CHAR	4	0	Referenced flow type	*
293	SKHWFIX_R	☐	TB_SKHWFIX	T_SKHWFIX	CHAR	1	0	Indicator for translation into local currency
294	ZUONR_R	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
295	RLDEPO_R	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
296	RANL_R	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
297	RTRBELNR_R	☐	TPM_DEDOC_RDOCNRINT	TPM_DEDOC_RDOCNRINT	CHAR	15	0	Internal document number of derivatives document
298	WSBETR_R	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
299	SSTCKKZ_R	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
300	SSTCKTG_R	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
301	SFLAT_R	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
302	SCOUPON_R	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
303	DCOUPON_R	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
304	AWKEY_R	☐	AWKEY	AWKEY	CHAR	20	0	Object key
305	INDEX_VALUE_R	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
306	SBASIS_R	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
307	REGI_STATE_R	☐	RPCODE	RPCODE	CHAR	20	0	Repetitive Code	*
308	RPCODE_R	☐	RPCODE	RPCODE	CHAR	20	0	Repetitive Code	*
309	RP_TEXT_R	☐	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
310	HEDGE_ID_R	☐	TPM_HEDGE_ID		CHAR	10	0	Identification for Hedging Relationship
311	XINCL_R	☐	VVXINCL	XFELD	CHAR	1	0	Indicator date inclusive

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTB_SFHAPO	BUKRS	T001	BUKRS	KEY	1	CN
2	VTB_SFHAPO	LANDL	T005	LAND1
3	VTB_SFHAPO	LZBKZ	T015L	LZBKZ
4	VTB_SFHAPO	MANDT	T000	MANDT	KEY	1	CN
5	VTB_SFHAPO	RFHA	VTBFHA	RFHA	KEY	1	CN
6	VTB_SFHAPO	WBASIS	TCURC	WAERS
7	VTB_SFHAPO	WZBETR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	462_10