1. Home
  2. Resources
  3. SAP Tables
  4. WISO_COND - SAP Retail Store: Sales Order Condition Data

SAP Table WISO_COND

SAP Retail Store: Sales Order Condition Data

WISO_COND (SAP Retail Store: Sales 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 WISO_COND to other SAP tables.

WISO_COND table fields

Field Data element Checktable Datatype Length Decimals
ITM_NUMBER Condition item number KPOSN NUMC 6 0
COND_ST_NO Step number STUNR T683S NUMC 3 0
COND_COUNT Condition counter DZAEHK NUMC 2 0
COND_TYPE Condition type KSCHA T685 CHAR 4 0
COND_VALUE Condition rate BAPIKBETR1 DEC 28 9
CURRENCY Currency Key WAERS TCURC CUKY 5 0
COND_UNIT Condition unit KMEIN T006 UNIT 3 0
COND_P_UNT Condition pricing unit KPEIN DEC 5 0
CURR_ISO ISO code currency WAERS_ISO CHAR 3 0
CD_UNT_ISO Condition unit of measure in UoM KVMEI_ISO T006I CHAR 3 0
REFOBJTYPE Object Type SWO_OBJTYP TOJTB CHAR 10 0
REFOBJKEY Object key SWO_TYPEID CHAR 70 0
REFLOGSYS Logical system LOGSYS TBDLS CHAR 10 0
APPLICATIO Application KAPPL T681A CHAR 2 0
CONPRICDAT Condition pricing date KDATU DATS 8 0
CALCTYPCON 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)
CONBASEVAL Condition base value BAPIKAWRT1 DEC 28 9
CONEXCHRAT Condition exchange rate for conversion to local currency KKURS DEC 9 5
NUMCONVERT Numerator for converting condition units to base units KUMZA DEC 5 0
DENOMINATO Denominator for converting condition units to base units KUMNE DEC 5 0
CONDTYPE 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
STAT_CON Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
SCALETYPE 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
ACCRUALS Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
CONINVOLST Condition for invoice list KRELI CHAR 1 0
CONDORIGIN 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
GROUPCOND Group condition KGRPE CHAR 1 0
X Group condition
NULL
COND_UPDAT Condition update KOUPD CHAR 1 0
X Yes
NULL No
ACCESS_SEQ Access sequence - Access number KOLNR T682I NUMC 2 0
CONDCOUNT Sequential number of the condition KOPOS NUMC 2 0
ROUNDOFFDI Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
CONDVALUE Condition value BAPIKWERT1 DEC 28 9
CURRENCY_2 SD Document Currency WAERK TCURC CUKY 5 0
CURR_ISO_2 ISO code currency WAERS_ISO CHAR 3 0
CONDCNTRL 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)
CONDISACTI 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
CONDCLASS 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
FACTBASVAL Factor for condition base value KFAKTOR FLTP 16 16
SCALEBASIN 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)
SCALBASVAL Scale base value of the condition BAPIKSTBS1 DEC 28 9
UNITMEASUR Condition scale unit of measure KONMS T006 UNIT 3 0
ISO_UNIT ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
CURRENCKEY Scale currency KONWS TCURC CUKY 5 0
CURRENISO ISO code currency WAERS_ISO CHAR 3 0
CONDINCOMP Condition for inter-company billing KFKIV CHAR 1 0
X Yes
NULL No
CONDCONFIG Condition for configuration KVARC CHAR 1 0
X Yes
NULL No
CONDCHAMAN Condition changed manually KMPRS CHAR 1 0
X Yes
NULL No
COND_NO Condition record number KNUMH CHAR 10 0
TAX_CODE Tax on sales/purchases code MWSKZ T007A CHAR 2 0
VARCOND Variant condition VARCOND CHAR 26 0
ACCOUNTKEY Account key KVSL1 CHAR 3 0
ACCOUNT_KE Account key - accruals / provisions KVSL2 CHAR 3 0
WT_WITHCD Withholding tax code WT_WITHCD CHAR 2 0
STRUCTCOND Structure condition KDUPL CHAR 1 0
NULL
A Condition to be duplicated
B Cumulation condition
FACTCONBAS Factor for condition basis (period) KFAKTOR1 FLTP 16 16
CONDCOINHD Condition counter for (header conditions) DZAEKO NUMC 2 0
TYPED_IN Checkbox XFELD CHAR 1 0
X Yes
NULL No
KBFLAG_CSO Bit encrypted flags in Pricing KBFLAG RAW 2 0

WISO_COND foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WISO_COND ACCESS_SEQ WISO_COND ACCESS_SEQ T682I Conditions: Access Sequences (Generated Form) KOLNR
WISO_COND ACCESS_SEQ * T682I Conditions: Access Sequences (Generated Form) KVEWE
WISO_COND ACCESS_SEQ WISO_COND APPLICATIO T682I Conditions: Access Sequences (Generated Form) KAPPL
WISO_COND ACCESS_SEQ * T682I Conditions: Access Sequences (Generated Form) KOZGF
WISO_COND APPLICATIO WISO_COND APPLICATIO T681A Conditions: Applications KAPPL
WISO_COND CD_UNT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
WISO_COND CD_UNT_ISO WISO_COND CD_UNT_ISO T006I ISO codes for units of measurement ISOCODE
WISO_COND COND_ST_NO WISO_COND COND_ST_NO T683S Pricing Procedure: Data STUNR
WISO_COND COND_ST_NO * T683S Pricing Procedure: Data ZAEHK
WISO_COND COND_ST_NO SYST MANDT T683S Pricing Procedure: Data MANDT
WISO_COND COND_ST_NO * T683S Pricing Procedure: Data KVEWE
WISO_COND COND_ST_NO * T683S Pricing Procedure: Data KAPPL
WISO_COND COND_ST_NO * T683S Pricing Procedure: Data KALSM
WISO_COND COND_TYPE SYST MANDT T685 Conditions: Types MANDT
WISO_COND COND_TYPE * T685 Conditions: Types KVEWE
WISO_COND COND_TYPE * T685 Conditions: Types KAPPL
WISO_COND COND_TYPE WISO_COND COND_TYPE T685 Conditions: Types KSCHL
WISO_COND COND_UNIT SYST MANDT T006 Units of Measurement MANDT
WISO_COND COND_UNIT WISO_COND COND_UNIT T006 Units of Measurement MSEHI
WISO_COND CURRENCKEY SYST MANDT TCURC Currency Codes MANDT
WISO_COND CURRENCKEY WISO_COND CURRENCKEY TCURC Currency Codes WAERS
WISO_COND CURRENCY SYST MANDT TCURC Currency Codes MANDT
WISO_COND CURRENCY WISO_COND CURRENCY TCURC Currency Codes WAERS
WISO_COND CURRENCY_2 SYST MANDT TCURC Currency Codes MANDT
WISO_COND CURRENCY_2 WISO_COND CURRENCY_2 TCURC Currency Codes WAERS
WISO_COND ISO_UNIT SYST MANDT T006I ISO codes for units of measurement CLIENT
WISO_COND ISO_UNIT WISO_COND ISO_UNIT T006I ISO codes for units of measurement ISOCODE
WISO_COND REFLOGSYS WISO_COND REFLOGSYS TBDLS Logical system LOGSYS
WISO_COND REFOBJTYPE WISO_COND REFOBJTYPE TOJTB Business object repository: Basic data NAME
WISO_COND TAX_CODE WISO_COND TAX_CODE T007A Tax Keys MWSKZ
WISO_COND TAX_CODE SYST MANDT T007A Tax Keys MANDT
WISO_COND TAX_CODE * T007A Tax Keys KALSM
WISO_COND UNITMEASUR SYST MANDT T006 Units of Measurement MANDT
WISO_COND UNITMEASUR WISO_COND UNITMEASUR T006 Units of Measurement MSEHI