I_CmmdtyPricingTermConversion

CPE Term Conversion | view: ITRMCNVRSN | Extraction: Not supported | Component: Commodity Pricing Engine
Tables used: CPEC_TERMCONV
Column Name Description
OriginSystem FK Logical system
PricingConditionTermKey FK CPE Term - Key
ConditionType CPE: Condition Type for Commodity Pricing
CndnTrmCnvrsnValdtyStrtDteTme CPE - 'Valid From' Time Stamp of Commodity Pricing Object
PrcgConditionConversionPlace FK CPE - Conversion Place
PricingConditionSourceCurrency FK CPE - Currency to Be Converted During Conversion ('from')
PrcgCndnSourceQuantityUnit FK CPE - Unit of Measure to Be Converted During Conv. ('From')
PricingConditionTargetCurrency FK CPE - Currency to Be Converted to During Conversion ('to')
PrcgCndnTargetQuantityUnit FK CPE - Unit of Measure Converted to During Conversion
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PrcgConditionFixedExchangeRate CPE Term - Fixed Exchange Rate for Currency Conversion CPE_CONVFACTOR
PrcgCndnSourceConversionFactor CPE - From-Factor for Conversion CPE_CONVFACTOR
PrcgCndnTargetConversionFactor CPE - To-Factor for Conversion CPE_CONVFACTOR
Master Data Relations Join Conditions
Logical system I_CMMDTYPRICINGTERMCONVERSION.ORIGINSYSTEM == TBDLS.LOGSYS
CPE - Unit of Measure to Be Converted During Conv. ('From')
  • Client
  • CPE - Unit of Measure to Be Converted During Conv. ('From')
  • I_CMMDTYPRICINGTERMCONVERSION.MANDT == T006.MANDT
  • I_CMMDTYPRICINGTERMCONVERSION.PRCGCNDNSOURCEQUANTITYUNIT == T006.MSEHI
CPE - Unit of Measure Converted to During Conversion
  • Client
  • CPE - Unit of Measure Converted to During Conversion
  • I_CMMDTYPRICINGTERMCONVERSION.MANDT == T006.MANDT
  • I_CMMDTYPRICINGTERMCONVERSION.PRCGCNDNTARGETQUANTITYUNIT == T006.MSEHI
CPE - Currency to Be Converted During Conversion ('from')
  • CPE - Currency to Be Converted During Conversion ('from')
  • Client
  • I_CMMDTYPRICINGTERMCONVERSION.PRICINGCONDITIONSOURCECURRENCY == TCURC.WAERS
  • I_CMMDTYPRICINGTERMCONVERSION.MANDT == TCURC.MANDT
CPE - Currency to Be Converted to During Conversion ('to')
  • Client
  • CPE - Currency to Be Converted to During Conversion ('to')
  • I_CMMDTYPRICINGTERMCONVERSION.MANDT == TCURC.MANDT
  • I_CMMDTYPRICINGTERMCONVERSION.PRICINGCONDITIONTARGETCURRENCY == TCURC.WAERS
CPE Term - Key
  • CPE: Condition Type for Commodity Pricing
  • ?
  • Logical system
  • CPE Term - Key
  • Client
  • I_CMMDTYPRICINGTERMCONVERSION.CONDITIONTYPE == CPEC_TERM.COND_TYPE
  • I_CMMDTYPRICINGTERMCONVERSION.[column in domain "CPET_VALIDFROM"] == CPEC_TERM.VALIDTO
  • I_CMMDTYPRICINGTERMCONVERSION.ORIGINSYSTEM == CPEC_TERM.LOGSYS
  • I_CMMDTYPRICINGTERMCONVERSION.PRICINGCONDITIONTERMKEY == CPEC_TERM.TERMID
  • I_CMMDTYPRICINGTERMCONVERSION.MANDT == CPEC_TERM.CLIENT