SAP ABAP Table FTI_LDB_TR_ATTR_LOAN (Loan 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_LOAN	Table Relationship Diagram
Short Description	Loan 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	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
4	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
5	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
6	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
7	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
8	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
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	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
12	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
13	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
14	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
15	RISK_PARTNER	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
16	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
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	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
23	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
24	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
25	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
26	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
27	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	*
28	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_LOAN	BUKRS	T001	BUKRS
2	FTI_LDB_TR_ATTR_LOAN	GSART	TZPA	GSART
3	FTI_LDB_TR_ATTR_LOAN	HKONT	SKB1	SAKNR
4	FTI_LDB_TR_ATTR_LOAN	LOANS_CONTRACT	VDARL	RANL
5	FTI_LDB_TR_ATTR_LOAN	MANDT	T000	MANDT
6	FTI_LDB_TR_ATTR_LOAN	PORTFOLIO	TWPOB	RPORTB
7	FTI_LDB_TR_ATTR_LOAN	RDEALER	TZDEA	RDEALER
8	FTI_LDB_TR_ATTR_LOAN	RISK_PARTNER	BUT000	PARTNER
9	FTI_LDB_TR_ATTR_LOAN	RMAID	VTBMA	RMAID
10	FTI_LDB_TR_ATTR_LOAN	RREFKONT_R	T037S	RREFKONT
11	FTI_LDB_TR_ATTR_LOAN	SANLF	TZAF	SANLF
12	FTI_LDB_TR_ATTR_LOAN	SBILK	TW11	SBILK
13	FTI_LDB_TR_ATTR_LOAN	SECURITY_ACCOUNT	TWD01	RLDEPO

History

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