CPE_PRCFIXSET

Transparent Table Application Table
10 Fields 2 CDS Views

CPE Price Fixation Set

CPE_PRCFIXSET is an SAP database table in S/4HANA. CPE Price Fixation Set. It contains 10 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 (10)

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

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]
    PRIMARY KEY (CLIENT, PRCFIXSET_GUID)
);

Learn More