CPET_TERM_COM SAP (CPE - Communication Structure for Term UIs) Structure details
Description: CPE - Communication Structure for Term UIs
Related tables to CPET_TERM_COM
Access table CPET_TERM_COM
Structure field list including key, data, relationships and ABAP select examples
CPET_TERM_COM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CPE - Communication Structure for Term UIs" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CPET_TERM_COM TYPE CPET_TERM_COM.
The CPET_TERM_COM table consists of various fields, each holding specific information or linking keys about CPE - Communication Structure for Term UIs data available in SAP. These include COND_TYPE (CPE: Condition Type for Commodity Pricing), TERMNO (CPE Term - Number in Formula), TERMID (CPE Term - Key), TERMTEXT (Description).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CPET_TERM_COM structure 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 |
DOCITEM_GUID | CPE Caller - GUID of Document Item | CPET_DOCITEM_GUID | RAW | 16 | SYSUUID | ||||
COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 4 | Assigned to domain | KSCHL | CPE_COND_TYPE | ||
TERMNO | CPE Term - Number in Formula | CPET_TERMNO | NUMC | 5 | NUMC5 | ||||
TERMID | CPE Term - Key | CPET_TERMID | CHAR | 10 | CPEC_TERM | CPE_TERMID | CPE_TERMID | ||
TERMTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TERMINPUT_GUID | CPE Term - GUID of Changed General Input | CPET_TERMINPUT_GUID | RAW | 16 | SYSUUID | ||||
VALIDFROM | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | TSTPS | CPE_TIMESTAMP | CPE_TIMESTAMP | ||
TERMGROUP | CPE Term - Term Group | CPET_TERMGROUP | CHAR | 1 | CHAR1 | ||||
PROVIS | CPE Term - Term Is Used only for Provisional Pricing | CPET_PROVIS | CHAR | 1 | CHAR1 | ||||
PROVTERMNO | CPE Term - Number of the Corresponding Provisional Term | CPET_PROVTERMNO | NUMC | 5 | NUMC5 | ||||
FACTOR1 | CPE Term - Factor 1 | CPET_FACTOR1 | DEC | 10(6) | CPE_FACTOR | ||||
FACTOR2 | CPE Term - Factor 2 | CPET_FACTOR2 | DEC | 10(6) | CPE_FACTOR | ||||
PERCENTAGE | CPE Term - Percentage | CPET_PERCENTAGE | DEC | 10(6) | CPE_FACTOR | ||||
TERMCOMMQUAN | CPE Term - Total Commodity Quantity for Calculating Term | CPET_TERMCOMMQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
TERMCOMMUOM | CPE Term - Unit of Measure of Total Commodity Quantity | CPET_TERMCOMMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
USEDQUAN | CPE Term - Calculated Commodity Quantity | CPET_USEDQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
USEDUOM | CPE Term - UoM for Calculated Commodity Quantity | CPET_USEDUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
TERMCONVOUT_GUID | CPE Term - GUID for Conversion Result | CPET_TERMCONVOUT_GUID | RAW | 16 | CPED_TERMCONVOUT | SYSUUID | |||
PERDTOUT_GUID_Q | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | CPED_PERIODDTOUT | SYSUUID | |||
PERDTOUT_GUID_C | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | CPED_PERIODDTOUT | SYSUUID | |||
TERMSTATUS | CPE Term - Status | CPET_TERMSTATUS | NUMC | 2 | CPE_TERMSTATUS | ||||
BILLING_BLOCK | CPE Caller - Billing: Blocking Reason for Document Items | CPET_BILLING_BLOCK | CHAR | 2 | CPEC_BLOCKING | CPE_BILLING_BLOCK | |||
TERMVAL | CPE Term - Value | CPET_TERMVAL | CURR | 15(2) | CPE_AMOUNT | ||||
TERMRATE | CPE Term - Rate in Term Currency | CPET_TERMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
TERMCURR | CPE Term - Currency | CPET_TERMCURR | CUKY | 5 | TCURC | WAERS | |||
TERMPRUN | CPE Term - Price Unit | CPET_TERMPRUN | DEC | 5 | CPE_PRUN | ||||
TERMUOM | CPE Term - Unit of Measure | CPET_TERMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
FORECAST_STATUS | Status of Quotation Forecast | CPET_FORECAST_STATUS | INT1 | 3 | CPE_FORECAST_STATUS | ||||
FORECAST_DATETIME | Forecast Date Time | CPET_FORECAST_DATETIME | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
CURVE_DATE | Curve Date | TBA_CURVEDATE | DATS | 8 | DATE | ||||
QUOTATION | CPE Term - Calculated Quotation | CPET_QUOTATION | CURR | 15(2) | CPE_AMOUNT | ||||
QUOTCURR | Quotation Currency | CPET_QUOTCURR | CUKY | 5 | TCURC | WAERS | |||
QUOTPRUN | Price Unit of Quotation | CPET_QUOTPRUN | DEC | 5 | CPE_PRUN | ||||
QUOTUOM | Unit of Measure of Quotation | CPET_QUOTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
CALC_LIMITUSED | CPE Term - Used Limit of Calculation Rule | CPET_LIMITUSED | NUMC | 1 | CPE_LIMITUSED | ||||
QUOT_UOMSUBST | CPE Term - Unit of Measure Substitution for Quotations | CPET_UOMSUB_QUOT | CHAR | 1 | CHAR1 | ||||
SURCHARGERATE | CPE Term - Total Surcharge for Commodity | CPET_SURCHARGERATE | CURR | 15(2) | CPE_AMOUNT | ||||
SURCHRATECURR | CPE Term - Currency of Absolute Surcharge | CPET_SURCHRATECURR | CUKY | 5 | TCURC | WAERS | |||
SURCHRATEPRUN | CPE Term - Price Unit of Absolute Surcharge | CPET_SURCHRATEPRUN | DEC | 5 | CPE_PRUN | ||||
SURCHRATEUOM | CPE Term - Unit of Measure of Absolute Surcharge | CPET_SURCHRATEUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
SURCH_UOMSUBST | CPE Term - Unit of Measure Substitution for Surcharge | CPET_UOMSUB_SUR | CHAR | 1 | CHAR1 | ||||
EXTENSION_GROUP | CPE Extension Group | CPET_EXTENSION_GROUP | NUMC | 5 | CPE_EXTENSION_GROUP | ||||
EXTENSION_USAGE | CPE Extension Usage | CPET_EXTENSION_USAGE | CHAR | 1 | CPE_EXTENSION_USAGE | ||||
FORMRES_REL | Relevance for Formula Result | CPET_FORMRES_REL | CHAR | 1 | CPE_FORMRES_REL | ||||
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 | ||||
PERDETRULE_C | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPET_PERDETRULE_C | CHAR | 5 | ALPHA | CPE_RULE | CPE_PERDETRULE | ||
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 | |||
TERMCONVIN_GUID | CPE Term - GUID for Conversion Input | CPET_TERMCONVIN_GUID | RAW | 16 | SYSUUID | ||||
TERMROUNDIN_GUID | CPE Term - GUID of Rounding Input | CPET_TERMROUNDIN_GUID | RAW | 16 | SYSUUID | ||||
TERMTYPETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TERMRULETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
CALCRULETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
SURCHARGETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
PERDETTEXT_Q | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
PERDETTEXT_C | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
BLOCKTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
FLAG | Checkbox in Reporting | CHECKBOX | CHAR | 1 | FUNC | ||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure CPET_TERM_COM using ABAP code?
As CPET_TERM_COM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CPET_TERM_COM as there is no data to select.How to access SAP table CPET_TERM_COM
Within an ECC or HANA version of SAP you can also view further information about CPET_TERM_COM 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