SAP ABAP Table FTI_LDB_TR_ATTR_DEAL (Transaction Attributes Used in the Logical Database)

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_ATTR_DEAL	Table Relationship Diagram
Short Description	Transaction Attributes Used in the Logical Database

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	VTBFHA
4	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
5	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
6	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
8	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
9	RANTYP_R	☐	FTI_RANTYP	FTI_RANTYP	CHAR	1	0	Contract type
10	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
11	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
12	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
13	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
14	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
15	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
16	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
17	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
18	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
19	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
20	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
21	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
22	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
23	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
24	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
25	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
26	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
27	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
28	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
29	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
30	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
31	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	TP07
32	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	TP06
33	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
34	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	*
35	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	*
36	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	*
37	NOMINAL_AMT_PC	☐	FTI_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Nominal Amount in Position Currency
38	NOMINAL_AMT_OUT_PC	☐	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
39	NOMINAL_AMT_IN_PC	☐	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
40	INT_CAT	☐	FTI_INTTYPE	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_TR_ATTR_DEAL	BUKRS	T001	BUKRS
2	FTI_LDB_TR_ATTR_DEAL	DEAL_NUMBER	VTBFHA	RFHA
3	FTI_LDB_TR_ATTR_DEAL	GSART	TZPA	GSART
4	FTI_LDB_TR_ATTR_DEAL	HKONT	SKB1	SAKNR
5	FTI_LDB_TR_ATTR_DEAL	PARTNR	BUT000	PARTNER
6	FTI_LDB_TR_ATTR_DEAL	PORTFOLIO	TWPOB	RPORTB
7	FTI_LDB_TR_ATTR_DEAL	RATING_RANL	TP06	RATING
8	FTI_LDB_TR_ATTR_DEAL	RDEALER	TZDEA	RDEALER
9	FTI_LDB_TR_ATTR_DEAL	RGARANT	BUT000	PARTNER
10	FTI_LDB_TR_ATTR_DEAL	RMAID	VTBMA	RMAID
11	FTI_LDB_TR_ATTR_DEAL	RREFKONT_R	T037S	RREFKONT
12	FTI_LDB_TR_ATTR_DEAL	SANLF	TZAF	SANLF
13	FTI_LDB_TR_ATTR_DEAL	SBWHR	TCURC	WAERS
14	FTI_LDB_TR_ATTR_DEAL	SFGTYP	AT01	SFGTYP
15	FTI_LDB_TR_ATTR_DEAL	SFHAART	AT10	SFHAART
16	FTI_LDB_TR_ATTR_DEAL	SOL_INS_RANL	TP07	SOL_INS

History

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