I_CntrlPurContrCmmdtyTerm

CCTR Commodity Term | view: ICCNTRTERM | Extraction: Not supported | Component: Basic Functions
Tables used: CPED_KNUMHTOGUID, CPED_TERMGRPOUT, CPED_PERIODDTOUT, CPED_FORMDOC, CPED_TERMINPUT, CPED_TERMOUT, CPEC_QUOTRULE, CPEC_TERM, A016, KONP, CPEC_TERMGRP
Column Name Description
ConditionRecord Number of the Condition Record
ConditionSequentialNumber Sequential number of the condition
CentralPurchaseContract FK Purchasing Document Number
CentralPurchaseContractItem FK Item Number of Purchasing Document
ConditionValidityEndDate null
PricingConditionTerm CPE Term - Number in Formula
Column Name Description
Column Name Description
📏 CPE - Unit of Measure Converted to During Conversion (PrcgCndnTargetQuantityUnit):
PrcgCndnFmlaCommodityQuantity CPE Formula - Total Quantity of Commodity in Document Item
Column Name Description
ConditionValidityEndDate null
PrcgCndnTrmQtanPerdRefDate CPE Term - Calculated Reference Date
PrcgCndnTrmExchRatePerdRefDate CPE Term - Calculated Reference Date
Column Name Description
PrcgCndnFmlaEvaluationModule CPE - Module of the Commodity Pricing Engine Show values
Column Name Description Domain name
DocItemCommodityPricingUUID CPE Caller - GUID of Document Item SYSUUID
ConditionType CPE: Condition Type for Commodity Pricing KSCHL
OriginSystem CPE Formula - Original Logical System LOGSYS
PrcgCndnFmlaEvaluationDateTime CPE Formula - Evaluation Date and Time CPE_TIMESTAMP_WO_CONV_EXIT
CndnExchRatePerdDetnResultUUID CPE Term - GUID for Result of Period Determination SYSUUID
PrcgCndnTrmConversionInputUUID CPE Term - GUID for Conversion Input SYSUUID
PrcgCndnTermConversionRsltUUID CPE Term - GUID for Conversion Result SYSUUID
PricingConditionConversionRule CPE - Conversion Rule CPE_RULE
PrcgConditionFixedExchangeRate CPE Term - Fixed Exchange Rate for Currency Conversion CPE_CONVFACTOR
CndnCnvrsnRuleValdtyStrtDteTme CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
CndnTrmCnvrsnValdtyStrtDteTme CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
PrcgConditionConversionPlace CPE - Conversion Place NUMC4
PrcgCndnGrpTrmValdtyStrtDteTme CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
PricingConditionTermKey CPE Term - Key CPE_TERMID
PrcgCndnTrmValdtyStartDateTime CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
CndnTrmCalcTypeRoutineSubMdl CPE Log - Submodule CHAR2
PrcgCndnTermCalculationType CPE Term - Term Calculation Type CPE_ROUTINE
PricingConditionTermRule CPE Term - Term Rule CPE_RULE
CndnTrmRuleValdtyStartDateTime CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
PrcgCndnTermCalculationRule CPE Term - Calculation Rule CPE_RULE
CndnCalcRuleValdtyStrtDateTime CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
PrcgCndnTermQuotationRule CPE Quotation Rule CPE_RULE
CndnQtanRuleValdtyStrtDateTime CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPE_TIMESTAMP_WO_CONV_EXIT
PricingConditionTermRate CPE Term - Rate
PrcgConditionTermRateQty CPE Term - Price Unit CPE_PRUN
PrcgConditionTermQuotationRate CPE Price Quotation
PrcgCndnTrmQtanRateQuantity Price Unit of Quotation
PrcgCndnTrmQtanPerdStrtDteTime CPE Term - First Date and Time of Period Determined
PrcgCndnTrmQtanPerdEndDateTime CPE Term - End Date and Time of Period Determined
PrcgCndnTrmQtanPerdBaseDteTime CPE Term - Calculated Base Date and Time
CndnTrmExchRatePerdStrtDteTime CPE Term - First Date and Time of Period Determined
CndnTrmExchRatePerdEndDateTime CPE Term - End Date and Time of Period Determined
CndnTrmExchRatePerdBaseDteTime CPE Term - Calculated Base Date and Time
PrcgConditionTermSurchargeRate CPE Term - Total Surcharge for Commodity
PrcgCndnTrmSurchargeRteQty CPE Term - Price Unit of Absolute Surcharge
PricingConditionTermGroup CPE Term - Term Group CHAR1
PricingConditionTermFixedRate CPE Term - Fixed Rate
PrcgConditionTermFixedRateQty CPE - Price Unit of Fixed Rate
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
TimeToMaturity Time to Maturity TBA_TENOR
QuotationPriceType Type of Price Quotation VVSKURSART
Master Data Relations Join Conditions
CPE Formula - Unit of Measure of Commodity Used in Formula
  • Client
  • CPE Formula - Unit of Measure of Commodity Used in Formula
  • I_CNTRLPURCONTRCMMDTYTERM.MANDT == T006.MANDT
  • I_CNTRLPURCONTRCMMDTYTERM.PRCGCNDNFMLACMMDTYQUANTITYUNIT == T006.MSEHI
CPE Formula - Key
  • Client
  • ?
  • ?
  • ?
  • CPE Formula - Key
  • I_CNTRLPURCONTRCMMDTYTERM.MANDT == CPEC_FORMULA.CLIENT
  • I_CNTRLPURCONTRCMMDTYTERM.[column in domain "CPET_COND_TYPE"] == CPEC_FORMULA.COND_TYPE
  • I_CNTRLPURCONTRCMMDTYTERM.[column in domain "CPET_VALIDFROM"] == CPEC_FORMULA.VALIDTO
  • I_CNTRLPURCONTRCMMDTYTERM.[column in domain "LOGSYS"] == CPEC_FORMULA.LOGSYS
  • I_CNTRLPURCONTRCMMDTYTERM.PRICINGCONDITIONFORMULAKEY == CPEC_FORMULA.FORMID