CPED_TERMINPUT SAP (CPE Term - Changed Input for General Data) Table details
Description: CPE Term - Changed Input for General Data
Related tables to CPED_TERMINPUT
Access table CPED_TERMINPUT
Table field list including key, data, relationships and ABAP select examples
CPED_TERMINPUT is a standard SAP Table which is used to store CPE Term - Changed Input for General Data data and is available within R/3 SAP systems depending on the version and release level.
The CPED_TERMINPUT table consists of various fields, each holding specific information or linking keys about CPE Term - Changed Input for General Data data available in SAP. These include CLIENT (Client), TERMINPUT_GUID (CPE Term - GUID of Changed General Input), QUOTKEY (Quotation Key in Document UI (all values)), TERMTYPE (CPE Term - Term Calculation Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CPED_TERMINPUT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
TERMINPUT_GUID | CPE Term - GUID of Changed General Input | CPET_TERMINPUT_GUID | RAW | 16 | SYSUUID | ||||
QUOTKEY | Quotation Key in Document UI (all values) | CPET_QUOTKEY_ALL | CHAR | 1 | CPE_QUOTKEY_ALL | ||||
TERMTYPE | CPE Term - Term Calculation Type | CPET_TERMTYPE | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
TERMRULE | CPE Term - Term Rule | CPET_TERMRULE | CHAR | 5 | CPEC_TERMRULE | ALPHA | CPE_RULE | CPE_TERMRULE | |
QUOTSRC | Quotation Source | CPET_QUOTSRC | CHAR | 2 | CPEC_QUOTSRC | CPE_QUOTSRC | CPE_QUOTSRC | ||
QUOTTYPE | Quotation Type | CPET_QUOTTYPE | CHAR | 5 | CPEC_QUOTTYPE | CPE_QUOTTYPE | CPE_QUOTTYPE | ||
QUOTNAME | Quotation Name | CPET_QUOTNAME | CHAR | 18 | CPEC_QUOTNAME | CPE_QUOTNAME | CPE_QUOTNAME | ||
QUOTGROUP | Quotation Group | CPET_QUOTGROUP | CHAR | 5 | CPEC_QUOTGROUP | CHAR5 | CPE_QUOTGROUP | ||
REFDOCCAT | CPE Term - Reference Document Category | CPET_REFDOCCAT | NUMC | 3 | CPE_DOCCATEGORY | ||||
REFDOC | CPE Term - Reference Document Number | CPET_REFDOC | CHAR | 10 | CPE_DOCUMENT | ||||
REFITEM | CPE Term - Reference Document Item Number | CPET_REFITEM | CHAR | 10 | CPE_DOCITEM | ||||
REFGUID | CPE Term - GUID of Reference Document Item | CPET_REFGUID | RAW | 16 | SYSUUID | ||||
REFCOND | CPE Term - Reference Condition Type | CPET_REFCOND | CHAR | 4 | Assigned to domain | KSCHL | |||
FIXTERMRATE | CPE Term - Fixed Rate | CPET_FIXTERMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
FIXTERMCURR | CPE - Currency for Fixed Rate | CPET_FIXCURR | CUKY | 5 | TCURC | WAERS | |||
FIXTERMPRUN | CPE - Price Unit of Fixed Rate | CPET_FIXPRUN | DEC | 5 | CPE_PRUN | ||||
FIXTERMUOM | CPE - Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
USERVAL1 | CPE Term - Freely Usable Field | CPET_USERVAL1 | DEC | 17(7) | CPE_USERVAL1 | ||||
USERUOM1 | CPE Term - Freely Usable Unit of Measure Field | CPET_USERUOM1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CALCRULE | CPE Term - Calculation Rule | CPET_CALCRULE | CHAR | 5 | CPEC_CALCRULE | ALPHA | CPE_RULE | CPE_CALCRULE | |
SURCHARGERULE | CPE Term - Surcharge Rule | CPET_SURCHARGERULE | CHAR | 5 | CPEC_SURCHARGE | ALPHA | CPE_RULE | CPE_SURCHARGERULE | |
PERDETRULE_Q | CPE Term - Period Determination Rule for Commodity Rates | CPET_PERDETRULE_Q | CHAR | 5 | CPEC_PERIODDET | ALPHA | CPE_RULE | CPE_PERDETRULE | |
PERDETRULE_C | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPET_PERDETRULE_C | CHAR | 5 | CPEC_PERIODDET | ALPHA | CPE_RULE | CPE_PERDETRULE | |
PERDTIN_GUID_Q | CPE Term - GUID for Changed Input of Period Determination | CPET_PERIODDTIN_GUID | RAW | 16 | CPED_PERIODDTIN | SYSUUID | |||
PERDTIN_GUID_C | CPE Term - GUID for Changed Input of Period Determination | CPET_PERIODDTIN_GUID | RAW | 16 | CPED_PERIODDTIN | SYSUUID | |||
CALCROUT | CPE Term - Calculation Routine | CPET_CALCROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
CALCMIN | CPE Term - Minimum of Commodity Rate Calculation | CPET_CALCMIN | CURR | 15(2) | CPE_AMOUNT | ||||
CALCMAX | CPE Term - Maximum of Commodity Rate Calculation | CPET_CALCMAX | CURR | 15(2) | CPE_AMOUNT | ||||
CALCMMCURR | CPE Term - Currency of Rate Calculation Limits | CPET_CALCMMCURR | CUKY | 5 | TCURC | WAERS | |||
CALCMMPRUN | CPE Term - Price Unit of Rate Calculation Limits | CPET_CALCMMPRUN | DEC | 5 | CPE_PRUN | ||||
CALCMMUOM | CPE Term - Unit of Measure for Rate Limits | CPET_CALCMMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
SURCHARGEROUT | CPE Term - Surcharge Routine | CPET_SURCHARGEROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
SURCHARGEABS | CPE Term - Absolute Surcharge for Commodity | CPET_SURCHARGEABS | CURR | 15(2) | CPE_AMOUNT | ||||
SURCHARGECURR | CPE Term - Currency of Absolute Surcharge | CPET_SURCHARGECURR | CUKY | 5 | TCURC | WAERS | |||
SURCHARGEPRUN | CPE Term - Price Unit of Absolute Surcharge | CPET_SURCHARGEPRUN | DEC | 5 | CPE_PRUN | ||||
SURCHARGEUOM | CPE Term - Unit of Measure of Absolute Surcharge | CPET_SURCHARGEUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
SURCHARGEFACTOR1 | CPE Term - Factor 1 when Combining Surcharge and Quotation | CPET_SURCHARGEFACTOR1 | DEC | 10(6) | CPE_FACTOR | ||||
SURCHARGEFACTOR2 | CPE Term - Factor 2 when Combining Surcharge and Quotation | CPET_SURCHARGEFACTOR2 | DEC | 10(6) | CPE_FACTOR | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | TBAC_DCS | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | TBAC_MIC | TBA_MIC | TBA_MIC | TBAH_MIC | |
TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | TBAC_TENOR | TBA_TENOR | TBAH_TENOR | ||
PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
FORECAST_ROUTINE | Quotation Forecast Routine | CPET_QUOTFORECASTROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | |||
FORECAST_DATE_ROUTINE | Forecast Date Routine | CPET_FORECAST_DATE_ROUTINE | NUMC | 7 | CPEC_REFDATEROUT | CPE_ROUTINE | |||
CURVE_TYPE | Commodity Curve Type | TBA_CURVETYPE | NUMC | 3 | TBA_CTY_CURVE_TYPE | TBAH_CURVETYPE | |||
CURVE_DCSID | Alternative Derivative Contract Specification ID | CPET_CURVE_DCSID | CHAR | 6 | TBAC_DCS | TBA_DCSID | |||
CURVE_MIC | Alternative Market Identifier Code | CPET_CURVE_MIC | CHAR | 4 | TBAC_MIC | TBA_MIC | |||
TERMTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP table CPED_TERMINPUT using ABAP code
The following ABAP code Example will allow you to do a basic selection on CPED_TERMINPUT to SELECT all data from the tableDATA: WA_CPED_TERMINPUT TYPE CPED_TERMINPUT.
SELECT SINGLE *
FROM CPED_TERMINPUT
INTO CORRESPONDING FIELDS OF WA_CPED_TERMINPUT
WHERE...
How to access SAP table CPED_TERMINPUT
Within an ECC or HANA version of SAP you can also view further information about CPED_TERMINPUT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects