SAP ABAP Table FTI_BIW_DELTA_DEAL_ATTR (TR-BI: Transaction Master Data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ CFM_TR_BIW (Package) CFM: Connection to BW

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_BIW_DELTA_DEAL_ATTR	Table Relationship Diagram
Short Description	TR-BI: Transaction Master Data

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	*
2	BUKRS	☐	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	FLAG_DEAL_TYPE	☐	FTI_DEAL_TYPE	FTI_DEAL_TYPE	CHAR	1	0	Transaction Category - OTC / Non-OTC	*
5	OBJECTNUMBER	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
6	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
7	CREATE_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	CREATE_TIME	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	UPDATE_USER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
10	UPDATE_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
11	UPDATE_TIME	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
12	CONTRACT_TYPE	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
13	PRODUCT_CAT	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
14	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
15	TRANSACTION_CAT	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
16	ACTIVITY_CAT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
17	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
18	START_TERM	☐	FTI_DBLFZ_DEAL	DATUM	DATS	8	0	Start of Term
19	END_TERM	☐	FTI_DELFZ_DEAL	DATUM	DATS	8	0	End of Term
20	NOTICE_DATE	☐	TB_NOTICE_DATE	DATUM	DATS	8	0	OTC Notice Date
21	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
22	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
23	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
24	COUNTERPARTY	☐	TB_KONTRH	BU_PARTNER	CHAR	10	0	Counterparty	BUT000
25	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
26	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
27	EXTERNAL_REFNCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
28	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
29	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
30	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
31	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
32	INTERNAL_REFNCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
33	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
34	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
35	FACILITY_DEALNO	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
36	FACILITY_CCODE	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
37	DEAL_ACTIVE	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
38	RELEASE_STATUS	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
39	REVERSAL_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
40	CURRENCY	☐	FTI_WGSCHFT	WAERS	CUKY	5	0	Currency of Transaction	TCURC
41	CURRENCY_RCV	☐	FTI_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side of Transaction	TCURC
42	CURRENCY_PAY	☐	FTI_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side of Transaction	TCURC
43	NOM_AMOUNT	☐	FTI_NOMAMT	WERTV7	CURR	13	2	Nominal Amount
44	NOM_AMOUNT_RCV	☐	FTI_BGSCHF2	WERTV7	CURR	13	2	Nominal Amount: Incoming Side of Transaction
45	NOM_AMOUNT_PAY	☐	FTI_BGSCHF1	WERTV7	CURR	13	2	Nominal Amount: Outgoing Side of Transaction
46	LEAD_CURRENCY	☐	FTI_LWAERS	WAERS	CUKY	5	0	Leading Currency	TCURC
47	FOLL_CURRENCY	☐	FTI_FWAERS	WAERS	CUKY	5	0	Following Currency	TCURC
48	RATE	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
49	SPOTRATE	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
50	SWAPRATE	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
51	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
52	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
53	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
54	COMMODITY_ID	☐	FTI_COMM_ID	CHAR18	CHAR	18	0	Commodity ID
55	QUANTITY_TRADED	☐	FTI_CTY_QUAN_DELVRD		QUAN	25	5	Commodity Quantity to be delivered
56	COMMODITY_UOM	☐	TPM_CTY_UOM	MEINS	UNIT	3	0	Unit of measure for the Commodity	*
57	CONTRACT_PRICE	☐	FTI_CTY_PRICE		DEC	13	5	Commodity Contract price
58	CTY_SPOT_PRICE	☐	FTI_CTY_SPOT_PRC		DEC	13	5	Commodity spot price
59	CONT_BACK	☐	FTR_CONBACK		DEC	13	5	Commodity Contango / Backwardation
60	EFF_INT	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
61	EFF_INT_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
62	INT_CAT	☐	FTI_INTTYPE	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category
63	INT_RATE	☐	FTI_NOMINALZINS	DEC3_7	DEC	10	7	Nominal Interest Rate
64	INT_REF	☐	FTI_INTREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
65	INT_REF_SPRD	☐	FTI_VAR_OFFSET	DECV3_7	DEC	10	7	Spread for Reference Interest Rate (Variable Interest)
66	INT_CALMETHD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
67	INT_FORMULA	☐	FTI_XINTFORMULA	TEXT132	CHAR	132	0	String for Interest Formula
68	INT_AMOUNT	☐	FTI_INTAMOUNT	TPM_AMOUNT	CURR	21	2	Interest Amount
69	INT_CAT_IN	☐	FTI_INTTYPE_IN	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Incoming Side
70	INT_RATE_IN	☐	FTI_NOMINALZINS_IN	DEC3_7	DEC	10	7	Nominal Interest Rate of Incoming Side
71	INT_REF_IN	☐	FTI_INTREF_IN	ZIREFKU	CHAR	10	0	Reference Interest Rate Incoming Side	*
72	INT_REF_SPRD_IN	☐	FTI_SPREAD_IN	DECV3_7	DEC	10	7	Spread Rate Incoming Side
73	INT_CALMETHD_IN	☐	FTI_INTCALMETHD_IN	SZBMETH	CHAR	1	0	Interest Calculation Method of Incoming Side
74	INT_FORMULA_IN	☐	FTI_XINTFORMULA_IN	TEXT132	CHAR	132	0	String for Interest Formula of Incoming Side
75	INT_AMOUNT_IN	☐	FTI_INTAMOUNT_IN	TPM_AMOUNT	CURR	21	2	Interest Amount of Incoming Side
76	INT_CAT_OUT	☐	FTI_INTTYPE_OUT	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category of Outgoing Side
77	INT_RATE_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_REF_SPRD_OUT	☐	FTI_SPREAD_OUT	DECV3_7	DEC	10	7	Spread Rate Outgoing Side
80	INT_CALMETHD_OUT	☐	FTI_INTCALMETHD_OUT	SZBMETH	CHAR	1	0	Interest Calculation Method of Outgoing Side
81	INT_FORMULA_OUT	☐	FTI_XINTFORMULA_OUT	TEXT132	CHAR	132	0	String for Interest Formula of Outgoing Side
82	INT_AMOUNT_OUT	☐	FTI_INTAMOUNT_OUT	TPM_AMOUNT	CURR	21	2	Interest Amount of Outgoing Side
83	EXERCISE_TYPE	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
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	POSITION_CCY	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
97	LOCAL_CCY	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
98	NOM_AMT_TRADED	☐	FTI_NOMAMT_TRADED	WERTV7	CURR	13	2	Traded Nominal Amount
99	NOMORGAMT_TRADED	☐	FTI_NOMORGAMT_TRADED	WERTV7	CURR	13	2	Traded Original Nominal Amount
100	NUMBER_TRADED	☐	FTI_NUMBER_TRADED	ASTUECK	DEC	15	5	Traded Number of Units for Unit-Quoted Securities
101	PRICE_TRADED	☐	FTI_PRICE_TRADED	FTI_PRICE_TRADED	DEC	15	6	Traded Price of Security (Mixed Representation)
102	PRICE_CCYUNT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
103	PRICE_CCYUNT_PRC	☐	FTI_QUOT_UNIT_PRCT	FTI_QUOT_UNIT_PRCT	CHAR	5	0	Quotation Currency Unit / Percent (Mixed Representation)
104	QUOTATION	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
105	MARKET_VAL_QC	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
106	QUOTATION_CCY	☐	FTI_QUOT_CCY	WAERS	CUKY	5	0	Quotation Currency	*
107	MARKET_VAL_CC	☐	FTI_MARKET_CC	TPM_AMOUNT	CURR	21	2	Market Value in Payment Currency
108	FX_RATE_TO_CC	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
109	MARKET_VAL_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
110	FX_RATE_TO_PC	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
111	MARKET_VAL_LC	☐	FTI_MARKET_LC	TPM_AMOUNT	CURR	21	2	Market Value in Local Currency
112	FX_RATE_TO_LC	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
113	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
114	VALID_FROM	☐	VALID_FRM	DATUM	DATS	8	0	Valid From
115	VALID_TO	☐	VALID_TODAT	DATUM	DATS	8	0	Valid To

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in