CPE_QTGP_EXCHRT

Transparent Table Application Table
20 Fields 1 CDS Views

CPE Quotation Group Exchange Rates

CPE_QTGP_EXCHRT is an SAP database table in S/4HANA. CPE Quotation Group Exchange Rates. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrcgCndnQtanGrpExchangeRate view_entity from BASIC Exchange Rates in Quotation Group

Fields (20)

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 quotgrouppos CPET_QUOTGROUPPOS Position
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

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 Quotation Group Exchange Rates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_QTGP_EXCHRT (
    CLIENT,                  -- Client [MANDT]
    DOCITEMCOND_GUID,        -- Doc. Cond. Item GUID [CPET_DOCITEMCOND_GUID]
    TERMNO,                  -- Term Number [CPET_TERMNO]
    QUOTGROUPPOS,            -- Position [CPET_QUOTGROUPPOS]
    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]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID, TERMNO, QUOTGROUPPOS, CONVPLACE, EXCHANGERATE_TIMESTAMP)
);

Learn More