I_CMMDTYPRCGTERMEXCHANGERATE

CDS View
20 Fields 2 CDS Views

CPE Term Used Exchange Rate

I_CMMDTYPRCGTERMEXCHANGERATE is a CDS View in S/4HANA. CPE Term Used Exchange Rate. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CntrlPurContrCmmdtyExchRate view from COMPOSITE CCTR Commodity Term Exchange Rate
I_PurHubCommodityExchangeRate view from BASIC Purchase Hub Commodity Exchange Rate

Fields (20)

KeyField CDS FieldsUsed in Views
KEY PrcgCndnTrmExchRateDateTime PrcgCndnTrmExchRateDateTime 2
KEY PricingConditionTerm PricingConditionTerm 2
_ExchRateSourceCurrency _ExchRateSourceCurrency 2
_ExchRateTargetCurrency _ExchRateTargetCurrency 2
CndnExchRatePerdDetnResultUUID CndnExchRatePerdDetnResultUUID 2
CndnTrmExchRateIsNonTradingDay CndnTrmExchRateIsNonTradingDay 1
CndnTrmExchRateIsSubstituted CndnTrmExchRateIsSubstituted 1
CndnTrmExchRateSubstnDateTime CndnTrmExchRateSubstnDateTime 2
ConditionType ConditionType 2
NumberOfSourceCurrencyUnits NumberOfSourceCurrencyUnits 2
NumberOfTargetCurrencyUnits NumberOfTargetCurrencyUnits 2
PrcgCndnTrmExchRateFcstStatus PrcgCndnTrmExchRateFcstStatus 1
PrcgCndnTrmExchRateIsIgnored PrcgCndnTrmExchRateIsIgnored 1
PrcgCndnTrmExchRateIsMissing PrcgCndnTrmExchRateIsMissing 1
PrcgConditionExchangeRateType PrcgConditionExchangeRateType 2
PrcgConditionSpotExchangeRate PrcgConditionSpotExchangeRate 2
PrcgConditionSwapExchangeRate PrcgConditionSwapExchangeRate 2
PricingConditionExchangeRate PricingConditionExchangeRate 1
PricingConditionSourceCurrency PricingConditionSourceCurrency 2
PricingConditionTargetCurrency PricingConditionTargetCurrency 2

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 Term Used Exchange Rate
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYPRCGTERMEXCHANGERATE (
    PRCGCNDNTRMEXCHRATEDATETIME,
    PRICINGCONDITIONTERM,
    _EXCHRATESOURCECURRENCY,
    _EXCHRATETARGETCURRENCY,
    CNDNEXCHRATEPERDDETNRESULTUUID,
    CNDNTRMEXCHRATEISNONTRADINGDAY,
    CNDNTRMEXCHRATEISSUBSTITUTED,
    CNDNTRMEXCHRATESUBSTNDATETIME,
    CONDITIONTYPE,
    NUMBEROFSOURCECURRENCYUNITS,
    NUMBEROFTARGETCURRENCYUNITS,
    PRCGCNDNTRMEXCHRATEFCSTSTATUS,
    PRCGCNDNTRMEXCHRATEISIGNORED,
    PRCGCNDNTRMEXCHRATEISMISSING,
    PRCGCONDITIONEXCHANGERATETYPE,
    PRCGCONDITIONSPOTEXCHANGERATE,
    PRCGCONDITIONSWAPEXCHANGERATE,
    PRICINGCONDITIONEXCHANGERATE,
    PRICINGCONDITIONSOURCECURRENCY,
    PRICINGCONDITIONTARGETCURRENCY,
    PRIMARY KEY (PRCGCNDNTRMEXCHRATEDATETIME, PRICINGCONDITIONTERM)
);

Learn More