CPEC_TERMGRP

Transparent Table Customizing Table
15 Fields 6 CDS Views

CPE Term - Grouping of Terms

CPEC_TERMGRP is an SAP database table in S/4HANA. CPE Term - Grouping of Terms. It contains 15 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgFmlaTrmGrpgDef view_entity from BASIC Formula Term Group
I_CmmdtyPricingTermGrouping view from BASIC CPE Term Grouping of Terms
P_CmmdtyPrcFixationOptionPurg view left_outer BASIC Cmmdty Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptionSales view left_outer BASIC Commodity Price Fixation Option Sales
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

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY logsys LOGSYS Logical system
KEY formid CPET_FORMID Formula Key
KEY cond_type CPET_COND_TYPE Condition Type
KEY termno CPET_TERMNO Term Number
KEY validto CPET_VALIDFROM Valid From
termid CPET_TERMID Term Key
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

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 - Grouping of Terms
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPEC_TERMGRP (
    CLIENT,        -- Client [MANDT]
    LOGSYS,        -- Logical system [LOGSYS]
    FORMID,        -- Formula Key [CPET_FORMID]
    COND_TYPE,     -- Condition Type [CPET_COND_TYPE]
    TERMNO,        -- Term Number [CPET_TERMNO]
    VALIDTO,       -- Valid From [CPET_VALIDFROM]
    TERMID,        -- Term Key [CPET_TERMID]
    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]
    PRIMARY KEY (CLIENT, LOGSYS, FORMID, COND_TYPE, TERMNO, VALIDTO)
);

Learn More