CPE_FORMULA

CPE Formula | #transactional | Component: Basic Functions
Column Name Description
CLIENT Client
DOCITEMCOND_GUID CPE Caller - GUID of Document Item Condition
Column Name Description
💲 CPE Formula - Currency (FORMCURR):
FORMVAL CPE Formula -Value in Formula Currency
FORMRATE CPE Formula - Rate in Formula Currency
💲 CPE Caller - Document Currency (DOCCURR):
FORMVAL_DOCCURR CPE Formula - Value in Document Currency
💲 CPE - Currency for Fixed Rate (FIXFORMCURR):
FIXFORMRATE CPE Formula - Fixed Rate
Column Name Description
📏 CPE Formula - Unit of Measure of Commodity Used in Formula (FORMCOMMUOM):
FORMCOMMQUAN CPE Formula - Total Quantity of Commodity in Document Item
QUANCNV_COMM CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM
📏 CPE Caller - Unit of Measure of Product in Document Item (ITEMPRODUOM):
QUANCNV_ITEM CPE - Item Qty for Conversion from Product UoM to Comm. UoM
Column Name Description
EVALTIMESTAMP Not used anymore !!! CPE Formula - Evaluation Date and Time
Column Name Description
FORECAST_REQUESTED Forecast Proposed Show values
FORECAST_STATUS Status of Quotation or Exchange Rate Forecast Show values
FORECAST_MODE Forecast Mode Show values
Column Name Description Domain name
DOCITEM_GUID CPE Caller - GUID of Document Item SYSUUID
COND_TYPE CPE: Condition Type for Commodity Pricing KSCHL
FORMINPUT_GUID CPE Formula - GUID of Changed Input for General Data SYSUUID
FORMVAL_DF34 CPE Formula - Value in Formula Currency DF34 CPE_INTERNAL_VALUE
FORMRATE_DF34 CPE Formula - Rate in Formula Currency DF34 CPE_INTERNAL_VALUE
FORMPRUN CPE Formula - Price Unit CPE_PRUN
CONTRACTGUID CPE Formula - GUID of Contract Item Related to Document Item SYSUUID
ORIG_GUID CPE Caller - GUID of Original Item of the Document Item SYSUUID
LOGSYS CPE Formula - Original Logical System LOGSYS
SRCSYSTEMTYPE CPE - Source System Type CHAR4
FORMVAL_DOCCURR_DF34 CPE Formula - Value in Document Currency DF34 CPE_INTERNAL_VALUE
EVAL_TIMESTAMP CPE Formula - Evaluation Date and Time CPE_TIMESTAMP_WO_CONV_EXIT
REQUESTED_EVAL_KEYDATE Requested Evaluation Key Date CPE_TIMESTAMP_WO_CONV_EXIT
LATEST_EVAL_KEYDATE Latest Evaluation Key Date CPE_TIMESTAMP_WO_CONV_EXIT
USED_EVAL_KEYDATE Evaluation Key Date Used CPE_TIMESTAMP
FORM_UOMSUBST Unit of Measure Substitution for Formula CHAR1
FIXFORMRATE_DF34 CPE Formula - Fixed Rate (upto 14 decimal places) CPE_INTERNAL_VALUE
FIXFORMPRUN CPE - Price Unit of Fixed Rate CPE_PRUN
LATEST_EVAL_KEYDATE_ROUT Latest Evaluation Key Date Routine CPE_ROUTINE
FORMTEXT Formula Description TEXT40
Master Data Relations Join Conditions
CPE Caller - Billing: Blocking Reason for Document Items
CPE Formula - Routine for Combining Terms
  • ?
  • ?
  • CPE Formula - Routine for Combining Terms
  • ?
  • CPE_FORMULA.CLIENT == CPEC_ROUTINE.CLIENT
  • CPE_FORMULA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPE_FORMULA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPE_FORMULA.COMBROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPE_FORMULA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
Exchange Rate Forecast Routine
  • ?
  • ?
  • Exchange Rate Forecast Routine
  • ?
  • CPE_FORMULA.CLIENT == CPEC_ROUTINE.CLIENT
  • CPE_FORMULA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPE_FORMULA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPE_FORMULA.EXRATE_FORECAST_ROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPE_FORMULA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE - Currency for Fixed Rate
  • CPE_FORMULA.CLIENT == TCURC.MANDT
  • CPE_FORMULA.FIXFORMCURR == TCURC.WAERS
CPE - Unit of Measure of Fixed Rate
  • CPE_FORMULA.CLIENT == T006.MANDT
  • CPE_FORMULA.FIXFORMUOM == T006.MSEHI
CPE Formula - Routine for Evaluation
  • ?
  • ?
  • CPE Formula - Routine for Evaluation
  • ?
  • CPE_FORMULA.CLIENT == CPEC_ROUTINE.CLIENT
  • CPE_FORMULA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPE_FORMULA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPE_FORMULA.FORMEVALROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPE_FORMULA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS
CPE Formula - Key
  • CPE Formula - Key
  • Client
  • ?
  • ?
  • ?
CPE - Quantity Conv. Rule from Product UoM to Commodity UoM
  • ?
  • CPE - Quantity Conv. Rule from Product UoM to Commodity UoM
  • ?
CPE Formula - Status of Evaluation
CPE Term - Routine f. Splitting the Commodity Qty into Terms
  • ?
  • ?
  • CPE Term - Routine f. Splitting the Commodity Qty into Terms
  • ?
  • CPE_FORMULA.CLIENT == CPEC_ROUTINE.CLIENT
  • CPE_FORMULA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE
  • CPE_FORMULA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE
  • CPE_FORMULA.QUANSPLITROUT == CPEC_ROUTINE.CPE_ROUTINE
  • CPE_FORMULA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS