1. Home
  2. Resources
  3. SAP Tables
  4. TDS_COND_COM - Lean Order - Condition Data

SAP Table TDS_COND_COM

Lean Order - Condition Data

TDS_COND_COM (Lean Order - Condition 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 TDS_COND_COM to other SAP tables.

Source: TDS_COND_COM (Lean Order - Condition Data)

TDS_COND_COM table fields

Field Data element Checktable Datatype Length Decimals
HANDLE GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
KSCHL Condition type KSCHA CHAR 4 0
COUNT Counter COUNT NUMC 3 0
KBETR_INT Rate (condition amount or percentage) KBETR CURR 11 2
KBETR_EXT Field of length 16 CHAR16 CHAR 16 0
KOEIN Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KOEIN_INT Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit in the document KVMEI T006 UNIT 3 0
KWERT_INT Condition value KWERT CURR 13 2
KWERT_EXT Field length 18 CHAR18 CHAR 18 0
WAERK SD Document Currency WAERK TCURC CUKY 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
MEINS Base Unit of Measure MEINS UNIT 3 0
KMEI1 Condition unit KMEIN UNIT 3 0
KINAK Condition is inactive KINAK CHAR 1 0
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 formulae of incorrect
Y Inactive because of subsequent price
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
HANDLE_I GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
KSCHL_I Single-Character Indicator CHAR1 CHAR 1 0
COUNT_I Single-Character Indicator CHAR1 CHAR 1 0
KBETR_INT_I Single-Character Indicator CHAR1 CHAR 1 0
KBETR_EXT_I Single-Character Indicator CHAR1 CHAR 1 0
KOEIN_I Single-Character Indicator CHAR1 CHAR 1 0
KOEIN_INT_I Single-Character Indicator CHAR1 CHAR 1 0
KPEIN_I Single-Character Indicator CHAR1 CHAR 1 0
KMEIN_I Single-Character Indicator CHAR1 CHAR 1 0
KWERT_INT_I Single-Character Indicator CHAR1 CHAR 1 0
KWERT_EXT_I Single-Character Indicator CHAR1 CHAR 1 0
WAERK_I Single-Character Indicator CHAR1 CHAR 1 0
KUMZA_I Single-Character Indicator CHAR1 CHAR 1 0
KUMNE_I Single-Character Indicator CHAR1 CHAR 1 0
MEINS_I Single-Character Indicator CHAR1 CHAR 1 0
KMEI1_I Single-Character Indicator CHAR1 CHAR 1 0
KINAK_I Single-Character Indicator CHAR1 CHAR 1 0
SELKZ_I Single-Character Indicator CHAR1 CHAR 1 0
HANDLE_R GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
KSCHL_T_R Description BEZEI20 CHAR 20 0
KINAK_T_R Description of rule BEZEI60 CHAR 60 0
KRECH_R_R 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)
KRECH_T_R Description BEZEI30 CHAR 30 0
KNTYP_R_R 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
KNTYP_T_R Description BEZEI30 CHAR 30 0
KSTEU_R_R Condition control KSTEU 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)
I Scale Base Value and Condition Amount Fixed (for BYD only)
KSTEU_T_R Description BEZEI30 CHAR 30 0
KHERK_R_R Origin of the condition KHERK 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
KHERK_T_R Description BEZEI30 CHAR 30 0
KZBZG_R_R 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)
KZBZG_T_R Description BEZEI30 CHAR 30 0
KOAID_R_R Condition class KOAID CHAR 1 0
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
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KOAID_T_R Explanatory short text DDTEXT CHAR 60 0
KMPRS_R Condition changed manually KMPRS CHAR 1 0
X Yes
NULL No
KNUMA_BO_R Agreement (various conditions grouped together) KNUMA CHAR 10 0
KDATU_R Condition pricing date KDATU DATS 8 0
KSTAT_R Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
KWERT_K_R Condition value KWERT CURR 13 2
KWAEH_R Condition currency (for cumulation fields) KWAEH CUKY 5 0
AWEI1_R Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
AWEIN_R Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KAWRT_R Condition base value KAWRT CURR 15 2

TDS_COND_COM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TDS_COND_COM KMEIN SYST MANDT T006 Units of Measurement MANDT
TDS_COND_COM KMEIN TDS_COND_COM KMEIN T006 Units of Measurement MSEHI
TDS_COND_COM WAERK SYST MANDT TCURC Currency Codes MANDT
TDS_COND_COM WAERK TDS_COND_COM WAERK TCURC Currency Codes WAERS