I_CmmdtyPricingTermGrouping

CPE Term Grouping of Terms | view: ITERMGROUPING | Extraction: Not supported | Component: Commodity Pricing Engine
Tables used: CPEC_TERMGRP
Column Name Description
OriginSystem FK Logical system
PricingConditionFormulaKey FK CPE Formula - Key
ConditionType CPE: Condition Type for Commodity Pricing
PricingConditionTerm CPE Term - Number in Formula
PrcgCndnGrpTrmValdtyStrtDteTme CPE - 'Valid From' Time Stamp of Commodity Pricing Object
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PricingConditionTermKey CPE Term - Key CPE_TERMID
PricingConditionTermGroup CPE Term - Term Group CHAR1
Master Data Relations Join Conditions
Logical system I_CMMDTYPRICINGTERMGROUPING.ORIGINSYSTEM == TBDLS.LOGSYS
CPE Formula - Key
  • Logical system
  • CPE - 'Valid From' Time Stamp of Commodity Pricing Object
  • Client
  • CPE Formula - Key
  • CPE: Condition Type for Commodity Pricing
  • I_CMMDTYPRICINGTERMGROUPING.ORIGINSYSTEM == CPEC_FORMULA.LOGSYS
  • I_CMMDTYPRICINGTERMGROUPING.PRCGCNDNGRPTRMVALDTYSTRTDTETME == CPEC_FORMULA.VALIDTO
  • I_CMMDTYPRICINGTERMGROUPING.MANDT == CPEC_FORMULA.CLIENT
  • I_CMMDTYPRICINGTERMGROUPING.PRICINGCONDITIONFORMULAKEY == CPEC_FORMULA.FORMID
  • I_CMMDTYPRICINGTERMGROUPING.CONDITIONTYPE == CPEC_FORMULA.COND_TYPE