TBAC_DCS_LOF

Transparent Table Customizing Table

Derivative Contrac Specification for Listed Options, Futures

TBAC_DCS_LOF is an SAP database table in S/4HANA. Derivative Contrac Specification for Listed Options, Futures. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/dmbe/i_Cpe_Dcs_Commodity view from DCS for Listed Options, Futures
/dmbe/i_Cpe_Maturity_KeyDate view inner Maturity Key Date
I_BrkrRecnclnContrSpecOptnFutr view from BASIC Brkr Recon Contr Spec for Opt and Futr
I_CmmdtyDrvtvContrMicPhys view left_outer BASIC View for DCS, MIC and Commodity
I_CmmdtyDrvtvContrSpecAttrib view from BASIC Basic View Drvtv Contr Spec Attributes
I_COND_HEADER view left_outer COMPOSITE

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY dcsid TBA_DCSID DCS ID
commodity TBA_STOEFFCHEN Commodity
dcssymbl TBA_DCS_SYMBL Product Symbol
calendar TBA_PROMPT_DATE_CALENDAR Prompt Date Cal.
pdef_id TBA_PERIODDEF_ID Period Determination
expdatelogic TBA_EXPIRATIONDATE Exp. Date Logic
repdatelogic TBA_REPORTINGDATE Reporting Date
sdef_id TBA_SECIDDEF_ID Sec. ID Determin.
underlying_dcsid TBA_DCSID_UNDERLYING Underlying DCS
optstyle TBA_OPTSTYLE Exercise Type
retention_time TBA_RETENTION_TIME Retention Period
publication_calendar SKALID Calendar
timing CMM_TIMING Timing
pricetype TBA_PRICETYPE Price Type
opttyp CMM_OPTTYP Option Category
flt_prc CMM_FLT_PRC Floating Price Def.
common_pricing CMM_COMMON_PRICING Common Pricing

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.

-- Derivative Contrac Specification for Listed Options, Futures
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBAC_DCS_LOF (
    CLIENT,                -- Client [MANDT]
    DCSID,                 -- DCS ID [TBA_DCSID]
    COMMODITY,             -- Commodity [TBA_STOEFFCHEN]
    DCSSYMBL,              -- Product Symbol [TBA_DCS_SYMBL]
    CALENDAR,              -- Prompt Date Cal. [TBA_PROMPT_DATE_CALENDAR]
    PDEF_ID,               -- Period Determination [TBA_PERIODDEF_ID]
    EXPDATELOGIC,          -- Exp. Date Logic [TBA_EXPIRATIONDATE]
    REPDATELOGIC,          -- Reporting Date [TBA_REPORTINGDATE]
    SDEF_ID,               -- Sec. ID Determin. [TBA_SECIDDEF_ID]
    UNDERLYING_DCSID,      -- Underlying DCS [TBA_DCSID_UNDERLYING]
    OPTSTYLE,              -- Exercise Type [TBA_OPTSTYLE]
    RETENTION_TIME,        -- Retention Period [TBA_RETENTION_TIME]
    PUBLICATION_CALENDAR,  -- Calendar [SKALID]
    TIMING,                -- Timing [CMM_TIMING]
    PRICETYPE,             -- Price Type [TBA_PRICETYPE]
    OPTTYP,                -- Option Category [CMM_OPTTYP]
    FLT_PRC,               -- Floating Price Def. [CMM_FLT_PRC]
    COMMON_PRICING,        -- Common Pricing [CMM_COMMON_PRICING]
    PRIMARY KEY (CLIENT, DCSID)
);