CPED_FORMDOC

Transparent Table Application Table
38 Fields 19 CDS Views

CPE Formula - Grouping and General Result

CPED_FORMDOC is an SAP database table in S/4HANA. CPE Formula - Grouping and General Result. It contains 38 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
/dmbe/i_DCSID_CPE view inner DCSID CPE Term
I_ACMFmlaGrpGeneralResult view_entity from BASIC ACM CPE Formula Group and General Result
I_ACMFormulaGrpgGeneralRes view from BASIC CPE Formula Grouping and General Result
I_ACMMntnPrcgGrpAndFormulaDet view inner BASIC CPE group and formula details
I_ACMTermInputCPEData view_entity inner BASIC Extract Source Fields for Migration Data
I_CmmdtyPricingFormulaResult view from BASIC CPE Formula Grouping and General Result
I_COND_HEADER view inner COMPOSITE
I_PrepaymentDocCmmdtyPrcgData view_entity inner BASIC PPMT Document Commodity Pricing data
I_PrepaymentDocCmmdtyPrcgVal view inner BASIC PPMT Document Commodity Pricing data
P_ACMFormulaGrpgGeneralRes view from BASIC
P_CmmdtyPrcFixationExerciseSls view inner BASIC Commodity Price Fixation Exercise Sales
P_CmmdtyPrcFixationExerPurg view inner BASIC Cmmdty Prc Fixation Exercise Purchasing
P_CmmdtyPrcFixationOptionPurg view from BASIC Cmmdty Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptionSales view from BASIC Commodity Price Fixation Option Sales
P_PrcFixationOptionBsHndlgPurg view from BASIC Cmmdt Prc Fix Option Basis Handling Purg
P_PrcFixationOptionBsHndlgSls view from BASIC Cmmdt Prc Fix Option Basis Handling Sls
P_PrcFixationOptionCnvrsnPurg view from BASIC Cmmdt Prc Fix Option Conversion Purg
P_PrcFixationOptionCnvrsnSls view from BASIC Cmmdt Prc Fix Option Conversion Sales
P_PrcSttgMethExecutionAnalysis view left_outer BASIC

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY docitem_guid CPET_DOCITEM_GUID Doc. Item GUID
KEY 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 Eval. Date and Time
itemproduom CPET_ITEMPRODUOM Product UoM
requested_eval_keydate CPET_REQUESTED_EVAL_KEYDATE Reqstd Eval. Date
latest_eval_keydate CPET_LATEST_EVAL_KEYDATE Latest Eval. Date
used_eval_keydate CPET_USED_EVAL_KEYDATE Eval. Key Date
forecast_requested CPET_FORECAST_REQUESTED Proposed
forecast_status CPET_FORECAST_STATUS Forecast Status
form_uomsubst CPET_UOMSUB_FORM UoM Subst. Form
migration_status CPET_SDM_STATUS Migration Status

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 - Grouping and General Result
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPED_FORMDOC (
    CLIENT,                  -- Client [MANDT]
    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]
    ITEMPRODUOM,             -- Product UoM [CPET_ITEMPRODUOM]
    REQUESTED_EVAL_KEYDATE,  -- Reqstd Eval. Date [CPET_REQUESTED_EVAL_KEYDATE]
    LATEST_EVAL_KEYDATE,     -- Latest Eval. Date [CPET_LATEST_EVAL_KEYDATE]
    USED_EVAL_KEYDATE,       -- Eval. Key Date [CPET_USED_EVAL_KEYDATE]
    FORECAST_REQUESTED,      -- Proposed [CPET_FORECAST_REQUESTED]
    FORECAST_STATUS,         -- Forecast Status [CPET_FORECAST_STATUS]
    FORM_UOMSUBST,           -- UoM Subst. Form [CPET_UOMSUB_FORM]
    MIGRATION_STATUS,        -- Migration Status [CPET_SDM_STATUS]
    PRIMARY KEY (CLIENT, DOCITEM_GUID, COND_TYPE)
);

Learn More