SAP ABAP Table FTI_LDB_TR_POS_DEAL_ATTR (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_POS_DEAL_ATTR	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	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
4	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
5	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
6	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
7	STICHTAG	☐	FTI_STICHTAG	VVSTDAT	DATS	8	0	Key Date
8	RANTYP_R	☐	FTI_RANTYP	FTI_RANTYP	CHAR	1	0	Contract type
9	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
10	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
11	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
12	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
13	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
14	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
15	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
16	RISK_PARTNER	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
17	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
18	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
19	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
20	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
21	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
22	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
23	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
24	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
25	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
26	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
27	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
28	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
29	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	*

Foreign Keys

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

History

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