VTIDERI

Transparent Table Application Table
37 Fields 4 CDS Views

Master Data Listed Options and Futures

VTIDERI is an SAP database table in S/4HANA. Master Data Listed Options and Futures. It contains 37 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BrkrRecnclnCmmdtyDrvtvClData view from BASIC Brkr Recon Commodity Derivitives Cl Data
I_CmmdtyOrderFutureIDVH view inner BASIC Commodity Order Future ID
I_SecurityClassLstdDerivative view from BASIC Security Class Listed Derivative
P_DrvtvSecurityData view from BASIC

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ranl vvranlw Security Class
sgsart vvsart Product Type
djahr ti_djahr Expiration year
dmonat ti_dmoant Expirat. month
softyp ti_softyp Opt./fut. cat.
sopttyp tv_opttyp Option Category
sabrmet ti_sabrmet Sett.method
smargart tb_margart Margin type
snottype ti_nottype Quotation type
pptick ti_pptick Tick in % pnts
betick ti_betick Tick amount
pitick ti_pitick Tick index pnts
bwtick ti_bwtick Tick value
wwtick ti_wwtick Tick currency
sputcall ti_sputcal Put/Call
ssettlfl ti_settlfl Settlement
soptaus soptaus Exercise Type
dverfall ti_dverf Expiration date
dlhandel ti_dlhand Last trade date
derfuell ti_derfue Settlement Date
skalid skalid Calendar
bnoms bnoms Nominal Value
rnwhr rnwhr Nominal curr.
pkond pkond Percentage Rate
szsref szsref Ref. Int. Rate
szbmeth szbmeth Int.calc.method
dendf dendf Final Due Date
astueck astueck_l No. of Units
uranl vvranlw Security Class
uindex idx Securities ind.
bpindex ti_bpindex Index pnt value
wpindex ti_wpindex Index pnt curr.
bstrike ti_bstrike Strike amount
wstrike ti_wstrike Currency
pkstrike ti_pkstrik Strike points
ipstrike ti_ipstrik Strike percent

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.

-- Master Data Listed Options and Futures
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIDERI (
    MANDT,     -- Client [mandt]
    RANL,      -- Security Class [vvranlw]
    SGSART,    -- Product Type [vvsart]
    DJAHR,     -- Expiration year [ti_djahr]
    DMONAT,    -- Expirat. month [ti_dmoant]
    SOFTYP,    -- Opt./fut. cat. [ti_softyp]
    SOPTTYP,   -- Option Category [tv_opttyp]
    SABRMET,   -- Sett.method [ti_sabrmet]
    SMARGART,  -- Margin type [tb_margart]
    SNOTTYPE,  -- Quotation type [ti_nottype]
    PPTICK,    -- Tick in % pnts [ti_pptick]
    BETICK,    -- Tick amount [ti_betick]
    PITICK,    -- Tick index pnts [ti_pitick]
    BWTICK,    -- Tick value [ti_bwtick]
    WWTICK,    -- Tick currency [ti_wwtick]
    SPUTCALL,  -- Put/Call [ti_sputcal]
    SSETTLFL,  -- Settlement [ti_settlfl]
    SOPTAUS,   -- Exercise Type [soptaus]
    DVERFALL,  -- Expiration date [ti_dverf]
    DLHANDEL,  -- Last trade date [ti_dlhand]
    DERFUELL,  -- Settlement Date [ti_derfue]
    SKALID,    -- Calendar [skalid]
    BNOMS,     -- Nominal Value [bnoms]
    RNWHR,     -- Nominal curr. [rnwhr]
    PKOND,     -- Percentage Rate [pkond]
    SZSREF,    -- Ref. Int. Rate [szsref]
    SZBMETH,   -- Int.calc.method [szbmeth]
    DENDF,     -- Final Due Date [dendf]
    ASTUECK,   -- No. of Units [astueck_l]
    URANL,     -- Security Class [vvranlw]
    UINDEX,    -- Securities ind. [idx]
    BPINDEX,   -- Index pnt value [ti_bpindex]
    WPINDEX,   -- Index pnt curr. [ti_wpindex]
    BSTRIKE,   -- Strike amount [ti_bstrike]
    WSTRIKE,   -- Currency [ti_wstrike]
    PKSTRIKE,  -- Strike points [ti_pkstrik]
    IPSTRIKE,  -- Strike percent [ti_ipstrik]
    PRIMARY KEY (MANDT, RANL)
);

Learn More