I_PurchaseHubCommodityTerm

Purchase hub commodity term | view: IPURHUBTERM | Extraction: Not supported | Component: Basic Functions
Tables used: CPED_KNUMHTOGUID, CPED_TERMGRPOUT, CPED_PERIODDTOUT, CPED_FORMDOC, CPED_TERMINPUT, CPED_TERMOUT, CPEC_QUOTRULE, CPEC_TERM, CPEC_TERMGRP
Column Name Description
ConditionRecord Number of the Condition Record
ConditionSequentialNumberShort Sequential number of the condition
PricingConditionTerm CPE Term - Number in Formula
Column Name Description
Column Name Description
📏 CPE Formula - Unit of Measure of Commodity Used in Formula (PrcgCndnFmlaCmmdtyQuantityUnit):
PrcgCndnFmlaCommodityQuantity CPE Formula - Total Quantity of Commodity in Document Item
Column Name Description
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 CPE_PRUN
PrcgCndnTrmQtanPerdStrtDteTime CPE Term - First Date and Time of Period Determined CPE_TIMESTAMP_WO_CONV_EXIT
PrcgCndnTrmQtanPerdEndDateTime CPE Term - End Date and Time of Period Determined CPE_TIMESTAMP_WO_CONV_EXIT
PrcgCndnTrmQtanPerdBaseDteTime CPE Term - Calculated Base Date and Time CPE_TIMESTAMP_WO_CONV_EXIT
CndnTrmExchRatePerdStrtDteTime CPE Term - First Date and Time of Period Determined CPE_TIMESTAMP_WO_CONV_EXIT
CndnTrmExchRatePerdEndDateTime CPE Term - End Date and Time of Period Determined CPE_TIMESTAMP_WO_CONV_EXIT
CndnTrmExchRatePerdBaseDteTime CPE Term - Calculated Base Date and Time CPE_TIMESTAMP_WO_CONV_EXIT
PrcgConditionTermSurchargeRate CPE Term - Total Surcharge for Commodity
PrcgCndnTrmSurchargeRteQty CPE Term - Price Unit of Absolute Surcharge CPE_PRUN
PricingConditionTermGroup CPE Term - Term Group CHAR1
PricingConditionTermFixedRate CPE Term - Fixed Rate
PrcgConditionTermFixedRateQty CPE - Price Unit of Fixed Rate CPE_PRUN
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
  • CPE Formula - Unit of Measure of Commodity Used in Formula
  • Client
  • I_PURCHASEHUBCOMMODITYTERM.PRCGCNDNFMLACMMDTYQUANTITYUNIT == T006.MSEHI
  • I_PURCHASEHUBCOMMODITYTERM.MANDT == T006.MANDT
CPE Formula - Key
  • ?
  • ?
  • ?
  • Client
  • CPE Formula - Key
  • I_PURCHASEHUBCOMMODITYTERM.[column in domain "CPET_COND_TYPE"] == CPEC_FORMULA.COND_TYPE
  • I_PURCHASEHUBCOMMODITYTERM.[column in domain "CPET_VALIDFROM"] == CPEC_FORMULA.VALIDTO
  • I_PURCHASEHUBCOMMODITYTERM.[column in domain "LOGSYS"] == CPEC_FORMULA.LOGSYS
  • I_PURCHASEHUBCOMMODITYTERM.MANDT == CPEC_FORMULA.CLIENT
  • I_PURCHASEHUBCOMMODITYTERM.PRICINGCONDITIONFORMULAKEY == CPEC_FORMULA.FORMID