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 Exchange Rate in Pricing Condition Term

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