CPED_TERMGRPOUT

Transparent Table Application Table
55 Fields 17 CDS Views

CPE Term - Changed Grouping and General Term Result

CPED_TERMGRPOUT is an SAP database table in S/4HANA. CPE Term - Changed Grouping and General Term Result. It contains 55 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
/dmbe/i_DCSID_CPE view inner DCSID CPE Term
I_ACMMntnPrcgGrpAndFormulaDet view inner BASIC CPE group and formula details
I_ACMTermInputCPEData view_entity inner BASIC Extract Source Fields for Migration Data
I_ACMTrmGrpGeneralResult view_entity from BASIC ACM CPE Term Grouping and General Result
I_CmmdtyPrcgTrmChangedResult view from BASIC CPE Term Chgd. Grouping and Gen. Result
I_CmmdtyPrcgTrmGrpgGenRes view from BASIC CPE Term Change Grouping
I_COND_HEADER view inner COMPOSITE
P_CmmdtyPrcFixationExerciseSls view from BASIC Commodity Price Fixation Exercise Sales
P_CmmdtyPrcFixationExerPurg view from BASIC Cmmdty Prc Fixation Exercise Purchasing
P_CmmdtyPrcFixationOptionPurg view left_outer BASIC Cmmdty Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptionSales view left_outer BASIC Commodity Price Fixation Option Sales
P_CmmdtyPrcgTrmGrpgGenR view from BASIC CPE Term Changed Grouping and General Term Result
P_PrcFixationOptionBsHndlgPurg view left_outer BASIC Cmmdt Prc Fix Option Basis Handling Purg
P_PrcFixationOptionBsHndlgSls view left_outer BASIC Cmmdt Prc Fix Option Basis Handling Sls
P_PrcFixationOptionCnvrsnPurg view left_outer BASIC Cmmdt Prc Fix Option Conversion Purg
P_PrcFixationOptionCnvrsnSls view left_outer BASIC Cmmdt Prc Fix Option Conversion Sales
P_PrcSttgMethExecutionAnalysis view left_outer BASIC

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY forminput_guid CPET_FORMINPUT_GUID Doc. Form. GUID
KEY termno CPET_TERMNO Term Number
termid CPET_TERMID Term Key
terminput_guid CPET_TERMINPUT_GUID Term Input GUID
termconvin_guid CPET_TERMCONVIN_GUID ConvInputGUID
termroundin_guid CPET_TERMROUNDIN_GUID Rnd Input GUID
termgroup CPET_TERMGROUP Term Group
provis CPET_PROVIS ProvPricing only
provtermno CPET_PROVTERMNO Prov.Term No.
factor1 CPET_FACTOR1 Factor 1
factor2 CPET_FACTOR2 Factor 2
percentage CPET_PERCENTAGE CPE Term - Percent
termcommquan CPET_TERMCOMMQUAN Commodity Qty
termcommuom CPET_TERMCOMMUOM Comm. Qty UoM
usedquan CPET_USEDQUAN Commodity Quantity
useduom CPET_USEDUOM Calc. Comm. UoM
termconvout_guid CPET_TERMCONVOUT_GUID ConvResultGUID
perdtout_guid_q CPET_PERIODDTOUT_GUID PerDet.Out.GUID
perdtout_guid_c CPET_PERIODDTOUT_GUID PerDet.Out.GUID
termstatus CPET_TERMSTATUS Term Status
billing_block CPET_BILLING_BLOCK Blocking Reason
termval CPET_TERMVAL Term Value
termrate CPET_TERMRATE Term Rate
termcurr CPET_TERMCURR Term Currency
termprun CPET_TERMPRUN Term Price Unit
termuom CPET_TERMUOM Term UoM
forecast_status CPET_FORECAST_STATUS Forecast Status
forecast_datetime CPET_USED_EVAL_KEYDATE Eval. Key Date
curve_date TBA_CURVEDATE Curve Date
termrate_df34 CPET_INTERNAL_VALUE CPE - Used for internal calculation (rounding, conversion)
termval_df34 CPET_TERMVALUE_DF34 Term Value
quotation CPET_QUOTATION Calculated Quotation
quotation_df34 CPET_PRICEQUOT_DF34 Price Quotation
quotcurr CPET_QUOTCURR Qtn Currency
quotprun CPET_QUOTPRUN Quotation PU
quotuom CPET_QUOTUOM Quotation UoM
calc_limitused CPET_LIMITUSED CalcRule: Limit
quot_uomsubst CPET_UOMSUB_QUOT UoM Subst. Quot
surchargerate CPET_SURCHARGERATE Total Surcharge
surchargerate_df34 CPET_SURCHARGERATE_DF34 Total Surcharge
surchratecurr CPET_SURCHRATECURR AbsSurchCurr
surchrateprun CPET_SURCHRATEPRUN AbsSurch PU
surchrateuom CPET_SURCHRATEUOM AbsSurchUoM
surch_uomsubst CPET_UOMSUB_SUR UoM Subst. Sur
extension_group CPET_EXTENSION_GROUP Extension Group
extension_usage CPET_EXTENSION_USAGE Extension Usage
is_basis_id_manual IS_BASIS_ID_MANUAL Manual Basis ID
basis_id TBAC_BASIS_ID Basis ID
fut_kschl CPET_COND_TYPE Condition Type
fut_termno CPET_TERMNO Term Number
flat_grp_timestamp TIMESTAMP Time Stamp
formres_rel CPET_FORMRES_REL Rel.for FormRes.
dcs_type TBA_DERIVATIVETYPE Derivative Category
keydate TBA_KEYDATE Maturity Key Date

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 Term - Changed Grouping and General Term Result
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPED_TERMGRPOUT (
    CLIENT,              -- Client [MANDT]
    FORMINPUT_GUID,      -- Doc. Form. GUID [CPET_FORMINPUT_GUID]
    TERMNO,              -- Term Number [CPET_TERMNO]
    TERMID,              -- Term Key [CPET_TERMID]
    TERMINPUT_GUID,      -- Term Input GUID [CPET_TERMINPUT_GUID]
    TERMCONVIN_GUID,     -- ConvInputGUID [CPET_TERMCONVIN_GUID]
    TERMROUNDIN_GUID,    -- Rnd Input GUID [CPET_TERMROUNDIN_GUID]
    TERMGROUP,           -- Term Group [CPET_TERMGROUP]
    PROVIS,              -- ProvPricing only [CPET_PROVIS]
    PROVTERMNO,          -- Prov.Term No. [CPET_PROVTERMNO]
    FACTOR1,             -- Factor 1 [CPET_FACTOR1]
    FACTOR2,             -- Factor 2 [CPET_FACTOR2]
    PERCENTAGE,          -- CPE Term - Percent [CPET_PERCENTAGE]
    TERMCOMMQUAN,        -- Commodity Qty [CPET_TERMCOMMQUAN]
    TERMCOMMUOM,         -- Comm. Qty UoM [CPET_TERMCOMMUOM]
    USEDQUAN,            -- Commodity Quantity [CPET_USEDQUAN]
    USEDUOM,             -- Calc. Comm. UoM [CPET_USEDUOM]
    TERMCONVOUT_GUID,    -- ConvResultGUID [CPET_TERMCONVOUT_GUID]
    PERDTOUT_GUID_Q,     -- PerDet.Out.GUID [CPET_PERIODDTOUT_GUID]
    PERDTOUT_GUID_C,     -- PerDet.Out.GUID [CPET_PERIODDTOUT_GUID]
    TERMSTATUS,          -- Term Status [CPET_TERMSTATUS]
    BILLING_BLOCK,       -- Blocking Reason [CPET_BILLING_BLOCK]
    TERMVAL,             -- Term Value [CPET_TERMVAL]
    TERMRATE,            -- Term Rate [CPET_TERMRATE]
    TERMCURR,            -- Term Currency [CPET_TERMCURR]
    TERMPRUN,            -- Term Price Unit [CPET_TERMPRUN]
    TERMUOM,             -- Term UoM [CPET_TERMUOM]
    FORECAST_STATUS,     -- Forecast Status [CPET_FORECAST_STATUS]
    FORECAST_DATETIME,   -- Eval. Key Date [CPET_USED_EVAL_KEYDATE]
    CURVE_DATE,          -- Curve Date [TBA_CURVEDATE]
    TERMRATE_DF34,       -- CPE - Used for internal calculation (rounding, conversion) [CPET_INTERNAL_VALUE]
    TERMVAL_DF34,        -- Term Value [CPET_TERMVALUE_DF34]
    QUOTATION,           -- Calculated Quotation [CPET_QUOTATION]
    QUOTATION_DF34,      -- Price Quotation [CPET_PRICEQUOT_DF34]
    QUOTCURR,            -- Qtn Currency [CPET_QUOTCURR]
    QUOTPRUN,            -- Quotation PU [CPET_QUOTPRUN]
    QUOTUOM,             -- Quotation UoM [CPET_QUOTUOM]
    CALC_LIMITUSED,      -- CalcRule: Limit [CPET_LIMITUSED]
    QUOT_UOMSUBST,       -- UoM Subst. Quot [CPET_UOMSUB_QUOT]
    SURCHARGERATE,       -- Total Surcharge [CPET_SURCHARGERATE]
    SURCHARGERATE_DF34,  -- Total Surcharge [CPET_SURCHARGERATE_DF34]
    SURCHRATECURR,       -- AbsSurchCurr [CPET_SURCHRATECURR]
    SURCHRATEPRUN,       -- AbsSurch PU [CPET_SURCHRATEPRUN]
    SURCHRATEUOM,        -- AbsSurchUoM [CPET_SURCHRATEUOM]
    SURCH_UOMSUBST,      -- UoM Subst. Sur [CPET_UOMSUB_SUR]
    EXTENSION_GROUP,     -- Extension Group [CPET_EXTENSION_GROUP]
    EXTENSION_USAGE,     -- Extension Usage [CPET_EXTENSION_USAGE]
    IS_BASIS_ID_MANUAL,  -- Manual Basis ID [IS_BASIS_ID_MANUAL]
    BASIS_ID,            -- Basis ID [TBAC_BASIS_ID]
    FUT_KSCHL,           -- Condition Type [CPET_COND_TYPE]
    FUT_TERMNO,          -- Term Number [CPET_TERMNO]
    FLAT_GRP_TIMESTAMP,  -- Time Stamp [TIMESTAMP]
    FORMRES_REL,         -- Rel.for FormRes. [CPET_FORMRES_REL]
    DCS_TYPE,            -- Derivative Category [TBA_DERIVATIVETYPE]
    KEYDATE,             -- Maturity Key Date [TBA_KEYDATE]
    PRIMARY KEY (CLIENT, FORMINPUT_GUID, TERMNO)
);

Learn More