SAP ABAP Table SECURITY_COMPLEX (Complex Structure of Class Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

Table Category	INTTAB	Structure
Structure	SECURITY_COMPLEX	Table Relationship Diagram
Short Description	Complex Structure of Class Data

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	Parameters for all securities
2	.INCLUDE	☐				0	0	Financial product parameter structure (general data)
3	SECURITY_NUMBER	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
4	SHORT_TEXT	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
5	LONG_TEXT	☐	XALLB	XLBEZ	CHAR	60	0	Long name
6	PRODUCT_CATEGORY	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
7	PRODUCT_CATEGORY_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
8	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
9	PRODUCT_TYPE_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
10	LISTED	☐	SEC_LISTED	ATXF1	CHAR	1	0	Indicator: Listed on an Exchange
11	QUOTATION	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
12	ISSUER	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	BUT000
13	ISSUER_TEXT	☐	LINES	LINES	CHAR	80	0	Address line
14	ISSUE_CURRENCY	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
15	ISSUE_PRICE	☐	VVKBEMPR	VVKWKURS	DEC	15	6	Issue price independent of currency
16	ISSUE_RATE	☐	PEMKURS	DEC3_7	DEC	10	7	Issue rate in percent
17	CLASSIFICATION	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
18	INSTITUTE	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
19	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
20	FUNDED	☐	SEC_FUNDED	ATXF1	CHAR	1	0	Indicator: Funded
21	PRICE_INDEX	☐	TIDX_INDEX_NAME	TIDX_INDEX_NAME	CHAR	15	0	Name of Price Index	TIDX_PRICE_INDEX
22	.INCLUDE	☐				0	0	Common parameters for stocks and bonds
23	SECURITY_TYPE	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
24	ELIGIBLE	☐	SEC_ELIGIBLE	ATXF1	CHAR	1	0	Eligibility indicator
25	ELIGIBLE_AS_COLL	☐	SEC_AS_COLL	ATXF1	CHAR	1	0	Indicator eligible as collateral
26	ELIGIBLE_TO_SERVE	☐	SEC_TO_SERVE	ATXF1	CHAR	1	0	Eligible for premium reserve fund
27	ISSUE_START	☐	DEBEG	DATUM	DATS	8	0	Issue start date
28	SMOVERW	☐	SMOVERW	SMOVERW	CHAR	2	0	Possible custody type	*
29	SDEPOSTAT	☐	VVDEPOSTAT	VVDEPOSTA	NUMC	2	0	Securities account statistics key	*
30	SSTBE	☐	SSTBE	JANEI	CHAR	1	0	Tax treatment indicator
31	SWPHGMPF	☐	VVSWPHGMPF	JANEI	CHAR	1	0	Securities trading law reporting obligation indicator
32	JNACHR	☐	VVJNACHR	JANE	CHAR	1	0	Secondary loans ID
33	CALC_BEGIN	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
34	.INCLUDE	☐				0	0	Parameters for stocks, investment certif. and shareholdings
35	NOMINAL_VALUE_S	☐	VVBNEWE	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
36	FELLOW_PARTNER	☐	SEC_FELLOW_PARTNER	ANKREUZ	CHAR	1	0	Joint partner vote indicator
37	CONDITION_VALID_FROM	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
38	.INCLUDE	☐				0	0	Financial product parameter structure (bonds)
39	SECURITY_CATEGORY	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
40	BONDCLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
41	NOMINAL_VALUE_B	☐	BNOMS	BWHR	CURR	13	2	Nominal value
42	TRADING_UNIT	☐	BNHAE	BWHR	CURR	13	2	Nominal per trading unit
43	ISSUER_CALL	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
44	BONDHOLDER_CALL	☐	DKOBL	DATUM	DATS	8	0	Bondholder call date
45	SECONDARY_LOANS	☐	VVJNACHR	JANE	CHAR	1	0	Secondary loans ID
46	DRAWING	☐	SEC_JAUSL	ATXF1	CHAR	1	0	Drawing Indicator
47	DRAWING_DATE	☐	DAUSL	DATUM	DATS	8	0	Drawing date
48	FINAL_DUE_DATE	☐	DELFZ	DATUM	DATS	8	0	End of Term
49	INCLUSIVE_INDICATOR	☐	VVWSINCL	XFELD	CHAR	1	0	Inclusive indicator
50	ISSUE_YIELD	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
51	YIELD_METHOD	☐	SEFFMETH_NEW	SEFFMETH_NEW	NUMC	1	0	Effective Interest Method (Financial Mathematics)
52	YIELD_FREQUENCY	☐	VVZVRHYEFF	NUMC03	NUMC	3	0	Int.sttlmnt frequency for effective int.rate calc.in months
53	INTEREST_CALC_METHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
54	REPAYMENT_TYPE	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
55	CUTTING_DAYS	☐	BATRT	NUMC03	NUMC	3	0	Number of cutting days
56	DISCOUNTED	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
57	CALENDAR_WT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
58	ROUNDING_RULE	☐	TPM_ROUNDING_RULE	TPM_ROUNDING_RULE	CHAR	4	0	Rounding Rule	TRSC_ROUND_RULE
59	SET_NAME	☐	RDPT_SET_NAME	RDPT_SET_NAME	CHAR	15	0	Redemption Schedule Set	*
60	.INCLUDE	☐				0	0	Common attributes for options and futures
61	FACTORY_CALENDAR	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
62	OPT_FUT_CATEGORY	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
63	OPT_FUT_QUOTATION	☐	TI_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type option/future
64	MARGIN_TYPE	☐	TB_MARGART	T_MARGART	CHAR	5	0	Margin type	*
65	TICK_IN_PERCENT	☐	TI_PPTICK	DECV3_7	DEC	10	7	Tick in percentage points
66	TICK_AMOUNT	☐	TI_BETICK	WERTV7	CURR	13	2	Tick as amount
67	TICK_IN_POINTS	☐	TI_PITICK	T_PKTKUR	DEC	11	6	Tick in index points
68	TICK_VALUE	☐	TI_BWTICK	WERTV7	CURR	13	2	Tick value
69	TICK_CURRENCY	☐	TI_WWTICK	WAERS	CUKY	5	0	Tick Value Currency	*
70	LAST_TRADING_DAY	☐	TI_DLHAND	DATUM	DATS	8	0	Last trade date
71	SETTLEMENT_DAY	☐	TI_DERFUE	DATUM	DATS	8	0	Settlement date
72	EXPIRY_DATE	☐	TI_DVERF	DATUM	DATS	8	0	Expiration date
73	REFERENCE_DATE	☐	TI_DREFDAT	DATUM	DATS	8	0	Reference date
74	LAST_TRADING_DAY_X	☐	TI_XLHAND	T_XDATUM	CHAR	10	0	Last trade date
75	SETTLEMENT_DAY_X	☐	TI_XERFUE	T_XDATUM	CHAR	10	0	Settlement date
76	EXPIRY_DATE_X	☐	TI_XVERF	T_XDATUM	CHAR	10	0	Expiration date
77	.INCLUDE	☐				0	0	Financial product parameter structure (warrant)
78	OPTION_CATEGORY	☐	SOPTTYP	SOPTTYP	NUMC	1	0	Indicator: Option Category
79	TERM_FROM	☐	DLAVO	DATUM	DATS	8	0	Term from
80	TERM_UPTO	☐	DLABI	DATUM	DATS	8	0	Term to
81	EXERCISE_TYPE	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
82	EXERCISE_MIN	☐	AMINDEST	ASTUECK	DEC	15	5	Exercise minimum
83	DENOMINATOR	☐	BOVNE	DEC5_4	DEC	9	4	Option ratio - Denominator
84	NUMERATOR	☐	BOVZA	DEC5_4	DEC	9	4	Option ratio - numerator
85	.INCLUDE	☐				0	0	Common parameters for bond and currency warrants
86	REFERENCE_UNITS	☐	VVBBEZEIN	BWHR	CURR	13	2	Reference units
87	REFERENCE_CURRENCY	☐	VVRBEZEIN	WAERS	CUKY	5	0	Reference unit currency	TCURC
88	.INCLUDE	☐				0	0	Financial product parameter structure (equity warrant)
89	SETTLEMENT	☐	SVERROPT	SVERROPT	NUMC	1	0	Option Settlement Indicator
90	UNDERLYING	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
91	UNDERLYING_TEXT	☐	XALLB	XLBEZ	CHAR	60	0	Long name
92	UNDERLYING2	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
93	UNDERLYING2_TEXT	☐	XALLB	XLBEZ	CHAR	60	0	Long name
94	.INCLUDE	☐				0	0	Common parameters for equity and currency warrants
95	EXERCISE_PRICE	☐	BBASPREI	BWHR	CURR	13	2	Exercise price
96	EXERCISE_CURRENCY	☐	RWHRBAS	WAERS	CUKY	5	0	Exercise price currency	TCURC
97	.INCLUDE	☐				0	0	Stock and shareholding parameters
98	STOCK_CATEGORY	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
99	STOCK_FORM	☐	SVBRE	SVBRE	NUMC	1	0	Stock form indicator
100	SHAREHOLDING_TYPE	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
101	SHAREHOLDING_STRUCT	☐	SKONBET	SKONBET	NUMC	2	0	Details about structure of shareholding	TW03
102	SHARES_OUTSTANDING	☐	AAAAKTIE	DEC12	DEC	12	0	Number of stocks issued
103	INPAYMENT_RATE	☐	KZAHLAKT	DEC3_7	DEC	10	7	Pay-in rate
104	PAYMENT_AMOUNT	☐	BZAHLAKT	WHRBTRG	CURR	10	2	Amount Deposited
105	BALANCE_DATE	☐	DREST	DATUM	DATS	8	0	Balance payment date
106	DIVIDEND_RIGHTS	☐	PDIVBER	DEC3_7	DEC	10	7	Dividend rights per unit in percentage terms
107	ENTITLED_FROM	☐	DDBAB	DATUM	DATS	8	0	Date from which entitled to dividends
108	EXCHANGE_FROM	☐	DTFVO	DATUM	DATS	8	0	Swap period from
109	EXCHANGE_TO	☐	DTFBI	DATUM	DATS	8	0	Swap period to
110	EXCHANGE_NUMERATOR	☐	BTVZA	DEC5_4	DEC	9	4	Swap ratio - numerator
111	EXCHANGE_DENOMINATOR	☐	BTVNE	DEC5_4	DEC	9	4	Swap ratio - denominator
112	CLEARING_AMOUNT	☐	BABTA	WHRBTRG	CURR	10	2	Clearing amount for swap
113	CLEARING_CURRENCY	☐	SWHRAUSG	WAERS	CUKY	5	0	Clearing amount currency	*
114	TRADING_UNTIL	☐	DTGBI	DATUM	DATS	8	0	Trading until
115	PARTLY_PAYED	☐	SEC_PARTLY_PAYED	ANKREUZ	CHAR	1	0	Partly paid stock
116	.INCLUDE	☐				0	0	Investment certificate parameters
117	FUND_TYPE	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
118	FUND_CATEGORY	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
119	FUND_VOLUME	☐	BFONVOL	WERT8	CURR	15	2	Fund volume
120	PUBLIC_FUND	☐	SEC_SOEFF	ATXF1	CHAR	1	0	Public fund indicator
121	ISSUE_PREMIUM	☐	PAUSG	DEC3_7	DEC	10	7	Issue premium in percentage
122	FOREIGN_INVESTMENT_LAW	☐	SEC_SAING	ATXF1	CHAR	1	0	Foreign Investment Law indicator
123	ACCUMULATION	☐	SEC_ACCUMULATION	ANKREUZ	CHAR	1	0	Reinvestment indicator
124	REINVESTMENT_DISCOUNT	☐	PWARB	DEC3_7	DEC	10	7	Reinvestment discount percent
125	.INCLUDE	☐				0	0	Subscription rights
126	.INCLUDE	☐				0	0	Subscription period for subscription rights
127	COUPON_NUMBER	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
128	SUB_PRICE	☐	BBPRU	VVBNENNW	CURR	10	2	Underlying subscription price
129	SUB_CURRENCY	☐	RWBZP	WAERS	CUKY	5	0	Subscription price currency	*
130	SUB_NUMERATOR	☐	BBVHZ	DEC5_4	DEC	9	4	Subscription ratio - Numerator
131	SUB_DENOMINATOR	☐	BBVHN	DEC5_4	DEC	9	4	Subscription ratio - Denominator
132	SUB_PERIOD_FROM	☐	DBFRV	DATUM	DATS	8	0	Subscription period from
133	SUB_PERIOD_UNTIL	☐	DBFRB	DATUM	DATS	8	0	Date subscription period until
134	SUB_TRADING_FROM	☐	DBHAV	DATUM	DATS	8	0	Date of subscription rights trading from
135	SUB_TRADING_UNTIL	☐	DBHAB	DATUM	DATS	8	0	Date of subscription rights trading until
136	PRICE_REF_SHARE	☐	KREAK	VVKWKURS	DEC	15	6	Post Subscription Rights
137	DIVIDEND_ADV_DIS	☐	BVNJA	WHRBTRG	CURR	10	2	Advantage/disadvantage dividend of new stock
138	.INCLUDE	☐				0	0	Bond parameters
139	OBLIGATION_TO_OFFER	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
140	RIGHT_TO_OFFER	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
141	.INCLUDE	☐				0	0	Convertible bond parameters
142	CONV_PERIOD_FROM	☐	DWAFV	DATUM	DATS	8	0	Conversion period from
143	CONV_PERIOD_TO	☐	DWAFB	DATUM	DATS	8	0	Conversion period until
144	CONV_RATIO_NUMERATOR	☐	BWAVZ	DEC5_4	DEC	9	4	Conversion ratio - Numerator
145	CONV_RATIO_DENOMINATOR	☐	BWAVN	DEC5_4	DEC	9	4	Conversion ratio - Denominator
146	CONV_PREMIUM	☐	BAUFP	BWHR	CURR	13	2	Premium when converting a convertible bond
147	CURRENCY_MARKUP	☐	RWAUF	WAERS	CUKY	5	0	Currency markup	TCURC
148	.INCLUDE	☐				0	0	Warrant bonds parameters
149	CUM_EX_INDICATOR	☐	SCUEX	SCUEX	NUMC	1	0	Cum/ex indicator
150	NUMBER_OF_WARRANTS	☐	BOPHE	NUM03	NUMC	3	0	Number of warrants per nominal value
151	.INCLUDE	☐				0	0	Financial product parameter structure (index warrant)
152	SECURITY_INDEX	☐	IDX	CHAR10	CHAR	10	0	Securities Index	INDEXD
153	INDEX_TEXT	☐	XKURZBEZ	XKBEZ	CHAR	15	0	Short name for ATAB tables
154	INDEX_MARK	☐	BINDEX	BWHR	CURR	13	2	Index point per monetary unit
155	INDEX_BASE	☐	VVBASIS	DEC5_3	DEC	8	3	Index base
156	INDEX_CURRENCY	☐	RINDWHR	WAERS	CUKY	5	0	Index currency	TCURC
157	.INCLUDE	☐				0	0	Financial product parameter structure (bond warrant)
158	BASIC_RATE	☐	PBASKURS	DEC3_7	DEC	10	7	Basic rate
159	.INCLUDE	☐				0	0	Attributes for options
160	SETTLEMENT_METHOD	☐	TI_SABRMET	T_SABRMET	CHAR	1	0	Settlement Method Option
161	PUT_CALL_INDICATOR	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
162	SETTLEMENT_OPT	☐	TI_SETTLFL	T_SETTLFL	CHAR	1	0	Settlement indicator
163	EXERCISE_TYPE_OPT	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
164	NUMBER_OF_UNITS	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
165	SECURITY_REFERENCE	☐	WP_RANL	WP_RANL	CHAR	13	0	Security ID number	*
166	STRIKE_AMOUNT	☐	TI_BSTRIKE	WERTV7	CURR	13	2	Strike as amount
167	STRIKE_CURRENCY	☐	TI_WSTRIKE	WAERS	CUKY	5	0	Strike Currency	TCURC
168	STRIKE_IN_PERCENT	☐	TI_IPSTRIK	DECV3_7	DEC	10	7	Strike as inverted percentage notation
169	STRIKE_IN_POINTS	☐	TI_PKSTRIK	DEC5_4	DEC	9	4	Strike in points
170	INDEX_POINT_VALUE	☐	TI_BPINDEX	WERTV7	CURR	13	2	Value of an index point
171	INDEX_P_CURRENCY	☐	TI_WPINDEX	WAERS	CUKY	5	0	Index point currency	TCURC
172	.INCLUDE	☐				0	0	Attributes for futures
173	NOMINAL_VALUE_F_X	☐	TI_XNOMS	CHAR18	CHAR	18	0	Nominal value
174	NOMINAL_CURRENCY	☐	RNWHR	WAERS	CUKY	5	0	Nominal currency	TCURC
175	PERCENTAGE_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
176	INTEREST_CALC_F	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
177	REF_INTEREST_RATE	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
178	REF_INTEREST_RATE_TEXT	☐	KUZITEXT	TEXT15	CHAR	15	0	Short Text for Reference Interest Rate
179	FINAL_DUE_DATE_F	☐	DENDF	DATUM	DATS	8	0	Final due date
180	FINAL_DUE_DATE_F_X	☐	TI_XENDF	T_XDATUM	CHAR	10	0	Final due date
181	NOMINAL_VALUE_F	☐	BNOMS	BWHR	CURR	13	2	Nominal value
182	.INCLUDE	☐				0	0	Field string for user data maintenance
183	ENTERED_BY	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
184	INITIAL_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
185	INITIAL_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
186	INITIAL_SOURCE	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
187	EMPLOYEE_ID	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
188	LAST_EDIT_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
189	LAST_EDIT_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
190	LAST_EDIT_SOURCE	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
191	.INCLUDE	☐				0	0	Internal fields which are not visible in the interface
192	STATUS	☐	SEC_STATUS	SEC_STATUS	NUMC	2	0	Status of a security
193	OBJECT_KEY	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
194	.INCLUDE	☐				0	0	Attributes for an ABS
195	POOL_ID	☐	VVPOOLID		CHAR	13	0	Pool ID
196	EXP_MAT_DATE	☐	VVEXPMATDATE	DATE	DATS	8	0	Expected End of Term
197	POOL_CLASSIF	☐	VVPOOLCL	VVPOOLCL	NUMC	3	0	Asset Pool Classification	VWIRPPOOLCLASSIF
198	POOL_VOLUME	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
199	REINV_PERIOD	☐	TPM_REINV_PERIOD	DATS	DATS	8	0	Reinvestment Period
200	TRANCHE_CLASSIF	☐	VVTRANCHECL	VVTRANCHECL	NUMC	3	0	Tranche Classification	VWIRPTRANCLASSIF
201	CONDITIONS	☐	SECURITY_CONDITIONS		TTYP	0	0
202	ADD_ISSUER	☐	SECURITY_ISSUERS		TTYP	0	0
203	REFS	☐	SECURITY_REFERENCES		TTYP	0	0
204	LISTINGS	☐	SECURITY_LISTINGS		TTYP	0	0
205	INDICES	☐	SECURITY_INDICES		TTYP	0	0
206	PERIODS	☐	SECURITY_SUBSCRIPTIONPERIODS		TTYP	0	0
207	RIGHTS	☐	RIGHTS_COMPLEX		TTYP	0	0
208	SHARE_CAPITALS	☐	SECURITY_SHARE_CAPITALS		TTYP	0	0
209	INTERNAL	☐	SECURITY_INTERNAL		STRU	0	0
210	STATUS	☐	SEC_STATUS	SEC_STATUS	NUMC	2	0	Status of a security
211	OBJECT_KEY	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
212	PARTLY_PAIDS	☐	SECURITY_PARTLY_PAIDS		TTYP	0	0
213	RATINGS	☐	SECURITY_RATINGS		TTYP	0	0
214	POOLDATA	☐	VWPPOOLDATA		STRU	0	0
215	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
216	POOL_ID	☐	VVPOOLID		CHAR	13	0	Pool ID
217	CLASSIFICATION	☐	VVPOOLCL	VVPOOLCL	NUMC	3	0	Asset Pool Classification
218	TOTAL_VOLUME	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
219	TOTAL_VOLUME_CUR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
220	REINV_PERIOD	☐	TPM_REINV_PERIOD	DATS	DATS	8	0	Reinvestment Period
221	POOLRATING	☐	VWPPOOLRATINGY		TTYP	0	0
222	POOLREMARK	☐	VWPPOOLREMARKY		TTYP	0	0
223	TIERLEVEL	☐	VVTIERLEVELY		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SECURITY_COMPLEX	BONDCLASS	TW01	SWPKLASS
2	SECURITY_COMPLEX	CLASSIFICATION	TW22	ALWPKL
3	SECURITY_COMPLEX	CURRENCY_MARKUP	TCURC	WAERS
4	SECURITY_COMPLEX	EXERCISE_CURRENCY	TCURC	WAERS
5	SECURITY_COMPLEX	FACTORY_CALENDAR	TFACD	IDENT
6	SECURITY_COMPLEX	FUND_TYPE	TW21	SFOTY
7	SECURITY_COMPLEX	INDEX_CURRENCY	TCURC	WAERS
8	SECURITY_COMPLEX	INDEX_P_CURRENCY	TCURC	WAERS	KEY	1	CN
9	SECURITY_COMPLEX	INSTITUTE	TP07	SOL_INS
10	SECURITY_COMPLEX	ISSUER	BUT000	PARTNER		1	CN
11	SECURITY_COMPLEX	ISSUE_CURRENCY	TCURC	WAERS		1	CN
12	SECURITY_COMPLEX	NOMINAL_CURRENCY	TCURC	WAERS	KEY	1	CN
13	SECURITY_COMPLEX	POOL_CLASSIF	VWIRPPOOLCLASSIF	POOL_CLASSIF
14	SECURITY_COMPLEX	PRICE_INDEX	TIDX_PRICE_INDEX	INDEX_NAME
15	SECURITY_COMPLEX	PRODUCT_CATEGORY	TZAF	SANLF		1	CN
16	SECURITY_COMPLEX	PRODUCT_TYPE	TZPA	GSART		1	CN
17	SECURITY_COMPLEX	RATING	TP06	RATING
18	SECURITY_COMPLEX	REFERENCE_CURRENCY	TCURC	WAERS
19	SECURITY_COMPLEX	REF_INTEREST_RATE	T056R	REFERENZ
20	SECURITY_COMPLEX	ROUNDING_RULE	TRSC_ROUND_RULE	ROUNDING_RULE	KEY	1	CN
21	SECURITY_COMPLEX	SECURITY_CATEGORY	TW22	ALWPKL
22	SECURITY_COMPLEX	SECURITY_INDEX	INDEXD	IDX
23	SECURITY_COMPLEX	SECURITY_NUMBER	VWPANLA	RANL
24	SECURITY_COMPLEX	SECURITY_TYPE	TW20	SWERTTYP
25	SECURITY_COMPLEX	SHAREHOLDING_STRUCT	TW03	SKONBET
26	SECURITY_COMPLEX	SHAREHOLDING_TYPE	TW02	SARTBET
27	SECURITY_COMPLEX	STRIKE_CURRENCY	TCURC	WAERS	KEY	1	CN
28	SECURITY_COMPLEX	TRANCHE_CLASSIF	VWIRPTRANCLASSIF	TRANCHE_CLASSIF

History

Last changed by/on	SAP	20140121
SAP Release Created in