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