SAP ABAP Table FTRS_VTBFINKO (Structure for Financial Transaction Conditions (Without Key))

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	INTTAB	Structure
Structure	FTRS_VTBFINKO	Table Relationship Diagram
Short Description	Structure for Financial Transaction Conditions (Without Key)

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	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
2	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
3	TCRTIM	☐	TB_CRTIM	TIME06	CHAR	6	0	Entry Time
4	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
5	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
6	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
7	SALTKOND	☐	TB_SALKOND	SKONDGRP	NUMC	4	0	Unit for supplementary condition items
8	SZINSANP	☐	SZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
9	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
10	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
11	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
12	SBKKLAS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
13	SBKTYP	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	AT08
14	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
15	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
16	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
17	SBASIS	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
18	BBASIS	☐	TFM_BBASIS2	TFM_WRTV7	CURR	13	2	Calculation Base Amount
19	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
20	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
21	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
22	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
23	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
24	SVARNAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
25	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
26	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
27	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
28	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
29	SVWERK	☐	TB_SVWERK	T_SWERK	NUMC	1	0	Working Day Shift for Calculation Day
30	SVMETH	☐	TB_SVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
31	AVGSTAGE	☐	TB_AVGSTAG	T_GSTAGE	INT4	10	0	Number of Days for Relative Calculation of Value Date
32	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
33	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
34	SFWERK	☐	TB_SFWERK	T_SWERK	NUMC	1	0	Working Day Shift for Due Date
35	SFMETH	☐	TB_SFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
36	AFGSTAGE	☐	TB_AFGSTAG	T_GSTAGE	INT4	10	0	Number of days for rel. determination of due date
37	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
38	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
39	AZGSTAGE	☐	TB_AZGSTAG	T_GSTAGE	INT4	10	0	No. of days for relative determinatn of interest fixing
40	DZSREF	☐	TB_ZSREF	DATUM	DATS	8	0	Reference interest rate fixing date
41	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
42	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
43	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
44	SHERKUNFT	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
45	SRHYTHM	☐	TB_SRHYTHM	T_SRHYTHM	NUMC	1	0	Frequency Indicator
46	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
47	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
48	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
49	SKURSART	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
50	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
51	SERBTERM	☐	TFMERBTERM	TFMERBTERM	CHAR	1	0	FiMa indicator: Date and frequency inheritance for condition
52	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
53	SEXCLGUEL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
54	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
55	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
56	SKALID3	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
57	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
58	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
59	PKOND1STPER	☐	TFM_PKOND1STPER	DECV3_7	DEC	10	7	Interest Rate for the First Period
60	SREFDISC	☐	SREFDISC	SKONDGRP	NUMC	4	0	Referenced Condition Group Discounting
61	SDISCOUNT	☐	TFM_SDISCOUNT	TFM_SDISCOUNT	NUMC	1	0	Discounting Category
62	BROUNDUNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
63	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
64	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
65	FACILITYLINE	☐	TB_CREDIT_LINE	T_CREDIT_LINE	CHAR	3	0	Line of Credit	*
66	BGUEL_KP	☐	BGUEL_KP	T_POS_AMOUNT	CURR	17	2	Condition Item Effective from Amount
67	SULTGUEL	☐	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
68	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTRS_VTBFINKO	SBERFIMA	AT40	SBERFIMA
2	FTRS_VTBFINKO	SBKTYP	AT08	BKTYP
3	FTRS_VTBFINKO	SKALID	TFACD	IDENT
4	FTRS_VTBFINKO	SKALID2	TFACD	IDENT
5	FTRS_VTBFINKO	SKALID3	TFACD	IDENT
6	FTRS_VTBFINKO	SKOART	TZK01	SKOART
7	FTRS_VTBFINKO	SWHRKOND	TCURC	WAERS
8	FTRS_VTBFINKO	SZSREF	T056R	REFERENZ

History

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