CPE_PRCFIXSET

Transparent Table Application Table
11 Fields 2 CDS Views

CPE Price Fixation Set

CPE_PRCFIXSET is an SAP database table in S/4HANA. CPE Price Fixation Set. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CmmdtyPrcgPriceFixationSet view_entity from EXTENSION Pricing Fixation Set - Extension
I_CmmdtyPrcgPriceFixationSet view_entity from BASIC Commodity Pricing price Fixation Set

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY prcfixset_guid CMM_CPE_PRCFIXSET_GUID Price Fix Set GUID
lastchangedon ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
scenariotype CMM_CPE_SCENARIO_TYPE Scenario Type
conditionapplication CMM_CPE_CONDITION_APPLICATION Application
fixationsetid CMM_CPE_FIXATION_SETID Price Fixtn Set ID
purchasingobjectcategory BSTYP Doc. Category
sddocumentcategory VBTYPL Document Cat.
pricecalculationprocesstype KVORG Event
sapobjecttype SBO_BO_TYPE SAP Object Type
dummy_cpe_s_prcfixset_incl_ps DUMMY Dummy function in length 1

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 Price Fixation Set
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_PRCFIXSET (
    CLIENT,                         -- Client [MANDT]
    PRCFIXSET_GUID,                 -- Price Fix Set GUID [CMM_CPE_PRCFIXSET_GUID]
    LASTCHANGEDON,                  -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    SCENARIOTYPE,                   -- Scenario Type [CMM_CPE_SCENARIO_TYPE]
    CONDITIONAPPLICATION,           -- Application [CMM_CPE_CONDITION_APPLICATION]
    FIXATIONSETID,                  -- Price Fixtn Set ID [CMM_CPE_FIXATION_SETID]
    PURCHASINGOBJECTCATEGORY,       -- Doc. Category [BSTYP]
    SDDOCUMENTCATEGORY,             -- Document Cat. [VBTYPL]
    PRICECALCULATIONPROCESSTYPE,    -- Event [KVORG]
    SAPOBJECTTYPE,                  -- SAP Object Type [SBO_BO_TYPE]
    DUMMY_CPE_S_PRCFIXSET_INCL_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, PRCFIXSET_GUID)
);

Learn More