CPE_PRCFIXGRP

Transparent Table Application Table
15 Fields 5 CDS Views

CPE Price Fixation Group

CPE_PRCFIXGRP is an SAP database table in S/4HANA. CPE Price Fixation Group. It contains 15 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_CmmdtyPrcgPriceFixationGroup view_entity from EXTENSION Price Fixation Set Group - Extn
I_ACMCancMigrationTargetData view_entity inner BASIC Cancellation Migration Target Data
I_ACMContractGroupData view_entity inner BASIC Extract Document Condition Data
I_ACMPrcGroupData view_entity from BASIC Extract Document Condition Data
I_CmmdtyPrcgPriceFixationGroup view_entity from BASIC Commodity Pricing Price Fixation Group

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY prcfixgrp_guid CMM_CPE_PRCFIXGRP_GUID Price Fix Group ID
prcfixset_guid CMM_CPE_PRCFIXSET_GUID Price Fix Set GUID
group_id CMM_CPE_GRPID Group ID Prc Fix Grp
status CMM_FBFIX_STATUS Price Fix. Status
pricequantity CMM_CPE_PRCFIXGROUPQUAN Fixation Set Grp Qty
priceunit CMM_CPE_PRCFIXGRPQTYUOM Fixation Set Grp UoM
statuslastchangedon CMM_CPE_CREATEDON Change Time Fix Grp
statuschangedtoflat CMM_CPE_FLATCHANGEDON Status Chng to Flat
status_icon CMM_CPE_STATUS_ICON Status Icon
dcsid CMM_CPE_DCSID DCSID
mic CMM_CPE_MIC MIC
maturitykeydate CMM_CPE_MATURITYKEYDATE MatKeyDate
contractmaturitycode CMM_CPE_CONTRACTMATURITYCODE Contr. Maturity Code
dummy_cpe_s_prcfxgrp_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 Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_PRCFIXGRP (
    CLIENT,                        -- Client [MANDT]
    PRCFIXGRP_GUID,                -- Price Fix Group ID [CMM_CPE_PRCFIXGRP_GUID]
    PRCFIXSET_GUID,                -- Price Fix Set GUID [CMM_CPE_PRCFIXSET_GUID]
    GROUP_ID,                      -- Group ID Prc Fix Grp [CMM_CPE_GRPID]
    STATUS,                        -- Price Fix. Status [CMM_FBFIX_STATUS]
    PRICEQUANTITY,                 -- Fixation Set Grp Qty [CMM_CPE_PRCFIXGROUPQUAN]
    PRICEUNIT,                     -- Fixation Set Grp UoM [CMM_CPE_PRCFIXGRPQTYUOM]
    STATUSLASTCHANGEDON,           -- Change Time Fix Grp [CMM_CPE_CREATEDON]
    STATUSCHANGEDTOFLAT,           -- Status Chng to Flat [CMM_CPE_FLATCHANGEDON]
    STATUS_ICON,                   -- Status Icon [CMM_CPE_STATUS_ICON]
    DCSID,                         -- DCSID [CMM_CPE_DCSID]
    MIC,                           -- MIC [CMM_CPE_MIC]
    MATURITYKEYDATE,               -- MatKeyDate [CMM_CPE_MATURITYKEYDATE]
    CONTRACTMATURITYCODE,          -- Contr. Maturity Code [CMM_CPE_CONTRACTMATURITYCODE]
    DUMMY_CPE_S_PRCFXGRP_INCL_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, PRCFIXGRP_GUID)
);

Learn More