PRH_CPET_TERM SAP (CPE Term) Structure details

Dictionary Type: Structure
Description: CPE Term




ABAP Code to SELECT data from PRH_CPET_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_GUIDCPE Caller - GUID of Document Item CPET_DOCITEM_GUIDRAW16SYSUUID
COND_TYPECPE: Condition Type for Commodity Pricing CPET_COND_TYPECHAR4Assigned to domainKSCHLCPE_COND_TYPE
TERMNOCPE Term - Number in Formula CPET_TERMNONUMC5NUMC5
TERMIDCPE Term - Key CPET_TERMIDCHAR10CPEC_TERMCPE_TERMIDCPE_TERMID
TERMGROUPCPE Term - Term Group CPET_TERMGROUPCHAR1CHAR1
PROVISCPE Term - Term Is Used only for Provisional Pricing CPET_PROVISCHAR1CHAR1
PROVTERMNOCPE Term - Number of the Corresponding Provisional Term CPET_PROVTERMNONUMC5NUMC5
FACTOR1CPE Term - Factor 1 CPET_FACTOR1DEC10(6) CPE_FACTOR
FACTOR2CPE Term - Factor 2 CPET_FACTOR2DEC10(6) CPE_FACTOR
PERCENTAGECPE Term - Percentage CPET_PERCENTAGEDEC10(6) CPE_FACTOR
TERMCOMMQUANCPE Term - Total Commodity Quantity for Calculating Term CPET_TERMCOMMQUANQUAN15(3) CPE_QUANTITY
TERMCOMMUOMCPE Term - Unit of Measure of Total Commodity Quantity CPET_TERMCOMMUOMUNIT3T006CUNITMEINS
USEDQUANCPE Term - Calculated Commodity Quantity CPET_USEDQUANQUAN15(3) CPE_QUANTITY
USEDUOMCPE Term - UoM for Calculated Commodity Quantity CPET_USEDUOMUNIT3T006CUNITMEINS
TERMCONVOUT_GUIDCPE Term - GUID for Conversion Result CPET_TERMCONVOUT_GUIDRAW16CPED_TERMCONVOUTSYSUUID
PERDTOUT_GUID_QCPE Term - GUID for Result of Period Determination CPET_PERIODDTOUT_GUIDRAW16CPED_PERIODDTOUTSYSUUID
PERDTOUT_GUID_CCPE Term - GUID for Result of Period Determination CPET_PERIODDTOUT_GUIDRAW16CPED_PERIODDTOUTSYSUUID
TERMSTATUSCPE Term - Status CPET_TERMSTATUSNUMC2CPE_TERMSTATUS
BILLING_BLOCKCPE Caller - Billing: Blocking Reason for Document Items CPET_BILLING_BLOCKCHAR2CPEC_BLOCKINGCPE_BILLING_BLOCK
TERMVALCPE Term - Value CPET_TERMVALCURR15(2) CPE_AMOUNT
TERMRATECPE Term - Rate in Term Currency CPET_TERMRATECURR15(2) CPE_AMOUNT
TERMCURRCPE Term - Currency CPET_TERMCURRCUKY5TCURCWAERS
TERMPRUNCPE Term - Price Unit CPET_TERMPRUNDEC5CPE_PRUN
TERMUOMCPE Term - Unit of Measure CPET_TERMUOMUNIT3T006CUNITMEINS
FORECAST_STATUSStatus of Quotation Forecast CPET_FORECAST_STATUSINT13CPE_FORECAST_STATUS
FORECAST_DATETIMEForecast Date Time CPET_FORECAST_DATETIMECHAR14TSTPSCPE_TIMESTAMP
CURVE_DATECurve Date TBA_CURVEDATEDATS8DATE
QUOTATIONCPE Term - Calculated Quotation CPET_QUOTATIONCURR15(2) CPE_AMOUNT
QUOTCURRQuotation Currency CPET_QUOTCURRCUKY5TCURCWAERS
QUOTPRUNPrice Unit of Quotation CPET_QUOTPRUNDEC5CPE_PRUN
QUOTUOMUnit of Measure of Quotation CPET_QUOTUOMUNIT3T006CUNITMEINS
CALC_LIMITUSEDCPE Term - Used Limit of Calculation Rule CPET_LIMITUSEDNUMC1CPE_LIMITUSED
QUOT_UOMSUBSTCPE Term - Unit of Measure Substitution for Quotations CPET_UOMSUB_QUOTCHAR1CHAR1
SURCHARGERATECPE Term - Total Surcharge for Commodity CPET_SURCHARGERATECURR15(2) CPE_AMOUNT
SURCHRATECURRCPE Term - Currency of Absolute Surcharge CPET_SURCHRATECURRCUKY5TCURCWAERS
SURCHRATEPRUNCPE Term - Price Unit of Absolute Surcharge CPET_SURCHRATEPRUNDEC5CPE_PRUN
SURCHRATEUOMCPE Term - Unit of Measure of Absolute Surcharge CPET_SURCHRATEUOMUNIT3T006CUNITMEINS
SURCH_UOMSUBSTCPE Term - Unit of Measure Substitution for Surcharge CPET_UOMSUB_SURCHAR1CHAR1
EXTENSION_GROUPCPE Extension Group CPET_EXTENSION_GROUPNUMC5CPE_EXTENSION_GROUP
EXTENSION_USAGECPE Extension Usage CPET_EXTENSION_USAGECHAR1CPE_EXTENSION_USAGE
QUOTKEYQuotation Key in Document UI (all values) CPET_QUOTKEY_ALLCHAR1CPE_QUOTKEY_ALL
TERMTYPECPE Term - Term Calculation Type CPET_TERMTYPENUMC7CPEC_ROUTINECPE_ROUTINECPE_ROUTINE
TERMRULECPE Term - Term Rule CPET_TERMRULECHAR5CPEC_TERMRULEALPHACPE_RULECPE_TERMRULE
QUOTSRCQuotation Source CPET_QUOTSRCCHAR2Assigned to domainCPE_QUOTSRCCPE_QUOTSRC
QUOTTYPEQuotation Type CPET_QUOTTYPECHAR5Assigned to domainCPE_QUOTTYPECPE_QUOTTYPE
QUOTNAMEQuotation Name CPET_QUOTNAMECHAR18Assigned to domainCPE_QUOTNAMECPE_QUOTNAME
QUOTGROUPQuotation Group CPET_QUOTGROUPCHAR5Assigned to domainCHAR5CPE_QUOTGROUP
REFDOCCATCPE Term - Reference Document Category CPET_REFDOCCATNUMC3CPE_DOCCATEGORY
REFDOCCPE Term - Reference Document Number CPET_REFDOCCHAR10CPE_DOCUMENT
REFITEMCPE Term - Reference Document Item Number CPET_REFITEMCHAR10CPE_DOCITEM
REFGUIDCPE Term - GUID of Reference Document Item CPET_REFGUIDRAW16SYSUUID
REFCONDCPE Term - Reference Condition Type CPET_REFCONDCHAR4Assigned to domainKSCHL
FIXTERMRATECPE Term - Fixed Rate CPET_FIXTERMRATECURR15(2) CPE_AMOUNT
FIXTERMCURRCPE - Currency for Fixed Rate CPET_FIXCURRCUKY5TCURCWAERS
FIXTERMPRUNCPE - Price Unit of Fixed Rate CPET_FIXPRUNDEC5CPE_PRUN
FIXTERMUOMCPE - Unit of Measure of Fixed Rate CPET_FIXUOMUNIT3T006CUNITMEINS
USERVAL1CPE Term - Freely Usable Field CPET_USERVAL1DEC17(7) CPE_USERVAL1
USERUOM1CPE Term - Freely Usable Unit of Measure Field CPET_USERUOM1UNIT3Assigned to domainCUNITMEINS
CALCRULECPE Term - Calculation Rule CPET_CALCRULECHAR5Assigned to domainALPHACPE_RULECPE_CALCRULE
SURCHARGERULECPE Term - Surcharge Rule CPET_SURCHARGERULECHAR5Assigned to domainALPHACPE_RULECPE_SURCHARGERULE
PERDETRULE_QCPE Term - Period Determination Rule for Commodity Rates CPET_PERDETRULE_QCHAR5Assigned to domainALPHACPE_RULECPE_PERDETRULE
PERDETRULE_CCPE Term - Period Determ. Rule for Currency Exchange Rates CPET_PERDETRULE_CCHAR5Assigned to domainALPHACPE_RULECPE_PERDETRULE
VTEXTDescription VTEXTCHAR20TEXT20
TERMTEXTDescription BEZEI40CHAR40TEXT40
BLOCKTEXTDescription BEZEI40CHAR40TEXT40
TERMTYPETEXTDescription BEZEI40CHAR40TEXT40
TERMRULETEXTDescription BEZEI40CHAR40TEXT40
CALCRULETEXTDescription BEZEI40CHAR40TEXT40
SURCHARGETEXTDescription BEZEI40CHAR40TEXT40
PERDETTEXT_QDescription BEZEI40CHAR40TEXT40
PERDETTEXT_CDescription BEZEI40CHAR40TEXT40
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6TBAC_DCSTBA_DCSIDTBA_DCSIDTBAH_DCS
MICMarket Identifier Code TBA_MICCHAR4TBAC_MICTBA_MICTBA_MICTBAH_MIC
TENORTime to Maturity TBA_TENORCHAR10TBAC_TENORTBA_TENORTBAH_TENOR
PRICETYPEType of Price Quotation TBA_PRICETYPECHAR2Assigned to domainVVSKURSARTRATETYPE_F4
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
FORECAST_ROUTINEQuotation Forecast Routine CPET_QUOTFORECASTROUTNUMC7CPEC_ROUTINECPE_ROUTINE
FORECAST_DATE_ROUTINEForecast Date Routine CPET_FORECAST_DATE_ROUTINENUMC7CPEC_REFDATEROUTCPE_ROUTINE
CURVE_TYPECommodity Curve Type TBA_CURVETYPENUMC3TBA_CTY_CURVE_TYPETBAH_CURVETYPE
CURVE_DCSIDAlternative Derivative Contract Specification ID CPET_CURVE_DCSIDCHAR6TBAC_DCSTBA_DCSID
CURVE_MICAlternative Market Identifier Code CPET_CURVE_MICCHAR4TBAC_MICTBA_MIC
PRCFIX_OPTION_EXISTSCPE Price Fixation Option Exists CPET_PRCFIX_OPTION_EXISTSCHAR1FLAG
ACTION3-Byte field CHAR3CHAR3CHAR3
TERMNO_OLDCPE Term - Number in Formula CPET_TERMNONUMC5NUMC5

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!