VTI_DERIVB SAP (Entry Table Master Data Listed Options and Futures) Structure details

Dictionary Type: Structure
Description: Entry Table Master Data Listed Options and Futures




ABAP Code to SELECT data from VTI_DERIVB
Related tables to VTI_DERIVB
Access table VTI_DERIVB




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
MANDTClient MANDTCLNT3T000MANDT
RANLSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
DJAHRExpiration year TI_DJAHRNUMC4GJAHRGJAHR
DMONATExpiration month TI_DMOANTNUMC2T_DMOANT
SOFTYPOptions/futures category TI_SOFTYPNUMC2T_SOFTYP
SOPTTYPOriginal option category (on closing) TV_OPTTYPNUMC3ATO1T_OPTTYP
SABRMETSettlement Method Option TI_SABRMETCHAR1T_SABRMET
SMARGARTMargin type TB_MARGARTCHAR5AT51T_MARGART
SNOTTYPEQuotation type option/future TI_NOTTYPECHAR1T_NOTTYPE
PPTICKTick in percentage points TI_PPTICKDEC10(7) DECV3_7
BETICKTick as amount TI_BETICKCURR13(2) WERTV7
PITICKTick in index points TI_PITICKDEC11(6) T_PKTKUR
BWTICKTick value TI_BWTICKCURR13(2) WERTV7
WWTICKTick Value Currency TI_WWTICKCUKY5TCURCWAERS
SPUTCALLPut/call indicator TI_SPUTCALNUMC1T_SPUTCAL
SSETTLFLSettlement indicator TI_SETTLFLCHAR1T_SETTLFL
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
DVERFALLExpiration date TI_DVERFDATS8DATUM
DLHANDELLast trade date TI_DLHANDDATS8DATUM
DERFUELLSettlement date TI_DERFUEDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
BNOMSNominal value BNOMSCURR13(2) BWHR
RNWHRNominal currency RNWHRCUKY5TCURCWAERS
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
SZSREFReference Interest Rate SZSREFCHAR10T056RZIREFKU
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DENDFFinal due date DENDFDATS8DATUM
ASTUECKNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
URANLSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
UINDEXSecurities Index IDXCHAR10INDEXDCHAR10
BPINDEXValue of an index point TI_BPINDEXCURR13(2) WERTV7
WPINDEXIndex point currency TI_WPINDEXCUKY5TCURCWAERS
BSTRIKEStrike as amount TI_BSTRIKECURR13(2) WERTV7
WSTRIKEStrike Currency TI_WSTRIKECUKY5TCURCWAERS
PKSTRIKEStrike in points TI_PKSTRIKDEC9(4) DEC5_4
IPSTRIKEStrike as inverted percentage notation TI_IPSTRIKDEC10(7) DECV3_7
.INCLU--AP 0
DEBEGIssue start date DEBEGDATS8DATUM
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SNWHRCurrency of nominal amount SNWHRCUKY5Assigned to domainWAERS
BWTICK_FINETick Value TPM_BWTICK_FINEDEC13(7) DEC13_7
BETICK_CTYTick Amount (Commodity) TI_BETICK_COMMODITYDEC13(7) DEC13_7
BWTICK_CTYTick Value (Commodity) TI_BWTICK_COMMODITYDEC13(7) DEC13_7
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CONTRACT_SIZEContract Size TPM_CTY_CONTRACT_SIZEQUAN13(3) FTR_QUAN
CONTRACT_SZ_UNITMengeneinheit der Kontraktgröße TPM_CTY_CONTRACT_SIZE_UNITUNIT3Assigned to domainTRCO_COMM_UOM
QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
QUANTITY_UNITUnit of measure TRCO_COMM_UOMUNIT3Assigned to domainTRCO_COMM_UOM
FIRST_NOTICE_DAYFirst Notice Day FIRST_NOTICE_DAYDATS8FIRST_NOTICE_DAY
BETICK_CTY_CUNITCurrency unit VVSRUNITCHAR5TZUNIVVSRUNIT
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6Assigned to domainTBA_DCSIDTBA_DCSIDTBAH_DCS
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
MICMarket Identifier Code TBA_MICCHAR4Assigned to domainTBA_MICTBA_MICTBAH_MIC
UNDERLYING_KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!