SAP VTIOF Additional Option Data Table
Overview
VTIOF is a standard SAP S/4HANA table that stores Additional Option Data data. There are total 36 fields in the VTIOF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTIOF belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 application development for Treasury forward trading (FTT).
In addition, following links provide an overview of foreign key relationships, if any, that link VTIOF to other SAP tables and standard CDS views available based on VTIOF table in S/4HANA 2020.
Techincal Settings of VTIOF
Below are technical details of the table VTIOF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTIOF Fields
The following table gives you an overview of the fields available in VTIOF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| OPTNR | Class | TI_RGATT | CHAR | 13 | |
| XRFHA | X - Option/Future is Already Traded | TI_XRFHA | CHAR | 1 | |
| ORFHA | Number of Related Transaction (for OTC) | TI_ORFHA | CHAR | 13 | |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| RFHA | Financial Transaction (Underlying) if Just One | TI_RFHA | CHAR | 13 | |
| SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | |
| DMATUR | Expiration date | TB_DMATUR | DATS | 8 | |
| VERFDA | Expiry Date Type | TB_VERFDA | AT52 | CHAR | 5 |
| MARGART | Margin type | TB_MARGART | AT51 | CHAR | 5 |
| XNAME | Name of Option/Future | TB_XOFNAME | CHAR | 30 | |
| NOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | |
| OFWAERS | Strike currency of option/future | TI_OFWAERS | TCURC | CUKY | 5 |
| OSTRIKE | Option strike amount | TI_OSTRIKE | CURR | 13 | |
| ONOTPT | Value of Option Quotation Point | TI_ONOTPT | CURR | 13 | |
| OPROZE | Reference Value of Option Percentage Quotation | TI_OPROZE | CURR | 13 | |
| ONOTWAE | Quotation Currency for Option | TI_ONOTWAE | TCURC | CUKY | 5 |
| GATTUNG | Class for option/future underlying | TI_URGATT | VTIUL | CHAR | 13 |
| SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | |
| DOFSTAR | Start of term | TI_DOFSTAR | DATS | 8 | |
| SETTLFL | Settlement Indicator | TI_SETTLFL | CHAR | 1 | |
| OPTTYP | Original Option Category (on Closing) | TV_OPTTYP | ATO1 | NUMC | 3 |
| OSSIGN | Direction of strike amount (Put/Call) | TB_OSSIGN | CHAR | 1 | |
| UNUMBER | Number of Underlyings | TB_UNUMBER | DEC | 4 | |
| FOGRUPP | Dummy/No Longer Used | TI_FOGRUPP | CHAR | 5 | |
| SLEVELTYP | Category of Knock-In/Knock-Out Level | TI_SLEVELT | NUMC | 2 | |
| WLWAERS | Leading Currency | TB_WLWAERS | TCURC | CUKY | 5 |
| WFWAERS | Following Currency | TB_WFWAERS | TCURC | CUKY | 5 |
| KWKURB1 | Barrier as Forex Rate for Exotic Options | TX_KWKURB1 | DEC | 13 | |
| KWKURB2 | Barrier 2 as Forex Rate for Exotic Options | TX_KWKURB2 | DEC | 13 | |
| SPUTCAL | Put/Call Indicator | TI_SPUTCAL | NUMC | 1 | |
| OSTRIKE_ALTER | Option strike amount | TI_OSTRIKE | CURR | 13 | |
| FWD_VOLA | Volatility | TB_VOLA | DEC | 11 | |
| LOAN_ID | Underlying Loan Contract | FTR_UL_LOAN | CHAR | 13 | |
| EXPIRY_LOCATION | Expiry Location | FTR_EXPIRY_LOCATION | CHAR | 4 | |
| EXPIRY_TIME | Expiry Time | FTR_EXPIRY_TIME | NUMC | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTIOF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTIOF | GATTUNG | 1: CN | VTIUL |
| VTIOF | MANDT | 1: CN | T000 |
| VTIOF | MARGART | : | AT51 |
| VTIOF | OFWAERS | : | TCURC |
| VTIOF | ONOTWAE | : | TCURC |
| VTIOF | OPTTYP | : | ATO1 |
| VTIOF | SGSART | 1: CN | TZPA |
| VTIOF | VERFDA | : | AT52 |
| VTIOF | WFWAERS | : | TCURC |
| VTIOF | WLWAERS | : | TCURC |