SAP ABAP Table FTI_LDB_TR_DEAL_MAIN (Treasury: Transaction Reporting, Main Data (-> 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_MAIN	Table Relationship Diagram
Short Description	Treasury: Transaction Reporting, Main Data (-> 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	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	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
5	SIDE	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
6	REFERENCE_NO	☐	KL_NR	KL_NR	CHAR	10	0	Reference number (unit no.)	*
7	REFERENCE_TYPE	☐	KL_TYP	KL_TYP	CHAR	3	0	Reference Category (Unit Category)	ATR1
8	OBJECTNUMBER	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
9	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
10	CREATE_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
11	CREATE_TIME	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
12	UPDATE_USER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
13	UPDATE_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
14	UPDATE_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
15	CONTRACT_TYPE	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
16	PRODUCT_CAT	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
17	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
18	TRANSACTION_CAT	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
19	ACTIVITY_CAT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
20	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
21	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
22	START_TERM	☐	FTI_DBLFZ_DEAL	DATUM	DATS	8	0	Start of Term
23	END_TERM	☐	FTI_DELFZ_DEAL	DATUM	DATS	8	0	End of Term
24	ROLLOVER_TERM	☐	FTI_ROLLOVER_DEAL	DATUM	DATS	8	0	Rollover Date
25	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
26	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
27	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
28	START_INCLUSIVE	☐	FTI_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
29	END_INCLUSIVE	☐	TB_SINCLE	XFELD	CHAR	1	0	End of Term Inclusive Indicator
30	NOTICE_DATE	☐	TB_NOTICE_DATE	DATUM	DATS	8	0	OTC Notice Date
31	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
32	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
33	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
34	COUNTERPARTY	☐	TB_KONTRH	BU_PARTNER	CHAR	10	0	Counterparty	BUT000
35	.INCLUDE	☐				0	0	Treasury: Partner Attributes
36	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
37	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
38	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
39	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
40	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
41	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
42	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
43	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
44	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
45	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
46	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
47	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
48	.INCLUDE	☐				0	0	Business partner credit standing data
49	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
50	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
51	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
52	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
53	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
54	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
55	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
56	EXTERNAL_REFNCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
57	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
58	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
59	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
60	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
61	INTERNAL_REFNCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
62	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
63	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
64	FACILITY_DEALNO	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
65	FACILITY_CCODE	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
66	DEAL_ACTIVE	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
67	RELEASE_STATUS	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
68	REVERSAL_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
69	CONFIRM_STATUS	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
70	CONFIRM_DATE	☐	TB_DCONF	DATUM	DATS	8	0	Confirmation Date
71	CONFIRM_USER	☐	TB_UCONF	USNAM	CHAR	12	0	Confirmation Executed By (User Responsible)
72	CNTRCONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
73	CNTRCONFIRM_DATE	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
74	CNTRCONFIRM_USER	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
75	CURRENCY	☐	FTI_WGSCHFT	WAERS	CUKY	5	0	Currency of Transaction	TCURC
76	CURRENCY_RCV	☐	FTI_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side of Transaction	TCURC
77	CURRENCY_PAY	☐	FTI_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side of Transaction	TCURC
78	NOM_AMOUNT	☐	FTI_NOMAMT	WERTV7	CURR	13	2	Nominal Amount
79	NOM_AMOUNT_RCV	☐	FTI_BGSCHF2	WERTV7	CURR	13	2	Nominal Amount: Incoming Side of Transaction
80	NOM_AMOUNT_PAY	☐	FTI_BGSCHF1	WERTV7	CURR	13	2	Nominal Amount: Outgoing Side of Transaction
81	UNITS	☐	FTI_POSITIONS_UNITS	TPM_UNITS	DEC	22	6	Units
82	LEAD_CURRENCY	☐	FTI_LWAERS	WAERS	CUKY	5	0	Leading Currency	TCURC
83	FOLL_CURRENCY	☐	FTI_FWAERS	WAERS	CUKY	5	0	Following Currency	TCURC
84	RATE	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
85	SPOTRATE	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
86	SWAPRATE	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
87	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
88	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
89	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
90	EFF_INT	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
91	EFF_INT_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
92	INT_CAT	☐	FTI_INTTYPE	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category
93	INT_CURRENT	☐	FTI_NOMINALZINS	DEC3_7	DEC	10	7	Nominal Interest Rate
94	INT_REF	☐	FTI_INTREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
95	INT_FORMULA	☐	FTI_XINTFORMULA	TEXT132	CHAR	132	0	String for Interest Formula
96	INT_STATUS	☐	FTI_INTSTATUS	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status
97	INT_NEXT_FIX	☐	FTI_NEXT_FIXDATE	DATUM	DATS	8	0	Next Interest Rate Adjustment Date
98	INT_AMOUNT	☐	FTI_INTAMOUNT	TPM_AMOUNT	CURR	21	2	Interest Amount
99	INT_CURRENCY	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
100	INT_CAT_IN	☐	FTI_INTTYPE_IN	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Incoming Side
101	INT_CURRENT_IN	☐	FTI_NOMINALZINS_IN	DEC3_7	DEC	10	7	Nominal Interest Rate of Incoming Side
102	INT_REF_IN	☐	FTI_INTREF_IN	ZIREFKU	CHAR	10	0	Reference Interest Rate Incoming Side	*
103	INT_FORMULA_IN	☐	FTI_XINTFORMULA_IN	TEXT132	CHAR	132	0	String for Interest Formula of Incoming Side
104	INT_STATUS_IN	☐	FTI_INTSTATUS_IN	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status: Incoming Side
105	INT_NEXT_FIX_IN	☐	FTI_NEXT_FIXDATE_IN	DATUM	DATS	8	0	Next Interest Rate Adjustment Date of Incoming Side
106	INT_AMOUNT_IN	☐	FTI_INTAMOUNT_IN	TPM_AMOUNT	CURR	21	2	Interest Amount of Incoming Side
107	INT_CURRENCY_IN	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
108	INT_CAT_OUT	☐	FTI_INTTYPE_OUT	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Outgoing Side
109	INT_CURRENT_OUT	☐	FTI_NOMINALZINS_OUT	DEC3_7	DEC	10	7	Nominal Interest Rate of Outgoing Side
110	INT_REF_OUT	☐	FTI_INTREF_OUT	ZIREFKU	CHAR	10	0	Reference Interest Rate of Outgoing Side	*
111	INT_FORMULA_OUT	☐	FTI_XINTFORMULA_OUT	TEXT132	CHAR	132	0	String for Interest Formula of Outgoing Side
112	INT_STATUS_OUT	☐	FTI_INTSTATUS_OUT	FTI_INTSTATUS	CHAR	1	0	Interest Fixing Status: Outgoing Side
113	INT_NEXT_FIX_OUT	☐	FTI_NEXT_FIXDATE_OUT	DATUM	DATS	8	0	Next Interest Rate Adjustment Date of Outgoing Side
114	INT_AMOUNT_OUT	☐	FTI_INTAMOUNT_OUT	TPM_AMOUNT	CURR	21	2	Interest Amount of Outgoing Side
115	INT_CURRENCY_OUT	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
116	EXERCISE_TYPE	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
117	PUT_CALL	☐	FTI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/Call Indicator
118	EXPIRATION_DATE	☐	FTI_DMATUR	DATUM	DATS	8	0	Exercise Date
119	STRIKE_CURRENCY	☐	FTI_OFWAERS	WAERS	CUKY	5	0	Strike Currency of Option/Future	*
120	STRIKE_AMOUNT	☐	FTI_OSTRIKE	WERTV7	CURR	13	2	Option Strike Amount
121	STRIKE_PRICE	☐	FTI_STRIKE_PRICE	DECV3_7	DEC	10	7	Strike Price (Upper Limit for Cap, Lower Limit for Floor)
122	SETTLEMENT_TYPE	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
123	OPTION_CATEGORY	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	*
124	DIR_STRIKEAMOUNT	☐	FTI_OSSIGN	T_SSIGN	CHAR	1	0	Direction of Strike Amount
125	BARRIER_CATEGORY	☐	TI_SLEVELT	T_SLEVELT	NUMC	2	0	Category of Knock-In/Knock-Out Level
126	LEAD_CURR_UL	☐	FTI_LWAERS_UL	WAERS	CUKY	5	0	Leading Currency of Underlying Transaction	*
127	FOLLOW_CURR_UL	☐	FTI_FWAERS_UL	WAERS	CUKY	5	0	Following Currency of Underlying Transaction	*
128	BARRIER	☐	TX_KWKURB1	TB_KKURS	DEC	13	9	Barrier as forex rate for exotic options
129	BARRIER2	☐	TX_KWKURB2	TB_KKURS	DEC	13	9	Barrier 2 as forex rate for exotic options
130	PREMIUM_AMT_PYC	☐	FTI_PREMIUM_PYC	WERTV7	CURR	13	2	Option Premium in Payment Currency
131	PREMIUM_AMT_LC	☐	FTI_PREMIUM_LC	WERTV7	CURR	13	2	Option Premium in Local Currency
132	PREMIUM_DATE	☐	FTI_PREMIUM_DATE	DATUM	DATS	8	0	Premium Payment Date
133	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
134	POSITION_CCY	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
135	LOCAL_CCY	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
136	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
137	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
138	NPV_LONG_PC	☐	TV_NPV_LONG_PC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Currency of Incoming Side
139	NPV_SHORT_PC	☐	TV_NPV_SHORT_PC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Currency of Outgoing Side
140	NPV_LONG_CC	☐	TV_NPV_LONG_CC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Evaluation Currency
141	NPV_SHORT_CC	☐	TV_NPV_SHORT_CC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Evaluation Currency
142	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
143	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
144	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
145	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
146	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
147	FW_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
148	CONVEXITY	☐	TV_CONVEXITY_MORE_ACCURATE	DEC6_5SIGN	DEC	11	5	Convexity with 5 Decimal Places
149	DELTA	☐	TV_DELTA	T_SENSI	DEC	15	10	Delta, 1st derivation of premium based on underlying rate
150	GAMMA	☐	TV_GAMMA	T_GAMMA	DEC	14	8	Gamma, 2nd derivation of premium based on underlying rate
151	THETA	☐	TV_THETA	T_SENSI	DEC	15	10	Theta, 1st derivation of premium according to time
152	VEGA	☐	TV_VEGA	T_SENSI	DEC	15	10	Vega, 1st Volatility Derivative
153	NUMBER_TRADED	☐	FTI_NUMBER_TRADED	ASTUECK	DEC	15	5	Traded Number of Units for Unit-Quoted Securities
154	NOM_AMT_TRADED	☐	FTI_NOMAMT_TRADED	WERTV7	CURR	13	2	Traded Nominal Amount
155	NOMORGAMT_TRADED	☐	FTI_NOMORGAMT_TRADED	WERTV7	CURR	13	2	Traded Original Nominal Amount
156	PRICE_TRADED	☐	FTI_PRICE_TRADED	FTI_PRICE_TRADED	DEC	15	6	Traded Price of Security (Mixed Representation)
157	PRICE_CCYUNT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
158	PRICE_CCYUNT_PRC	☐	FTI_QUOT_UNIT_PRCT	FTI_QUOT_UNIT_PRCT	CHAR	5	0	Quotation Currency Unit / Percent (Mixed Representation)
159	QUOTATION	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
160	MARKET_VAL_QC	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
161	QUOTATION_CCY	☐	FTI_QUOT_CCY	WAERS	CUKY	5	0	Quotation Currency	*
162	MARKET_VAL_CC	☐	FTI_MARKET_CC	TPM_AMOUNT	CURR	21	2	Market Value in Payment Currency
163	FX_RATE_TO_CC	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
164	MARKET_VAL_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
165	FX_RATE_TO_PC	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
166	MARKET_VAL_LC	☐	FTI_MARKET_LC	TPM_AMOUNT	CURR	21	2	Market Value in Local Currency
167	FX_RATE_TO_LC	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
168	HOUSEBNK_IN	☐	FTI_HBANK_IN	HBKID	CHAR	5	0	Short Key for Own House Bank: Incoming Side	*
169	HOUSEBNKACCT_IN	☐	FTI_HBACCT_IN	HKTID	CHAR	5	0	Short Key for House Bank Account: Incoming Side	*
170	PAYER_PAYEE_IN	☐	FTI_PAYERPAYEE_IN	BU_PARTNER	CHAR	10	0	Payer/Payee of Incoming Side	*
171	PARTNERBNK_IN	☐	FTI_PBANK_IN	BVTYP	CHAR	4	0	Partner Bank Details of Incoming Side
172	HOUSEBNK_OUT	☐	FTI_HBANK_OUT	HBKID	CHAR	5	0	Short Key for Own House Bank: Outgoing Side	*
173	HOUSEBNKACCT_OUT	☐	FTI_HBACCT_OUT	HKTID	CHAR	5	0	Short Key for House Bank Account: Outgoing Side	*
174	PAYER_PAYEE_OUT	☐	FTI_PAYERPAYEE_OUT	BU_PARTNER	CHAR	10	0	Payer/Payee of Outgoing Side	*
175	PARTNERBNK_OUT	☐	FTI_PBANK_OUT	BVTYP	CHAR	4	0	Partner Bank Details of Outgoing Side
176	PURCH_PC	☐	FTI_PURCH_PC	TPM_AMOUNT	CURR	21	2	Purchase Value in Position Currency
177	PURCH_LC	☐	FTI_PURCH_LC	TPM_AMOUNT	CURR	21	2	Purchase Value in Local Currency
178	AQU_VAL_PC	☐	FTI_AQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Position Currency
179	AQU_VAL_LC	☐	FTI_AQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Local Currency
180	BOOK_VAL_PC	☐	FTI_BOOK_VAL_PC	TPM_AMOUNT	CURR	21	2	Book Value in Position Currency
181	BOOK_VAL_LC	☐	FTI_BOOK_VAL_LC	TPM_AMOUNT	CURR	21	2	Book Value in Local Currency
182	VAL_TI_PC	☐	FTI_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency
183	VAL_TI_LC	☐	FTI_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency
184	VAL_FX_LC	☐	FTI_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency
185	VAL_TI_NPL_PC	☐	FTI_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in Position Currency
186	VAL_TI_NPL_LC	☐	FTI_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in Local Currency
187	VAL_FX_NPL_LC	☐	FTI_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Affecting P/L, in Local Crcy
188	SWAPACC_PC	☐	FTI_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Currency
189	SWAPACC_LC	☐	FTI_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap or Margin Accrual/Deferral in Local Currency
190	SWAPVAL_LC	☐	FTI_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency
191	SPOTVALP_LC	☐	FTI_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Purchase Currency in Local Currency
192	SPOTVALS_LC	☐	FTI_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Sale Currency in Local Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_TR_DEAL_MAIN	ABWTYP	AT05	ABWTYP
2	FTI_LDB_TR_DEAL_MAIN	ACTIVITY_CAT	AT02	SFGZUSTT
3	FTI_LDB_TR_DEAL_MAIN	CALC_CCY	TCURC	WAERS
4	FTI_LDB_TR_DEAL_MAIN	CNTRY_COMP	T005	LAND1
5	FTI_LDB_TR_DEAL_MAIN	COMPANYCODE	T001	BUKRS
6	FTI_LDB_TR_DEAL_MAIN	COUNTERPARTY	BUT000	PARTNER
7	FTI_LDB_TR_DEAL_MAIN	CURRENCY	TCURC	WAERS
8	FTI_LDB_TR_DEAL_MAIN	CURRENCY_PAY	TCURC	WAERS
9	FTI_LDB_TR_DEAL_MAIN	CURRENCY_RCV	TCURC	WAERS
10	FTI_LDB_TR_DEAL_MAIN	FOLL_CURRENCY	TCURC	WAERS
11	FTI_LDB_TR_DEAL_MAIN	GROUP_D	TP13	GROUP_D
12	FTI_LDB_TR_DEAL_MAIN	GROUP_ID	TB001	BU_GROUP
13	FTI_LDB_TR_DEAL_MAIN	GUARANTOR	BUT000	PARTNER
14	FTI_LDB_TR_DEAL_MAIN	IND_SECTOR	TB038A	IND_SECTOR
15	FTI_LDB_TR_DEAL_MAIN	ISTYPE	TB038	ISTYPE
16	FTI_LDB_TR_DEAL_MAIN	LEAD_CURRENCY	TCURC	WAERS
17	FTI_LDB_TR_DEAL_MAIN	LEGAL_ENTY	TB019	LEGAL_ENTY
18	FTI_LDB_TR_DEAL_MAIN	LEGAL_ORG	TB032	LEGAL_ORG
19	FTI_LDB_TR_DEAL_MAIN	MANDT	T000	MANDT
20	FTI_LDB_TR_DEAL_MAIN	NATION	T005	LAND1
21	FTI_LDB_TR_DEAL_MAIN	PRODUCT_CAT	TZAF	SANLF
22	FTI_LDB_TR_DEAL_MAIN	PRODUCT_TYPE	TZPA	GSART
23	FTI_LDB_TR_DEAL_MAIN	RATING	TP06	RATING
24	FTI_LDB_TR_DEAL_MAIN	REFERENCE_TYPE	ATR1	REFTYP
25	FTI_LDB_TR_DEAL_MAIN	REVERSAL_REASON	TZST	SSTOGRD
26	FTI_LDB_TR_DEAL_MAIN	SECURITY_ACCOUNT	TWD01	RLDEPO
27	FTI_LDB_TR_DEAL_MAIN	SOL_INS	TP07	SOL_INS
28	FTI_LDB_TR_DEAL_MAIN	STAFF_GRP	TP05	STAFF_GRP
29	FTI_LDB_TR_DEAL_MAIN	STATE	T005	LAND1
30	FTI_LDB_TR_DEAL_MAIN	TRADER	TZDEA	RDEALER
31	FTI_LDB_TR_DEAL_MAIN	TRANSACTION_CAT	AT01	SFGTYP
32	FTI_LDB_TR_DEAL_MAIN	TRANSACTION_TYPE	AT10	SFHAART
33	FTI_LDB_TR_DEAL_MAIN	VALUATION_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS

History

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