CPET_FORMULA_COM SAP (CPE - Communication Structure for Formula UIs) Structure details
Description: CPE - Communication Structure for Formula UIs
Related tables to CPET_FORMULA_COM
Access table CPET_FORMULA_COM
Structure field list including key, data, relationships and ABAP select examples
CPET_FORMULA_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 Formula 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_FORMULA_COM TYPE CPET_FORMULA_COM.
The CPET_FORMULA_COM table consists of various fields, each holding specific information or linking keys about CPE - Communication Structure for Formula UIs data available in SAP. These include COND_TYPE (CPE: Condition Type for Commodity Pricing), FORMID (CPE Formula - Key), FORMINPUT_GUID (CPE Formula - GUID of Changed Input for General Data), FORMCONVIN_GUID (CPE Formula - GUID of Input for Conversion).. 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_FORMULA_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 | ||
FORMID | CPE Formula - Key | CPET_FORMID | CHAR | 10 | CPEC_FORMULA | CPE_FORMID | CPE_FORMID | ||
FORMINPUT_GUID | CPE Formula - GUID of Changed Input for General Data | CPET_FORMINPUT_GUID | RAW | 16 | CPED_FORMINPUT | SYSUUID | |||
FORMCONVIN_GUID | CPE Formula - GUID of Input for Conversion | CPET_FORMCONVIN_GUID | RAW | 16 | CPED_FORMCONVIN | SYSUUID | |||
FORMROUNDIN_GUID | CPE Formula - GUID for Rounding Input | CPET_FORMROUNDIN_GUID | RAW | 16 | CPED_FORMROUNDIN | SYSUUID | |||
FORMTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
VTEXT | Description | VTEXT | CHAR | 20 | TEXT20 | ||||
VALIDFROM | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | TSTPS | CPE_TIMESTAMP | CPE_TIMESTAMP | ||
FORMCONVOUT_GUID | CPE Formula - GUID of Conversion Result | CPET_FORMCONVOUT_GUID | RAW | 16 | SYSUUID | ||||
FORMSTATUS | CPE Formula - Status of Evaluation | CPET_FORMSTATUS | NUMC | 2 | CPE_FORMSTATUS | ||||
BILLING_BLOCK | CPE Caller - Billing: Blocking Reason for Document Items | CPET_BILLING_BLOCK | CHAR | 2 | Assigned to domain | CPE_BILLING_BLOCK | |||
FORMVAL | CPE Formula -Value in Formula Currency | CPET_FORMVAL | CURR | 15(2) | CPE_AMOUNT | ||||
FORMRATE | CPE Formula - Rate in Formula Currency | CPET_FORMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
FORMCURR_OUT | CPE Formula - Currency | CPET_FORMCURR | CUKY | 5 | Assigned to domain | WAERS | |||
FORMPRUN_OUT | CPE Formula - Price Unit | CPET_FORMPRUN | DEC | 5 | CPE_PRUN | ||||
FORMUOM_OUT | CPE Formula - Unit of Measure | CPET_FORMUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FORMCOMMQUAN | CPE Formula - Total Quantity of Commodity in Document Item | CPET_FORMCOMMQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
FORMCOMMUOM_OUT | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUANCNV_COMM_OUT | CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_COMM | QUAN | 15(3) | CPE_QUANTITY | ||||
QUANCNV_ITEM_OUT | CPE Caller - Product Quantity of Document Item | CPET_ITEMPRODQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
FORMVAL_DOCCURR | CPE Formula - Value in Document Currency | CPET_FORMVAL_DOCCURR | CURR | 15(2) | CPE_AMOUNT | ||||
DOCCURR | CPE Caller - Document Currency | CPET_DOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
EVAL_TIMESTAMP | CPE Formula - Evaluation Date and Time | CPET_EVAL_TIMESTAMP | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
ITEMPRODUOM_OUT | CPE Caller - Unit of Measure of Product in Document Item | CPET_ITEMPRODUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FIXFORMRATE | CPE Formula - Fixed Rate | CPET_FIXFORMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
FIXFORMCURR | CPE - Currency for Fixed Rate | CPET_FIXCURR | CUKY | 5 | TCURC | WAERS | |||
FIXFORMPRUN | CPE - Price Unit of Fixed Rate | CPET_FIXPRUN | DEC | 5 | CPE_PRUN | ||||
FIXFORMUOM | CPE - Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
FORMCOMMUOM | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
FORMCURR | CPE Formula - Currency | CPET_FORMCURR | CUKY | 5 | TCURC | WAERS | |||
FORMPRUN | CPE Formula - Price Unit | CPET_FORMPRUN | DEC | 5 | CPE_PRUN | ||||
FORMUOM | CPE Formula - Unit of Measure | CPET_FORMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
FORMEVALROUT | CPE Formula - Routine for Evaluation | CPET_FORMEVALROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
COMBROUT | CPE Formula - Routine for Combining Terms | CPET_COMBROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
QUANSPLITROUT | CPE Term - Routine f. Splitting the Commodity Qty into Terms | CPET_QUANSPLITROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
FORMQUANCONV | CPE - Quantity Conv. Rule from Product UoM to Commodity UoM | CPET_QUANCNV_FORM | CHAR | 5 | CPEC_QUANCONV | ALPHA | CPE_RULE | CPE_QUANCONVRULE | |
QUANCNV_COMM | CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_COMM | QUAN | 15(3) | CPE_QUANTITY | ||||
QUANCNV_ITEM | CPE - Item Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_ITEM | QUAN | 15(3) | CPE_QUANTITY | ||||
ITEMPRODUOM | CPE Caller - Unit of Measure of Product in Document Item | CPET_ITEMPRODUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
R3ACCURACY | CPE - Evaluation with ABAP Accuracy | CPET_R3ACCURACY | CHAR | 1 | CHAR1 | ||||
BLOCKTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
COMBROUTTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
QUANSPLITTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
QUANCONVTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
FORMEVALTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
FLAG | Checkbox in Reporting | CHECKBOX | CHAR | 1 | FUNC |
Key field | Non-key field |
How do I retrieve data from SAP structure CPET_FORMULA_COM using ABAP code?
As CPET_FORMULA_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_FORMULA_COM as there is no data to select.How to access SAP table CPET_FORMULA_COM
Within an ECC or HANA version of SAP you can also view further information about CPET_FORMULA_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