CPED_PRCFIX_DEF

Transparent Table Application Table
27 Fields 6 CDS Views

Price Fixation Definition

CPED_PRCFIX_DEF is an SAP database table in S/4HANA. Price Fixation Definition. It contains 27 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_CmmdtyPrcFixationOptionPurg view inner BASIC Cmmdty Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptionSales view inner BASIC Commodity Price Fixation Option Sales
P_PrcFixationOptionBsHndlgPurg view inner BASIC Cmmdt Prc Fix Option Basis Handling Purg
P_PrcFixationOptionBsHndlgSls view inner BASIC Cmmdt Prc Fix Option Basis Handling Sls
P_PrcFixationOptionCnvrsnPurg view inner BASIC Cmmdt Prc Fix Option Conversion Purg
P_PrcFixationOptionCnvrsnSls view inner BASIC Cmmdt Prc Fix Option Conversion Sales

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY ref_guid CPET_REF_GUID Reference GUID
exer_date_early_rout CPET_PRCFIX_EARLY_EXERDATEROUT Earl. Exc. Date Rtn
exer_date_earliest CPET_PRCFIX_EARLY_EXERCISEDATE Earliest Exc. Date
exer_date_earliest_ref_date_rt CPET_REFDATEROUT Ref. Date Routine
exer_date_latest_rout CPET_PRCFIX_LATE_EXERDATEROUT Latest Exc. Date Rtn
exer_date_latest CPET_PRCFIX_LATE_EXERCISEDATE Latest Exercise Date
exer_date_latest_ref_date_rt CPET_REFDATEROUT Ref. Date Routine
quantity_distr_rout CPET_PRCFIX_QTYDISTRROUT Qty. Distr. Routine
quantity_ref CPET_PRCFIX_QUANTITY Qty for Price Fix.
quantity_ref_uom CPET_PRCFIX_QTY_UOM Quantity UoM
limit_rout CPET_PRCFIX_LIMROUT Limit Routine
limit_quantity CPET_PRCFIX_LIMQTY Limit Quantity
limit_quantity_uom CPET_PRCFIX_LIMQTY_UOM Limit Qty UoM
limit_factor_1 CPET_PRCFIX_LIMFACTOR1 Limit Factor 1
limit_factor_2 CPET_PRCFIX_LIMFACTOR2 Limit Factor 2
price_ref_rout CPET_PRCFIX_REF_ROUT Ref. Price Routine
pricefixrule CPET_PRCFIXOPTDEFRULE Price Fixation Rule
tier_ref_date_rout CPET_REFDATEROUT Ref. Date Routine
prc_fixation_status CPET_PRCFIX_STATUS Price Fix. Status
non_fixed_quantity CPET_PRCFIX_QUANTITY Qty for Price Fix.
non_fixed_qty_uom CPET_PRCFIX_QTY_UOM Quantity UoM
exer_date_earliest_prelim_ind CPET_PRCFIX_EARLIESTPRELIM_IND Provisional Earliest
exer_date_latest_prelim_ind CPET_PRCFIX_LATESTPRELIM_IND Provisional Latest
limit_quantity_out CPET_PRCFIX_LIMQTY Limit Quantity
limit_quantity_uom_out CPET_PRCFIX_LIMQTY_UOM Limit Qty UoM
option_comment CPET_PRCFIX_OPTION_TEXT Comment

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.

-- Price Fixation Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPED_PRCFIX_DEF (
    CLIENT,                          -- Client [MANDT]
    REF_GUID,                        -- Reference GUID [CPET_REF_GUID]
    EXER_DATE_EARLY_ROUT,            -- Earl. Exc. Date Rtn [CPET_PRCFIX_EARLY_EXERDATEROUT]
    EXER_DATE_EARLIEST,              -- Earliest Exc. Date [CPET_PRCFIX_EARLY_EXERCISEDATE]
    EXER_DATE_EARLIEST_REF_DATE_RT,  -- Ref. Date Routine [CPET_REFDATEROUT]
    EXER_DATE_LATEST_ROUT,           -- Latest Exc. Date Rtn [CPET_PRCFIX_LATE_EXERDATEROUT]
    EXER_DATE_LATEST,                -- Latest Exercise Date [CPET_PRCFIX_LATE_EXERCISEDATE]
    EXER_DATE_LATEST_REF_DATE_RT,    -- Ref. Date Routine [CPET_REFDATEROUT]
    QUANTITY_DISTR_ROUT,             -- Qty. Distr. Routine [CPET_PRCFIX_QTYDISTRROUT]
    QUANTITY_REF,                    -- Qty for Price Fix. [CPET_PRCFIX_QUANTITY]
    QUANTITY_REF_UOM,                -- Quantity UoM [CPET_PRCFIX_QTY_UOM]
    LIMIT_ROUT,                      -- Limit Routine [CPET_PRCFIX_LIMROUT]
    LIMIT_QUANTITY,                  -- Limit Quantity [CPET_PRCFIX_LIMQTY]
    LIMIT_QUANTITY_UOM,              -- Limit Qty UoM [CPET_PRCFIX_LIMQTY_UOM]
    LIMIT_FACTOR_1,                  -- Limit Factor 1 [CPET_PRCFIX_LIMFACTOR1]
    LIMIT_FACTOR_2,                  -- Limit Factor 2 [CPET_PRCFIX_LIMFACTOR2]
    PRICE_REF_ROUT,                  -- Ref. Price Routine [CPET_PRCFIX_REF_ROUT]
    PRICEFIXRULE,                    -- Price Fixation Rule [CPET_PRCFIXOPTDEFRULE]
    TIER_REF_DATE_ROUT,              -- Ref. Date Routine [CPET_REFDATEROUT]
    PRC_FIXATION_STATUS,             -- Price Fix. Status [CPET_PRCFIX_STATUS]
    NON_FIXED_QUANTITY,              -- Qty for Price Fix. [CPET_PRCFIX_QUANTITY]
    NON_FIXED_QTY_UOM,               -- Quantity UoM [CPET_PRCFIX_QTY_UOM]
    EXER_DATE_EARLIEST_PRELIM_IND,   -- Provisional Earliest [CPET_PRCFIX_EARLIESTPRELIM_IND]
    EXER_DATE_LATEST_PRELIM_IND,     -- Provisional Latest [CPET_PRCFIX_LATESTPRELIM_IND]
    LIMIT_QUANTITY_OUT,              -- Limit Quantity [CPET_PRCFIX_LIMQTY]
    LIMIT_QUANTITY_UOM_OUT,          -- Limit Qty UoM [CPET_PRCFIX_LIMQTY_UOM]
    OPTION_COMMENT,                  -- Comment [CPET_PRCFIX_OPTION_TEXT]
    PRIMARY KEY (CLIENT, REF_GUID)
);

Learn More