SAP table WISO_COND (SAP Retail Store: Sales Order Condition Data)

Field Description Data Type Length Decimals Checktable Data Element
ITM_NUMBER Condition item number NUMC 6 0 KPOSN
COND_ST_NO Step Number NUMC 3 0 T683S STUNR
COND_COUNT Condition counter (short length) NUMC 2 0 DZAEHK_SHORT
COND_TYPE Condition Type CHAR 4 0 T685 KSCHA
COND_VALUE Condition Amount DEC 28 9 BAPIKBETR1
CURRENCY Currency Key CUKY 5 0 TCURC WAERS
COND_UNIT Condition Unit UNIT 3 0 T006 KMEIN
COND_P_UNT Condition Pricing Unit DEC 5 0 KPEIN
CURR_ISO ISO code currency CHAR 3 0 WAERS_ISO
CD_UNT_ISO Condition unit of measure in UoM CHAR 3 0 T006I KVMEI_ISO
REFOBJTYPE Object Type CHAR 10 0 TOJTB SWO_OBJTYP
REFOBJKEY Object key CHAR 70 0 SWO_TYPEID
REFLOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
APPLICATIO Application CHAR 2 0 T681A KAPPL
CONPRICDAT Condition Pricing Date DATS 8 0 KDATU
CALCTYPCON 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)
CONBASEVAL Condition base value DEC 28 9 BAPIKAWRT1
CONEXCHRAT Condition exchange rate for conversion to local currency DEC 9 5 KKURS
NUMCONVERT Numerator for converting condition units to base units DEC 5 0 KUMZA
DENOMINATO Denominator for converting condition units to base units DEC 5 0 KUMNE
CONDTYPE 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
STAT_CON Condition is used for statistics CHAR 1 0 KSTAT
SCALETYPE Scale Type CHAR 1 0 STFKZ
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) CHAR 1 0 KRUEK
CONINVOLST Condition for Invoice List CHAR 1 0 KRELI
No
X Yes
CONDORIGIN 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
GROUPCOND Group Condition CHAR 1 0 KGRPE
X Group condition
COND_UPDAT Condition Update CHAR 1 0 KOUPD
ACCESS_SEQ Access sequence - Access number (short length) NUMC 2 0 * KOLNR_SHORT
CONDCOUNT Sequential number of the condition NUMC 2 0 KOPOS
ROUNDOFFDI Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
CONDVALUE Condition value DEC 28 9 BAPIKWERT1
CURRENCY_2 SD Document Currency CUKY 5 0 TCURC WAERK
CURR_ISO_2 ISO code currency CHAR 3 0 WAERS_ISO
CONDCNTRL 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)
CONDISACTI 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
CONDCLASS 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
FACTBASVAL Factor for Condition Base Value FLTP 16 16 KFAKTOR
SCALEBASIN 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)
SCALBASVAL Scale base value of the condition DEC 28 9 BAPIKSTBS1
UNITMEASUR Condition Scale Unit of Measure UNIT 3 0 T006 KONMS
ISO_UNIT ISO code for unit of measurement CHAR 3 0 T006I ISOCD_UNIT
CURRENCKEY Scale Currency CUKY 5 0 TCURC KONWS
CURRENISO ISO code currency CHAR 3 0 WAERS_ISO
CONDINCOMP Condition for Intercompany Billing CHAR 1 0 KFKIV
CONDCONFIG Condition Used for Variant Configuration CHAR 1 0 KVARC
CONDCHAMAN Condition Changed Manually CHAR 1 0 KMPRS
COND_NO Number of the Condition Record CHAR 10 0 KNUMH
TAX_CODE Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
VARCOND Variant Condition Key CHAR 26 0 * VARCOND
ACCOUNTKEY Account Key CHAR 3 0 * KVSL1
ACCOUNT_KE Account Key - Accruals / Provisions CHAR 3 0 * KVSL2
WT_WITHCD Withholding Tax Code CHAR 2 0 * WT_WITHCD
STRUCTCOND Structure Condition CHAR 1 0 KDUPL
None
A Duplication Condition
B Cumulation condition
FACTCONBAS Factor for Condition Basis (Period) FLTP 16 16 KFAKTOR1
CONDCOINHD Condition counter for header conditions (short length) NUMC 2 0 DZAEKO_SHORT
ACCESS_SEQ_LONG Access sequence - Access number NUMC 3 0 T682I KOLNR
COND_COUNT_LONG Condition Counter NUMC 3 0 DZAEHK
CONDCOINHD_LONG Condition counter for (header conditions) NUMC 3 0 DZAEKO
TYPED_IN Checkbox CHAR 1 0 XFELD
No
X Yes
KBFLAG_CSO Bit encrypted flags in Pricing RAW 2 0 KBFLAG

WISO_COND foreign key relationships

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