1. Home
  2. Resources
  3. SAP Tables
  4. CPEC_TERM - CPE Term

SAP Table CPEC_TERM

CPE Term

CPEC_TERM (CPE Term) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CPEC_TERM to other SAP tables.

CPEC_TERM table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
TERMID CPE Term - Key CPET_TERMID CHAR 10 0
COND_TYPE CPE: Condition Type for Commodity Pricing CPET_COND_TYPE CHAR 4 0
VALIDTO CPE - 'Valid From' Time Stamp of Commodity Pricing Object CPET_VALIDFROM CHAR 14 0
QUOTKEY Quotation Key Customizing CPET_QUOTKEY_CUS CHAR 1 0
1 Derivative Contract Specification
2 Quotation Source, Type, Name
3 Quotation Group
TERMTYPE CPE Term - Term Calculation Type CPET_TERMTYPE CPEC_ROUTINE NUMC 7 0
TERMRULE CPE Term - Term Rule CPET_TERMRULE CPEC_TERMRULE CHAR 5 0
QUOTSRC Quotation Source CPET_QUOTSRC CPEC_QUOTSRC CHAR 2 0
QUOTTYPE Quotation Type CPET_QUOTTYPE CPEC_QUOTTYPE CHAR 5 0
QUOTNAME Quotation Name CPET_QUOTNAME CPEC_QUOTNAME CHAR 18 0
QUOTGROUP Quotation Group CPET_QUOTGROUP CPEC_QUOTGROUP CHAR 5 0
REFDOCCAT CPE Term - Reference Document Category CPET_REFDOCCAT NUMC 3 0
001 Inquiry (Sales)
002 Quotation (Sales)
003 Sales Order
004 Contract (Sales)
005 Master Contract (Sales)
006 Returns (Sales)
007 Credit Memo Request (Sales)
008 Debit Memo Request (Sales)
009 Invoice (Sales)
010 Invoice Cancellation (Sales)
011 Intercompany Invoice (Sales)
012 Intercompany Credit Memo (Sales)
013 Credit Memo (Sales)
014 Debit Memo (Sales)
015 Credit Memo Cancellation (Sales)
016 Goods Movement
017 Returns Delivery for Order (Sales)
018 Purchase Order
019 Purchase Contract
020 Commodity Coverage
021 Opportunity
022 Vendor Billing Document (Agency Business)
023 Payment Document (Agency Business)
031 Invoice (Purchasing)
032 Credit Memo (Purchasing)
033 Subsequent Debit (Purchasing)
034 Subsequent Credit (Purchasing)
035 Provisional Invoice (Purchasing)
036 Differential Invoice (Purchasing)
037 Final Invoice (Purchasing)
038 Scheduling Agreement (Sales)
039 Scheduling Agreement (Purchasing)
REFDOC CPE Term - Reference Document Number CPET_REFDOC CHAR 10 0
REFITEM CPE Term - Reference Document Item Number CPET_REFITEM CHAR 10 0
REFGUID CPE Term - GUID of Reference Document Item CPET_REFGUID RAW 16 0
REFCOND CPE Term - Reference Condition Type CPET_REFCOND CHAR 4 0
FIXTERMRATE CPE Term - Fixed Rate CPET_FIXTERMRATE CURR 15 2
FIXTERMCURR CPE - Currency for Fixed Rate CPET_FIXCURR TCURC CUKY 5 0
FIXTERMPRUN CPE - Price Unit of Fixed Rate CPET_FIXPRUN DEC 5 0
FIXTERMUOM CPE - Unit of Measure of Fixed Rate CPET_FIXUOM T006 UNIT 3 0
USERVAL1 CPE Term - Freely Usable Field CPET_USERVAL1 DEC 17 7
USERUOM1 CPE Term - Freely Usable Unit of Measure Field CPET_USERUOM1 UNIT 3 0
DCSID Derivative Contract Specification ID TBA_DCSID TBAC_DCS CHAR 6 0
MIC Market Identifier Code TBA_MIC TBAC_MIC CHAR 4 0
TENOR Time to Maturity TBA_TENOR TBAC_TENOR CHAR 10 0
PRICETYPE Type of Price Quotation TBA_PRICETYPE CHAR 2 0
FORECAST_ROUTINE Quotation Forecast Routine CPET_QUOTFORECASTROUT CPEC_ROUTINE NUMC 7 0
FORECAST_DATE_ROUTINE Forecast Date Routine CPET_FORECAST_DATE_ROUTINE CPEC_REFDATEROUT NUMC 7 0
CURVE_TYPE Commodity Curve Type TBA_CURVETYPE NUMC 3 0
CURVE_DCSID Alternative Derivative Contract Specification ID CPET_CURVE_DCSID TBAC_DCS CHAR 6 0
CURVE_MIC Alternative Market Identifier Code CPET_CURVE_MIC TBAC_MIC CHAR 4 0

CPEC_TERM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CPEC_TERM CURVE_DCSID SYST MANDT TBAC_DCS Derivative contract specification customizing table CLIENT
CPEC_TERM CURVE_DCSID CPEC_TERM CURVE_DCSID TBAC_DCS Derivative contract specification customizing table .INCLUDE
CPEC_TERM CURVE_MIC SYST MANDT TBAC_MIC Customizing table for Market Identification Code CLIENT
CPEC_TERM CURVE_MIC CPEC_TERM CURVE_MIC TBAC_MIC Customizing table for Market Identification Code MIC
CPEC_TERM DCSID CPEC_TERM DCSID TBAC_DCS Derivative contract specification customizing table .INCLUDE
CPEC_TERM DCSID SYST MANDT TBAC_DCS Derivative contract specification customizing table CLIENT
CPEC_TERM FIXTERMCURR SYST MANDT TCURC Currency Codes MANDT
CPEC_TERM FIXTERMCURR CPEC_TERM FIXTERMCURR TCURC Currency Codes WAERS
CPEC_TERM FIXTERMUOM SYST MANDT T006 Units of Measurement MANDT
CPEC_TERM FIXTERMUOM CPEC_TERM FIXTERMUOM T006 Units of Measurement MSEHI
CPEC_TERM FORECAST_DATE_ROUTINE * CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine APPLICATION
CPEC_TERM FORECAST_DATE_ROUTINE CPEC_TERM FORECAST_DATE_ROUTINE CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine REFDATEROUT
CPEC_TERM FORECAST_DATE_ROUTINE SYST MANDT CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine CLIENT
CPEC_TERM FORECAST_DATE_ROUTINE ' ' CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine LOGSYS
CPEC_TERM FORECAST_ROUTINE '26' CPEC_ROUTINE CPE Routine SUBMODULE
CPEC_TERM FORECAST_ROUTINE CPEC_TERM FORECAST_ROUTINE CPEC_ROUTINE CPE Routine CPE_ROUTINE
CPEC_TERM FORECAST_ROUTINE SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPEC_TERM FORECAST_ROUTINE ' ' CPEC_ROUTINE CPE Routine LOGSYS
CPEC_TERM FORECAST_ROUTINE 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPEC_TERM LOGSYS CPEC_TERM LOGSYS TBDLS Logical system LOGSYS
CPEC_TERM MIC SYST MANDT TBAC_MIC Customizing table for Market Identification Code CLIENT
CPEC_TERM MIC CPEC_TERM MIC TBAC_MIC Customizing table for Market Identification Code MIC
CPEC_TERM QUOTGROUP CPEC_TERM LOGSYS CPEC_QUOTGROUP Quotation Group LOGSYS
CPEC_TERM QUOTGROUP CPEC_TERM VALIDTO CPEC_QUOTGROUP Quotation Group VALIDTO
CPEC_TERM QUOTGROUP CPEC_TERM QUOTGROUP CPEC_QUOTGROUP Quotation Group QUOTGROUP
CPEC_TERM QUOTGROUP CPEC_TERM CLIENT CPEC_QUOTGROUP Quotation Group CLIENT
CPEC_TERM QUOTNAME CPEC_TERM QUOTSRC CPEC_QUOTNAME Quotation Name QUOTSRC
CPEC_TERM QUOTNAME CPEC_TERM QUOTTYPE CPEC_QUOTNAME Quotation Name QUOTTYPE
CPEC_TERM QUOTNAME CPEC_TERM QUOTNAME CPEC_QUOTNAME Quotation Name QUOTNAME
CPEC_TERM QUOTNAME CPEC_TERM CLIENT CPEC_QUOTNAME Quotation Name CLIENT
CPEC_TERM QUOTNAME CPEC_TERM LOGSYS CPEC_QUOTNAME Quotation Name LOGSYS
CPEC_TERM QUOTSRC CPEC_TERM CLIENT CPEC_QUOTSRC Quotation Source CLIENT
CPEC_TERM QUOTSRC CPEC_TERM LOGSYS CPEC_QUOTSRC Quotation Source LOGSYS
CPEC_TERM QUOTSRC CPEC_TERM QUOTSRC CPEC_QUOTSRC Quotation Source QUOTSRC
CPEC_TERM QUOTTYPE CPEC_TERM CLIENT CPEC_QUOTTYPE Quotation Type CLIENT
CPEC_TERM QUOTTYPE CPEC_TERM LOGSYS CPEC_QUOTTYPE Quotation Type LOGSYS
CPEC_TERM QUOTTYPE CPEC_TERM QUOTTYPE CPEC_QUOTTYPE Quotation Type QUOTTYPE
CPEC_TERM TENOR CPEC_TERM TENOR TBAC_TENOR Customizing Table for Time to Maturity .INCLUDE
CPEC_TERM TENOR SYST MANDT TBAC_TENOR Customizing Table for Time to Maturity CLIENT
CPEC_TERM TERMRULE CPEC_TERM CLIENT CPEC_TERMRULE CPE Term - Term Rule CLIENT
CPEC_TERM TERMRULE CPEC_TERM LOGSYS CPEC_TERMRULE CPE Term - Term Rule LOGSYS
CPEC_TERM TERMRULE CPEC_TERM TERMRULE CPEC_TERMRULE CPE Term - Term Rule TERMRULE
CPEC_TERM TERMRULE * CPEC_TERMRULE CPE Term - Term Rule VALIDTO
CPEC_TERM TERMTYPE CPEC_TERM TERMTYPE CPEC_ROUTINE CPE Routine CPE_ROUTINE
CPEC_TERM TERMTYPE SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPEC_TERM TERMTYPE * CPEC_ROUTINE CPE Routine LOGSYS
CPEC_TERM TERMTYPE 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPEC_TERM TERMTYPE '05' CPEC_ROUTINE CPE Routine SUBMODULE