SAP table SACO (Sales price calculation: validity periods of SP conditions)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KSCHL Condition Type CHAR 4 0 T685 KSCHA
DATAB Start of a Time Interval with the Same Sales Conditions DATS 8 0 W_SACO_DATAB
DATBI End of a Time Interval with the Same Sales Conditions DATS 8 0 W_SACO_DATBI
DATAB_KOND Validity start date of the condition record DATS 8 0 KODATAB
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KOTABNR Number of the Condition Table CHAR 3 0 * KOTABNR
KRECH 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)
KAWRT Condition Basis CURR 15 2 KAWRT
KBETR Condition Amount or Percentage CURR 11 2 KBETR
WAERS Currency Key CUKY 5 0 TCURC WAERS
KKURS Condition exchange rate for conversion to local currency DEC 9 5 KKURS
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit in the Document UNIT 3 0 T006 KVMEI
KNTYP 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
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
AKTNR Promotion CHAR 10 0 WAKH WAKTION
KZBZG 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)
KONMS Condition Scale Unit of Measure UNIT 3 0 T006 KONMS
KONWS Scale Currency CUKY 5 0 TCURC KONWS
LIFNR Account Number of Supplier CHAR 10 0 * LIFNR
CHGFL Checkbox CHAR 1 0 XFELD
No
X Yes

SACO foreign key relationships

Table Field Check Table Check Field
0 SACO AKTNR WAKH Promotion Header Data, IS-R MANDT
0 SACO AKTNR WAKH Promotion Header Data, IS-R AKTNR
1 SACO KAPPL T681A Conditions: Applications KAPPL
0 SACO KMEIN T006 Units of Measurement MANDT
1 SACO KONMS T006 Units of Measurement MANDT
0 SACO KONWS TCURC Currency Codes MANDT
0 SACO KONWS TCURC Currency Codes WAERS
1 SACO KSCHL T685 Conditions: Types KAPPL
1 SACO KSCHL T685 Conditions: Types KSCHL
0 SACO KVEWE T681V Conditions: Usages KVEWE
1 SACO WAERS TCURC Currency Codes MANDT
1 SACO WAERS TCURC Currency Codes WAERS