I_CMMDTYPRCGCNDNTRMEXCHRATE

CDS View
19 Fields 6 CDS Views

Exchange Rate in Pricing Condition Term

I_CMMDTYPRCGCNDNTRMEXCHRATE is a CDS View in S/4HANA. Exchange Rate in Pricing Condition Term. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CndnRmndrFltgTrmExchangeRate view_entity from COMPOSITE
I_PrcgCndnExerTermExchangeRate view_entity from COMPOSITE
I_PrcgCndnQtanExchangeRate view_entity from COMPOSITE Exchange Rate in Pricing Condition Term
I_PrcgCndnRmndrTrmExchangeRate view_entity from COMPOSITE Remainder Term Exchange Rate
I_PrcgCndnRootTermExchangeRate view_entity from COMPOSITE
R_CmmdtyPrcgCndnTrmExchRateTP view_entity from TRANSACTIONAL Exchange rate for CPE term - TP

Fields (19)

KeyField CDS FieldsUsed in Views
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID 4
KEY PrcgCndnTrmExchRateDateTime PrcgCndnTrmExchRateDateTime 4
KEY PrcgConditionConversionPlace PrcgConditionConversionPlace 4
KEY PricingConditionTerm PricingConditionTerm 4
CndnTrmExchRateIsNonTradingDay CndnTrmExchRateIsNonTradingDay 4
CndnTrmExchRateIsSubstituted CndnTrmExchRateIsSubstituted 4
CndnTrmExchRateSubstnDateTime CndnTrmExchRateSubstnDateTime 4
ConditionType ConditionType 2
NumberOfSourceCurrencyUnits NumberOfSourceCurrencyUnits 4
NumberOfTargetCurrencyUnits NumberOfTargetCurrencyUnits 4
PrcgCndnTrmExchRateFcstStatus PrcgCndnTrmExchRateFcstStatus 4
PrcgCndnTrmExchRateIsIgnored PrcgCndnTrmExchRateIsIgnored 4
PrcgCndnTrmExchRateIsMissing PrcgCndnTrmExchRateIsMissing 4
PrcgConditionExchangeRateType PrcgConditionExchangeRateType 4
PrcgConditionSpotExchangeRate PrcgConditionSpotExchangeRate 4
PrcgConditionSwapExchangeRate PrcgConditionSwapExchangeRate 4
PricingConditionExchangeRate PricingConditionExchangeRate 4
PricingConditionSourceCurrency PricingConditionSourceCurrency 4
PricingConditionTargetCurrency PricingConditionTargetCurrency 4

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.

-- Exchange Rate in Pricing Condition Term
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYPRCGCNDNTRMEXCHRATE (
    DOCITMCMMDTYPRCGCNDNUUID,
    PRCGCNDNTRMEXCHRATEDATETIME,
    PRCGCONDITIONCONVERSIONPLACE,
    PRICINGCONDITIONTERM,
    CNDNTRMEXCHRATEISNONTRADINGDAY,
    CNDNTRMEXCHRATEISSUBSTITUTED,
    CNDNTRMEXCHRATESUBSTNDATETIME,
    CONDITIONTYPE,
    NUMBEROFSOURCECURRENCYUNITS,
    NUMBEROFTARGETCURRENCYUNITS,
    PRCGCNDNTRMEXCHRATEFCSTSTATUS,
    PRCGCNDNTRMEXCHRATEISIGNORED,
    PRCGCNDNTRMEXCHRATEISMISSING,
    PRCGCONDITIONEXCHANGERATETYPE,
    PRCGCONDITIONSPOTEXCHANGERATE,
    PRCGCONDITIONSWAPEXCHANGERATE,
    PRICINGCONDITIONEXCHANGERATE,
    PRICINGCONDITIONSOURCECURRENCY,
    PRICINGCONDITIONTARGETCURRENCY,
    PRIMARY KEY (DOCITMCMMDTYPRCGCNDNUUID, PRCGCNDNTRMEXCHRATEDATETIME, PRCGCONDITIONCONVERSIONPLACE, PRICINGCONDITIONTERM)
);

Learn More