SAP ABAP Table VFSFHAPO (Fin. Flows from View of Listed Options and Futures)

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	VFSFHAPO	Table Relationship Diagram
Short Description	Fin. Flows from View of Listed Options and Futures

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	Financial Flows: Futures Screen Fields
142	SSELECTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
143	XZTERM	☐	TM_XZTERM	T_XDATUM	CHAR	10	0	Payment date
144	XZBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
145	XNWHR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
146	XPRICE	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
147	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
148	XSTORNOART	☐	TB_XSTOART	TEXT30	CHAR	30	0	Name of manual reversal type for posted flows
149	XKALIDWT	☐	TB_XKALIDWT	TEXT60	CHAR	60	0	Name of interest rate calendar
150	XINCL	☐	VVXINCL	XFELD	CHAR	1	0	Indicator date inclusive
151	WHWBETR	☐	TB_WHWBETR	WAERS	CUKY	5	0	Local currency	*
152	DBESTANDX	☐	TB_DBESTANDX	T_XDATUM	CHAR	10	0	Position value date
153	DVALUTX	☐	TB_DVALUTX	T_XDATUM	CHAR	10	0	Calculation date
154	KZWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
155	KZWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
156	KHWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
157	KHWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
158	KBWKURS_FROM	☐	TB_WFROM	WAERS	CUKY	5	0	Currency Key for Currency Conversion: Source Currency	*
159	KBWKURS_TO	☐	TB_WTO	WAERS	CUKY	5	0	Currency key for curreny conversion: Target currency	*
160	XHBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
161	XEBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
162	XBBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
163	XFLG_DEALFLOW	☐	XFELD	XFELD	CHAR	1	0	Checkbox
164	WZBETR_NEW	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
165	SRUNIT_NEW	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
166	DEFECT_RATE	☐	DEFECTRATE	DECV3_7	DEC	10	7	Negative interest rate
167	DEFECT_RATE_NEW	☐	DEFECTRATE	DECV3_7	DEC	10	7	Negative interest rate
168	ZUONR_NEW	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
169	INDEX_VALUE_P	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
170	INDEX_VALUE_U	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
171	SKALIDWT_TEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text

Foreign Keys

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

History

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