1. Home
  2. Resources
  3. SAP Tables
  4. CPED_TERMINPUT - CPE Term - Changed Input for General Data

SAP Table CPED_TERMINPUT

CPE Term - Changed Input for General Data

CPED_TERMINPUT (CPE Term - Changed Input for General Data) 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 CPED_TERMINPUT to other SAP tables.

CPED_TERMINPUT table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
TERMINPUT_GUID CPE Term - GUID of Changed General Input CPET_TERMINPUT_GUID RAW 16 0
QUOTKEY Quotation Key in Document UI (all values) CPET_QUOTKEY_ALL 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
CALCRULE CPE Term - Calculation Rule CPET_CALCRULE CPEC_CALCRULE CHAR 5 0
SURCHARGERULE CPE Term - Surcharge Rule CPET_SURCHARGERULE CPEC_SURCHARGE CHAR 5 0
PERDETRULE_Q CPE Term - Period Determination Rule for Commodity Rates CPET_PERDETRULE_Q CPEC_PERIODDET CHAR 5 0
PERDETRULE_C CPE Term - Period Determ. Rule for Currency Exchange Rates CPET_PERDETRULE_C CPEC_PERIODDET CHAR 5 0
PERDTIN_GUID_Q CPE Term - GUID for Changed Input of Period Determination CPET_PERIODDTIN_GUID CPED_PERIODDTIN RAW 16 0
PERDTIN_GUID_C CPE Term - GUID for Changed Input of Period Determination CPET_PERIODDTIN_GUID CPED_PERIODDTIN RAW 16 0
CALCROUT CPE Term - Calculation Routine CPET_CALCROUT CPEC_ROUTINE NUMC 7 0
CALCMIN CPE Term - Minimum of Commodity Rate Calculation CPET_CALCMIN CURR 15 2
CALCMAX CPE Term - Maximum of Commodity Rate Calculation CPET_CALCMAX CURR 15 2
CALCMMCURR CPE Term - Currency of Rate Calculation Limits CPET_CALCMMCURR TCURC CUKY 5 0
CALCMMPRUN CPE Term - Price Unit of Rate Calculation Limits CPET_CALCMMPRUN DEC 5 0
CALCMMUOM CPE Term - Unit of Measure for Rate Limits CPET_CALCMMUOM T006 UNIT 3 0
SURCHARGEROUT CPE Term - Surcharge Routine CPET_SURCHARGEROUT CPEC_ROUTINE NUMC 7 0
SURCHARGEABS CPE Term - Absolute Surcharge for Commodity CPET_SURCHARGEABS CURR 15 2
SURCHARGECURR CPE Term - Currency of Absolute Surcharge CPET_SURCHARGECURR TCURC CUKY 5 0
SURCHARGEPRUN CPE Term - Price Unit of Absolute Surcharge CPET_SURCHARGEPRUN DEC 5 0
SURCHARGEUOM CPE Term - Unit of Measure of Absolute Surcharge CPET_SURCHARGEUOM T006 UNIT 3 0
SURCHARGEFACTOR1 CPE Term - Factor 1 when Combining Surcharge and Quotation CPET_SURCHARGEFACTOR1 DEC 10 6
SURCHARGEFACTOR2 CPE Term - Factor 2 when Combining Surcharge and Quotation CPET_SURCHARGEFACTOR2 DEC 10 6
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
KEYDATE DCS Key Date TBA_KEYDATE DATS 8 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
TERMTEXT Description BEZEI40 CHAR 40 0

CPED_TERMINPUT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CPED_TERMINPUT CALCMMCURR SYST MANDT TCURC Currency Codes MANDT
CPED_TERMINPUT CALCMMCURR CPED_TERMINPUT CALCMMCURR TCURC Currency Codes WAERS
CPED_TERMINPUT CALCMMUOM SYST MANDT T006 Units of Measurement MANDT
CPED_TERMINPUT CALCMMUOM CPED_TERMINPUT CALCMMUOM T006 Units of Measurement MSEHI
CPED_TERMINPUT CALCROUT SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPED_TERMINPUT CALCROUT * CPEC_ROUTINE CPE Routine LOGSYS
CPED_TERMINPUT CALCROUT 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPED_TERMINPUT CALCROUT '07' CPEC_ROUTINE CPE Routine SUBMODULE
CPED_TERMINPUT CALCROUT CPED_TERMINPUT CALCROUT CPEC_ROUTINE CPE Routine CPE_ROUTINE
CPED_TERMINPUT CALCRULE SYST MANDT CPEC_CALCRULE CPE Term - Calculation Rule CLIENT
CPED_TERMINPUT CALCRULE ' ' CPEC_CALCRULE CPE Term - Calculation Rule LOGSYS
CPED_TERMINPUT CALCRULE CPED_TERMINPUT CALCRULE CPEC_CALCRULE CPE Term - Calculation Rule CALCRULE
CPED_TERMINPUT CALCRULE * CPEC_CALCRULE CPE Term - Calculation Rule VALIDTO
CPED_TERMINPUT CURVE_DCSID SYST MANDT TBAC_DCS Derivative contract specification customizing table CLIENT
CPED_TERMINPUT CURVE_DCSID CPED_TERMINPUT CURVE_DCSID TBAC_DCS Derivative contract specification customizing table .INCLUDE
CPED_TERMINPUT CURVE_MIC SYST MANDT TBAC_MIC Customizing table for Market Identification Code CLIENT
CPED_TERMINPUT CURVE_MIC CPED_TERMINPUT CURVE_MIC TBAC_MIC Customizing table for Market Identification Code MIC
CPED_TERMINPUT DCSID SYST MANDT TBAC_DCS Derivative contract specification customizing table CLIENT
CPED_TERMINPUT DCSID CPED_TERMINPUT DCSID TBAC_DCS Derivative contract specification customizing table .INCLUDE
CPED_TERMINPUT FIXTERMCURR SYST MANDT TCURC Currency Codes MANDT
CPED_TERMINPUT FIXTERMCURR CPED_TERMINPUT FIXTERMCURR TCURC Currency Codes WAERS
CPED_TERMINPUT FIXTERMUOM SYST MANDT T006 Units of Measurement MANDT
CPED_TERMINPUT FIXTERMUOM CPED_TERMINPUT FIXTERMUOM T006 Units of Measurement MSEHI
CPED_TERMINPUT FORECAST_DATE_ROUTINE CPED_TERMINPUT FORECAST_DATE_ROUTINE CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine REFDATEROUT
CPED_TERMINPUT FORECAST_DATE_ROUTINE SYST MANDT CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine CLIENT
CPED_TERMINPUT FORECAST_DATE_ROUTINE ' ' CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine LOGSYS
CPED_TERMINPUT FORECAST_DATE_ROUTINE * CPEC_REFDATEROUT CPE Term - Reference Date and Time Routine APPLICATION
CPED_TERMINPUT FORECAST_ROUTINE SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPED_TERMINPUT FORECAST_ROUTINE ' ' CPEC_ROUTINE CPE Routine LOGSYS
CPED_TERMINPUT FORECAST_ROUTINE 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPED_TERMINPUT FORECAST_ROUTINE '26' CPEC_ROUTINE CPE Routine SUBMODULE
CPED_TERMINPUT FORECAST_ROUTINE CPED_TERMINPUT FORECAST_ROUTINE CPEC_ROUTINE CPE Routine CPE_ROUTINE
CPED_TERMINPUT MIC SYST MANDT TBAC_MIC Customizing table for Market Identification Code CLIENT
CPED_TERMINPUT MIC CPED_TERMINPUT MIC TBAC_MIC Customizing table for Market Identification Code MIC
CPED_TERMINPUT PERDETRULE_C SYST MANDT CPEC_PERIODDET CPE Term - Period Determination Rule CLIENT
CPED_TERMINPUT PERDETRULE_C * CPEC_PERIODDET CPE Term - Period Determination Rule LOGSYS
CPED_TERMINPUT PERDETRULE_C CPED_TERMINPUT PERDETRULE_C CPEC_PERIODDET CPE Term - Period Determination Rule PERIODDETRULE
CPED_TERMINPUT PERDETRULE_C * CPEC_PERIODDET CPE Term - Period Determination Rule VALIDTO
CPED_TERMINPUT PERDETRULE_Q * CPEC_PERIODDET CPE Term - Period Determination Rule LOGSYS
CPED_TERMINPUT PERDETRULE_Q CPED_TERMINPUT PERDETRULE_Q CPEC_PERIODDET CPE Term - Period Determination Rule PERIODDETRULE
CPED_TERMINPUT PERDETRULE_Q * CPEC_PERIODDET CPE Term - Period Determination Rule VALIDTO
CPED_TERMINPUT PERDETRULE_Q SYST MANDT CPEC_PERIODDET CPE Term - Period Determination Rule CLIENT
CPED_TERMINPUT PERDTIN_GUID_C SYST MANDT CPED_PERIODDTIN CPE Term - Changed Input Data for Period Determination .INCLUDE
CPED_TERMINPUT PERDTIN_GUID_C CPED_TERMINPUT PERDTIN_GUID_C CPED_PERIODDTIN CPE Term - Changed Input Data for Period Determination CLIENT
CPED_TERMINPUT PERDTIN_GUID_Q CPED_TERMINPUT PERDTIN_GUID_Q CPED_PERIODDTIN CPE Term - Changed Input Data for Period Determination CLIENT
CPED_TERMINPUT PERDTIN_GUID_Q SYST MANDT CPED_PERIODDTIN CPE Term - Changed Input Data for Period Determination .INCLUDE
CPED_TERMINPUT QUOTGROUP * CPEC_QUOTGROUP Quotation Group VALIDTO
CPED_TERMINPUT QUOTGROUP CPED_TERMINPUT QUOTGROUP CPEC_QUOTGROUP Quotation Group QUOTGROUP
CPED_TERMINPUT QUOTGROUP SYST MANDT CPEC_QUOTGROUP Quotation Group CLIENT
CPED_TERMINPUT QUOTGROUP ' ' CPEC_QUOTGROUP Quotation Group LOGSYS
CPED_TERMINPUT QUOTNAME CPED_TERMINPUT QUOTNAME CPEC_QUOTNAME Quotation Name QUOTNAME
CPED_TERMINPUT QUOTNAME SYST MANDT CPEC_QUOTNAME Quotation Name CLIENT
CPED_TERMINPUT QUOTNAME * CPEC_QUOTNAME Quotation Name LOGSYS
CPED_TERMINPUT QUOTNAME CPED_TERMINPUT QUOTSRC CPEC_QUOTNAME Quotation Name QUOTSRC
CPED_TERMINPUT QUOTNAME CPED_TERMINPUT QUOTTYPE CPEC_QUOTNAME Quotation Name QUOTTYPE
CPED_TERMINPUT QUOTSRC SYST MANDT CPEC_QUOTSRC Quotation Source CLIENT
CPED_TERMINPUT QUOTSRC ' ' CPEC_QUOTSRC Quotation Source LOGSYS
CPED_TERMINPUT QUOTSRC CPED_TERMINPUT QUOTSRC CPEC_QUOTSRC Quotation Source QUOTSRC
CPED_TERMINPUT QUOTTYPE ' ' CPEC_QUOTTYPE Quotation Type LOGSYS
CPED_TERMINPUT QUOTTYPE CPED_TERMINPUT QUOTTYPE CPEC_QUOTTYPE Quotation Type QUOTTYPE
CPED_TERMINPUT QUOTTYPE SYST MANDT CPEC_QUOTTYPE Quotation Type CLIENT
CPED_TERMINPUT SURCHARGECURR CPED_TERMINPUT SURCHARGECURR TCURC Currency Codes WAERS
CPED_TERMINPUT SURCHARGECURR SYST MANDT TCURC Currency Codes MANDT
CPED_TERMINPUT SURCHARGEROUT SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPED_TERMINPUT SURCHARGEROUT * CPEC_ROUTINE CPE Routine LOGSYS
CPED_TERMINPUT SURCHARGEROUT 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPED_TERMINPUT SURCHARGEROUT '09' CPEC_ROUTINE CPE Routine SUBMODULE
CPED_TERMINPUT SURCHARGEROUT CPED_TERMINPUT SURCHARGEROUT CPEC_ROUTINE CPE Routine CPE_ROUTINE
CPED_TERMINPUT SURCHARGERULE ' ' CPEC_SURCHARGE CPE Term - Surcharge Rule LOGSYS
CPED_TERMINPUT SURCHARGERULE CPED_TERMINPUT SURCHARGERULE CPEC_SURCHARGE CPE Term - Surcharge Rule SURCHARGERULE
CPED_TERMINPUT SURCHARGERULE * CPEC_SURCHARGE CPE Term - Surcharge Rule VALIDTO
CPED_TERMINPUT SURCHARGERULE SYST MANDT CPEC_SURCHARGE CPE Term - Surcharge Rule CLIENT
CPED_TERMINPUT SURCHARGEUOM CPED_TERMINPUT SURCHARGEUOM T006 Units of Measurement MSEHI
CPED_TERMINPUT SURCHARGEUOM SYST MANDT T006 Units of Measurement MANDT
CPED_TERMINPUT TENOR CPED_TERMINPUT TENOR TBAC_TENOR Customizing Table for Time to Maturity .INCLUDE
CPED_TERMINPUT TENOR SYST MANDT TBAC_TENOR Customizing Table for Time to Maturity CLIENT
CPED_TERMINPUT TERMRULE CPED_TERMINPUT TERMRULE CPEC_TERMRULE CPE Term - Term Rule TERMRULE
CPED_TERMINPUT TERMRULE * CPEC_TERMRULE CPE Term - Term Rule VALIDTO
CPED_TERMINPUT TERMRULE SYST MANDT CPEC_TERMRULE CPE Term - Term Rule CLIENT
CPED_TERMINPUT TERMRULE ' ' CPEC_TERMRULE CPE Term - Term Rule LOGSYS
CPED_TERMINPUT TERMTYPE SYST MANDT CPEC_ROUTINE CPE Routine CLIENT
CPED_TERMINPUT TERMTYPE * CPEC_ROUTINE CPE Routine LOGSYS
CPED_TERMINPUT TERMTYPE 'FE' CPEC_ROUTINE CPE Routine CPE_MODULE
CPED_TERMINPUT TERMTYPE '05' CPEC_ROUTINE CPE Routine SUBMODULE
CPED_TERMINPUT TERMTYPE CPED_TERMINPUT TERMTYPE CPEC_ROUTINE CPE Routine CPE_ROUTINE