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