CPE_FORMULA

Transparent Table Application Table
63 Fields 2 CDS Views

CPE Formula

CPE_FORMULA is an SAP database table in S/4HANA. CPE Formula. It contains 63 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CmmdtyPrcgConditionFormula view_entity from EXTENSION Cmmdty Prcng Cndn Formula - Extension
I_CmmdtyPrcgConditionFormula view_entity from BASIC CPE Condition Formula

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY docitemcond_guid cpet_docitemcond_guid Doc. Cond. Item GUID
docitem_guid cpet_docitem_guid Doc. Item GUID
cond_type cpet_cond_type Condition Type
formid cpet_formid Formula Key
forminput_guid cpet_forminput_guid Doc. Form. GUID
formconvin_guid cpet_formconvin_guid ConvInp:Formula
formroundin_guid cpet_formroundin_guid Round.Inp. GUID
formconvout_guid cpet_formconvout_guid ConvOut:Formula
formstatus cpet_formstatus Status Formula Eval.
billing_block cpet_billing_block Blocking Reason
evaltimestamp cpet_evaltimestamp EvalDateTime
formval cpet_formval Formula Value
formval_df34 cpet_formval_df34 Formula Value
formrate cpet_formrate Formula Rate
formrate_df34 cpet_formrate_df34 Formula Rate
formcurr cpet_formcurr Formula Currency
formprun cpet_formprun Formula Price Unit
formuom cpet_formuom Formula UoM
formcommquan cpet_formcommquan Comm.Qty Item
formcommuom cpet_formcommuom Commodity UoM
quancnv_comm cpet_quancnv_comm Commodity Quantity
quancnv_item cpet_quancnv_item Item Quantity
contractguid cpet_contract_guid Con.Item: GUID
orig_guid cpet_orig_guid Doc.Item GUID
logsys cpet_formlogsys LogSys: Formula
srcsystemtype cpet_srcsystemtype System Type
formval_doccurr cpet_formval_doccurr Formula Value
formval_doccurr_df34 cpet_formval_doccurr_df34 Formula Value
doccurr cpet_doccurr Doc. Currency
eval_timestamp cpet_eval_timestamp_cds Eval. Date and Time
itemproduom cpet_itemproduom Product UoM
requested_eval_keydate cpet_reqd_eval_keydate_cds Reqstd Eval. Date
latest_eval_keydate cpet_latest_eval_keydate_cds Latest Eval. Date
used_eval_keydate cpet_used_eval_keydate_cds Eval. Key Date
forecast_requested cpet_forecast_requested Proposed
forecast_status cpet_forecast_status Forecast Status
form_uomsubst cpet_uomsub_form UoM Subst. Form
fixformrate cpet_fixformrate Fixed Rate
fixformrate_df34 cpet_fixformrate_df34 Fixed Rate
fixformcurr cpet_fixcurr Currency Fixed Rate
fixformprun cpet_fixprun PrcUnit Fixed Value
fixformuom cpet_fixuom UoM for Fixed Value
formevalrout cpet_formevalrout Form.Eval.Rtine
combrout cpet_combrout Combination Routine
quansplitrout cpet_quansplitrout Splitting Routine
formquanconv cpet_quancnv_form Qty Conversion Rule
latest_eval_keydate_rout cpet_latest_eval_keydate_rout Latest Eval. Date R.
forecast_mode cpet_forecast_mode Forecast Mode
exrate_forecast_rout cpet_exrate_forecast_routine ExRateForecast Rout
formula_last_changed_date_time abp_lastchange_tstmpl Changed On
roundrout_qcr cpet_roundrout Round. Routine
numdecs_qcr cpet_numdecs Dec. Places Rnd
numtens_qcr cpet_numtens Predec. Rndng
formtext cpet_formula_text Formula Description
purchasingobjectcategory bstyp Doc. Category
sddocumentcategory vbtypl Document Cat.
pricecalculationprocesstype kvorg Event
sapobjecttype sbo_bo_type SAP Object Type
pricefixationexists cpet_prcfix_option_exists PrcFix Option Exists
numberofdecimalsused tba_nodecimals Decimal Places
kappl kappl Application
kalsm kalsm_d Procedure

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CPE Formula
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_FORMULA (
    CLIENT,                          -- Client [mandt]
    DOCITEMCOND_GUID,                -- Doc. Cond. Item GUID [cpet_docitemcond_guid]
    DOCITEM_GUID,                    -- Doc. Item GUID [cpet_docitem_guid]
    COND_TYPE,                       -- Condition Type [cpet_cond_type]
    FORMID,                          -- Formula Key [cpet_formid]
    FORMINPUT_GUID,                  -- Doc. Form. GUID [cpet_forminput_guid]
    FORMCONVIN_GUID,                 -- ConvInp:Formula [cpet_formconvin_guid]
    FORMROUNDIN_GUID,                -- Round.Inp. GUID [cpet_formroundin_guid]
    FORMCONVOUT_GUID,                -- ConvOut:Formula [cpet_formconvout_guid]
    FORMSTATUS,                      -- Status Formula Eval. [cpet_formstatus]
    BILLING_BLOCK,                   -- Blocking Reason [cpet_billing_block]
    EVALTIMESTAMP,                   -- EvalDateTime [cpet_evaltimestamp]
    FORMVAL,                         -- Formula Value [cpet_formval]
    FORMVAL_DF34,                    -- Formula Value [cpet_formval_df34]
    FORMRATE,                        -- Formula Rate [cpet_formrate]
    FORMRATE_DF34,                   -- Formula Rate [cpet_formrate_df34]
    FORMCURR,                        -- Formula Currency [cpet_formcurr]
    FORMPRUN,                        -- Formula Price Unit [cpet_formprun]
    FORMUOM,                         -- Formula UoM [cpet_formuom]
    FORMCOMMQUAN,                    -- Comm.Qty Item [cpet_formcommquan]
    FORMCOMMUOM,                     -- Commodity UoM [cpet_formcommuom]
    QUANCNV_COMM,                    -- Commodity Quantity [cpet_quancnv_comm]
    QUANCNV_ITEM,                    -- Item Quantity [cpet_quancnv_item]
    CONTRACTGUID,                    -- Con.Item: GUID [cpet_contract_guid]
    ORIG_GUID,                       -- Doc.Item GUID [cpet_orig_guid]
    LOGSYS,                          -- LogSys: Formula [cpet_formlogsys]
    SRCSYSTEMTYPE,                   -- System Type [cpet_srcsystemtype]
    FORMVAL_DOCCURR,                 -- Formula Value [cpet_formval_doccurr]
    FORMVAL_DOCCURR_DF34,            -- Formula Value [cpet_formval_doccurr_df34]
    DOCCURR,                         -- Doc. Currency [cpet_doccurr]
    EVAL_TIMESTAMP,                  -- Eval. Date and Time [cpet_eval_timestamp_cds]
    ITEMPRODUOM,                     -- Product UoM [cpet_itemproduom]
    REQUESTED_EVAL_KEYDATE,          -- Reqstd Eval. Date [cpet_reqd_eval_keydate_cds]
    LATEST_EVAL_KEYDATE,             -- Latest Eval. Date [cpet_latest_eval_keydate_cds]
    USED_EVAL_KEYDATE,               -- Eval. Key Date [cpet_used_eval_keydate_cds]
    FORECAST_REQUESTED,              -- Proposed [cpet_forecast_requested]
    FORECAST_STATUS,                 -- Forecast Status [cpet_forecast_status]
    FORM_UOMSUBST,                   -- UoM Subst. Form [cpet_uomsub_form]
    FIXFORMRATE,                     -- Fixed Rate [cpet_fixformrate]
    FIXFORMRATE_DF34,                -- Fixed Rate [cpet_fixformrate_df34]
    FIXFORMCURR,                     -- Currency Fixed Rate [cpet_fixcurr]
    FIXFORMPRUN,                     -- PrcUnit Fixed Value [cpet_fixprun]
    FIXFORMUOM,                      -- UoM for Fixed Value [cpet_fixuom]
    FORMEVALROUT,                    -- Form.Eval.Rtine [cpet_formevalrout]
    COMBROUT,                        -- Combination Routine [cpet_combrout]
    QUANSPLITROUT,                   -- Splitting Routine [cpet_quansplitrout]
    FORMQUANCONV,                    -- Qty Conversion Rule [cpet_quancnv_form]
    LATEST_EVAL_KEYDATE_ROUT,        -- Latest Eval. Date R. [cpet_latest_eval_keydate_rout]
    FORECAST_MODE,                   -- Forecast Mode [cpet_forecast_mode]
    EXRATE_FORECAST_ROUT,            -- ExRateForecast Rout [cpet_exrate_forecast_routine]
    FORMULA_LAST_CHANGED_DATE_TIME,  -- Changed On [abp_lastchange_tstmpl]
    ROUNDROUT_QCR,                   -- Round. Routine [cpet_roundrout]
    NUMDECS_QCR,                     -- Dec. Places Rnd [cpet_numdecs]
    NUMTENS_QCR,                     -- Predec. Rndng [cpet_numtens]
    FORMTEXT,                        -- Formula Description [cpet_formula_text]
    PURCHASINGOBJECTCATEGORY,        -- Doc. Category [bstyp]
    SDDOCUMENTCATEGORY,              -- Document Cat. [vbtypl]
    PRICECALCULATIONPROCESSTYPE,     -- Event [kvorg]
    SAPOBJECTTYPE,                   -- SAP Object Type [sbo_bo_type]
    PRICEFIXATIONEXISTS,             -- PrcFix Option Exists [cpet_prcfix_option_exists]
    NUMBEROFDECIMALSUSED,            -- Decimal Places [tba_nodecimals]
    KAPPL,                           -- Application [kappl]
    KALSM,                           -- Procedure [kalsm_d]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID)
);

Learn More