PRH_CPET_TERM SAP (CPE Term) Structure details
Description: CPE Term
Related tables to PRH_CPET_TERM
Access table PRH_CPET_TERM
Structure field list including key, data, relationships and ABAP select examples
PRH_CPET_TERM 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 Term" 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_PRH_CPET_TERM TYPE PRH_CPET_TERM.
The PRH_CPET_TERM table consists of various fields, each holding specific information or linking keys about CPE Term data available in SAP. These include COND_TYPE (CPE: Condition Type for Commodity Pricing), TERMNO (CPE Term - Number in Formula), TERMID (CPE Term - Key), TERMGROUP (CPE Term - Term Group).. 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 PRH_CPET_TERM 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 | ||
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 | ||||
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 | Assigned to domain | CPE_QUOTSRC | CPE_QUOTSRC | ||
QUOTTYPE | Quotation Type | CPET_QUOTTYPE | CHAR | 5 | Assigned to domain | CPE_QUOTTYPE | CPE_QUOTTYPE | ||
QUOTNAME | Quotation Name | CPET_QUOTNAME | CHAR | 18 | Assigned to domain | CPE_QUOTNAME | CPE_QUOTNAME | ||
QUOTGROUP | Quotation Group | CPET_QUOTGROUP | CHAR | 5 | Assigned to domain | 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 | Assigned to domain | ALPHA | CPE_RULE | CPE_CALCRULE | |
SURCHARGERULE | CPE Term - Surcharge Rule | CPET_SURCHARGERULE | CHAR | 5 | Assigned to domain | ALPHA | CPE_RULE | CPE_SURCHARGERULE | |
PERDETRULE_Q | CPE Term - Period Determination Rule for Commodity Rates | CPET_PERDETRULE_Q | CHAR | 5 | Assigned to domain | ALPHA | CPE_RULE | CPE_PERDETRULE | |
PERDETRULE_C | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPET_PERDETRULE_C | CHAR | 5 | Assigned to domain | ALPHA | CPE_RULE | CPE_PERDETRULE | |
VTEXT | Description | VTEXT | CHAR | 20 | TEXT20 | ||||
TERMTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
BLOCKTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
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 | ||||
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 | |||
PRCFIX_OPTION_EXISTS | CPE Price Fixation Option Exists | CPET_PRCFIX_OPTION_EXISTS | CHAR | 1 | FLAG | ||||
ACTION | 3-Byte field | CHAR3 | CHAR | 3 | CHAR3 | ||||
TERMNO_OLD | CPE Term - Number in Formula | CPET_TERMNO | NUMC | 5 | NUMC5 |
Key field | Non-key field |
How do I retrieve data from SAP structure PRH_CPET_TERM using ABAP code?
As PRH_CPET_TERM 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 PRH_CPET_TERM as there is no data to select.How to access SAP table PRH_CPET_TERM
Within an ECC or HANA version of SAP you can also view further information about PRH_CPET_TERM 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