CMM_GMDAFX

Transparent Table Application Table
15 Fields 1 CDS Views

FX Curve Pre-calculated Values

CMM_GMDAFX is an SAP database table in S/4HANA. FX Curve Pre-calculated Values. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GmdaFx view from BASIC Generic Market Data - Exchange Rate

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY scenario tv_szenari Scenario
KEY currency_from cmm_fx_fcurr Source Currency
KEY currency_to cmm_fx_tcurr Target Currency
KEY rate_type kurst_curr Exch. Rate Type
KEY maturity cmm_maturity_date Maturity Date
KEY eval_date_from cmm_fx_rate_from From Date of FX Rate
eval_date_to cmm_fx_rate_to To Date of FX Rate
fwd_rate ukurs_curr Exchange Rate
spot_rate cpet_erp_spot_exchange_rate Spot Exch. Rate
swap_rate cmm_swap_rate Swap Exchange Rate
interpolated cpet_erp_swaprate_interpolated Interpolated
read_back tba_read_back_indicator Read Back
ffact ffact_curr Ratio (from)
tfact tfact_curr Ratio (to)

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.

-- FX Curve Pre-calculated Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_GMDAFX (
    CLIENT,          -- Client [mandt]
    SCENARIO,        -- Scenario [tv_szenari]
    CURRENCY_FROM,   -- Source Currency [cmm_fx_fcurr]
    CURRENCY_TO,     -- Target Currency [cmm_fx_tcurr]
    RATE_TYPE,       -- Exch. Rate Type [kurst_curr]
    MATURITY,        -- Maturity Date [cmm_maturity_date]
    EVAL_DATE_FROM,  -- From Date of FX Rate [cmm_fx_rate_from]
    EVAL_DATE_TO,    -- To Date of FX Rate [cmm_fx_rate_to]
    FWD_RATE,        -- Exchange Rate [ukurs_curr]
    SPOT_RATE,       -- Spot Exch. Rate [cpet_erp_spot_exchange_rate]
    SWAP_RATE,       -- Swap Exchange Rate [cmm_swap_rate]
    INTERPOLATED,    -- Interpolated [cpet_erp_swaprate_interpolated]
    READ_BACK,       -- Read Back [tba_read_back_indicator]
    FFACT,           -- Ratio (from) [ffact_curr]
    TFACT,           -- Ratio (to) [tfact_curr]
    PRIMARY KEY (CLIENT, SCENARIO, CURRENCY_FROM, CURRENCY_TO, RATE_TYPE, MATURITY, EVAL_DATE_FROM)
);

Learn More