The CCTRCPETERM_D table in SAP ERP or S/4HANA stores I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYTERMTP data. There are total 52 fields in CCTRCPETERM_D table. The I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYTERMTP 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 CCTRCPETERM_D table. It is in Commodity Pricing Engine Central Contract Integration (LOG_CMM_PRC_CCTR) ABAP package and is part of the Basic Functions (LO-CMM-BF) module.
SAP CCTRCPETERM_D Table Fields
Following is the list of fields that are available in SAP CCTRCPETERM_D table. The primary key fields of I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYTERMTP table in SAP are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| CONDITIONRECORD | Number of the Condition Record | KNUMH | CHAR (10) | |
| CONDITIONSEQUENTIALNUMBER | Sequential number of the condition | KOPOS | NUMC (2) | |
| CENTRALPURCHASECONTRACT | Purchasing Document Number | EBELN | CHAR (10) | |
| CENTRALPURCHASECONTRACTITEM | Item Number of Purchasing Document | EBELP | NUMC (5) | |
| PRICINGCONDITIONTERM | CPE Term – Number in Formula | CPET_TERMNO | NUMC (5) | |
| DOCITEMCOMMODITYPRICINGUUID | CPE Caller – GUID of Document Item | CPET_DOCITEM_GUID | RAW (16) | |
| CONDITIONTYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR (4) | |
| PRICINGCONDITIONFORMULAKEY | CPE Formula – Key | CPET_FORMID | CHAR (10) | |
| PRCGCONDITIONFORMULAINPUTUUID | CPE Formula – GUID of Changed Input for General Data | CPET_FORMINPUT_GUID | RAW (16) | |
| PRCGCNDNFMLACOMMODITYQUANTITY | CPE Formula – Total Quantity of Commodity in Document Item | CPET_FORMCOMMQUAN | QUAN (15) | |
| PRCGCNDNFMLACMMDTYQUANTITYUNIT | CPE Formula – Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | UNIT (3) | |
| ORIGINSYSTEM | CPE Formula – Original Logical System | CPET_FORMLOGSYS | CHAR (10) | |
| PRCGCNDNFMLAEVALUATIONDATETIME | CPE Formula – Evaluation Date and Time | CPET_EVAL_TIMESTAMP_CDS | CHAR (14) | |
| PRICINGCONDITIONTERMGROUP | CPE Term – Term Group | CPET_TERMGROUP | CHAR (1) | |
| PRCGCNDNGRPTRMVALDTYSTRTDTETME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| PRICINGCONDITIONTERMKEY | CPE Term – Key | CPET_TERMID | CHAR (10) | |
| PRCGCNDNTRMVALDTYSTARTDATETIME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| PRCGCNDNTERMCALCULATIONTYPE | CPE Term – Term Calculation Type | CPET_TERMTYPE | NUMC (7) | |
| PRCGCONDITIONTERMFIXEDRATECRCY | CPE – Currency for Fixed Rate | CPET_FIXCURR | CUKY (5) | |
| PRCGCONDITIONTERMFIXEDRATEQTY | CPE – Price Unit of Fixed Rate | CPET_FIXPRUN | DEC (5) | |
| PRCGCNDNTERMFIXEDRATEQTYUNIT | CPE – Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT (3) | |
| PRICINGCONDITIONTERMRULE | CPE Term – Term Rule | CPET_TERMRULE | CHAR (10) | |
| CNDNTRMRULEVALDTYSTARTDATETIME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| PRCGCNDNTERMCALCULATIONRULE | CPE Term – Calculation Rule | CPET_CALCRULE | CHAR (10) | |
| CNDNCALCRULEVALDTYSTRTDATETIME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| PRCGCNDNTERMQUOTATIONRULE | CPE Quotation Rule | CPET_QUOTATIONRULE | CHAR (10) | |
| CNDNQTANRULEVALDTYSTRTDATETIME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| DERIVATIVECONTRSPECIFICATION | Derivative Contract Specification ID | TBA_DCSID | CHAR (20) | |
| MARKETIDENTIFIERCODE | Market Identifier Code | TBA_MIC | CHAR (4) | |
| TIMETOMATURITY | Time to Maturity | TBA_TENOR | CHAR (10) | |
| QUOTATIONPRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR (2) | |
| PRCGCONDITIONTERMRATECRCY | CPE Term – Currency | CPET_TERMCURR | CUKY (5) | |
| PRCGCONDITIONTERMRATEQTY | CPE Term – Price Unit | CPET_TERMPRUN | DEC (5) | |
| PRCGCONDITIONTERMRATEQTYUNIT | CPE Term – Unit of Measure | CPET_TERMUOM | UNIT (3) | |
| PRCGCNDNTRMQTANRATECURRENCY | Quotation Currency | CPET_QUOTCURR | CUKY (5) | |
| PRCGCNDNTRMQTANRATEQUANTITY | Price Unit of Quotation | CPET_QUOTPRUN | DEC (5) | |
| PRCGCNDNTRMQTANRATEQTYUNIT | Unit of Measure of Quotation | CPET_QUOTUOM | UNIT (3) | |
| PRCGCNDNTRMSURCHARGERTECRCY | CPE Term – Currency of Absolute Surcharge | CPET_SURCHRATECURR | CUKY (5) | |
| PRCGCNDNTRMSURCHARGERTEQTY | CPE Term – Price Unit of Absolute Surcharge | CPET_SURCHRATEPRUN | DEC (5) | |
| PRCGCNDNTRMSURCHARGERTEQTYUNIT | CPE Term – Unit of Measure of Absolute Surcharge | CPET_SURCHRATEUOM | UNIT (3) | |
| PRCGCNDNFMLAEVALUATIONMODULE | CPE – Module of the Commodity Pricing Engine | CPET_MODULE | CHAR (2) | |
| CNDNTRMCALCTYPEROUTINESUBMDL | CPE Log – Submodule | CPET_LOG_SUBMODULE | CHAR (2) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
