The CCTRCPEFORMULA_D table in SAP ERP or S/4HANA stores I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYFORMULATP data. There are total 31 fields in CCTRCPEFORMULA_D table. The I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYFORMULATP 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 CCTRCPEFORMULA_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 CCTRCPEFORMULA_D Table Fields
Following is the list of fields that are available in SAP CCTRCPEFORMULA_D table. The primary key fields of I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYFORMULATP 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) | |
| CONDITIONVALIDITYENDDATE | Validity end date of the condition record | KODATBI | DATS (8) | |
| 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) | |
| PRCGCNDNFORMULAAMOUNTCURRENCY | CPE Caller – Document Currency | CPET_DOCCURR | CUKY (5) | |
| PRCGCNDNFORMULARATECURRENCY | CPE Formula – Currency | CPET_FORMCURR | CUKY (5) | |
| PRCGCNDNFORMULARATEQUANTITY | CPE Formula – Price Unit | CPET_FORMPRUN | DEC (5) | |
| PRCGCNDNFORMULARATEQTYUNIT | CPE Formula – Unit of Measure | CPET_FORMUOM | UNIT (3) | |
| 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) | |
| PRCGCNDNFMLAEVALUATIONDATETIME | CPE Formula – Evaluation Date and Time | CPET_EVAL_TIMESTAMP_CDS | CHAR (14) | |
| PRCGCNDNFMLACOMBINATIONROUTINE | CPE Formula – Routine for Combining Terms | CPET_COMBROUT | NUMC (7) | |
| ORIGINSYSTEM | CPE Formula – Original Logical System | CPET_FORMLOGSYS | CHAR (10) | |
| PRCGCNDNFMLAVALDTYSTRTDATETIME | CPE – ‘Valid From’ Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR (14) | |
| PRCGCNDNFMLAEVALUATIONMODULE | CPE – Module of the Commodity Pricing Engine | CPET_MODULE | CHAR (2) | |
| PRCGCNDNFMLACOMBNROUTINESUBMDL | 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) |
