SAP PRH_CPET_FORMULA_DATA CPE Formula data (without techn fields) Table data and field list

PRH_CPET_FORMULA_DATA 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 Formula data (without techn fields)" 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_FORMULA_DATA TYPE PRH_CPET_FORMULA_DATA.

The PRH_CPET_FORMULA_DATA table consists of various fields, each holding specific information or linking keys about CPE Formula data (without techn fields) data available in SAP. These include FORMSTATUS (CPE Formula - Status of Evaluation), BILLING_BLOCK (CPE Caller - Billing: Blocking Reason for Document Items), FORMVAL (CPE Formula -Value in Formula Currency), FORMRATE (CPE Formula - Rate in Formula Currency)... 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. .

PRH_CPET_FORMULA_DATA structure Technical Details:

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_FORMULA_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PRH_CPET_FORMULA_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FORMIDCPE Formula - Key CPET_FORMIDCHAR10CPEC_FORMULACPE_FORMIDCPE_FORMID
FORMSTATUSCPE Formula - Status of Evaluation CPET_FORMSTATUSNUMC2CPE_FORMSTATUS
BILLING_BLOCKCPE Caller - Billing: Blocking Reason for Document Items CPET_BILLING_BLOCKCHAR2CPEC_BLOCKINGCPE_BILLING_BLOCK
FORMVALCPE Formula -Value in Formula Currency CPET_FORMVALCURR15(2) CPE_AMOUNT
FORMRATECPE Formula - Rate in Formula Currency CPET_FORMRATECURR15(2) CPE_AMOUNT
FORMCURR_OUTCPE Formula - Currency CPET_FORMCURRCUKY5TCURCWAERS
FORMPRUN_OUTCPE Formula - Price Unit CPET_FORMPRUNDEC5CPE_PRUN
FORMUOM_OUTCPE Formula - Unit of Measure CPET_FORMUOMUNIT3T006CUNITMEINS
FORMCOMMQUANCPE Formula - Total Quantity of Commodity in Document Item CPET_FORMCOMMQUANQUAN15(3) CPE_QUANTITY
FORMCOMMUOM_OUTCPE Formula - Unit of Measure of Commodity Used in Formula CPET_FORMCOMMUOMUNIT3T006CUNITMEINS
QUANCNV_COMM_OUTCPE - Comm. Qty for Conversion from Product UoM to Comm. UoM CPET_QUANCNV_COMMQUAN15(3) CPE_QUANTITY
QUANCNV_ITEM_OUTCPE Caller - Product Quantity of Document Item CPET_ITEMPRODQUANQUAN15(3) CPE_QUANTITY
FORMVAL_DOCCURRCPE Formula - Value in Document Currency CPET_FORMVAL_DOCCURRCURR15(2) CPE_AMOUNT
DOCCURRCPE Caller - Document Currency CPET_DOCCURRCUKY5TCURCWAERS
EVAL_TIMESTAMPCPE Formula - Evaluation Date and Time CPET_EVAL_TIMESTAMPCHAR14TSTPSCPE_TIMESTAMP
ITEMPRODUOM_OUTCPE Caller - Unit of Measure of Product in Document Item CPET_ITEMPRODUOMUNIT3T006CUNITMEINS
FIXFORMRATECPE Formula - Fixed Rate CPET_FIXFORMRATECURR15(2) CPE_AMOUNT
FIXFORMCURRCPE - Currency for Fixed Rate CPET_FIXCURRCUKY5TCURCWAERS
FIXFORMPRUNCPE - Price Unit of Fixed Rate CPET_FIXPRUNDEC5CPE_PRUN
FIXFORMUOMCPE - Unit of Measure of Fixed Rate CPET_FIXUOMUNIT3T006CUNITMEINS
FORMCOMMUOMCPE Formula - Unit of Measure of Commodity Used in Formula CPET_FORMCOMMUOMUNIT3T006CUNITMEINS
FORMCURRCPE Formula - Currency CPET_FORMCURRCUKY5TCURCWAERS
FORMPRUNCPE Formula - Price Unit CPET_FORMPRUNDEC5CPE_PRUN
FORMUOMCPE Formula - Unit of Measure CPET_FORMUOMUNIT3T006CUNITMEINS
FORMEVALROUTCPE Formula - Routine for Evaluation CPET_FORMEVALROUTNUMC7CPEC_ROUTINECPE_ROUTINECPE_ROUTINE
COMBROUTCPE Formula - Routine for Combining Terms CPET_COMBROUTNUMC7CPEC_ROUTINECPE_ROUTINECPE_ROUTINE
QUANSPLITROUTCPE Term - Routine f. Splitting the Commodity Qty into Terms CPET_QUANSPLITROUTNUMC7CPEC_ROUTINECPE_ROUTINECPE_ROUTINE
FORMQUANCONVCPE - Quantity Conv. Rule from Product UoM to Commodity UoM CPET_QUANCNV_FORMCHAR5ALPHACPE_RULECPE_QUANCONVRULE
QUANCNV_COMMCPE - Comm. Qty for Conversion from Product UoM to Comm. UoM CPET_QUANCNV_COMMQUAN15(3) CPE_QUANTITY
QUANCNV_ITEMCPE - Item Qty for Conversion from Product UoM to Comm. UoM CPET_QUANCNV_ITEMQUAN15(3) CPE_QUANTITY
ITEMPRODUOMCPE Caller - Unit of Measure of Product in Document Item CPET_ITEMPRODUOMUNIT3T006CUNITMEINS
VTEXTDescription VTEXTCHAR20TEXT20
FORMTEXTDescription BEZEI40CHAR40TEXT40
BLOCKTEXTDescription BEZEI40CHAR40TEXT40
FORMEVALTEXTDescription BEZEI40CHAR40TEXT40
COMBROUTTEXTDescription BEZEI40CHAR40TEXT40
QUANSPLITTEXTDescription BEZEI40CHAR40TEXT40
QUANCONVTEXTDescription BEZEI40CHAR40TEXT40
PRCFIX_OPTION_EXISTSCPE Price Fixation Option Exists CPET_PRCFIX_OPTION_EXISTSCHAR1FLAG
REQUESTED_EKD_DATERequested Evaluation Key Date CPET_ERP_REQUESTED_EKD_DATDATS8DATE
LATEST_EKD_DATELatest Evaluation Key Date CPET_ERP_LATEST_EKD_DATDATS8DATE
LATEST_EVAL_KEYDATE_ROUTLatest Evaluation Key Date Routine CPET_ERP_LATEST_EKD_ROUTNUMC7Assigned to domainCPE_ROUTINE
USED_EKD_DATEEvaluation Key Date Used CPET_ERP_USED_EKD_DATDATS8DATE
USED_EKD_TIMETime of Evaluation Key Date Used CPET_ERP_USED_EKD_TIMTIMS6TIME
PRICING_DATEDate for pricing and exchange rate PRSDTDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure PRH_CPET_FORMULA_DATA using ABAP code?

As PRH_CPET_FORMULA_DATA 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_FORMULA_DATA as there is no data to select.

How to access SAP table PRH_CPET_FORMULA_DATA

Within an ECC or HANA version of SAP you can also view further information about PRH_CPET_FORMULA_DATA and the data within it using relevant transactions such as

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