CPEC_TERM

CPE Term | #masterdata | Component: Commodity Pricing Engine
Column Name Description
CLIENT Client
LOGSYS FK Logical system
TERMID CPE Term - Key
COND_TYPE CPE: Condition Type for Commodity Pricing
VALIDTO CPE - 'Valid From' Time Stamp of Commodity Pricing Object
Column Name Description
💲 CPE - Currency for Fixed Rate (FIXTERMCURR):
FIXTERMRATE CPE Term - Fixed Rate
Column Name Description
Column Name Description
Column Name Description
REFDOCCAT CPE Term - Reference Document Category Show values
QUOTKEY Quotation Key Type in Document UI (all values) Show values
DCS_SELECTION_TYPE Maturity Selection Type Show values
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
DCS_PERIOD_TYPE Period Type Show values
Column Name Description Domain name
REFDOC CPE Term - Reference Document Number CPE_DOCUMENT
REFITEM CPE Term - Reference Document Item Number CPE_DOCITEM
REFGUID CPE Term - GUID of Reference Document Item SYSUUID
REFCOND CPE Term - Reference Condition Type KSCHL
FIXTERMPRUN CPE - Price Unit of Fixed Rate CPE_PRUN
USERVAL1 CPE Term - Freely Usable Field CPE_USERVAL1
PRICETYPE Type of Price Quotation VVSKURSART
CURVE_TYPE Commodity Curve Type TBA_CTY_CURVE_TYPE
KEYDATE_OFFSET_UNITS CPE Term - Number of Time Units for Date Offset Routine DEC3
BASIS_TYPE Basis Type TBAC_BASIS_TYPE
FIXTERMRATE_DF34 CPE Term - Fixed Rate (up to 14 decimals) CPE_INTERNAL_VALUE
Master Data Relations Join Conditions
Foreign key for currency of fix term rate
  • CPEC_TERM.CLIENT == TCURC.MANDT
  • CPEC_TERM.FIXTERMCURR == TCURC.WAERS
Foreign key for UoM of fix term rate
  • CPEC_TERM.CLIENT == T006.MANDT
  • CPEC_TERM.FIXTERMUOM == T006.MSEHI
Latest Evaluation Key Date Routine
  • ?
  • Client
  • ?
  • Latest Evaluation Key Date Routine
Logical system CPEC_TERM.LOGSYS == TBDLS.LOGSYS
foreign key for quotation group
  • CPE - 'Valid From' Time Stamp of Commodity Pricing Object
  • Client
  • Logical system
  • Quotation Group
foreign key for term rule
  • ?
  • Client
  • ?
  • CPE Term - Term Rule
CPE Term - Term Calculation Type
  • ?
  • ?
  • CPE Term - Term Calculation Type
  • ?