VTIDERI

Transparent Table Application Table
60 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 60 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 (60)

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
debeg DEBEG Issue Start
bnwhr BNWHR Nominal amnt
snwhr SNWHR Nominal currency
bwtick_fine TPM_BWTICK_FINE Tick Value
betick_cty TI_BETICK_COMMODITY Tick Size
bwtick_cty TI_BWTICK_COMMODITY Tick Value
commodity_id TRCO_COMM_ID Cmdty ID (obsolete)
contract_size TPM_CTY_CONTRACT_SIZE Contract Size
contract_sz_unit TPM_CTY_CONTRACT_SIZE_UNIT Unit of M
quantity FTR_QUAN Qty
quantity_unit TRCO_COMM_UOM Unit of M
first_notice_day FIRST_NOTICE_DAY First Not. Day
betick_cty_cunit VVSRUNIT Unit
dcsid TBA_DCSID DCS ID
keydate TBA_KEYDATE Maturity Key Date
mic TBA_MIC MIC
underlying_keydate TBA_KEYDATE Maturity Key Date
cty_strike_price TB_CTY_STRIKE_PRICE Strike Price
cty_strike_curr_unit TB_RUNIT Currency Unit
timing CMM_TIMING Timing
avg_period_start CMM_AP_START Avg. Period Start
avg_period_end CMM_AP_END Avg. Period End
opttyp CMM_OPTTYP Option Category

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]
    DEBEG,                 -- Issue Start [DEBEG]
    BNWHR,                 -- Nominal amnt [BNWHR]
    SNWHR,                 -- Nominal currency [SNWHR]
    BWTICK_FINE,           -- Tick Value [TPM_BWTICK_FINE]
    BETICK_CTY,            -- Tick Size [TI_BETICK_COMMODITY]
    BWTICK_CTY,            -- Tick Value [TI_BWTICK_COMMODITY]
    COMMODITY_ID,          -- Cmdty ID (obsolete) [TRCO_COMM_ID]
    CONTRACT_SIZE,         -- Contract Size [TPM_CTY_CONTRACT_SIZE]
    CONTRACT_SZ_UNIT,      -- Unit of M [TPM_CTY_CONTRACT_SIZE_UNIT]
    QUANTITY,              -- Qty [FTR_QUAN]
    QUANTITY_UNIT,         -- Unit of M [TRCO_COMM_UOM]
    FIRST_NOTICE_DAY,      -- First Not. Day [FIRST_NOTICE_DAY]
    BETICK_CTY_CUNIT,      -- Unit [VVSRUNIT]
    DCSID,                 -- DCS ID [TBA_DCSID]
    KEYDATE,               -- Maturity Key Date [TBA_KEYDATE]
    MIC,                   -- MIC [TBA_MIC]
    UNDERLYING_KEYDATE,    -- Maturity Key Date [TBA_KEYDATE]
    CTY_STRIKE_PRICE,      -- Strike Price [TB_CTY_STRIKE_PRICE]
    CTY_STRIKE_CURR_UNIT,  -- Currency Unit [TB_RUNIT]
    TIMING,                -- Timing [CMM_TIMING]
    AVG_PERIOD_START,      -- Avg. Period Start [CMM_AP_START]
    AVG_PERIOD_END,        -- Avg. Period End [CMM_AP_END]
    OPTTYP,                -- Option Category [CMM_OPTTYP]
    PRIMARY KEY (MANDT, RANL)
);

Learn More