CPEC_TERM - CPE Term

CPE Term information is stored in SAP table CPEC_TERM.
It is part of development package CPE_BASIS in software component CA-GTF-CPE. This development package consists of objects that can be grouped under "Commodity Pricing Engine: Basic Objects".

Fields for table CPEC_TERM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
LOGSYS	Logical system	X	LOGSYS	CHAR	20	TBDLS
TERMID	CPE Term - Key	X	CPET_TERMID	CHAR	20
COND_TYPE	CPE: Condition Type for Commodity Pricing	X	CPET_COND_TYPE	CHAR	8
VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	X	CPET_VALIDFROM	CHAR	28
.INCLUDE				CPET_TERM_IN	0
.INCLUDE				BAPI_CPE_TERM_IN	0
TERMTYPE	CPE Term - Term Calculation Type		CPET_TERMTYPE	NUMC	14	CPEC_ROUTINE
TERMRULE	CPE Term - Term Rule		CPET_TERMRULE	CHAR	20	CPEC_TERMRULE
REFDOCCAT	CPE Term - Reference Document Category		CPET_REFDOCCAT	NUMC	6
REFDOC	CPE Term - Reference Document Number		CPET_REFDOC	CHAR	20
REFITEM	CPE Term - Reference Document Item Number		CPET_REFITEM	CHAR	20
REFGUID	CPE Term - GUID of Reference Document Item		CPET_REFGUID	RAW	16
REFCOND	CPE Term - Reference Condition Type		CPET_REFCOND	CHAR	8	*
FIXTERMRATE	CPE Term - Fixed Rate		CPET_FIXTERMRATE	CURR	8
FIXTERMCURR	CPE - Currency for Fixed Rate		CPET_FIXCURR	CUKY	10	TCURC
FIXTERMPRUN	CPE - Price Unit of Fixed Rate		CPET_FIXPRUN	DEC	3
FIXTERMUOM	CPE - Unit of Measure of Fixed Rate		CPET_FIXUOM	UNIT	6	T006
USERVAL1	CPE Term - Freely Usable Field		CPET_USERVAL1	DEC	9
USERUOM1	CPE Term - Freely Usable Unit of Measure Field		CPET_USERUOM1	UNIT	6	*
.INCLUDE				BAPI_CPE_QUOTATIONRULE_NEW	0
QUOTKEY	Quotation Key Type in Document UI (all values)		CPET_QUOTKEY_ALL	CHAR	2
DCSID	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
MIC	Market Identifier Code		TBA_MIC	CHAR	8
TENOR	Time to Maturity		TBA_TENOR	CHAR	20
PRICETYPE	Type of Price Quotation		TBA_PRICETYPE	CHAR	4
FORECAST_ROUTINE	Quotation Forecast Routine		CPET_QUOTFORECASTROUT	NUMC	14	*
CURVE_TYPE	Commodity Curve Type		TBA_CURVETYPE	NUMC	6
CURVE_DCSID	Alternative Derivative Contract Specification ID		CPET_CURVE_DCSID	CHAR	40	*
CURVE_MIC	Alternative Market Identifier Code		CPET_CURVE_MIC	CHAR	8	*
DCS_SELECTION_TYPE	Maturity Selection Type		CPET_KEYDATE_SELECTION_TYPE	INT1	1
TIMING	Timing/Periodicity of Commodity Forward Indexes		TBA_TIMING	NUMC	4
.INCLUDE				CPET_KEYDATE_SELECTION	0
KEYDATE_REFDATE_ROUT	Reference Date Routine for Maturity Selection		CPET_KEYDATE_REFDATE_ROUT	NUMC	14	*
KEYDATE_SELECTION_ROUT	Maturity Selection Routine		CPET_KEYDATE_SELECTION_ROUT	NUMC	14	*
KEYDATE_OFFSET_ROUT	CPE Term - Date Offset Routine for Period Determination		CPET_KEYDATE_OFFSET_ROUT	NUMC	14
KEYDATE_OFFSET_UNITS	CPE Term - Number of Time Units for Date Offset Routine		CPET_KEYDATE_OFFSETUNITS	DEC	2
DCS_PERIOD_TYPE	Period Type		TBA_PERIODTYPE	CHAR	8
BASIS_TYPE	Basis Type		TBAC_BASIS_TYPE	CHAR	6
QUOTGROUP	Quotation Group		CPET_QUOTGROUP	CHAR	20	CPEC_QUOTGROUP
QUOTATIONRULE	CPE Quotation Rule		CPET_QUOTATIONRULE	CHAR	20	*
FORECAST_DATE_ROUTINE	Latest Evaluation Key Date Routine		CPET_LATEST_EVAL_KEYDATE_ROUT	NUMC	14	CPEC_REFDATEROUT
.INCLUDE				CI_BAPI_CPET_TERMIN_USER	0
FIXTERMRATE_DF34	CPE Term - Fixed Rate (up to 14 decimals)		CPET_FIXTERMRATE_DF34	D34D	16