The CPEC_TERM table in SAP ERP or S/4HANA stores CPE Term data. There are total 39 fields in CPEC_TERM table. The CPE Term table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CPEC_TERM table. It is in Commodity Pricing Engine: Basic Objects (CPE_BASIS) ABAP package and is part of the Commodity Pricing Engine (CA-GTF-CPE) module.
SAP CPEC_TERM Table Fields
Following is the list of fields that are available in SAP CPEC_TERM table. The primary key fields of the table are CLIENT (Client), LOGSYS (Logical system), TERMID (CPE Term – Key), COND_TYPE (CPE: Condition Type for Commodity Pricing), VALIDTO (CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| TERMID | CPE Term – Key | CPET_TERMID | CHAR (10) | |
| COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR (4) | |
| VALIDTO | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR (14) | |
| TERMTYPE | CPE Term – Term Calculation Type | CPET_TERMTYPE | CPEC_ROUTINE | NUMC (7) |
| TERMRULE | CPE Term – Term Rule | CPET_TERMRULE | CPEC_TERMRULE | CHAR (10) |
| REFDOCCAT | CPE Term – Reference Document Category | CPET_REFDOCCAT | NUMC (3) | |
| REFDOC | CPE Term – Reference Document Number | CPET_REFDOC | CHAR (10) | |
| REFITEM | CPE Term – Reference Document Item Number | CPET_REFITEM | CHAR (10) | |
| REFGUID | CPE Term – GUID of Reference Document Item | CPET_REFGUID | RAW (16) | |
| REFCOND | CPE Term – Reference Condition Type | CPET_REFCOND | * | CHAR (4) |
| FIXTERMRATE | CPE Term – Fixed Rate | CPET_FIXTERMRATE | CURR (15) | |
| FIXTERMCURR | CPE – Currency for Fixed Rate | CPET_FIXCURR | TCURC | CUKY (5) |
| FIXTERMPRUN | CPE – Price Unit of Fixed Rate | CPET_FIXPRUN | DEC (5) | |
| FIXTERMUOM | CPE – Unit of Measure of Fixed Rate | CPET_FIXUOM | T006 | UNIT (3) |
| USERVAL1 | CPE Term – Freely Usable Field | CPET_USERVAL1 | DEC (17) | |
| USERUOM1 | CPE Term – Freely Usable Unit of Measure Field | CPET_USERUOM1 | * | UNIT (3) |
| QUOTKEY | Quotation Key Type in Document UI (all values) | CPET_QUOTKEY_ALL | CHAR (1) | |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR (20) | |
| MIC | Market Identifier Code | TBA_MIC | CHAR (4) | |
| TENOR | Time to Maturity | TBA_TENOR | CHAR (10) | |
| PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR (2) | |
| FORECAST_ROUTINE | Quotation Forecast Routine | CPET_QUOTFORECASTROUT | * | NUMC (7) |
| CURVE_TYPE | Commodity Curve Type | TBA_CURVETYPE | NUMC (3) | |
| CURVE_DCSID | Alternative Derivative Contract Specification ID | CPET_CURVE_DCSID | * | CHAR (20) |
| CURVE_MIC | Alternative Market Identifier Code | CPET_CURVE_MIC | * | CHAR (4) |
| DCS_SELECTION_TYPE | Maturity Selection Type | CPET_KEYDATE_SELECTION_TYPE | INT1 (3) | |
| TIMING | Timing/Periodicity of Commodity Forward Indexes | TBA_TIMING | NUMC (2) | |
| KEYDATE_REFDATE_ROUT | Reference Date Routine for Maturity Selection | CPET_KEYDATE_REFDATE_ROUT | * | NUMC (7) |
| KEYDATE_SELECTION_ROUT | Maturity Selection Routine | CPET_KEYDATE_SELECTION_ROUT | * | NUMC (7) |
| KEYDATE_OFFSET_ROUT | CPE Term – Date Offset Routine for Period Determination | CPET_KEYDATE_OFFSET_ROUT | NUMC (7) | |
| KEYDATE_OFFSET_UNITS | CPE Term – Number of Time Units for Date Offset Routine | CPET_KEYDATE_OFFSETUNITS | DEC (3) | |
| DCS_PERIOD_TYPE | Period Type | TBA_PERIODTYPE | CHAR (4) | |
| BASIS_TYPE | Basis Type | TBAC_BASIS_TYPE | CHAR (3) | |
| QUOTGROUP | Quotation Group | CPET_QUOTGROUP | CPEC_QUOTGROUP | CHAR (10) |
| QUOTATIONRULE | CPE Quotation Rule | CPET_QUOTATIONRULE | * | CHAR (10) |
| FORECAST_DATE_ROUTINE | Latest Evaluation Key Date Routine | CPET_LATEST_EVAL_KEYDATE_ROUT | CPEC_REFDATEROUT | NUMC (7) |
| FIXTERMRATE_DF34 | CPE Term – Fixed Rate (up to 14 decimals) | CPET_FIXTERMRATE_DF34 | D34D (31) |
