SAP ABAP Table FTI_LDB_TR_SEC_DEAL_1 (Treasury: Transaction Reporting, Securities Main Data)

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_SEC_DEAL_1	Table Relationship Diagram
Short Description	Treasury: Transaction Reporting, Securities Main 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	T000
2	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
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	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
18	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
19	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
20	COUNTERPARTY	☐	TB_KONTRH	BU_PARTNER	CHAR	10	0	Counterparty	BUT000
21	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
22	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
23	EXTERNAL_REFNCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
24	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
25	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
26	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
27	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
28	INTERNAL_REFNCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
29	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
30	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
31	DEAL_ACTIVE	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
32	RELEASE_STATUS	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
33	CONFIRM_STATUS	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
34	CONFIRM_DATE	☐	TB_DCONF	DATUM	DATS	8	0	Confirmation Date
35	CONFIRM_USER	☐	TB_UCONF	USNAM	CHAR	12	0	Confirmation Executed By (User Responsible)
36	CNTRCONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
37	CNTRCONFIRM_DATE	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
38	CNTRCONFIRM_USER	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
39	CURRENCY	☐	FTI_WGSCHFT	WAERS	CUKY	5	0	Currency of Transaction	TCURC
40	NOM_AMOUNT	☐	FTI_NOMAMT	WERTV7	CURR	13	2	Nominal Amount
41	UNITS	☐	FTI_POSITIONS_UNITS	TPM_UNITS	DEC	22	6	Units
42	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
43	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
44	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
45	POSITION_CCY	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
46	LOCAL_CCY	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	*
47	NOMORGAMT_TRADED	☐	FTI_NOMORGAMT_TRADED	WERTV7	CURR	13	2	Traded Original Nominal Amount
48	NOM_AMT_TRADED	☐	FTI_NOMAMT_TRADED	WERTV7	CURR	13	2	Traded Nominal Amount
49	NUMBER_TRADED	☐	FTI_NUMBER_TRADED	ASTUECK	DEC	15	5	Traded Number of Units for Unit-Quoted Securities
50	PRICE_CCYUNT_PRC	☐	FTI_QUOT_UNIT_PRCT	FTI_QUOT_UNIT_PRCT	CHAR	5	0	Quotation Currency Unit / Percent (Mixed Representation)
51	PRICE_CCYUNT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
52	PRICE_TRADED	☐	FTI_PRICE_TRADED	FTI_PRICE_TRADED	DEC	15	6	Traded Price of Security (Mixed Representation)
53	QUOTATION	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
54	MARKET_VAL_QC	☐	TB_BEBETR	WERTV7	CURR	13	2	Market Value in Quotation Currency
55	QUOTATION_CCY	☐	FTI_QUOT_CCY	WAERS	CUKY	5	0	Quotation Currency	*
56	MARKET_VAL_CC	☐	FTI_MARKET_CC	TPM_AMOUNT	CURR	21	2	Market Value in Payment Currency
57	FX_RATE_TO_CC	☐	TB_KZWKURS	UKURS	DEC	9	5	Payment currency rate
58	MARKET_VAL_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
59	FX_RATE_TO_PC	☐	TB_KBWKURS	UKURS	DEC	9	5	Position currency rate
60	MARKET_VAL_LC	☐	FTI_MARKET_LC	TPM_AMOUNT	CURR	21	2	Market Value in Local Currency
61	FX_RATE_TO_LC	☐	TB_KHWKURS	UKURS	DEC	9	5	Local currency rate
62	HOUSEBNK_IN	☐	FTI_HBANK_IN	HBKID	CHAR	5	0	Short Key for Own House Bank: Incoming Side	*
63	HOUSEBNKACCT_IN	☐	FTI_HBACCT_IN	HKTID	CHAR	5	0	Short Key for House Bank Account: Incoming Side	*
64	PAYER_PAYEE_IN	☐	FTI_PAYERPAYEE_IN	BU_PARTNER	CHAR	10	0	Payer/Payee of Incoming Side	*
65	PARTNERBNK_IN	☐	FTI_PBANK_IN	BVTYP	CHAR	4	0	Partner Bank Details of Incoming Side
66	HOUSEBNK_OUT	☐	FTI_HBANK_OUT	HBKID	CHAR	5	0	Short Key for Own House Bank: Outgoing Side	*
67	HOUSEBNKACCT_OUT	☐	FTI_HBACCT_OUT	HKTID	CHAR	5	0	Short Key for House Bank Account: Outgoing Side	*
68	PAYER_PAYEE_OUT	☐	FTI_PAYERPAYEE_OUT	BU_PARTNER	CHAR	10	0	Payer/Payee of Outgoing Side	*
69	PARTNERBNK_OUT	☐	FTI_PBANK_OUT	BVTYP	CHAR	4	0	Partner Bank Details of Outgoing Side
70	EFF_INT	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
71	EFF_INT_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in