CMM_FIX_SPREAD

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

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
bukrs BUKRS Company Code
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
spread_rate_ext CMM_SPREAD_RATE Fixed Spread Rate
phid JBRPHID Portfolio Hierarchy
pknoten JBRPKNOTEN PH Node
sichtid JBRSICHTID View

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]
    BUKRS,            -- Company Code [BUKRS]
    ERDAT,            -- Created On [ERDAT]
    ERNAM,            -- Created By [ERNAM]
    AEDAT,            -- Changed On [AEDAT]
    AENAM,            -- Changed By [AENAM]
    SPREAD_RATE_EXT,  -- Fixed Spread Rate [CMM_SPREAD_RATE]
    PHID,             -- Portfolio Hierarchy [JBRPHID]
    PKNOTEN,          -- PH Node [JBRPKNOTEN]
    SICHTID,          -- View [JBRSICHTID]
    PRIMARY KEY (MANDT, ENTITY_KEY, DCSID, MIC, KEYDATE1)
);

Learn More