SAP Table CPEC_FORMULA
CPE Formula
CPEC_FORMULA (CPE Formula) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CPEC_FORMULA to other SAP tables.
CPEC_FORMULA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||
| FORMID | CPE Formula - Key | CPET_FORMID | CHAR | 10 | 0 | |||
| COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 4 | 0 | |||
| VALIDTO | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | 0 | |||
| FORMCOMMUOM | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | T006 | UNIT | 3 | 0 | ||
| FORMCURR | CPE Formula - Currency | CPET_FORMCURR | TCURC | CUKY | 5 | 0 | ||
| FORMPRUN | CPE Formula - Price Unit | CPET_FORMPRUN | DEC | 5 | 0 | |||
| FORMUOM | CPE Formula - Unit of Measure | CPET_FORMUOM | T006 | UNIT | 3 | 0 | ||
| FORMEVALROUT | CPE Formula - Routine for Evaluation | CPET_FORMEVALROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||
| COMBROUT | CPE Formula - Routine for Combining Terms | CPET_COMBROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||
| QUANSPLITROUT | CPE Term - Routine f. Splitting the Commodity Qty into Terms | CPET_QUANSPLITROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||
| FORMQUANCONV | CPE - Quantity Conv. Rule from Product UoM to Commodity UoM | CPET_QUANCNV_FORM | CPEC_QUANCONV | CHAR | 5 | 0 | ||
| QUANCNV_COMM | CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_COMM | QUAN | 15 | 3 | |||
| QUANCNV_ITEM | CPE - Item Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_ITEM | QUAN | 15 | 3 | |||
| ITEMPRODUOM | CPE Caller - Unit of Measure of Product in Document Item | CPET_ITEMPRODUOM | UNIT | 3 | 0 | |||
| R3ACCURACY | CPE - Evaluation with ABAP Accuracy | CPET_R3ACCURACY | CHAR | 1 | 0 | |||
CPEC_FORMULA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CPEC_FORMULA | COMBROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_FORMULA | COMBROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_FORMULA | COMBROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_FORMULA | COMBROUT | '04' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_FORMULA | COMBROUT | CPEC_FORMULA | COMBROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_FORMULA | FORMCOMMUOM | CPEC_FORMULA | FORMCOMMUOM | T006 | Units of Measurement | MSEHI |
| CPEC_FORMULA | FORMCOMMUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| CPEC_FORMULA | FORMCURR | SYST | MANDT | TCURC | Currency Codes | MANDT |
| CPEC_FORMULA | FORMCURR | CPEC_FORMULA | FORMCURR | TCURC | Currency Codes | WAERS |
| CPEC_FORMULA | FORMEVALROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_FORMULA | FORMEVALROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_FORMULA | FORMEVALROUT | '01' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_FORMULA | FORMEVALROUT | CPEC_FORMULA | FORMEVALROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_FORMULA | FORMEVALROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_FORMULA | FORMQUANCONV | SYST | MANDT | CPEC_QUANCONV | CPE - Quantity Conversion Rule | CLIENT |
| CPEC_FORMULA | FORMQUANCONV | ' ' | CPEC_QUANCONV | CPE - Quantity Conversion Rule | LOGSYS | |
| CPEC_FORMULA | FORMQUANCONV | CPEC_FORMULA | FORMQUANCONV | CPEC_QUANCONV | CPE - Quantity Conversion Rule | QUANCONVRULE |
| CPEC_FORMULA | FORMQUANCONV | * | CPEC_QUANCONV | CPE - Quantity Conversion Rule | VALIDTO | |
| CPEC_FORMULA | FORMUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| CPEC_FORMULA | FORMUOM | CPEC_FORMULA | FORMUOM | T006 | Units of Measurement | MSEHI |
| CPEC_FORMULA | LOGSYS | CPEC_FORMULA | LOGSYS | TBDLS | Logical system | LOGSYS |
| CPEC_FORMULA | QUANSPLITROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_FORMULA | QUANSPLITROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_FORMULA | QUANSPLITROUT | '02' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_FORMULA | QUANSPLITROUT | CPEC_FORMULA | QUANSPLITROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_FORMULA | QUANSPLITROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
