CPE_EXCHANGERATE

Transparent Table Application Table
22 Fields 1 CDS Views

CPE Exchange Rate

CPE_EXCHANGERATE is an SAP database table in S/4HANA. CPE Exchange Rate. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgCndnTrmExchRate view_entity from BASIC CPE Condition Exchange Rate

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY docitemcond_guid cpet_docitemcond_guid Doc. Cond. Item GUID
KEY termno cpet_termno Term Number
KEY convplace cpet_convplace Conv. Place
KEY exchangerate_timestamp cpet_exchangerate_timestamp Exch Rate Time Stamp
exchangerate_type kurst_curr Exch. Rate Type
from_currency cpet_currfrom Curr:Conv. from
to_currency cpet_currto Curr.: Conv. to
exchangerate cpet_usedexchrate Conv.:Ex.Rate
ratio_from_currency ffact_curr Ratio (from)
ratio_to_currency tfact_curr Ratio (to)
substitution_timestamp cpet_substitution_timestamp Subst Time Stamp
closed_market cpet_exchrate_closed_market Non-Trading Day
missing cpet_exchrate_missing ExchangeRate Missing
substituted cpet_exchrate_substituted Substitute Exr
ignored cpet_exchrate_ignored Exchg. Rate Ignored
forecast_status cpet_forecast_status Forecast Status
swap_rate cmm_swap_rate Swap Exchange Rate
spot_rate cmm_spot_rate Spot Exchange Rate
perioddetermination_uuid cpet_perioddtout_guid PerDet.Out.GUID
docitem_guid cpet_docitem_guid Doc. Item GUID
cond_type cpet_cond_type Condition Type

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.

-- CPE Exchange Rate
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_EXCHANGERATE (
    CLIENT,                    -- Client [mandt]
    DOCITEMCOND_GUID,          -- Doc. Cond. Item GUID [cpet_docitemcond_guid]
    TERMNO,                    -- Term Number [cpet_termno]
    CONVPLACE,                 -- Conv. Place [cpet_convplace]
    EXCHANGERATE_TIMESTAMP,    -- Exch Rate Time Stamp [cpet_exchangerate_timestamp]
    EXCHANGERATE_TYPE,         -- Exch. Rate Type [kurst_curr]
    FROM_CURRENCY,             -- Curr:Conv. from [cpet_currfrom]
    TO_CURRENCY,               -- Curr.: Conv. to [cpet_currto]
    EXCHANGERATE,              -- Conv.:Ex.Rate [cpet_usedexchrate]
    RATIO_FROM_CURRENCY,       -- Ratio (from) [ffact_curr]
    RATIO_TO_CURRENCY,         -- Ratio (to) [tfact_curr]
    SUBSTITUTION_TIMESTAMP,    -- Subst Time Stamp [cpet_substitution_timestamp]
    CLOSED_MARKET,             -- Non-Trading Day [cpet_exchrate_closed_market]
    MISSING,                   -- ExchangeRate Missing [cpet_exchrate_missing]
    SUBSTITUTED,               -- Substitute Exr [cpet_exchrate_substituted]
    IGNORED,                   -- Exchg. Rate Ignored [cpet_exchrate_ignored]
    FORECAST_STATUS,           -- Forecast Status [cpet_forecast_status]
    SWAP_RATE,                 -- Swap Exchange Rate [cmm_swap_rate]
    SPOT_RATE,                 -- Spot Exchange Rate [cmm_spot_rate]
    PERIODDETERMINATION_UUID,  -- PerDet.Out.GUID [cpet_perioddtout_guid]
    DOCITEM_GUID,              -- Doc. Item GUID [cpet_docitem_guid]
    COND_TYPE,                 -- Condition Type [cpet_cond_type]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID, TERMNO, CONVPLACE, EXCHANGERATE_TIMESTAMP)
);

Learn More