SAP Table SACO

Sales price calculation: validity periods of SP conditions

SACO (Sales price calculation: validity periods of SP conditions) 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 SACO to other SAP tables.

SACO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KSCHL Condition type KSCHA T685 CHAR 4 0
DATAB Start of a Time Interval with the Same Sales Conditions W_SACO_DATAB DATS 8 0
DATBI End of a Time Interval with the Same Sales Conditions W_SACO_DATBI DATS 8 0
DATAB_KOND Validity start date of the condition record KODATAB DATS 8 0
KVEWE Usage of the condition table KVEWE T681V CHAR 1 0
KAPPL Application KAPPL T681A CHAR 2 0
KOTABNR Condition table KOTABNR NUMC 3 0
KRECH 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)
KAWRT Condition base value KAWRT CURR 15 2
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
WAERS Currency Key WAERS TCURC CUKY 5 0
KKURS Condition exchange rate for conversion to local currency KKURS DEC 9 5
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit in the document KVMEI T006 UNIT 3 0
KNTYP 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
KNUMH Condition record number KNUMH CHAR 10 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
KZBZG 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)
KONMS Condition scale unit of measure KONMS T006 UNIT 3 0
KONWS Scale currency KONWS TCURC CUKY 5 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
CHGFL Checkbox XFELD CHAR 1 0
X Yes
NULL No

SACO foreign key relationships

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