SAP ABAP Table FTI_LDB_TR_ATTR_SEC (Class 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_SEC	Table Relationship Diagram
Short Description	Class 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	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
3	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
4	RANTYP_R	☐	FTI_RANTYP	FTI_RANTYP	CHAR	1	0	Contract type
5	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
6	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
8	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
9	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
10	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
11	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
12	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	*
13	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
14	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
15	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
16	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	TP07
17	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	TP06
18	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
19	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
20	SFOART	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
21	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
22	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
23	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
24	AAAAKTIE	☐	FTI_AAAKTIE	DEC12	DEC	12	0	Number of stocks issued
25	KBNEWE	☐	VVBNEWE	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
26	KZAHLAKT	☐	KZAHLAKT	DEC3_7	DEC	10	7	Pay-in rate
27	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
28	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
29	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
30	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
31	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	*
32	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
33	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_SEC	ALWPKL	TW22	ALWPKL
2	FTI_LDB_TR_ATTR_SEC	GSART	TZPA	GSART
3	FTI_LDB_TR_ATTR_SEC	RATING_RANL	TP06	RATING
4	FTI_LDB_TR_ATTR_SEC	SANLF	TZAF	SANLF
5	FTI_LDB_TR_ATTR_SEC	SARTBET	TW02	SARTBET
6	FTI_LDB_TR_ATTR_SEC	SECURITY_ID	VWPANLA	RANL
7	FTI_LDB_TR_ATTR_SEC	SFOTY	TW21	SFOTY
8	FTI_LDB_TR_ATTR_SEC	SOL_INS_RANL	TP07	SOL_INS
9	FTI_LDB_TR_ATTR_SEC	SWERTTYP	TW20	SWERTTYP
10	FTI_LDB_TR_ATTR_SEC	SWPKLASS	TW01	SWPKLASS
11	FTI_LDB_TR_ATTR_SEC	SZSREF	T056R	REFERENZ

History

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