VTI_DERIVB SAP (Entry Table Master Data Listed Options and Futures) Structure details
Description: Entry Table Master Data Listed Options and Futures
Structure field list including key, data, relationships and ABAP select examples
VTI_DERIVB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Entry Table Master Data Listed Options and Futures" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VTI_DERIVB TYPE VTI_DERIVB.
The VTI_DERIVB table consists of various fields, each holding specific information or linking keys about Entry Table Master Data Listed Options and Futures data available in SAP. These include MANDT (Client), RANL (Security ID Number), SGSART (Product Type), DJAHR (Expiration year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VTI_DERIVB structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RANL | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SGSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
DJAHR | Expiration year | TI_DJAHR | NUMC | 4 | GJAHR | GJAHR | |||
DMONAT | Expiration month | TI_DMOANT | NUMC | 2 | T_DMOANT | ||||
SOFTYP | Options/futures category | TI_SOFTYP | NUMC | 2 | T_SOFTYP | ||||
SOPTTYP | Original option category (on closing) | TV_OPTTYP | NUMC | 3 | ATO1 | T_OPTTYP | |||
SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | T_SABRMET | ||||
SMARGART | Margin type | TB_MARGART | CHAR | 5 | AT51 | T_MARGART | |||
SNOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
PPTICK | Tick in percentage points | TI_PPTICK | DEC | 10(7) | DECV3_7 | ||||
BETICK | Tick as amount | TI_BETICK | CURR | 13(2) | WERTV7 | ||||
PITICK | Tick in index points | TI_PITICK | DEC | 11(6) | T_PKTKUR | ||||
BWTICK | Tick value | TI_BWTICK | CURR | 13(2) | WERTV7 | ||||
WWTICK | Tick Value Currency | TI_WWTICK | CUKY | 5 | TCURC | WAERS | |||
SPUTCALL | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
SSETTLFL | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
DVERFALL | Expiration date | TI_DVERF | DATS | 8 | DATUM | ||||
DLHANDEL | Last trade date | TI_DLHAND | DATS | 8 | DATUM | ||||
DERFUELL | Settlement date | TI_DERFUE | DATS | 8 | DATUM | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | TFACD | WFCID | H_TFACD | ||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
RNWHR | Nominal currency | RNWHR | CUKY | 5 | TCURC | WAERS | |||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DENDF | Final due date | DENDF | DATS | 8 | DATUM | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
URANL | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
UINDEX | Securities Index | IDX | CHAR | 10 | INDEXD | CHAR10 | |||
BPINDEX | Value of an index point | TI_BPINDEX | CURR | 13(2) | WERTV7 | ||||
WPINDEX | Index point currency | TI_WPINDEX | CUKY | 5 | TCURC | WAERS | |||
BSTRIKE | Strike as amount | TI_BSTRIKE | CURR | 13(2) | WERTV7 | ||||
WSTRIKE | Strike Currency | TI_WSTRIKE | CUKY | 5 | TCURC | WAERS | |||
PKSTRIKE | Strike in points | TI_PKSTRIK | DEC | 9(4) | DEC5_4 | ||||
IPSTRIKE | Strike as inverted percentage notation | TI_IPSTRIK | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BWTICK_FINE | Tick Value | TPM_BWTICK_FINE | DEC | 13(7) | DEC13_7 | ||||
BETICK_CTY | Tick Amount (Commodity) | TI_BETICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
BWTICK_CTY | Tick Value (Commodity) | TI_BWTICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
CONTRACT_SIZE | Contract Size | TPM_CTY_CONTRACT_SIZE | QUAN | 13(3) | FTR_QUAN | ||||
CONTRACT_SZ_UNIT | Mengeneinheit der Kontraktgröße | TPM_CTY_CONTRACT_SIZE_UNIT | UNIT | 3 | Assigned to domain | TRCO_COMM_UOM | |||
QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
QUANTITY_UNIT | Unit of measure | TRCO_COMM_UOM | UNIT | 3 | Assigned to domain | TRCO_COMM_UOM | |||
FIRST_NOTICE_DAY | First Notice Day | FIRST_NOTICE_DAY | DATS | 8 | FIRST_NOTICE_DAY | ||||
BETICK_CTY_CUNIT | Currency unit | VVSRUNIT | CHAR | 5 | TZUNI | VVSRUNIT | |||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
UNDERLYING_KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
Key field | Non-key field |
How do I retrieve data from SAP structure VTI_DERIVB using ABAP code?
As VTI_DERIVB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VTI_DERIVB as there is no data to select.How to access SAP table VTI_DERIVB
Within an ECC or HANA version of SAP you can also view further information about VTI_DERIVB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects