SAP table TDS_COND_COM (Lean Order - Condition Data)

Field Description Data Type Length Decimals Checktable Data Element
HANDLE GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
KSCHL Condition Type CHAR 4 0 * KSCHA
COUNT Counter NUMC 3 0 COUNT
KBETR_INT Condition Amount or Percentage CURR 11 2 KBETR
KBETR_EXT Field of length 16 CHAR 16 0 CHAR16
KOEIN Condition Unit (Currency, Sales Unit, or %) CUKY 5 0 KOEIN
KOEIN_INT Condition Unit (Currency, Sales Unit, or %) CUKY 5 0 KOEIN
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit in the Document UNIT 3 0 T006 KVMEI
KWERT_INT Condition Value CURR 13 2 KWERT
KWERT_EXT Field length 18 CHAR 18 0 CHAR18
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
KUMZA Numerator for converting condition units to base units DEC 5 0 KUMZA
KUMNE Denominator for converting condition units to base units DEC 5 0 KUMNE
MEINS Base Unit of Measure UNIT 3 0 * MEINS
KMEI1 Condition Unit UNIT 3 0 * KMEIN
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
SELKZ Selection flag CHAR 1 0 SELKZ
Not selected
* Selected and processed
X Selected but not yet processed
HANDLE_I GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
KSCHL_I Single-Character Flag CHAR 1 0 CHAR1
COUNT_I Single-Character Flag CHAR 1 0 CHAR1
KBETR_INT_I Single-Character Flag CHAR 1 0 CHAR1
KBETR_EXT_I Single-Character Flag CHAR 1 0 CHAR1
KOEIN_I Single-Character Flag CHAR 1 0 CHAR1
KOEIN_INT_I Single-Character Flag CHAR 1 0 CHAR1
KPEIN_I Single-Character Flag CHAR 1 0 CHAR1
KMEIN_I Single-Character Flag CHAR 1 0 CHAR1
KWERT_INT_I Single-Character Flag CHAR 1 0 CHAR1
KWERT_EXT_I Single-Character Flag CHAR 1 0 CHAR1
WAERK_I Single-Character Flag CHAR 1 0 CHAR1
KUMZA_I Single-Character Flag CHAR 1 0 CHAR1
KUMNE_I Single-Character Flag CHAR 1 0 CHAR1
MEINS_I Single-Character Flag CHAR 1 0 CHAR1
KMEI1_I Single-Character Flag CHAR 1 0 CHAR1
KINAK_I Single-Character Flag CHAR 1 0 CHAR1
SELKZ_I Single-Character Flag CHAR 1 0 CHAR1
HANDLE_R GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
KSCHL_T_R Description CHAR 20 0 BEZEI20
KINAK_T_R Description of Rule CHAR 60 0 BEZEI60
KRECH_R_R Calculation Type for Condition CHAR 1 0 KRECH
A Percentage
B Fixed Amount
C Quantity
D Gross Weight
E Net Weight
F Volume
G Formula
H Percentage (in Hundreds)
I Percentage (Travel Costs)
J Per Mille
K Per Mille (in Thousands)
L Points
M Quantity - Monthly Price
N Quantity - Year 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)
V Quantity Adjustment
W Percentage (with 6 Decimal Places)
KRECH_T_R Description CHAR 30 0 BEZEI30
KNTYP_R_R 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
KNTYP_T_R Description CHAR 30 0 BEZEI30
KSTEU_R_R 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)
KSTEU_T_R Description CHAR 30 0 BEZEI30
KHERK_R_R 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
KHERK_T_R Description CHAR 30 0 BEZEI30
KZBZG_R_R Scale Base Type CHAR 1 0 KZBZG
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 CHAR 30 0 BEZEI30
KOAID_R_R 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
KOAID_T_R Explanatory Short Text CHAR 60 0 DDTEXT
KMPRS_R Condition Changed Manually CHAR 1 0 KMPRS
KNUMA_BO_R Agreement (various conditions grouped together) CHAR 10 0 KNUMA
KDATU_R Condition Pricing Date DATS 8 0 KDATU
KSTAT_R Condition is used for statistics CHAR 1 0 KSTAT
KWERT_K_R Condition Value CURR 13 2 KWERT
KWAEH_R Condition Currency (for Cumulation Fields) CUKY 5 0 * KWAEH
AWEI1_R Condition Unit (Currency, Sales Unit, or %) CUKY 5 0 KOEIN
AWEIN_R Condition Unit (Currency, Sales Unit, or %) CUKY 5 0 KOEIN
KAWRT_R Condition Basis CURR 15 2 KAWRT

TDS_COND_COM foreign key relationships

Table Field Check Table Check Field
0 TDS_COND_COM KMEIN T006 Units of Measurement MANDT
1 TDS_COND_COM WAERK TCURC Currency Codes MANDT
1 TDS_COND_COM WAERK TCURC Currency Codes WAERS