CPE_FORMULA - CPE Formula
CPE Formula information is stored in SAP table CPE_FORMULA.
It is part of development package LOG_CMM_PRC_BASIC in software component LO-CMM-BF. This development package consists of objects that can be grouped under "Smart CPE Objects".
It is part of development package LOG_CMM_PRC_BASIC in software component LO-CMM-BF. This development package consists of objects that can be grouped under "Smart CPE Objects".
Fields for table CPE_FORMULA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| DOCITEMCOND_GUID | CPE Caller - GUID of Document Item Condition | X | CPET_DOCITEMCOND_GUID | RAW | 16 | |
| DOCITEM_GUID | CPE Caller - GUID of Document Item | CPET_DOCITEM_GUID | RAW | 16 | ||
| COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 8 | ||
| FORMID | CPE Formula - Key | CPET_FORMID | CHAR | 20 | CPEC_FORMULA | |
| FORMINPUT_GUID | CPE Formula - GUID of Changed Input for General Data | CPET_FORMINPUT_GUID | RAW | 16 | ||
| FORMCONVIN_GUID | CPE Formula - GUID of Input for Conversion | CPET_FORMCONVIN_GUID | RAW | 16 | CPED_FORMCONVIN | |
| FORMROUNDIN_GUID | CPE Formula - GUID for Rounding Input | CPET_FORMROUNDIN_GUID | RAW | 16 | CPED_FORMROUNDIN | |
| FORMCONVOUT_GUID | CPE Formula - GUID of Conversion Result | CPET_FORMCONVOUT_GUID | RAW | 16 | CPED_FORMCONVOUT | |
| FORMSTATUS | CPE Formula - Status of Evaluation | CPET_FORMSTATUS | NUMC | 4 | CPEC_FORMSTATUS | |
| BILLING_BLOCK | CPE Caller - Billing: Blocking Reason for Document Items | CPET_BILLING_BLOCK | CHAR | 4 | CPEC_BLOCKING | |
| EVALTIMESTAMP | Not used anymore !!! CPE Formula - Evaluation Date and Time | CPET_EVALTIMESTAMP | DATS | 16 | ||
| FORMVAL | CPE Formula -Value in Formula Currency | CPET_FORMVAL | CURR | 8 | ||
| FORMVAL_DF34 | CPE Formula - Value in Formula Currency DF34 | CPET_FORMVAL_DF34 | D34D | 16 | ||
| FORMRATE | CPE Formula - Rate in Formula Currency | CPET_FORMRATE | CURR | 8 | ||
| FORMRATE_DF34 | CPE Formula - Rate in Formula Currency DF34 | CPET_FORMRATE_DF34 | D34D | 16 | ||
| FORMCURR | CPE Formula - Currency | CPET_FORMCURR | CUKY | 10 | ||
| FORMPRUN | CPE Formula - Price Unit | CPET_FORMPRUN | DEC | 3 | ||
| FORMUOM | CPE Formula - Unit of Measure | CPET_FORMUOM | UNIT | 6 | ||
| FORMCOMMQUAN | CPE Formula - Total Quantity of Commodity in Document Item | CPET_FORMCOMMQUAN | QUAN | 8 | ||
| FORMCOMMUOM | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | UNIT | 6 | ||
| QUANCNV_COMM | CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_COMM | QUAN | 8 | ||
| QUANCNV_ITEM | CPE - Item Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_ITEM | QUAN | 8 | ||
| CONTRACTGUID | CPE Formula - GUID of Contract Item Related to Document Item | CPET_CONTRACT_GUID | RAW | 16 | ||
| ORIG_GUID | CPE Caller - GUID of Original Item of the Document Item | CPET_ORIG_GUID | RAW | 16 | ||
| LOGSYS | CPE Formula - Original Logical System | CPET_FORMLOGSYS | CHAR | 20 | ||
| SRCSYSTEMTYPE | CPE - Source System Type | CPET_SRCSYSTEMTYPE | CHAR | 8 | ||
| FORMVAL_DOCCURR | CPE Formula - Value in Document Currency | CPET_FORMVAL_DOCCURR | CURR | 8 | ||
| FORMVAL_DOCCURR_DF34 | CPE Formula - Value in Document Currency DF34 | CPET_FORMVAL_DOCCURR_DF34 | D34D | 16 | ||
| DOCCURR | CPE Caller - Document Currency | CPET_DOCCURR | CUKY | 10 | ||
| EVAL_TIMESTAMP | CPE Formula - Evaluation Date and Time | CPET_EVAL_TIMESTAMP_CDS | CHAR | 28 | ||
| ITEMPRODUOM | CPE Caller - Unit of Measure of Product in Document Item | CPET_ITEMPRODUOM | UNIT | 6 | ||
| REQUESTED_EVAL_KEYDATE | Requested Evaluation Key Date | CPET_REQD_EVAL_KEYDATE_CDS | CHAR | 28 | ||
| LATEST_EVAL_KEYDATE | Latest Evaluation Key Date | CPET_LATEST_EVAL_KEYDATE_CDS | CHAR | 28 | ||
| USED_EVAL_KEYDATE | Evaluation Key Date Used | CPET_USED_EVAL_KEYDATE_CDS | CHAR | 28 | ||
| FORECAST_REQUESTED | Forecast Proposed | CPET_FORECAST_REQUESTED | CHAR | 2 | ||
| FORECAST_STATUS | Status of Quotation or Exchange Rate Forecast | CPET_FORECAST_STATUS | INT1 | 1 | ||
| FORM_UOMSUBST | Unit of Measure Substitution for Formula | CPET_UOMSUB_FORM | CHAR | 2 | ||
| FIXFORMRATE | CPE Formula - Fixed Rate | CPET_FIXFORMRATE | CURR | 8 | ||
| FIXFORMRATE_DF34 | CPE Formula - Fixed Rate (upto 14 decimal places) | CPET_FIXFORMRATE_DF34 | D34D | 16 | ||
| FIXFORMCURR | CPE - Currency for Fixed Rate | CPET_FIXCURR | CUKY | 10 | TCURC | |
| FIXFORMPRUN | CPE - Price Unit of Fixed Rate | CPET_FIXPRUN | DEC | 3 | ||
| FIXFORMUOM | CPE - Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT | 6 | T006 | |
| FORMEVALROUT | CPE Formula - Routine for Evaluation | CPET_FORMEVALROUT | NUMC | 14 | CPEC_ROUTINE | |
| COMBROUT | CPE Formula - Routine for Combining Terms | CPET_COMBROUT | NUMC | 14 | CPEC_ROUTINE | |
| QUANSPLITROUT | CPE Term - Routine f. Splitting the Commodity Qty into Terms | CPET_QUANSPLITROUT | NUMC | 14 | CPEC_ROUTINE | |
| FORMQUANCONV | CPE - Quantity Conv. Rule from Product UoM to Commodity UoM | CPET_QUANCNV_FORM | CHAR | 20 | CPEC_QUANCONV | |
| LATEST_EVAL_KEYDATE_ROUT | Latest Evaluation Key Date Routine | CPET_LATEST_EVAL_KEYDATE_ROUT | NUMC | 14 | ||
| FORECAST_MODE | Forecast Mode | CPET_FORECAST_MODE | CHAR | 2 | ||
| EXRATE_FORECAST_ROUT | Exchange Rate Forecast Routine | CPET_EXRATE_FORECAST_ROUTINE | NUMC | 14 | CPEC_ROUTINE | |
| .INCLUDE | CI_BAPI_CPET_FORMOUT_USER | 0 | ||||
| .INCLUDE | CI_BAPI_CPET_FORMIN_USER | 0 | ||||
| FORMTEXT | Formula Description | CPET_FORMULA_TEXT | CHAR | 80 |