The CPED_PRCFIX_DEF table in SAP ERP or S/4HANA stores Price Fixation Definition data. There are total 26 fields in CPED_PRCFIX_DEF table. The Price Fixation Definition table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CPED_PRCFIX_DEF table. It is in Commodity Pricing: Document Data (CPE_DOC) ABAP package and is part of the Commodity Pricing Engine (CA-GTF-CPE) module.
SAP CPED_PRCFIX_DEF Table Fields
Following is the list of fields that are available in SAP CPED_PRCFIX_DEF table. The primary key fields of the table are CLIENT (Client), REF_GUID (CPE Reference GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| REF_GUID | CPE Reference GUID | CPET_REF_GUID | RAW (16) | |
| EXER_DATE_EARLY_ROUT | Earliest Price Fixation Exercise Date Routine | CPET_PRCFIX_EARLY_EXERDATEROUT | CPEC_ROUTINE | NUMC (7) |
| EXER_DATE_EARLIEST | CPE Price Fixation – Earliest Exercise Date | CPET_PRCFIX_EARLY_EXERCISEDATE | DATS (8) | |
| EXER_DATE_EARLIEST_REF_DATE_RT | Reference Date and Time Routine on CPE Term Level | CPET_REFDATEROUT | CPEC_REFDATEROUT | NUMC (7) |
| EXER_DATE_LATEST_ROUT | Latest Price Fixation Exercise Date Routine | CPET_PRCFIX_LATE_EXERDATEROUT | CPEC_ROUTINE | NUMC (7) |
| EXER_DATE_LATEST | CPE Price Fixation – Latest Exercise Date | CPET_PRCFIX_LATE_EXERCISEDATE | DATS (8) | |
| EXER_DATE_LATEST_REF_DATE_RT | Reference Date and Time Routine on CPE Term Level | CPET_REFDATEROUT | CPEC_REFDATEROUT | NUMC (7) |
| QUANTITY_DISTR_ROUT | CPE Quantity Distribution Routine for Price Fixation | CPET_PRCFIX_QTYDISTRROUT | CPEC_ROUTINE | NUMC (7) |
| QUANTITY_REF | CPE Quantity for Price Fixation | CPET_PRCFIX_QUANTITY | QUAN (15) | |
| QUANTITY_REF_UOM | CPE Quantity UoM for Price Fixation | CPET_PRCFIX_QTY_UOM | T006 | UNIT (3) |
| LIMIT_ROUT | CPE Price Fixation Limit Routine | CPET_PRCFIX_LIMROUT | CPEC_ROUTINE | NUMC (7) |
| LIMIT_QUANTITY | CPE Price Fixation Limit Quantity | CPET_PRCFIX_LIMQTY | QUAN (15) | |
| LIMIT_QUANTITY_UOM | CPE Price Fixation Limit Quantity UoM | CPET_PRCFIX_LIMQTY_UOM | T006 | UNIT (3) |
| LIMIT_FACTOR_1 | CPE Price Fixation Limit Factor 1 | CPET_PRCFIX_LIMFACTOR1 | DEC (10) | |
| LIMIT_FACTOR_2 | CPE Price Fixation Limit Factor 2 | CPET_PRCFIX_LIMFACTOR2 | DEC (10) | |
| PRICE_REF_ROUT | CPE Reference Price Routine for Non-Fixed Quantity | CPET_PRCFIX_REF_ROUT | CPEC_ROUTINE | NUMC (7) |
| PRICEFIXRULE | CPE Term – Rule for Definition of Price Fixation Option | CPET_PRCFIXOPTDEFRULE | CPEC_PRCFIXRULE | CHAR (10) |
| TIER_REF_DATE_ROUT | Reference Date and Time Routine on CPE Term Level | CPET_REFDATEROUT | CPEC_REFDATEROUT | NUMC (7) |
| PRC_FIXATION_STATUS | Status of Price Fixation Option | CPET_PRCFIX_STATUS | CHAR (1) | |
| NON_FIXED_QUANTITY | CPE Quantity for Price Fixation | CPET_PRCFIX_QUANTITY | QUAN (15) | |
| NON_FIXED_QTY_UOM | CPE Quantity UoM for Price Fixation | CPET_PRCFIX_QTY_UOM | * | UNIT (3) |
| EXER_DATE_EARLIEST_PRELIM_IND | CPE Provisional Earliest Exercise Date | CPET_PRCFIX_EARLIESTPRELIM_IND | CHAR (1) | |
| EXER_DATE_LATEST_PRELIM_IND | CPE Provisional Latest Exercise Date | CPET_PRCFIX_LATESTPRELIM_IND | CHAR (1) | |
| LIMIT_QUANTITY_OUT | CPE Price Fixation Limit Quantity | CPET_PRCFIX_LIMQTY | QUAN (15) | |
| LIMIT_QUANTITY_UOM_OUT | CPE Price Fixation Limit Quantity UoM | CPET_PRCFIX_LIMQTY_UOM | * | UNIT (3) |
