The CPOPRICINGTP_D table in SAP ERP or S/4HANA stores I_CENTRALPURCHASEORDERTP I_CNTRLPURORDERPRCGELEMENTTP data. There are total 85 fields in CPOPRICINGTP_D table. The I_CENTRALPURCHASEORDERTP I_CNTRLPURORDERPRCGELEMENTTP 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 CPOPRICINGTP_D table. It is in Manage External Purchase Order Application Logic (APPL_MM_PUR_EXT_PO) ABAP package and is part of the Central Purchase Order (MM-PUR-HUB-PO) module.
SAP CPOPRICINGTP_D Table Fields
Following is the list of fields that are available in SAP CPOPRICINGTP_D table. The primary key fields of the table 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) | |
| PURCHASEORDER | Purchasing Document Number | EBELN | CHAR (10) | |
| PURCHASEORDERITEM | Item Number of Purchasing Document | EBELP | NUMC (5) | |
| PRICINGDOCUMENT | Number of the Document Condition | KNUMV | CHAR (10) | |
| PRICINGDOCUMENTITEM | Condition item number | KPOSN | NUMC (6) | |
| PRICINGPROCEDURESTEP | Step Number | STUNR | NUMC (3) | |
| PRICINGPROCEDURECOUNTER | Condition Counter | VFPRC_COND_COUNT | NUMC (3) | |
| CONDITIONAPPLICATION | Application | KAPPL | CHAR (2) | |
| CONDITIONTYPE | Condition type | KSCHA | CHAR (4) | |
| PRICINGDATETIME | Timestamp for Pricing | VFPRC_TIMESTAMP | CHAR (14) | |
| CONDITIONCALCULATIONTYPE | Calculation Type for Condition | KRECH_LONG | CHAR (3) | |
| CONDITIONBASEVALUE | Condition Basis | VFPRC_ELEMENT_BASE_VALUE | DEC (24) | |
| CONDITIONRATEVALUE | Condition Amount or Percentage | VFPRC_ELEMENT_AMOUNT | DEC (24) | |
| CONDITIONCURRENCY | Currency Key | WAERS | CUKY (5) | |
| PRICEDETNEXCHANGERATE | Condition exchange rate for conversion to local currency | KKURS | DEC (9) | |
| CONDITIONQUANTITY | Condition Pricing Unit | KPEIN | DEC (5) | |
| CONDITIONQUANTITYUNIT | Condition Unit in the Document | KVMEI | UNIT (3) | |
| CONDITIONTOBASEQTYNMRTR | Numerator for Converting to Base UoM | VFPRC_NUMERATOR | DEC (10) | |
| CONDITIONTOBASEQTYDNMNTR | Denominator for Converting to Base UoM | VFPRC_DENOMINATOR | DEC (10) | |
| CONDITIONCATEGORY | Condition Category (Examples: Tax, Freight, Price, Cost) | KNTYP | CHAR (1) | |
| CONDITIONISFORSTATISTICS | Condition is used for statistics | KSTAT | CHAR (1) | |
| PRICINGSCALETYPE | Scale Type | STFKZ | CHAR (1) | |
| ISRELEVANTFORACCRUAL | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR (1) | |
| CNDNISRELEVANTFORINVOICELIST | Condition for Invoice List | KRELI | CHAR (1) | |
| CONDITIONORIGIN | Origin of the Condition | KHERK | CHAR (1) | |
| ISGROUPCONDITION | Group Condition | KGRPE | CHAR (1) | |
| ACCESSNUMBEROFACCESSSEQUENCE | Access sequence – Access number | KOLNR | NUMC (3) | |
| CONDITIONRECORD | Number of the Condition Record | KNUMH | CHAR (10) | |
| CONDITIONSEQUENTIALNUMBER | Sequential Number of the Condition | KOPOS_LONG | NUMC (3) | |
| ACCOUNTKEYFORGLACCOUNT | Account Key | KVSL1 | CHAR (3) | |
| GLACCOUNT | G/L Account Number | SAKNR | CHAR (10) | |
| TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR (2) | |
| ACCTKEYFORACCRUALSGLACCOUNT | Account Key – Accruals / Provisions | KVSL2 | CHAR (3) | |
| ACCRUALSGLACCOUNT | Number of Accruals Account | SAKNR_ACCR | CHAR (10) | |
| WITHHOLDINGTAXCODE | Withholding Tax Code | WT_WITHCD | CHAR (2) | |
| FREIGHTSUPPLIER | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| CNDNROUNDINGOFFDIFFAMOUNT | Rounding-Off Difference of the Condition | KDIFF | CURR (5) | |
| CONDITIONAMOUNT | Condition Value | VFPRC_ELEMENT_VALUE | CURR (15) | |
| TRANSACTIONCURRENCY | SD document currency | WAERK | CUKY (5) | |
| CONDITIONCONTROL | Condition Control | KSTEU | CHAR (1) | |
| CONDITIONINACTIVEREASON | Condition is Inactive | KINAK | CHAR (1) | |
| CONDITIONINACTIVEREASONNAME | Condition Inactive (Description) | PRICE_ELEMENT_INACTIVE_DESCR | CHAR (60) | |
| CONDITIONCLASS | Condition Class | KOAID | CHAR (1) | |
| PRCGPROCEDURECOUNTERFORHEADER | Condition Counter (Header) | VFPRC_COND_COUNT_HEAD | NUMC (3) | |
| FACTORFORCONDITIONBASISVALUE | Factor for Condition Base Value | KFAKTOR | FLTP (16) | |
| STRUCTURECONDITION | Structure Condition | KDUPL | CHAR (1) | |
| PERIODFACTORFORCNDNBASISVALUE | Factor for Condition Basis (Period) | KFAKTOR1 | FLTP (16) | |
| PRICINGSCALEBASIS | Scale Basis Indicator | KZBZG_LONG | CHAR (3) | |
| CONDITIONSCALEBASISVALUE | Scale Base Value | VFRPC_SCALE_BASE_VALUE | DEC (24) | |
| CONDITIONSCALEBASISUNIT | Condition Scale Unit of Measure | KONMS | UNIT (3) | |
| CONDITIONSCALEBASISCURRENCY | Scale Currency | KONWS | CUKY (5) | |
| CONDITIONALTERNATIVECURRENCY | Condition Currency (for Cumulation Fields) | KWAEH | CUKY (5) | |
| CONDITIONAMOUNTINLOCALCRCY | Condition Value | VFPRC_ELEMENT_VALUE | CURR (15) | |
| CNDNISRELEVANTFORINTCOBILLING | Condition for Intercompany Billing | KFKIV | CHAR (1) | |
| CONDITIONISMANUALLYCHANGED | Condition Changed Manually | KMPRS | CHAR (1) | |
| BILLINGPRICESOURCE | Price Source | PRSQU1 | CHAR (1) | |
| TAXJURISDICTIONLEVEL | Tax jurisdiction code level | TXJCD_LEVEL | CHAR (1) | |
| CONDITIONBYTESEQUENCE | Bit encrypted flags in Pricing | KBFLAG | RAW (2) | |
| CNDNISRELEVANTFORLIMITVALUE | Condition Update | KOUPD | CHAR (1) | |
| CONDITIONBASISLIMITEXCEEDED | Indicator for Maximum Condition Basis Value | KMXAW | CHAR (1) | |
| CONDITIONAMOUNTLIMITEXCEEDED | Indicator for Maximum Condition Amount | KMXWR | CHAR (1) | |
| CUMULATEDCONDITIONBASISVALUE | Condition Basis | VFPRC_ELEMENT_BASE_VALUE | DEC (24) | |
| CUSTOMERREBATERECIPIENT | Customer number (rebate recipient) | KUNNR_KO | CHAR (10) | |
| CONDITIONISFORCONFIGURATION | Condition Used for Variant Configuration | KVARC | CHAR (1) | |
| VARIANTCONDITION | Variant Condition Key | VARCOND | CHAR (26) | |
| CONDITIONACCTASSGMTRELEVANCE | Relevance for Account Assignment | KTREL | CHAR (1) | |
| CONDITIONMATRIXMAINTRELEVANCE | Indicator: Matrix Maintenance | MDFLG | CHAR (1) | |
| CONFIGBLPARAMETERSANDFORMULAS | Identifier of CPF Formula in Document | CPF_GUID | CHAR (32) | |
| CONDITIONADJUSTEDQUANTITY | Adjusted Quantity | KAQTY | DEC (31) | |
| CONDITIONTYPENAME | Description | VTXTM | CHAR (30) | |
| CONDITIONBASEVALUEINTLUNIT | Currency Key | WAERS | CUKY (5) | |
| CONDITIONBASEVALUEUNIT | Condition Unit (Currency, Sales Unit, or %) | KOEIN | CUKY (5) | |
| CONDITIONRATEVALUEINTLUNIT | Currency Key | WAERS | CUKY (5) | |
| TAXCODENAME | Tax Code Description | PRICE_ELEMENT_TAX_CODE_DESCR | CHAR (50) | |
| PRICINGPROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,…) | KALSM_D | CHAR (6) | |
| CONDITIONRATEVALUEUNIT | Currency Key | WAERS | CUKY (5) | |
| 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) |
