SAP ABAP Table FIMA_TEST_DI_VTBKOND (Conditions for ALV)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-FIM-FMA (Application Component) Financial Mathematics
     ⤷ FIMA_TEST_DI (Package) Daily Interest Test Programs

Basic Data

Table Category	INTTAB	Structure
Structure	FIMA_TEST_DI_VTBKOND	Table Relationship Diagram
Short Description	Conditions for ALV

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

Foreign Keys

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

History

Last changed by/on	SAP	20140802
SAP Release Created in