SAP ABAP Table FTI_LDB_TR_OTC_DEAL_2 (TR RAPIs - OTC Transact. Reporting Incl. Risk Man. Figures)

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_OTC_DEAL_2	Table Relationship Diagram
Short Description	TR RAPIs - OTC Transact. Reporting Incl. Risk Man. Figures

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
4	OBJECTNUMBER	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
5	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
6	CREATE_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
7	CREATE_TIME	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	UPDATE_USER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
9	UPDATE_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
10	UPDATE_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
11	CONTRACT_TYPE	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
12	PRODUCT_CAT	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
13	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
14	TRANSACTION_CAT	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
15	ACTIVITY_CAT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
16	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
17	START_TERM	☐	FTI_DBLFZ_DEAL	DATUM	DATS	8	0	Start of Term
18	END_TERM	☐	FTI_DELFZ_DEAL	DATUM	DATS	8	0	End of Term
19	ROLLOVER_TERM	☐	FTI_ROLLOVER_DEAL	DATUM	DATS	8	0	Rollover Date
20	START_INCLUSIVE	☐	FTI_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
21	END_INCLUSIVE	☐	TB_SINCLE	XFELD	CHAR	1	0	End of Term Inclusive Indicator
22	NOTICE_DATE	☐	TB_NOTICE_DATE	DATUM	DATS	8	0	OTC Notice Date
23	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
24	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
25	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
26	COUNTERPARTY	☐	TB_KONTRH	BU_PARTNER	CHAR	10	0	Counterparty	BUT000
27	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
28	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
29	EXTERNAL_REFNCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
30	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
31	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
32	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
33	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
34	INTERNAL_REFNCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
35	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
36	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
37	FACILITY_DEALNO	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
38	FACILITY_CCODE	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
39	DEAL_ACTIVE	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
40	RELEASE_STATUS	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
41	CONFIRM_STATUS	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
42	CONFIRM_DATE	☐	TB_DCONF	DATUM	DATS	8	0	Confirmation Date
43	CONFIRM_USER	☐	TB_UCONF	USNAM	CHAR	12	0	Confirmation Executed By (User Responsible)
44	CNTRCONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
45	CNTRCONFIRM_DATE	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
46	CNTRCONFIRM_USER	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
47	CURRENCY	☐	FTI_WGSCHFT	WAERS	CUKY	5	0	Currency of Transaction	TCURC
48	CURRENCY_RCV	☐	FTI_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side of Transaction	TCURC
49	CURRENCY_PAY	☐	FTI_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side of Transaction	TCURC
50	NOM_AMOUNT	☐	FTI_NOMAMT	WERTV7	CURR	13	2	Nominal Amount
51	NOM_AMOUNT_RCV	☐	FTI_BGSCHF2	WERTV7	CURR	13	2	Nominal Amount: Incoming Side of Transaction
52	NOM_AMOUNT_PAY	☐	FTI_BGSCHF1	WERTV7	CURR	13	2	Nominal Amount: Outgoing Side of Transaction
53	LEAD_CURRENCY	☐	FTI_LWAERS	WAERS	CUKY	5	0	Leading Currency	TCURC
54	FOLL_CURRENCY	☐	FTI_FWAERS	WAERS	CUKY	5	0	Following Currency	TCURC
55	RATE	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
56	SPOTRATE	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
57	SWAPRATE	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
58	EFF_INT	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
59	EFF_INT_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
60	INT_CAT	☐	FTI_INTTYPE	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category
61	INT_CURRENT	☐	FTI_NOMINALZINS	DEC3_7	DEC	10	7	Nominal Interest Rate
62	INT_REF	☐	FTI_INTREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
63	INT_FORMULA	☐	FTI_XINTFORMULA	TEXT132	CHAR	132	0	String for Interest Formula
64	INT_STATUS	☐	FTI_INTSTATUS	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status
65	INT_NEXT_FIX	☐	FTI_NEXT_FIXDATE	DATUM	DATS	8	0	Next Interest Rate Adjustment Date
66	INT_AMOUNT	☐	FTI_INTAMOUNT	TPM_AMOUNT	CURR	21	2	Interest Amount
67	INT_CURRENCY	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
68	INT_CAT_IN	☐	FTI_INTTYPE_IN	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Incoming Side
69	INT_CURRENT_IN	☐	FTI_NOMINALZINS_IN	DEC3_7	DEC	10	7	Nominal Interest Rate of Incoming Side
70	INT_REF_IN	☐	FTI_INTREF_IN	ZIREFKU	CHAR	10	0	Reference Interest Rate Incoming Side	*
71	INT_FORMULA_IN	☐	FTI_XINTFORMULA_IN	TEXT132	CHAR	132	0	String for Interest Formula of Incoming Side
72	INT_STATUS_IN	☐	FTI_INTSTATUS_IN	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status: Incoming Side
73	INT_NEXT_FIX_IN	☐	FTI_NEXT_FIXDATE_IN	DATUM	DATS	8	0	Next Interest Rate Adjustment Date of Incoming Side
74	INT_AMOUNT_IN	☐	FTI_INTAMOUNT_IN	TPM_AMOUNT	CURR	21	2	Interest Amount of Incoming Side
75	INT_CURRENCY_IN	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
76	INT_CAT_OUT	☐	FTI_INTTYPE_OUT	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Outgoing Side
77	INT_CURRENT_OUT	☐	FTI_NOMINALZINS_OUT	DEC3_7	DEC	10	7	Nominal Interest Rate of Outgoing Side
78	INT_REF_OUT	☐	FTI_INTREF_OUT	ZIREFKU	CHAR	10	0	Reference Interest Rate of Outgoing Side	*
79	INT_FORMULA_OUT	☐	FTI_XINTFORMULA_OUT	TEXT132	CHAR	132	0	String for Interest Formula of Outgoing Side
80	INT_STATUS_OUT	☐	FTI_INTSTATUS_OUT	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status: Outgoing Side
81	INT_NEXT_FIX_OUT	☐	FTI_NEXT_FIXDATE_OUT	DATUM	DATS	8	0	Next Interest Rate Adjustment Date of Outgoing Side
82	INT_AMOUNT_OUT	☐	FTI_INTAMOUNT_OUT	TPM_AMOUNT	CURR	21	2	Interest Amount of Outgoing Side
83	INT_CURRENCY_OUT	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
84	PUT_CALL	☐	FTI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/Call Indicator
85	EXPIRATION_DATE	☐	FTI_DMATUR	DATUM	DATS	8	0	Exercise Date
86	STRIKE_CURRENCY	☐	FTI_OFWAERS	WAERS	CUKY	5	0	Strike Currency of Option/Future	*
87	STRIKE_AMOUNT	☐	FTI_OSTRIKE	WERTV7	CURR	13	2	Option Strike Amount
88	SETTLEMENT_TYPE	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
89	OPTION_CATEGORY	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	*
90	DIR_STRIKEAMOUNT	☐	FTI_OSSIGN	T_SSIGN	CHAR	1	0	Direction of Strike Amount
91	BARRIER_CATEGORY	☐	TI_SLEVELT	T_SLEVELT	NUMC	2	0	Category of Knock-In/Knock-Out Level
92	LEAD_CURR_UL	☐	FTI_LWAERS_UL	WAERS	CUKY	5	0	Leading Currency of Underlying Transaction	*
93	FOLLOW_CURR_UL	☐	FTI_FWAERS_UL	WAERS	CUKY	5	0	Following Currency of Underlying Transaction	*
94	BARRIER	☐	TX_KWKURB1	TB_KKURS	DEC	13	9	Barrier as forex rate for exotic options
95	BARRIER2	☐	TX_KWKURB2	TB_KKURS	DEC	13	9	Barrier 2 as forex rate for exotic options
96	PREMIUM_AMT_PYC	☐	FTI_PREMIUM_PYC	WERTV7	CURR	13	2	Option Premium in Payment Currency
97	PREMIUM_DATE	☐	FTI_PREMIUM_DATE	DATUM	DATS	8	0	Premium Payment Date
98	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	*
99	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
100	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
101	NPV_LONG_PC	☐	TV_NPV_LONG_PC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Currency of Incoming Side
102	NPV_SHORT_PC	☐	TV_NPV_SHORT_PC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Currency of Outgoing Side
103	NPV_LONG_CC	☐	TV_NPV_LONG_CC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Evaluation Currency
104	NPV_SHORT_CC	☐	TV_NPV_SHORT_CC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Evaluation Currency
105	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
106	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
107	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
108	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
109	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
110	FW_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
111	CONVEXITY	☐	TV_CONVEXITY_MORE_ACCURATE	DEC6_5SIGN	DEC	11	5	Convexity with 5 Decimal Places
112	DELTA	☐	TV_DELTA	T_SENSI	DEC	15	10	Delta, 1st derivation of premium based on underlying rate
113	GAMMA	☐	TV_GAMMA	T_GAMMA	DEC	14	8	Gamma, 2nd derivation of premium based on underlying rate
114	THETA	☐	TV_THETA	T_SENSI	DEC	15	10	Theta, 1st derivation of premium according to time
115	VEGA	☐	TV_VEGA	T_SENSI	DEC	15	10	Vega, 1st Volatility Derivative
116	HOUSEBNK_IN	☐	FTI_HBANK_IN	HBKID	CHAR	5	0	Short Key for Own House Bank: Incoming Side	*
117	HOUSEBNKACCT_IN	☐	FTI_HBACCT_IN	HKTID	CHAR	5	0	Short Key for House Bank Account: Incoming Side	*
118	PAYER_PAYEE_IN	☐	FTI_PAYERPAYEE_IN	BU_PARTNER	CHAR	10	0	Payer/Payee of Incoming Side	*
119	PARTNERBNK_IN	☐	FTI_PBANK_IN	BVTYP	CHAR	4	0	Partner Bank Details of Incoming Side
120	HOUSEBNK_OUT	☐	FTI_HBANK_OUT	HBKID	CHAR	5	0	Short Key for Own House Bank: Outgoing Side	*
121	HOUSEBNKACCT_OUT	☐	FTI_HBACCT_OUT	HKTID	CHAR	5	0	Short Key for House Bank Account: Outgoing Side	*
122	PAYER_PAYEE_OUT	☐	FTI_PAYERPAYEE_OUT	BU_PARTNER	CHAR	10	0	Payer/Payee of Outgoing Side	*
123	PARTNERBNK_OUT	☐	FTI_PBANK_OUT	BVTYP	CHAR	4	0	Partner Bank Details of Outgoing Side

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_TR_OTC_DEAL_2	ACTIVITY_CAT	AT02	SFGZUSTT
2	FTI_LDB_TR_OTC_DEAL_2	COMPANYCODE	T001	BUKRS
3	FTI_LDB_TR_OTC_DEAL_2	COUNTERPARTY	BUT000	PARTNER
4	FTI_LDB_TR_OTC_DEAL_2	CURRENCY	TCURC	WAERS
5	FTI_LDB_TR_OTC_DEAL_2	CURRENCY_PAY	TCURC	WAERS
6	FTI_LDB_TR_OTC_DEAL_2	CURRENCY_RCV	TCURC	WAERS
7	FTI_LDB_TR_OTC_DEAL_2	FOLL_CURRENCY	TCURC	WAERS
8	FTI_LDB_TR_OTC_DEAL_2	GUARANTOR	BUT000	PARTNER
9	FTI_LDB_TR_OTC_DEAL_2	LEAD_CURRENCY	TCURC	WAERS
10	FTI_LDB_TR_OTC_DEAL_2	MANDT	T000	MANDT
11	FTI_LDB_TR_OTC_DEAL_2	PRODUCT_CAT	TZAF	SANLF
12	FTI_LDB_TR_OTC_DEAL_2	PRODUCT_TYPE	TZPA	GSART
13	FTI_LDB_TR_OTC_DEAL_2	TRADER	TZDEA	RDEALER
14	FTI_LDB_TR_OTC_DEAL_2	TRANSACTION_CAT	AT01	SFGTYP
15	FTI_LDB_TR_OTC_DEAL_2	TRANSACTION_TYPE	AT10	SFHAART
16	FTI_LDB_TR_OTC_DEAL_2	VALUATION_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS

History

Last changed by/on	SAP	20130529
SAP Release Created in