PRH_CPET_FORMULA SAP (CPE Formula) Structure details

Dictionary Type: Structure
Description: CPE Formula




ABAP Code to SELECT data from PRH_CPET_FORMULA
Related tables to PRH_CPET_FORMULA
Access table PRH_CPET_FORMULA




Structure field list including key, data, relationships and ABAP select examples

PRH_CPET_FORMULA 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" 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 TYPE PRH_CPET_FORMULA.

The PRH_CPET_FORMULA table consists of various fields, each holding specific information or linking keys about CPE Formula data available in SAP. These include COND_TYPE (CPE: Condition Type for Commodity Pricing), FORMID (CPE Formula - Key), FORMSTATUS (CPE Formula - Status of Evaluation), BILLING_BLOCK (CPE Caller - Billing: Blocking Reason for Document Items).. 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_FORMULA 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
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_FORMCHAR5Assigned to domainALPHACPE_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
ACTION3-Byte field CHAR3CHAR3CHAR3

Key field Non-key field



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

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

How to access SAP table PRH_CPET_FORMULA

Within an ECC or HANA version of SAP you can also view further information about PRH_CPET_FORMULA 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!