SAP ABAP Table VTBKOND (Transfer Structure of Cash Flow Calculator for Conditions)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-FIM-FMA (Application Component) Financial Mathematics
     ⤷ FIMA (Package) Financial mathematics

Basic Data

Table Category	INTTAB	Structure
Structure	VTBKOND	Table Relationship Diagram
Short Description	Transfer Structure of Cash Flow Calculator for Conditions

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	SKONDGRP	☐	SKONDGRP	SKONDGRP	NUMC	4	0	Condition group in cash flow calculator
2	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
3	TGUEL_KP	☐	TFM_TGUEL_KP	SYTIME	TIMS	6	0	Time 'Condition Item Effective From'
4	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
5	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
6	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
7	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
8	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
9	JGESUCHT	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
10	SALTKOND	☐	TB_SALKOND	SKONDGRP	NUMC	4	0	Unit for supplementary condition items
11	SZINSANP	☐	SZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
12	SKONDGRPREF	☐	TFM_SKONDGRPREF	SKONDGRP	NUMC	4	0	Referenced Condition Group
13	SZSREF	☐	TFM_SZSREF	TFMZIREFKU	CHAR	10	0	Reference Interest Rate
14	PFLUCT	☐	TFM_PFLUCT	DECV3_7	DEC	10	7	Fluctuation margin
15	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	AT30
16	SVARNAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
17	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
18	PKOND	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
19	PKONDUR	☐	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
20	SIRUNIT	☐	TFM_SIRUNIT	TFM_SIRUNIT	NUMC	3	0	Time Unit for the Interest Rate
21	ALFZTAGE	☐	TFMLFZTAGE	INT6	NUMC	6	0	Number of days
22	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
23	BKOND	☐	TFM_BKOND	TFM_WRTV9	CURR	17	2	Condition item currency amount
24	KBKOND	☐	TFM_KBKOND	TFM_KBKOND	DEC	15	6	Currency-independent FiMa condition amount
25	BUGRENZ	☐	TFMBUGRENZ	TFM_WRTV12	CURR	23	2	Lower Limit for Amount
26	BOGRENZ	☐	TFMBOGRENZ	TFM_WRTV12	CURR	23	2	Upper Limit for Amt
27	SSTAFF	☐	TFMSSTAFF	TFMSSTAFF	NUMC	1	0	Type of Scaled Calculation
28	SBASIS	☐	TFM_SBASIS	TFM_SBASIS	CHAR	4	0	Calculation Base Reference
29	BBASIS	☐	TFM_BBASIS2	TFM_WRTV7	CURR	13	2	Calculation Base Amount
30	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
31	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
32	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
33	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
34	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
35	AMMRHYSAV	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
36	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
37	ATTRHYSAV	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
38	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
39	TVALUT	☐	TFM_TVALUT	SYTIME	TIMS	6	0	Time of Calculation Date
40	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
41	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
42	SVMETH	☐	TB_SVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
43	AVGSTAGE	☐	TB_AVGSTAG	T_GSTAGE	INT4	10	0	Number of Days for Relative Calculation of Value Date
44	SVWERK	☐	TB_SVWERK	T_SWERK	NUMC	1	0	Working Day Shift for Calculation Day
45	SVON	☐	TFM_SVON	XFELD	CHAR	1	0	Int. FiMa indicator to interprete DVALUT/SINCL
46	SVMOVE	☐	TFMSVMOVE	TFMSVMOVE	NUMC	1	0	FiMa Indicator: Shift Settlement Date Back
47	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
48	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
49	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
50	SFMETH	☐	TB_SFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
51	AFGSTAGE	☐	TB_AFGSTAG	T_GSTAGE	INT4	10	0	Number of days for rel. determination of due date
52	SFWERK	☐	TB_SFWERK	T_SWERK	NUMC	1	0	Working Day Shift for Due Date
53	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
54	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
55	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
56	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
57	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
58	SKALID3	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
59	SKALID4	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
60	SKALID5	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
61	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
62	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
63	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
64	SERBTERM	☐	TFMERBTERM	TFMERBTERM	CHAR	1	0	FiMa indicator: Date and frequency inheritance for condition
65	SRUNDVORF	☐	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
66	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
67	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
68	RURKONDIND	☐	VVRKONDIND	SYST_LONG	INT4	10	0	Reference index for an investment mathematical item
69	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	TFACD
70	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
71	BROUNDUNIT	☐	TFMBRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
72	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
73	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
74	SDISCOUNT	☐	TFM_SDISCOUNT	TFM_SDISCOUNT	NUMC	1	0	Discounting Category
75	PDISCOUNT	☐	TFM_PDISCOUNT	DECV3_7	DEC	10	7	Percentage Discount Rate
76	SREFDISC	☐	SREFDISC	SKONDGRP	NUMC	4	0	Referenced Condition Group Discounting
77	APERIODS	☐	TFM_APERIODS	NUMC03	NUMC	3	0	Number of Periods
78	SZAWS	☐	TFM_SZAWS	TFM_SZAWS	NUMC	1	0	Payment Form (Period Start, Mid-Period, Period End, Other)
79	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
80	ARHYREL	☐	TFM_ARHYREL	NUMC3	NUMC	3	0	Relative Frequency
81	JRATENFIX	☐	TFM_JRATENFIX	XFELD	CHAR	1	0	Keep Installment
82	PKOND1STPER	☐	TFM_PKOND1STPER	DECV3_7	DEC	10	7	Interest Rate for the First Period
83	ADGSTAGE	☐	TFM_ADGSTAGE	T_GSTAGE	INT4	10	0	Number of Days for Relative Payment Date Calculation
84	JANNVERR	☐	TFM_JANNVERR	TFM_JANNVERR	CHAR	1	0	Settle Annuity Installment
85	SVKEYDAY	☐	TFM_SVKEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Update of Calculation Date
86	SFKEYDAY	☐	TFM_SFKEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Update of Due Date
87	JINTRADAY	☐	TFM_JINTRADAY	XFELD	CHAR	1	0	Intraday Interest Calculation
88	DPKONDSAV	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
89	JEFFZREL	☐	TFM_JEFFZREL	CHAR1	CHAR	1	0	Relevant for Effective Interest Rate
90	DZFESTSAV	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
91	WPAYCURR	☐	TFM_WPAYCURR	WAERS	CUKY	5	0	Payment Currency	*
92	PEXCHRATE	☐	TFM_PEXCHRATE	TFM_PEXCHRATE	DEC	15	11	Exchange Rate
93	DBPERIODSAV	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
94	SPAEXCLSAV	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
95	SPAULTSAV	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
96	SKONDGRPSAV	☐	SKONDGRP	SKONDGRP	NUMC	4	0	Condition group in cash flow calculator
97	SSEQUENCE	☐	TFM_SEQUENCE	TFM_SEQUENCE	NUMC	2	0	Processing Sequence of Conditions
98	SZSREFSAV	☐	TFM_SZSREF	TFMZIREFKU	CHAR	10	0	Reference Interest Rate
99	DGUEL_KPSAV	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
100	STGMETHSAV	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTBKOND	SBERFIMA	AT40	SBERFIMA
2	VTBKOND	SFORMREF	AT30	RFORMBEZ
3	VTBKOND	SKALID	TFACD	IDENT
4	VTBKOND	SKALID2	TFACD	IDENT
5	VTBKOND	SKALIDWT	TFACD	IDENT
6	VTBKOND	SWHRKOND	TCURC	WAERS

History

Last changed by/on	SAP	20140802
SAP Release Created in