The PRCD_ELEMENTS table in SAP ERP or S/4HANA stores Pricing Elements data. There are total 71 fields in PRCD_ELEMENTS table. The Pricing Elements 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 PRCD_ELEMENTS table. It is in DB Layer for Pricing Result (VF_PRC_DB) ABAP package and is part of the Pricing and Conditions (SD-BF-PR) module.
SAP PRCD_ELEMENTS Table Fields
Following is the list of fields that are available in SAP PRCD_ELEMENTS table. The primary key fields of the table are CLIENT (Client), KNUMV (Number of the Document Condition), KPOSN (Condition item number), STUNR (Step Number), ZAEHK (Condition Counter).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| KNUMV | Number of the Document Condition | KNUMV | CHAR (10) | |
| KPOSN | Condition item number | KPOSN | NUMC (6) | |
| STUNR | Step Number | STUNR | * | NUMC (3) |
| ZAEHK | Condition Counter | VFPRC_COND_COUNT | NUMC (3) | |
| KAPPL | Application | KAPPL | * | CHAR (2) |
| KSCHL | Condition type | KSCHA | * | CHAR (4) |
| KDATU | Timestamp for Pricing | VFPRC_TIMESTAMP | CHAR (14) | |
| KRECH | Calculation Type for Condition | KRECH_LONG | CHAR (3) | |
| KAWRT | Condition Basis | VFPRC_ELEMENT_BASE_VALUE | DEC (24) | |
| KBETR | Condition Amount or Percentage | VFPRC_ELEMENT_AMOUNT | DEC (24) | |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| KKURS | Condition exchange rate for conversion to local currency | KKURS | DEC (9) | |
| KPEIN | Condition Pricing Unit | KPEIN | DEC (5) | |
| KMEIN | Condition Unit in the Document | KVMEI | * | UNIT (3) |
| KUMZA | Numerator for Converting to Base UoM | VFPRC_NUMERATOR | DEC (10) | |
| KUMNE | Denominator for Converting to Base UoM | VFPRC_DENOMINATOR | DEC (10) | |
| KNTYP | Condition Category (Examples: Tax, Freight, Price, Cost) | KNTYP | CHAR (1) | |
| KSTAT | Condition is used for statistics | KSTAT | CHAR (1) | |
| KNPRS | Scale Type | STFKZ | CHAR (1) | |
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR (1) | |
| KRELI | Condition for Invoice List | KRELI | CHAR (1) | |
| KHERK | Origin of the Condition | KHERK | CHAR (1) | |
| KGRPE | Group Condition | KGRPE | CHAR (1) | |
| KOLNR | Access sequence – Access number | KOLNR | * | NUMC (3) |
| KNUMH | Number of the Condition Record | KNUMH | CHAR (10) | |
| KOPOS | Sequential Number of the Condition | KOPOS_LONG | NUMC (3) | |
| KVSL1 | Account Key | KVSL1 | * | CHAR (3) |
| SAKN1 | G/L Account Number | SAKNR | CHAR (10) | |
| MWSK1 | Tax on sales/purchases code | MWSKZ | * | CHAR (2) |
| KVSL2 | Account Key – Accruals / Provisions | KVSL2 | * | CHAR (3) |
| SAKN2 | Number of Accruals Account | SAKNR_ACCR | CHAR (10) | |
| MWSK2 | Withholding Tax Code | WT_WITHCD | * | CHAR (2) |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| KDIFF | Rounding-Off Difference of the Condition | KDIFF | CURR (5) | |
| KWERT | Condition Value | VFPRC_ELEMENT_VALUE | CURR (15) | |
| WAERK | SD document currency | WAERK | * | CUKY (5) |
| KSTEU | Condition Control | KSTEU | CHAR (1) | |
| KINAK | Condition is Inactive | KINAK | CHAR (1) | |
| KOAID | Condition Class | KOAID | CHAR (1) | |
| ZAEKO | Condition Counter (Header) | VFPRC_COND_COUNT_HEAD | NUMC (3) | |
| KFAKTOR | Factor for Condition Base Value | KFAKTOR | FLTP (16) | |
| KDUPL | Structure Condition | KDUPL | CHAR (1) | |
| KFAKTOR1 | Factor for Condition Basis (Period) | KFAKTOR1 | FLTP (16) | |
| KZBZG | Scale Basis Indicator | KZBZG_LONG | CHAR (3) | |
| KSTBS | Scale Base Value | VFRPC_SCALE_BASE_VALUE | DEC (24) | |
| KONMS | Condition Scale Unit of Measure | KONMS | * | UNIT (3) |
| KONWS | Scale Currency | KONWS | * | CUKY (5) |
| KWAEH | Condition Currency (for Cumulation Fields) | KWAEH | * | CUKY (5) |
| KWERT_K | Condition Value | VFPRC_ELEMENT_VALUE | CURR (15) | |
| KFKIV | Condition for Intercompany Billing | KFKIV | CHAR (1) | |
| KMPRS | Condition Changed Manually | KMPRS | CHAR (1) | |
| PRSQU | Price Source | PRSQU1 | CHAR (1) | |
| TXJLV | Tax jurisdiction code level | TXJCD_LEVEL | CHAR (1) | |
| KBFLAG | Bit encrypted flags in Pricing | KBFLAG | RAW (2) | |
| KOUPD | Condition Update | KOUPD | CHAR (1) | |
| KMXAW | Indicator for Maximum Condition Basis Value | KMXAW | CHAR (1) | |
| KMXWR | Indicator for Maximum Condition Amount | KMXWR | CHAR (1) | |
| KAWRT_K | Condition Basis | VFPRC_ELEMENT_BASE_VALUE | DEC (24) | |
| KUNNR | Customer number (rebate recipient) | KUNNR_KO | * | CHAR (10) |
| KVARC | Condition Used for Variant Configuration | KVARC | CHAR (1) | |
| VARCOND | Variant Condition Key | VARCOND | * | CHAR (26) |
| KTREL | Relevance for Account Assignment | KTREL | CHAR (1) | |
| MDFLG | Indicator: Matrix Maintenance | MDFLG | CHAR (1) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) | |
| CPF_GUID | Identifier of CPF Formula in Document | CPF_GUID | CHAR (32) | |
| KAQTY | Adjusted Quantity | KAQTY | DEC (31) | |
| VAL_ZERO | Process conditions with value equal to zero | VAL_ZERO | CHAR (1) | |
| IS_ACCT_DETN_RELEVANT | Statistical and Relevant for Account Determination | IS_ACCT_DETN_RELEVANT | CHAR (1) | |
| TAX_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | CHAR (3) | |
| /IDT/AUNA | Character Field with Length 10 | CHAR10 | CHAR (10) |
