VTIOF SAP (Additional Option Data) Table details
Dictionary Type: Table
Description: Additional Option Data
Description: Additional Option Data
Table field list including key, data, relationships and ABAP select examples
VTIOF is a standard SAP Table which is used to store Additional Option Data data and is available within R/3 SAP systems depending on the version and release level.
The VTIOF table consists of various fields, each holding specific information or linking keys about Additional Option Data data available in SAP. These include OPTNR (Class), XRFHA (Option/Future is already traded), ORFHA (Number of related transaction (for OTC)), SGSART (Product Type).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP VTIOF table 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 | |||
OPTNR | Class | TI_RGATT | CHAR | 13 | ALPHA | T_RGATT | T04 | ||
XRFHA | Option/Future is already traded | TI_XRFHA | CHAR | 1 | XFELD | ||||
ORFHA | Number of related transaction (for OTC) | TI_ORFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | ||
SGSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
RFHA | Transaction (underlying) if only one | TI_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | ||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
DMATUR | Expiration date | TB_DMATUR | DATS | 8 | DATUM | ||||
VERFDA | Expiry date type | TB_VERFDA | CHAR | 5 | AT52 | T_VERFDA | |||
MARGART | Margin type | TB_MARGART | CHAR | 5 | AT51 | T_MARGART | |||
XNAME | Name of option/future | TB_XOFNAME | CHAR | 30 | T_XTEXT30 | ||||
NOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
OFWAERS | Strike currency of option/future | TI_OFWAERS | CUKY | 5 | TCURC | WAERS | |||
OSTRIKE | Option strike amount | TI_OSTRIKE | CURR | 13(2) | WERTV7 | ||||
ONOTPT | Value of option quotation point | TI_ONOTPT | CURR | 13(2) | WERTV7 | ||||
OPROZE | Reference value of option percentage quotation | TI_OPROZE | CURR | 13(2) | WERTV7 | ||||
ONOTWAE | Quotation currency for option | TI_ONOTWAE | CUKY | 5 | TCURC | WAERS | |||
GATTUNG | Class for option/future underlying | TI_URGATT | CHAR | 13 | VTIUL | ALPHA | T_URGATT | ||
SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | T_SABRMET | ||||
DOFSTAR | Start of term | TI_DOFSTAR | DATS | 8 | TI_DOFSTAR | ||||
SETTLFL | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
OPTTYP | Original option category (on closing) | TV_OPTTYP | NUMC | 3 | ATO1 | T_OPTTYP | |||
OSSIGN | Direction of strike amount (Put/Call) | TB_OSSIGN | CHAR | 1 | T_SSIGN | ||||
UNUMBER | Number of underlyings | TB_UNUMBER | DEC | 4 | T_UNUMBER | ||||
FOGRUPP | Dummy/no longer used | TI_FOGRUPP | CHAR | 5 | Assigned to domain | T_FOGRUPP | |||
SLEVELTYP | Category of Knock-In/Knock-Out Level | TI_SLEVELT | NUMC | 2 | T_SLEVELT | ||||
WLWAERS | Leading currency | TB_WLWAERS | CUKY | 5 | TCURC | WAERS | |||
WFWAERS | Following Currency | TB_WFWAERS | CUKY | 5 | TCURC | WAERS | |||
KWKURB1 | Barrier as forex rate for exotic options | TX_KWKURB1 | DEC | 13(9) | TB_KKURS | ||||
KWKURB2 | Barrier 2 as forex rate for exotic options | TX_KWKURB2 | DEC | 13(9) | TB_KKURS | ||||
SPUTCAL | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
OSTRIKE_ALTER | Option strike amount | TI_OSTRIKE | CURR | 13(2) | WERTV7 | ||||
FWD_VOLA | Volatility | TB_VOLA | DEC | 11(7) | T_VOLA | ||||
LOAN_ID | Underlying Loan Contract | FTR_UL_LOAN | CHAR | 13 | ALPHA | RANL | RAD | FTRH_UL_LOAN |
Key field | Non-key field |
How do I retrieve data from SAP table VTIOF using ABAP code
The following ABAP code Example will allow you to do a basic selection on VTIOF to SELECT all data from the tableDATA: WA_VTIOF TYPE VTIOF.
SELECT SINGLE *
FROM VTIOF
INTO CORRESPONDING FIELDS OF WA_VTIOF
WHERE...
How to access SAP table VTIOF
Within an ECC or HANA version of SAP you can also view further information about VTIOF 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