- Home
- Resources
- SAP Tables
- SACO - Sales price calculation: validity periods of SP conditions
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.
Source: SACO (Sales price calculation: validity periods of SP conditions)
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 |
Possible values
| 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 |
Possible values
| $ |
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 |
Possible values
| 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 |
Possible values
|
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 |
KMEIN |
T006 |
Units of Measurement |
MSEHI |
| SACO |
KMEIN |
SACO |
MANDT |
T006 |
Units of Measurement |
MANDT |
| SACO |
KONMS |
SACO |
KONMS |
T006 |
Units of Measurement |
MSEHI |
| SACO |
KONMS |
SACO |
MANDT |
T006 |
Units of Measurement |
MANDT |
| SACO |
KONWS |
SACO |
MANDT |
TCURC |
Currency Codes |
MANDT |
| SACO |
KONWS |
SACO |
KONWS |
TCURC |
Currency Codes |
WAERS |
| SACO |
KSCHL |
SACO |
KVEWE |
T685 |
Conditions: Types |
KVEWE |
| SACO |
KSCHL |
SACO |
KSCHL |
T685 |
Conditions: Types |
KSCHL |
| SACO |
KSCHL |
SACO |
KAPPL |
T685 |
Conditions: Types |
KAPPL |
| SACO |
KSCHL |
SACO |
MANDT |
T685 |
Conditions: Types |
MANDT |
| SACO |
KVEWE |
SACO |
KVEWE |
T681V |
Conditions: Usages |
KVEWE |
| SACO |
MANDT |
SACO |
MANDT |
T000 |
Clients |
MANDT |
| SACO |
WAERS |
SACO |
WAERS |
TCURC |
Currency Codes |
WAERS |
| SACO |
WAERS |
SACO |
MANDT |
TCURC |
Currency Codes |
MANDT |
