SAP ABAP Table FTI_LDB_CLASS_MASTER_DATA (Harmonized Class Master Data from BAPI 1076)

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_CLASS_MASTER_DATA	Table Relationship Diagram
Short Description	Harmonized Class Master Data from BAPI 1076

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	.INCLUDE	☐				0	0	Common Fields for all Classes
2	.INCLUDE	☐				0	0	Header structure for financial product (FP)
3	SECURITY_NUMBER	☐	WP_RANL	WP_RANL	CHAR	13	0	Security ID number	VWPANLA
4	PRODUCT_CATEGORY	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
5	.INCLUDE	☐				0	0	Financial product parameter structure (general data)
6	SHORT_TEXT	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
7	LONG_TEXT	☐	XALLB	XLBEZ	CHAR	60	0	Long name
8	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
9	LISTED	☐	SEC_LISTED	ATXF1	CHAR	1	0	Indicator: Listed on an Exchange
10	QUOTATION	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
11	ISSUER	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	*
12	ISSUE_CURRENCY	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
13	ISSUE_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
14	ISSUE_PRICE	☐	VVKBEMPR	VVKWKURS	DEC	15	6	Issue price independent of currency
15	ISSUE_RATE	☐	PEMKURS	DEC3_7	DEC	10	7	Issue rate in percent
16	SSTBE	☐	SSTBE	JANEI	CHAR	1	0	Tax treatment indicator
17	SECURITY_CATEGORY	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	*
18	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
19	INSTITUTE	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	*
20	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	TCURC
21	BKOND	☐	TB_BKOND	WERTV7	CURR	13	2	Interest rate as amount
22	.INCLUDE	☐				0	0	Common Fields for all Fixed-Term Classes
23	TERM_FROM	☐	FTI_LDB_FP_TERMFROM	DATUM	DATS	8	0	Start of Term
24	TERM_UPTO	☐	FTI_LDB_FP_TERMUPTO	DATUM	DATS	8	0	End of Term
25	.INCLUDE	☐				0	0	Common Fields: Stocks, Shareholdings, Funds, and Bonds
26	SECURITY_TYPE	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	*
27	ELIGIBLE	☐	SEC_ELIGIBLE	ATXF1	CHAR	1	0	Eligibility indicator
28	ELIGIBLE_AS_COLL	☐	SEC_AS_COLL	ATXF1	CHAR	1	0	Indicator eligible as collateral
29	ELIGIBLE_TO_SERVE	☐	SEC_TO_SERVE	ATXF1	CHAR	1	0	Eligible for premium reserve fund
30	.INCLUDE	☐				0	0	Common Fields: Stocks, Shareholdings, and Funds
31	NOMINAL_VALUE_CI	☐	VVBNEWE	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
32	FELLOW_PARTNER	☐	JABMI	JANEI	CHAR	1	0	Joint partner vote indicator
33	CONDITION_VALID_FROM	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
34	.INCLUDE	☐				0	0	Common Fields: Stocks and Shareholdings
35	SHAREHOLDING_TYPE	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	*
36	SHAREHOLDING_STRUCT	☐	SKONBET	SKONBET	NUMC	2	0	Details about structure of shareholding	*
37	SHARES_OUTSTANDING	☐	AAAAKTIE	DEC12	DEC	12	0	Number of stocks issued
38	STOCK_CATEGORY	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
39	STOCK_FORM	☐	SVBRE	SVBRE	NUMC	1	0	Stock form indicator
40	.INCLUDE	☐				0	0	Only Fields for Stocks
41	INPAYMENT_RATE	☐	KZAHLAKT	DEC3_7	DEC	10	7	Pay-in rate
42	PAYMENT_AMOUNT	☐	BAPI_BZAHLAKT	BAPICURR	DEC	23	4	Pay-in amount
43	BALANCE_DATE	☐	DREST	DATUM	DATS	8	0	Balance payment date
44	DIVIDEND_RIGHTS	☐	PDIVBER	DEC3_7	DEC	10	7	Dividend rights per unit in percentage terms
45	ENTITLED_FROM	☐	DDBAB	DATUM	DATS	8	0	Date from which entitled to dividends
46	EXCHANGE_FROM	☐	DTFVO	DATUM	DATS	8	0	Swap period from
47	EXCHANGE_TO	☐	DTFBI	DATUM	DATS	8	0	Swap period to
48	EXCHANGE_NUMERATOR	☐	BTVZA	DEC5_4	DEC	9	4	Swap ratio - numerator
49	EXCHANGE_DENOMINATOR	☐	BTVNE	DEC5_4	DEC	9	4	Swap ratio - denominator
50	CLEARING_AMOUNT	☐	BAPI_BABTA	BAPICURR	DEC	23	4	Clearing amount for swap
51	CLEARING_CURRENCY	☐	SWHRAUSG	WAERS	CUKY	5	0	Clearing amount currency	*
52	CLEARING_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
53	TRADING_UNTIL	☐	DTGBI	DATUM	DATS	8	0	Trading until
54	.INCLUDE	☐				0	0	Only Fields for Funds
55	FUND_TYPE	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	*
56	FUND_CATEGORY	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
57	FUND_VOLUME	☐	BAPI_BFONVOL	BAPICURR	DEC	23	4	Fund volume
58	PUBLIC_FUND	☐	SOEFF	JANEI	CHAR	1	0	Public fund indicator
59	ISSUE_PREMIUM	☐	PAUSG	DEC3_7	DEC	10	7	Issue premium in percentage
60	FOREIGN_INVESTMENT_LAW	☐	SAING	JANEI	CHAR	1	0	Foreign Investment Law indicator
61	ACCUMULATION	☐	STHES	JANEI	CHAR	1	0	Reinvestment indicator
62	REINVESTMENT_DISCOUNT	☐	PWARB	DEC3_7	DEC	10	7	Reinvestment discount percent
63	.INCLUDE	☐				0	0	Common Fields: Bonds, Warrant Bonds, and Convertible Bonds
64	CLASSIFICATION	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	*
65	NOMINAL_VALUE	☐	BAPI_BNOMS	BAPICURR	DEC	23	4	Nominal value
66	TRADING_UNIT	☐	BAPI_BNHAE	BAPICURR	DEC	23	4	Nominal per trading unit
67	ISSUER_CALL	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
68	BONDHOLDER_CALL	☐	DKOBL	DATUM	DATS	8	0	Bondholder call date
69	SECONDARY_LOANS	☐	VVJNACHR	JANE	CHAR	1	0	Secondary loans ID
70	INCLUSIVE_INDICATOR	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
71	ISSUE_YIELD	☐	ISSUE_YIELD	DEC3_7	DEC	10	7	Issue Yield
72	PERCENTAGE_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
73	YIELD_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
74	YIELD_FREQUENCY	☐	VVZVRHYEFF	NUMC03	NUMC	3	0	Int.sttlmnt frequency for effective int.rate calc.in months
75	INTEREST_CALC_METHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
76	REPAYMENT_TYPE	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
77	CUTTING_DAYS	☐	BATRT	NUMC03	NUMC	3	0	Number of cutting days
78	DISCOUNTED	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
79	AMOUNT	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
80	CURRENCY	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
81	.INCLUDE	☐				0	0	Only Field for Bonds
82	REF_INTEREST_RATE	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
83	REF_SIGN	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
84	OBLIGATION_TO_OFFER	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
85	RIGHT_TO_OFFER	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
86	INT_CAT	☐	FTI_INTTYPE	FTI_INTEREST_TYPE	CHAR	1	0	Interest Category
87	.INCLUDE	☐				0	0	Only Fields for Convertible Bonds
88	CONV_PERIOD_FROM	☐	DWAFB	DATUM	DATS	8	0	Conversion period until
89	CONV_PERIOD_TO	☐	DWAFV	DATUM	DATS	8	0	Conversion period from
90	CONV_RATIO_NOMINATOR	☐	BWAVZ	DEC5_4	DEC	9	4	Conversion ratio - Numerator
91	CONV_RATIO_DENOMINATOR	☐	BWAVN	DEC5_4	DEC	9	4	Conversion ratio - Denominator
92	CONV_PREMIUM	☐	BAPI_BAUFP	BAPICURR	DEC	23	4	Conversion premium
93	CURRENCY_MARKUP	☐	RWAUF	WAERS	CUKY	5	0	Currency markup	*
94	CURRENCY_MARKUP_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
95	.INCLUDE	☐				0	0	Only Fields for Warrant Bonds
96	CUM_EX_INDICATOR	☐	SCUEX	SCUEX	NUMC	1	0	Cum/ex indicator
97	NUMBER_OF_WARRANTS	☐	BOPHE	NUM03	NUMC	3	0	Number of warrants per nominal value
98	.INCLUDE	☐				0	0	Only Fields for Drawable Bonds
99	DRAWING	☐	SEC_JAUSL	ATXF1	CHAR	1	0	Drawing Indicator
100	DRAWING_DATE	☐	DAUSL	DATUM	DATS	8	0	Drawing date
101	.INCLUDE	☐				0	0	Only Fields for Subscription Rights
102	COUPON_NUMBER	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
103	SUB_PRICE	☐	BAPI_BBPRU	BAPICURR	DEC	23	4	Underlying subscription price
104	SUB_CURRENCY	☐	RWBZP	WAERS	CUKY	5	0	Subscription price currency	TCURC
105	SUB_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
106	SUB_NUMERATOR	☐	BBVHZ	DEC5_4	DEC	9	4	Subscription ratio - Numerator
107	SUB_DENOMINATOR	☐	BBVHN	DEC5_4	DEC	9	4	Subscription ratio - Denominator
108	SUB_TRADING_FROM	☐	DBHAV	DATUM	DATS	8	0	Date of subscription rights trading from
109	SUB_TRADING_UNTIL	☐	DBHAB	DATUM	DATS	8	0	Date of subscription rights trading until
110	PRICE_REF_SHARE	☐	KREAK	VVKWKURS	DEC	15	6	Post Subscription Rights
111	DIVIDEND_ADV_DIS	☐	BAPI_BVNJA	BAPICURR	DEC	23	4	Advantage/disadvantage dividend of new stock
112	.INCLUDE	☐				0	0	Only Fields for Options/Futures
113	SETTLEMENT_METHOD	☐	TI_SABRMET	T_SABRMET	CHAR	1	0	Settlement Method Option
114	PUT_CALL_INDICATOR	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
115	SETTLEMENT_OPT	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
116	EXERCISE_TYPE_OPT	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
117	SECURITY_REFERENCE	☐	WP_RANL	WP_RANL	CHAR	13	0	Security ID number	*
118	OPT_FUT_CATEGORY	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
119	ORG_OPTTYPE	☐	TV_OPTTYP	T_OPTTYP	NUMC	3	0	Original option category (on closing)	*
120	OPT_FUT_QUOTATION	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
121	EXPIRY_DATE	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
122	LAST_TRADING_DAY	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
123	SETTLEMENT_DAY	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
124	FACTORY_CALENDAR	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
125	FINAL_DUE_DATE_F	☐	DENDF	DATUM	DATS	8	0	Final due date
126	SECURITY_INDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index
127	NUMBER_OF_UNITS	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
128	STRIKE_AMOUNT	☐	BAPI_TI_BSTRIKE	BAPICURR	DEC	23	4	Strike as amount
129	STRIKE_IN_POINTS	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
130	TICK_AMOUNT	☐	BAPI_TI_BETICK	BAPICURR	DEC	23	4	Tick as amount
131	TICK_IN_POINTS	☐	TI_PITICK	T_PKTKUR	DEC	11	6	Tick in index points
132	TICK_VALUE	☐	BAPI_TI_BWTICK	BAPICURR	DEC	23	4	Tick value
133	NOMINAL_VALUE_F	☐	BAPI_BNOMS	BAPICURR	DEC	23	4	Nominal value
134	INDEX_POINT_VALUE	☐	BAPI_TI_BPINDEX	BAPICURR	DEC	23	4	Value of an index point
135	.INCLUDE	☐				0	0	nur Felder Anleihe mit Ratentilgung
136	TRANCHE_CLASSIF	☐	VVTRANCHECL	VVTRANCHECL	NUMC	3	0	Tranche Classification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_CLASS_MASTER_DATA	ISSUE_CURRENCY	TCURC	WAERS		1	CN
2	FTI_LDB_CLASS_MASTER_DATA	PRODUCT_CATEGORY	TZAF	SANLF
3	FTI_LDB_CLASS_MASTER_DATA	PRODUCT_TYPE	TZPA	GSART		1	CN
4	FTI_LDB_CLASS_MASTER_DATA	SECURITY_NUMBER	VWPANLA	RANL
5	FTI_LDB_CLASS_MASTER_DATA	SUB_CURRENCY	TCURC	WAERS
6	FTI_LDB_CLASS_MASTER_DATA	SWHRKOND	TCURC	WAERS

History

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