1. Home
  2. Resources
  3. SAP Tables
  4. KOND - Conditions (Data)

SAP Table KOND

Conditions (Data)

KOND (Conditions (Data)) 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 KOND to other SAP tables.

KOND table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KNUMD Condition record number KNUMD CHAR 10 0
ZUSKO Number of additional condition DZUSKO NUMC 2 0
KSCHL Condition Type KSCHL CHAR 4 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
KNUMB Rebate data number KNUMB CHAR 10 0
KNUMK Account assignment number KNUMK CHAR 10 0
KNUMT Number of texts KNUMT CHAR 10 0
KNUMS Number of scale values KNUMS CHAR 10 0
KNUM1 Number of the line scale (scaling) KNUM1 CHAR 10 0
STFKZ Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KZBZG Scale basis indicator KZBZG CHAR 1 0
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)
KONBE Scale basis (unit of measure) KONBE CHAR 5 0
KNUM2 Number of column scale KNUM2 CHAR 10 0
STFK2 Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KZBZ2 Scale basis indicator KZBZG CHAR 1 0
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)
KONB2 Scale basis (unit of measure) KONBE CHAR 5 0
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
KONWA Rate unit (currency or percentage) KONWA CUKY 5 0
KMEIN Condition unit KMEIN UNIT 3 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KUMZA Numerator for converting condition units to base units KUMZA DEC 5 0
KUMNE Denominator for converting condition units to base units KUMNE DEC 5 0
KWAEH Condition currency (for cumulation fields) KWAEH CUKY 5 0
KSKTO Condition is qualifying for cash discount KSKTO CHAR 1 0
X Yes
NULL No
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ 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
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
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 Input Tax not Deductible
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
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
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KMWST Condition VAT indicator KMWST CHAR 2 0
KSTAT Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
KNPRS Pricing type KNPRS CHAR 1 0
A Copy price components and redetermine scales
B Carry out new pricing
C Copy manual pricing elements and redetermine the others
D Copy pricing elements unchanged
E Adopt price components and fix values
F Copy pricing elements, turn value and fix
G Copy pricing elements unchanged and redetermine taxes
H Redetermine freight conditions
I Redetermine rebate conditions
J Redetermine confirmed purch. net price / value (KNTYP=d)
K Adopt price components and cose. Redetermine taxes.
M Copy pricing elements, turn value
N Transfer pricing components unchanged, new cost
O Redetermine variant conditions (KNTYP=O)
Q Redetermine calculation conditions (KNTYP=Q)
R Apply Price Parts and Bonus Conditions
U Redetermine precious metal conditions (KNTYP=U)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
1 Customer reserve 1
2 Customer reserve 2
3 Customer reserve 3
4 Customer reserve 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
S Ship & Debit (IBU HiTec)
KRUEK Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
KRELI Condition for invoice list KRELI CHAR 1 0
KMANU Making manual entries KMANU CHAR 1 0
NULL No limitations
A Free
B Automatic entry has priority
C Manual entry has priority
D Not possible to process manually
KGRPE Group condition KGRPE CHAR 1 0
X Group condition
NULL
KAUFT Absolute condition is to be split up KAUFT CHAR 1 0
MXWRT Lower limit of the condition rate/amount MXWRT CURR 11 2
GKWRT Upper limit for the condition rate GKWRT CURR 11 2
PKWRT Planned condition value PKWRT CURR 15 2
FKWRT Cumulative guaranteed discount (not used) FKWRT CURR 15 2
RSWRT Accumulated accruals values (not used) RSWRT CURR 15 2
UKBAS Planned condition basis UKBAS CURR 15 2
PRBAS Price basis PRBAS CURR 11 2
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KONKZ Account assignment allowed KONKZ CHAR 1 0
KZNEP Condition exclusion indicator KZNEP CHAR 1 0
KOUPD Condition update KOUPD CHAR 1 0
X Yes
NULL No
STBAS Accumulated scale base (from settlement run) STBAS CURR 15 2
KOBAS Cumulative condition basis (from settlement run) KOBAS CURR 15 2
GRUMS Minimum business volume GRUMS CURR 15 2
MAXRA Maximum discount from total sales volume MAXRA CURR 11 2
AUBET Payment amount AUBET CURR 11 2
ABRBG Start of accounting settlement period ABRBG DATS 8 0
ABREN End of accounting settlement period ABREN DATS 8 0
KWRTA Payment amount KWRTA CURR 11 2
KWRTR Accrual Amount KWRTR CURR 11 2
KVSL1 Account key KVSL1 CHAR 3 0
KVSL2 Account key - accruals / provisions KVSL2 CHAR 3 0
KSTBS Scale base value of the condition KSTBS CURR 15 2
KBETR Rate (condition amount or percentage) where no scale exists KBETR_KOND CURR 11 2