SAP Table PRCT_COND_WRK

Condition Line (KOMV)

PRCT_COND_WRK (Condition Line (KOMV)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PRCT_COND_WRK to other SAP tables.

Source: PRCT_COND_WRK (Condition Line (KOMV))

PRCT_COND_WRK table fields

Field Data element Checktable Datatype Length Decimals
KNUMV Pricing Document GUID PRCT_PRIDOC_GUID RAW 16 0
KPOSN Item Number PRCT_ITEM_NO RAW 16 0
STUNR Level Number PRCT_PP_STEP NUMC 3 0
ZAEHK Condition Counter PRCT_PP_COUNTER NUMC 3 0
KSCHL Pricing - Condition Type PRCT_COND_TYPE CHAR 4 0
KSTAT Condition is Statistical PRCT_FLAG_COND_STATISTICAL CHAR 1 0
X Yes
NULL No
KVSL1 Account Key PRCT_ACCOUNT_KEY_1 CHAR 3 0
KVSL2 Account Key - Accruals PRCT_ACCOUNT_KEY_2 CHAR 3 0
KVEWE Usage for Condition Technique /SAPCND/USAGE /SAPCND/T681V CHAR 2 0
KRECH Calculation Type for Condition PRCT_CALCULATION_TYPE PRCC_CTYPE_DEF CHAR 3 0
KZBZG Indicator: Scale Base Type PRCT_SCALE_BASE_TYPE CHAR 3 0
STFKZ Scale Type of a Condition PRCT_COND_SCALE_TYPE CHAR 1 0
A Base-scale
B To-scale
D Graduated-to interval scale
KNTYP Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost PRCT_COND_CATEGORY CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Reserved (IS-OIL)
0 Reserved (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
B Delivery costs
C Insurance
D Tax
E Cash Discount
F Freight
G Cost
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Sales tax not deductible (VAT)
O Variants
P Base amount including tax
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
a Reserved (fixed extra pay)
b Transfer price for group valuation for reporting purposes
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
KGRPE Condition is Group Condition PRCT_FLAG_GROUP_COND CHAR 1 0
X Group condition
KDUPL Structure Condition PRCT_COND_STRUCT CHAR 1 0
A Condition to be duplicated
B Cumulation condition
KRUEK Accruals are Set up for the Condition (e.g. Freight) PRCT_FLAG_ACCRUAL CHAR 1 0
X Yes
NULL No
KOAID Condition Class PRCT_COND_CLASS CHAR 1 0
A Discount or Surcharge
B Prices
C Expense Reimbursement
D Taxes
E Extra Pay
F Reserved (IS-OIL)
G Tax Code
H Sales Deal Determination
Q Reserved (IS-OIL)
W Withholding Tax
KFKIV Condition for Inter-Company Billing PRCT_COND_INTER_COMPANY CHAR 1 0
X Yes
NULL No
KVARC Condition for Configuration PRCT_COND_VARIANTS CHAR 1 0
X Yes
NULL No
KTREL Relevance for Account Assignment PRCT_FLAG_ACCOUNT_RELEVANT CHAR 1 0
B Account assignment with accounting indicator
NULL Relevant for account assignment
KBFLAG Bit Encrypted Flags in Pricing PRCT_GENERAL_FLAGS RAW 2 0
DTASRC Primary Data Record Source for a Condition Record PRCT_DATA_SOURCE1 CHAR 2 0
NULL Condition technique (old)
A Condition technique (new)
B Cash Flow (FS/Leasing)
C Tax Determination
D Financial mathematics (Leasing)
E Cash Discount
F Billing for One-Time Payments
G EBP: Price From Product Catalog
H Cost
I Floating Rates / Indexation
J IPM: Basic Value
K EBP: Price From Backend Contract
L Social: Requirement Determination
M CRM: Condition from ERP Purchasing Contract
N CRM: Download of an ERP Dispute Case
O CRM: Accruals
Q CRM: Pricing
U UBB: Prebilling
X Customer Reserve 1
Y Customer Reserve 2
Z Customer Reserve 3
EC CRM: External Configurator
CP Pricing: Calculation Tool
KRELI Invoice List Condition Flag PRCT_FLAG_INVOICE_LIST CHAR 1 0
X Yes
NULL No
KOUPD Condition Update Flag PRCT_FLAG_COND_UPDATE CHAR 1 0
X Yes
NULL No
KAPPL Application PRCT_APPLICATION CHAR 3 0
KAWRT Price Determination: Condition Basis PRCT_COND_BASIS DEC 18 5
KHERK Condition Origin PRCT_COND_ORIGIN CHAR 1 0
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
J Transaction Tax Engine
KDIFF Rounding-Off Difference of the Condition PRCT_COND_ROUND_DIFF CURR 5 2
KWERT Price Determination: Condition Value PRCT_COND_VALUE CURR 15 2
KSTEU Condition Control PRCT_COND_STATUS CHAR 1 0
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)
KINAK Condition is Inactive PRCT_FLAG_COND_INACTIVE CHAR 1 0
A Condition exclusion item
G Not applying scale level (in interval scales)
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
ZAEKO Condition Counter (Header) PRCT_COND_COUNT_HEAD NUMC 3 0
KFAKTOR1 Correction Factor for Condition Basis (Interval Scale) PRCT_COND_BASIS_FACTOR FLTP 16 16
KMPRS Indicator: Condition Manually Changed PRCT_FLAG_COND_MAN_CHANGED CHAR 1 0
X Yes
NULL No
KWAEH Second Currency PRCT_CURRENCY2 CUKY 5 0
KWERT_K Second Condition Value PRCT_COND_VALUE2 CURR 15 2
KAWRT_K Second Condition Basis PRCT_COND_BASIS2 DEC 18 5
KSTBS Pricing: Scale Basis PRCT_SCALE_BASIS DEC 18 5
KDATU Condition Pricing Date PRCT_PRICING_DATE DATS 8 0
WAERS Condition Currency PRCT_COND_CURR CUKY 5 0
KKURS Condition Exchange Rate for Conversion to Local Currency PRCT_EXCH_RATE_COND_CURR DEC 9 5
KFAKTOR Correction Factor for Conditions From Configuration PRCT_COND_FACTOR_CONFIG FLTP 16 16
PRSQU Price Source PRCT_COND_PRICE_SOURCE CHAR 1 0
NULL Order
A Purchase order
B Purchase order/delivery
C Not used
D Delivery
E Delivery/order
F Shipment Costs
G external
VARCOND Variant Key of a Variant Condition PRCT_VARIANT_KEY CHAR 26 0
TXJLV Tax Jurisdiction Code Level PRCT_TXJCD_LEVEL CHAR 1 0
DTASRC2 Secondary Data Record Source for a Condition Record PRCT_DATA_SOURCE2 CHAR 2 0
NULL Condition technique (old)
A Condition technique (new)
B Cash Flow (FS/Leasing)
C Tax Determination
D Financial mathematics (Leasing)
E Cash Discount
F Billing for One-Time Payments
G EBP: Price From Product Catalog
H Cost
I Floating Rates / Indexation
J IPM: Basic Value
K EBP: Price From Backend Contract
L Social: Requirement Determination
M CRM: Condition from ERP Purchasing Contract
N CRM: Download of an ERP Dispute Case
O CRM: Accruals
Q CRM: Pricing
U UBB: Prebilling
X Customer Reserve 1
Y Customer Reserve 2
Z Customer Reserve 3
EC CRM: External Configurator
CP Pricing: Calculation Tool
KNUMH ID of a Condition Record PRCT_COND_REC_GUID RAW 16 0
KBETR Condition Rate PRCT_COND_RATE CURR 15 2
KPEIN Condition Pricing Unit PRCT_COND_PRICING_UNIT DEC 5 0
KMEIN Condition Unit PRCT_COND_UOM UNIT 3 0
KUMZA Counter for Conversion to Base Unit of Measure PRCT_NUMERATOR INT4 10 0
KUMNE Denominator for Conversion to Base Unit of Measure PRCT_DENOMINATOR INT4 10 0
EXPNT Base 10 Exponent for Conversion to the Base Unit of Measure PRCT_CONV_COND_EXP INT2 5 0
MWSK1 Sales Tax Code PRCT_SALES_TAX_CODE CHAR 2 0
MWSK2 Withholding Tax Code PRCT_WITHHOLDING_TAX CHAR 2 0
KONMS Condition Scale Unit of Measure PRCT_COND_SCALE_UOM UNIT 3 0
KONWS Currency Key: Condition Scale PRCT_COND_SCALE_CURR CUKY 5 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
STUNB From Reference Step (for Percentage Conditions) PRCT_PP_STEP_FROM NUMC 3 0
STUN2 To Reference Step (for Percentage Conditions) PRCT_PP_STEP_TO NUMC 3 0
KZWIW Condition Subtotal PRCT_PP_SUBTOTAL CHAR 1 0
NULL No separate sub-totals
1 Carry over value to KOMP-KZWI1
2 Carry over value to KOMP-KZWI2
3 Carry over value to KOMP-KZWI3
4 Carry over value to KOMP-KZWI4
5 Carry over value to KOMP-KZWI5
6 Carry over value to KOMP-KZWI6
7 Carry over value to KOMP_BONBA (rebate basis 1)
8 Copy values according to KOMP-PREVA (preference value)
9 Copy values to KOMP-BRTWR (gross value)
A Carry over price to KOMP-CMPRE (credit price)
B Carry over value to KOMP-WAVWR (cost)
C Carry over value to KOMP-GKWRT (statistical value)
D Copy value to XWORKD
E Copy value to XWORKE
F Copy value to XWORKF
G Copy value to XWORKG
H Copy value to XWORKH
I Wertübernahme nach XWORKI
J Copy value to XWORKJ
K Copy price to XWORKK
L Copy price to XWORKL
M Copy price to XWORKM
Q Reserved (IS-OIL)
S Copy values to KOMP-EFFWR (effective value)
Y Reserved (IS-OIL)
Z Reserved (IS-OIL)
KOFRM Condition Value Formula PRCT_FRM_VALUE CHAR 20 0
KOFRM_NUM Condition Value Formula IPC PRCT_FRM_VALUE_NUM NUMC 7 0
KOFRA Condition Formula for Condition Basis PRCT_FRM_BASIS CHAR 20 0
KOFRA_NUM Condition Base Formula IPC PRCT_FRM_BASIS_NUM NUMC 7 0
KOBED Pricing Condition PRCT_FRM_REQUIREMENT CHAR 20 0
KOBED_NUM IPC Requirement PRCT_FRM_REQUIREMENT_NUM NUMC 7 0
DRUKZ Print Flag PRCT_PRINT_INDICATOR CHAR 1 0
NULL It was not printed
X Printing at item level (previous procedure)
S Printing at totals level (previous procedure)
A Total: General
B Total: if value <> zero
C Total: if value <> previous value
D Total: if value <> zero and value <> previous value
a at item: General
b at item: if value <> zero
c at item: if value <> previous value
d at item: if value <> zero and value <> previous value
KOBLI Condition is Mandatory PRCT_FLAG_COND_OBLIGATORY CHAR 1 0
X Yes
NULL No
KAUTO Manual Condition PRCT_FLAG_COND_MANUAL CHAR 1 0
X Yes
NULL No
AUTHORITY_LEVEL Level for Authorization Checks PRCT_AUTHORITY_LEVEL NUMC 4 0
MANDATORY_TYPE Behaviour of Mandatory Conditions PRCT_MANDATORY_TYPE CHAR 1 0
NULL Error
A Warning
KMANU Give Way Rule for Manual Entries (KMANU) PRCT_COND_MAN_PRIORITY CHAR 1 0
NULL No restrictions
B Automatic entry has priority
C Manual entry has priority
D Not possible to process manually
GANZZ Indicator: Currency Conversion after Multiplication PRCT_FLAG_CURR_CONV_LAST CHAR 1 0
X Yes
NULL No
KOFRS Scale Basis Formula PRCT_FRM_SCALE_BASIS CHAR 20 0
KOFRS_NUM Scale Basis Formula IPC PRCT_FRM_SCALE_BASIS_NUM NUMC 7 0
KNEGA Plus/Minus Sign of the Condition Amount PRCT_COND_SIGN CHAR 1 0
NULL Positive and negative
X Negative
A Positive
TXPRF Rounding Rule PRCT_ROUNDING_RULE CHAR 1 0
NULL Commercial
A Round up
B Round down
KAEND_BTR Condition Rate of Change for Amount/Percentage PRCT_FLAG_EDIT_RATE CHAR 1 0
X Yes
NULL No
KAEND_WRT Scope for Changing the Value PRCT_FLAG_EDIT_VALUE CHAR 1 0
X Yes
NULL No
KAEND_UFK Scope for Changing Conversion Factors PRCT_FLAG_EDIT_CONV CHAR 1 0
X Yes
NULL No
KAEND_RCH Condition Rate of Change for Calculation Type PRCT_FLAG_EDIT_RULE CHAR 1 0
X Yes
NULL No
KAEND_LOE Delete the Scope for Changing Rate PRCT_FLAG_EDIT_DELE CHAR 1 0
X Yes
NULL No
KAEND_MEH Condition Scope of Change for Unit of Measure PRCT_FLAG_EDIT_UNIT CHAR 1 0
X Yes
NULL No
BERGL Calculation Base PRCT_CALCULATION_BASE CHAR 1 0
RDIFA Rounding Difference Clearing PRCT_ROUNDING_COMPARISON CHAR 1 0
X Yes
NULL No
KMENG Quantity Conversion PRCT_FLAG_UNIT_CONVERSION CHAR 1 0
X Yes
NULL No
KKOPF Flag 'Condition is Condition' PRCT_FLAG_HEAD_COND CHAR 1 0
X Yes
NULL No
KPOSI Condition is Item Condition PRCT_FLAG_ITEM_COND CHAR 1 0
X Yes
NULL No
PURP Condition Function PRCT_COND_PURPOSE CHAR 4 0
USE_HOLIDAYS exclude holidays for time-dependent conditions PRCT_USE_HOLIDAYS CHAR 1 0
X Yes
NULL No
GRLNR Group Key Routine PRCT_FRM_GROUP_KEY CHAR 20 0
GRLNR_NUM Group Key Routine IPC PRCT_FRM_GROUP_KEY_NUM NUMC 7 0
GRMEN Condition Scale Unit of Measure PRCT_COND_SCALE_UOM UNIT 3 0
KSTPR Checking Rule for Scale Rates PRCT_RATE_CHECK_RULE CHAR 1 0
NULL None
A Descending
B Ascending
IDXUP Update Condition Index PRCT_FLAG_INDEX_UPDATE CHAR 1 0
X Yes
NULL No
KPRDT Pricing Date (KPRDT) PRCT_FLAG_PRICING_DATE CHAR 1 0
NULL Standard (KOMK-PRSDT; tax and rebate KOMK-FBUDA)
A Date of services rendered (KOMK-FBUDA)
B Price date (KOMK-PRSDT)
C Billing date (KOMK-FKDAT)
D Creation date (KOMK-ERDAT)
E Order date (KOMK-AUDAT)
PRECH Period Condition Calculation Type PRCT_CALCULATION_TYPE_PERIODS CHAR 3 0
KFRST Release Status PRCT_RELEASE_STATUS CHAR 1 0
NULL Released
A Locked
B Released for Price Simulation
C Released for Planning and Price Simulation
D Contains Errors
a Deleted (Was Blocked)
b Deleted (Released for Price Simulation)
c Deleted (Was Released for Planning and Price Simulation)
d Deleted (Was Incorrect)
x Deleted (Was Released)
KDELE Condition Records Should be Deleted from the Database PRCT_FLAG_DELETION CHAR 1 0
NULL Do not delete (set the deletion flag only)
A with popup
B without popup
UPDKZ Operation Category (INSERT, UPDATE, DELETE) PRCT_OPERATION_TYPE CHAR 1 0
D Delete
I Insert
U Change
VTEXT Description of condition PRCT_PRINT_COND_TEXT CHAR 40 0
FIX_RATE Pricing: Fixation Type for Condition Amount PRCT_FIX_RATE CHAR 1 0
NULL Do not fix condition amount
A Suppress condition record and scale determination
KOTABNR Condition Table /SAPCND/COND_TABLE_ID CHAR 8 0
KONWA Condition Currency PRCT_COND_CURR CUKY 5 0
KSTBM Scale Limit PRCT_COND_SCALE_LEVEL DEC 18 5
MEINS Base Unit of Measure for a Product PRCT_BASE_UOM UNIT 3 0
KSTBM_NEXT Scale Limit PRCT_COND_SCALE_LEVEL DEC 18 5
DUMMY1 Dummy function in length 1 DUMMY CHAR 1 0

PRCT_COND_WRK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PRCT_COND_WRK KRECH SYST MANDT PRCC_CTYPE_DEF Calculation Types in Pricing MANDT
PRCT_COND_WRK KRECH PRCT_COND_WRK KRECH PRCC_CTYPE_DEF Calculation Types in Pricing CTYPE
PRCT_COND_WRK KVEWE PRCT_COND_WRK KVEWE /SAPCND/T681V Condition Technique - Usage .INCLUDE