VTIOF

Transparent Table Application Table
37 Fields 3 CDS Views

Additional Option Data

VTIOF is an SAP database table in S/4HANA. Additional Option Data. It contains 37 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FinancialTransactionOption view from BASIC Financial Transction Option
TOE_CDS_TRM_DEALS view inner cds view for deal nominals in TOENE
toe_cds_trm_deals_rfc view_entity inner View for Deal Nominals with RiskFreeCurr

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY optnr ti_rgatt Class
xrfha ti_xrfha X - Option/Future is Already Traded
orfha ti_orfha Trans.No.
sgsart vvsart Product Type
rfha ti_rfha Financial Transaction (Underlying) if Just One
soptaus soptaus Exercise Type
dmatur tb_dmatur Expiration Date
verfda tb_verfda Expiry Dt Type
margart tb_margart Margin type
xname tb_xofname Name
nottype ti_nottype Quotation type
ofwaers ti_ofwaers Strike Currency
ostrike ti_ostrike Strike amount
onotpt ti_onotpt Point Value
oproze ti_oproze Reference Value
onotwae ti_onotwae Quotation Crcy
gattung ti_urgatt Class
sabrmet ti_sabrmet Sett.method
dofstar ti_dofstar StartTerm
settlfl ti_settlfl Settlement
opttyp tv_opttyp Option Category
ossign tb_ossign Direction
unumber tb_unumber No. Underlyings
fogrupp ti_fogrupp Dummy/No Longer Used
sleveltyp ti_slevelt Level Category
wlwaers tb_wlwaers Lead. Currency
wfwaers tb_wfwaers Following Crcy
kwkurb1 tx_kwkurb1 Barrier
kwkurb2 tx_kwkurb2 Barrier 2
sputcal ti_sputcal Put/Call
ostrike_alter ti_ostrike Strike amount
fwd_vola tb_vola Volatility
loan_id ftr_ul_loan Underlying Loan
expiry_location ftr_expiry_location Expiry Location
expiry_time ftr_expiry_time Expiry Time
barrier_type barrier_type Barrier Type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Additional Option Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIOF (
    MANDT,            -- Client [mandt]
    OPTNR,            -- Class [ti_rgatt]
    XRFHA,            -- X - Option/Future is Already Traded [ti_xrfha]
    ORFHA,            -- Trans.No. [ti_orfha]
    SGSART,           -- Product Type [vvsart]
    RFHA,             -- Financial Transaction (Underlying) if Just One [ti_rfha]
    SOPTAUS,          -- Exercise Type [soptaus]
    DMATUR,           -- Expiration Date [tb_dmatur]
    VERFDA,           -- Expiry Dt Type [tb_verfda]
    MARGART,          -- Margin type [tb_margart]
    XNAME,            -- Name [tb_xofname]
    NOTTYPE,          -- Quotation type [ti_nottype]
    OFWAERS,          -- Strike Currency [ti_ofwaers]
    OSTRIKE,          -- Strike amount [ti_ostrike]
    ONOTPT,           -- Point Value [ti_onotpt]
    OPROZE,           -- Reference Value [ti_oproze]
    ONOTWAE,          -- Quotation Crcy [ti_onotwae]
    GATTUNG,          -- Class [ti_urgatt]
    SABRMET,          -- Sett.method [ti_sabrmet]
    DOFSTAR,          -- StartTerm [ti_dofstar]
    SETTLFL,          -- Settlement [ti_settlfl]
    OPTTYP,           -- Option Category [tv_opttyp]
    OSSIGN,           -- Direction [tb_ossign]
    UNUMBER,          -- No. Underlyings [tb_unumber]
    FOGRUPP,          -- Dummy/No Longer Used [ti_fogrupp]
    SLEVELTYP,        -- Level Category [ti_slevelt]
    WLWAERS,          -- Lead. Currency [tb_wlwaers]
    WFWAERS,          -- Following Crcy [tb_wfwaers]
    KWKURB1,          -- Barrier [tx_kwkurb1]
    KWKURB2,          -- Barrier 2 [tx_kwkurb2]
    SPUTCAL,          -- Put/Call [ti_sputcal]
    OSTRIKE_ALTER,    -- Strike amount [ti_ostrike]
    FWD_VOLA,         -- Volatility [tb_vola]
    LOAN_ID,          -- Underlying Loan [ftr_ul_loan]
    EXPIRY_LOCATION,  -- Expiry Location [ftr_expiry_location]
    EXPIRY_TIME,      -- Expiry Time [ftr_expiry_time]
    BARRIER_TYPE,     -- Barrier Type [barrier_type]
    PRIMARY KEY (MANDT, OPTNR)
);

Learn More