SAP table PRCD_ELEMENTS (Pricing Elements)

SAP table PRCD_ELEMENTS has 5 primary key fields being CLIENT,KNUMV,KPOSN,STUNR,ZAEHK.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 MANDT
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KPOSN Condition item number NUMC 6 0 KPOSN
STUNR Step Number NUMC 3 0 * STUNR
ZAEHK Condition Counter NUMC 3 0 VFPRC_COND_COUNT
KAPPL Application CHAR 2 0 * KAPPL
KSCHL Condition Type CHAR 4 0 * KSCHA
KDATU Timestamp for Pricing CHAR 14 0 VFPRC_TIMESTAMP
KRECH Calculation Type for Condition CHAR 3 0 KRECH_LONG
KAWRT Condition Basis DEC 24 9 VFPRC_ELEMENT_BASE_VALUE
KBETR Condition Amount or Percentage DEC 24 9 VFPRC_ELEMENT_AMOUNT
WAERS Currency Key CUKY 5 0 * WAERS
KKURS Condition exchange rate for conversion to local currency DEC 9 5 KKURS
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit in the Document UNIT 3 0 * KVMEI
KUMZA Numerator for Converting to Base UoM DEC 10 0 VFPRC_NUMERATOR
KUMNE Denominator for Converting to Base UoM DEC 10 0 VFPRC_DENOMINATOR
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
KSTAT Condition is used for statistics CHAR 1 0 KSTAT
KNPRS Scale Type CHAR 1 0 STFKZ
can be maintained in condition record
A Base scale
B To-scale
C not used
D Graduated-to interval scale
KRUEK Condition is Relevant for Accrual (e.g. Freight) CHAR 1 0 KRUEK
KRELI Condition for Invoice List CHAR 1 0 KRELI
No
X Yes
KHERK Origin of the Condition CHAR 1 0 KHERK
A Automatic pricing
B Duplicated from main item
C Manually entered
D Header condition
E Item total
F Condition supplement
G Original header condition
H Correction Rebate
I Cost Correction
KGRPE Group Condition CHAR 1 0 KGRPE
X Group condition
KOLNR Access sequence - Access number NUMC 3 0 * KOLNR
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential Number of the Condition NUMC 3 0 KOPOS_LONG
KVSL1 Account Key CHAR 3 0 * KVSL1
SAKN1 G/L Account Number CHAR 10 0 SAKNR
MWSK1 Tax on sales/purchases code CHAR 2 0 * MWSKZ
KVSL2 Account Key - Accruals / Provisions CHAR 3 0 * KVSL2
SAKN2 Number of Accruals Account CHAR 10 0 SAKNR_ACCR
MWSK2 Withholding Tax Code CHAR 2 0 * WT_WITHCD
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
KDIFF Rounding-Off Difference of the Condition CURR 5 2 KDIFF
KWERT Condition Value CURR 15 2 VFPRC_ELEMENT_VALUE
WAERK SD Document Currency CUKY 5 0 * WAERK
KSTEU Condition Control CHAR 1 0 KSTEU
A Adjust for quantity variance
B Free
C Changed manually
D Fixed
E Condition value and basis fixed
F Condition value fixed (billed items)
G Condition basis fixed
H Condition value fixed (cost price)
I Scale Base Value and Condition Amount Fixed (for BYD only)
KINAK Condition is Inactive CHAR 1 0 KINAK
A Condition exclusion item
K Inactive due to calculation basis/shipping material type
L Condition exclusion header or inactive at header level
M Inactive due to manual entry
T Inactive at header level
W The document item is statistical
X Inactive via formulas or incorrect
Y Inactive because of subsequent price
KOAID Condition Class CHAR 1 0 KOAID
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
P Compare Price Protection
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
ZAEKO Condition Counter (Header) NUMC 3 0 VFPRC_COND_COUNT_HEAD
KFAKTOR Factor for Condition Base Value FLTP 16 16 KFAKTOR
KDUPL Structure Condition CHAR 1 0 KDUPL
None
A Duplication Condition
B Cumulation condition
KFAKTOR1 Factor for Condition Basis (Period) FLTP 16 16 KFAKTOR1
KZBZG Scale Basis Indicator CHAR 3 0 KZBZG_LONG
B Value scale
C Quantity scale
D Gross weight scale
E Net weight scale
F Volume scale
G Scale based on a formula
L Point scale
M Time period scale - Month
N Time period scale - Years
O Time period scale - Days
P Time period scale - Week
R Distance
S Number of shipping units
T reserved (IS-OIL, time prices)
X reserved (IS-OIL, day prices)
KSTBS Scale Base Value DEC 24 9 VFRPC_SCALE_BASE_VALUE
KONMS Condition Scale Unit of Measure UNIT 3 0 * KONMS
KONWS Scale Currency CUKY 5 0 * KONWS
KWAEH Condition Currency (for Cumulation Fields) CUKY 5 0 * KWAEH
KWERT_K Condition Value CURR 15 2 VFPRC_ELEMENT_VALUE
KFKIV Condition for Intercompany Billing CHAR 1 0 KFKIV
KMPRS Condition Changed Manually CHAR 1 0 KMPRS
PRSQU Price Source CHAR 1 0 PRSQU1
TXJLV Tax jurisdiction code level CHAR 1 0 TXJCD_LEVEL
KBFLAG Bit encrypted flags in Pricing RAW 2 0 KBFLAG
KOUPD Condition Update CHAR 1 0 KOUPD
KMXAW Indicator for Maximum Condition Basis Value CHAR 1 0 KMXAW
KMXWR Indicator for Maximum Condition Amount CHAR 1 0 KMXWR
X Maximum value set: limit has been exceeded
Y Maximum value set: limit has not yet been exceeded
KAWRT_K Condition Basis DEC 24 9 VFPRC_ELEMENT_BASE_VALUE
KUNNR Customer number (rebate recipient) CHAR 10 0 * KUNNR_KO
KVARC Condition Used for Variant Configuration CHAR 1 0 KVARC
VARCOND Variant Condition Key CHAR 26 0 * VARCOND
KTREL Relevance for Account Assignment CHAR 1 0 KTREL
Relevant for account assignment
B Account assignment with accounting indicator
MDFLG Indicator: Matrix Maintenance CHAR 1 0 MDFLG
Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
CPF_GUID Identifier of CPF Formula in Document CHAR 32 0 CPF_GUID
KAQTY Adjusted Quantity DEC 31 14 KAQTY
VAL_ZERO Process Conditions with Value Equal to Zero CHAR 1 0 VAL_ZERO
A Amount of zero will be considered
IS_ACCT_DETN_RELEVANT Statistical and Relevant for Account Determination CHAR 1 0 IS_ACCT_DETN_RELEVANT
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
COMMON_SUPPL_DATA Common Supplementary Data Indicator CHAR 1 0 COMMON_SUPPL_DATA