CMM_FIX_SPREAD

Transparent Table Application Table
13 Fields 1 CDS Views

Master Data for Fix Spreads between Future Market References

CMM_FIX_SPREAD is an SAP database table in S/4HANA. Master Data for Fix Spreads between Future Market References. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FixedSpreads view from BASIC Fixed Spreads between Future Market References

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY entity_key cmm_dend_spread_entity_key Entity Key Sprd
KEY dcsid tba_dcsid DCS ID
KEY mic tba_mic MIC
KEY keydate1 tba_keydate Maturity Key Date
keydate2 cmm_dend_spread_keydate2 Maturity Key Date 2
spread_fix_date cmm_dend_spread_dt Spread Fixation Date
fix_date_only cmm_dend_spread_date_only From Fixation Date
spread_rate cmm_dend_spread Fixed Spread
currency cmm_dend_spread_cur Spread Currency
uom cmm_dend_spread_uom Fixed Spread UoM
valid_from_tst cmm_mtm_valid_from_tst Valid-From Tstmp
spread_rate_ext cmm_spread_rate Fixed Spread Rate

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 for Fix Spreads between Future Market References
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_FIX_SPREAD (
    MANDT,            -- Client [mandt]
    ENTITY_KEY,       -- Entity Key Sprd [cmm_dend_spread_entity_key]
    DCSID,            -- DCS ID [tba_dcsid]
    MIC,              -- MIC [tba_mic]
    KEYDATE1,         -- Maturity Key Date [tba_keydate]
    KEYDATE2,         -- Maturity Key Date 2 [cmm_dend_spread_keydate2]
    SPREAD_FIX_DATE,  -- Spread Fixation Date [cmm_dend_spread_dt]
    FIX_DATE_ONLY,    -- From Fixation Date [cmm_dend_spread_date_only]
    SPREAD_RATE,      -- Fixed Spread [cmm_dend_spread]
    CURRENCY,         -- Spread Currency [cmm_dend_spread_cur]
    UOM,              -- Fixed Spread UoM [cmm_dend_spread_uom]
    VALID_FROM_TST,   -- Valid-From Tstmp [cmm_mtm_valid_from_tst]
    SPREAD_RATE_EXT,  -- Fixed Spread Rate [cmm_spread_rate]
    PRIMARY KEY (MANDT, ENTITY_KEY, DCSID, MIC, KEYDATE1)
);

Learn More