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 CPE Quotation Group Exchange Rates

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