SAP ABAP Table VTBFHAPO_UNFIXED (Non-Fixed Financial Transaction Flows)

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	TRANSP	Transparent table
Transparent table	VTBFHAPO_UNFIXED	Table Relationship Diagram
Short Description	Non-Fixed Financial Transaction Flows

Delivery and Maintenance

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

History

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