SAP VTIDERI Master Data Listed Options and Futures Table
Overview
VTIDERI is a standard SAP S/4HANA table that stores Master Data Listed Options and Futures data. There are total 60 fields in the VTIDERI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTIDERI belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Former FTT Objects Required in AL0 (FTT_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link VTIDERI to other SAP tables and standard CDS views available based on VTIDERI table in S/4HANA 2020.
Techincal Settings of VTIDERI
Below are technical details of the table VTIDERI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTIDERI Fields
The following table gives you an overview of the fields available in VTIDERI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RANL | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| DJAHR | Expiration year | TI_DJAHR | NUMC | 4 | |
| DMONAT | Expiration month | TI_DMOANT | NUMC | 2 | |
| SOFTYP | Options/futures category | TI_SOFTYP | NUMC | 2 | |
| SOPTTYP | Original Option Category (on Closing) | TV_OPTTYP | ATO1 | NUMC | 3 |
| SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | |
| SMARGART | Margin type | TB_MARGART | AT51 | CHAR | 5 |
| SNOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | |
| PPTICK | Tick in percentage points | TI_PPTICK | DEC | 10 | |
| BETICK | Tick as amount | TI_BETICK | CURR | 13 | |
| PITICK | Tick in index points | TI_PITICK | DEC | 11 | |
| BWTICK | Tick value | TI_BWTICK | CURR | 13 | |
| WWTICK | Tick Value Currency | TI_WWTICK | TCURC | CUKY | 5 |
| SPUTCALL | Put/Call Indicator | TI_SPUTCAL | NUMC | 1 | |
| SSETTLFL | Settlement Indicator | TI_SETTLFL | CHAR | 1 | |
| SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | |
| DVERFALL | Expiration date | TI_DVERF | DATS | 8 | |
| DLHANDEL | Last trade date | TI_DLHAND | DATS | 8 | |
| DERFUELL | Settlement Date | TI_DERFUE | DATS | 8 | |
| SKALID | Factory calendar | SKALID | TFACD | CHAR | 2 |
| BNOMS | Nominal Value | BNOMS | CURR | 13 | |
| RNWHR | Nominal currency | RNWHR | TCURC | CUKY | 5 |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| SZSREF | Reference Interest Rate | SZSREF | T056R | CHAR | 10 |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| DENDF | Final Due Date | DENDF | DATS | 8 | |
| ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15 | |
| URANL | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| UINDEX | Securities Index | IDX | INDEXD | CHAR | 10 |
| BPINDEX | Value of an index point | TI_BPINDEX | CURR | 13 | |
| WPINDEX | Index point currency | TI_WPINDEX | TCURC | CUKY | 5 |
| BSTRIKE | Strike as amount | TI_BSTRIKE | CURR | 13 | |
| WSTRIKE | Strike Currency | TI_WSTRIKE | TCURC | CUKY | 5 |
| PKSTRIKE | Strike in points | TI_PKSTRIK | DEC | 9 | |
| IPSTRIKE | Strike as inverted percentage notation | TI_IPSTRIK | DEC | 10 | |
| DEBEG | Issue Start Date | DEBEG | DATS | 8 | |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | |
| BWTICK_FINE | Tick Value | TPM_BWTICK_FINE | DEC | 13 | |
| BETICK_CTY | Tick Size | TI_BETICK_COMMODITY | DEC | 13 | |
| BWTICK_CTY | Tick Value | TI_BWTICK_COMMODITY | DEC | 13 | |
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18 | |
| CONTRACT_SIZE | Contract Size | TPM_CTY_CONTRACT_SIZE | QUAN | 13 | |
| CONTRACT_SZ_UNIT | Mengeneinheit der Kontraktgröße | TPM_CTY_CONTRACT_SIZE_UNIT | UNIT | 3 | |
| QUANTITY | Quantity | FTR_QUAN | QUAN | 13 | |
| QUANTITY_UNIT | Unit of measure | TRCO_COMM_UOM | UNIT | 3 | |
| FIRST_NOTICE_DAY | First Notice Day | FIRST_NOTICE_DAY | DATS | 8 | |
| BETICK_CTY_CUNIT | Currency unit | VVSRUNIT | TZUNI | CHAR | 5 |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 20 | |
| KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 8 | |
| MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | |
| UNDERLYING_KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 8 | |
| CTY_STRIKE_PRICE | Strike price for commodity listed options | TB_CTY_STRIKE_PRICE | DEC | 13 | |
| CTY_STRIKE_CURR_UNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | |
| TIMING | Timing | CMM_TIMING | NUMC | 2 | |
| AVG_PERIOD_START | Averaging Period Start Date | CMM_AP_START | DATS | 8 | |
| AVG_PERIOD_END | Averaging Period End Date | CMM_AP_END | DATS | 8 | |
| OPTTYP | Option Category | CMM_OPTTYP | NUMC | 3 |
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 VTIDERI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTIDERI | BETICK_CTY_CUNIT | : | TZUNI |
| VTIDERI | MANDT | 1: CN | T000 |
| VTIDERI | RANL | 1: C | VWPANLA |
| VTIDERI | RNWHR | C: CN | TCURC |
| VTIDERI | SGSART | 1: CN | TZPA |
| VTIDERI | SKALID | C: CN | TFACD |
| VTIDERI | SMARGART | C: CN | AT51 |
| VTIDERI | SOPTTYP | C: CN | ATO1 |
| VTIDERI | SZSREF | C: CN | T056R |
| VTIDERI | UINDEX | C: CN | INDEXD |
| VTIDERI | URANL | C: CN | VWPANLA |
| VTIDERI | WPINDEX | C: CN | TCURC |
| VTIDERI | WSTRIKE | C: CN | TCURC |
| VTIDERI | WWTICK | 1: CN | TCURC |