SAP ABAP Table FTI_LDB_TR_DEAL_CONDITIONS (Treasury: Transaction Reporting, Conditions (-> LDB))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI_LDB (Package) Logical Databases for the R/3 CFM Information System

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_LDB_TR_DEAL_CONDITIONS	Table Relationship Diagram
Short Description	Treasury: Transaction Reporting, Conditions (-> LDB)

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	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
3	NUMBER	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
4	EFF_FROM	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
5	DIRECTION	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
6	SINGLE_DATES	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
7	TYPE	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
8	CLASS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
9	CATEGORY	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	*
10	EFF_FROM_EXCL	☐	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
11	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
12	CREATE_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
13	CREATE_TIME	☐	TB_CRTIM	TIME06	CHAR	6	0	Entry Time
14	UPDATE_USER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
15	UPDATE_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
16	UPDATE_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
17	ZERO_CONDITION	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
18	FIX_PERC_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
19	FIX_PAYMENT_RATE	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
20	FIX_BASIS	☐	TFM_BBASIS2	TFM_WRTV7	CURR	13	2	Calculation Base Amount
21	VAR_INT_REF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
22	VAR_SPREAD	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
23	VAR_FORMULA	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
24	VAR_FORMULA_NAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
25	VAR_1ST_PER_RATE	☐	TFM_PKOND1STPER	DECV3_7	DEC	10	7	Interest Rate for the First Period
26	CALC_METHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
27	CALC_METHOD_CAL	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
28	CALC_TYPE	☐	TFMSINTCALC	TFMSINTCALC	NUMC	1	0	Type of interest calculation
29	CALC_EXP_FREQ	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
30	CALC_IMM_SETTLE	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
31	AMOUNT	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
32	AMOUNT_CURRENCY	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
33	AMOUNT_TEMP_CALC	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
34	CALCDAT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
35	CALCDAT_INCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
36	CALCDAT_MONTHEND	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
37	CALCDAT_WKDAYSFT	☐	TB_SVWERK	T_SWERK	NUMC	1	0	Working Day Shift for Calculation Day
38	CALCDAT_SFTDAYS	☐	TB_AVGSTAG	T_GSTAGE	INT4	10	0	Number of Days for Relative Calculation of Value Date
39	CALCDAT_SFTDIR	☐	FTI_SFTDIR	FTI_RICHTUNG	CHAR	1	0	Direction of Daily Shift
40	CALCDAT_PERRULE	☐	TB_SVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
41	CALCDAT_ADJRULE	☐	TFMSRHYZAP	TFMSRHYZAP	NUMC	1	0	Rule for Date Update for Interest Rate Adjustment
42	DUEDAT	☐	DFAELL	DATUM	DATS	8	0	Due date
43	DUEDAT_MONTHEND	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
44	DUEDAT_SFTEND	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
45	DUEDAT_WKDAYSFT	☐	TB_SFWERK	T_SWERK	NUMC	1	0	Working Day Shift for Due Date
46	DUEDAT_SFTDAYS	☐	TB_AFGSTAG	T_GSTAGE	INT4	10	0	Number of days for rel. determination of due date
47	DUEDAT_SFTDIR	☐	FTI_SFTDIR	FTI_RICHTUNG	CHAR	1	0	Direction of Daily Shift
48	DUEDAT_DUERULE	☐	TB_SFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
49	DUEDAT_FIXRULE	☐	TFMSRHY	TFMSRHY	NUMC	1	0	Rule for Date Update
50	DUEDAT_FIXREFDAT	☐	FTI_ZRELDAT	TFMZRELDAT	NUMC	1	0	Reference Date for Interest Rate Fixing Date
51	FREQUENCY	☐	TFMARHY	NUMC3	NUMC	3	0	Cycle
52	FREQUENCY_UNIT	☐	TFMURHY	TFMURHY	NUMC	1	0	Unit for Frequency
53	CALENDAR1	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
54	CALENDAR2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
55	CALENDAR3	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
56	ROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
57	ROUND_UNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
58	DISCOUNT	☐	TFM_SDISCOUNT	TFM_SDISCOUNT	NUMC	1	0	Discounting Category
59	VARNAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
60	ALT_INTEREST_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
61	ALT_INT_REFERENCE	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*

History

Last changed by/on	SAP	20130529
SAP Release Created in	600