SAP Table S060

Model Structure for Info Structures with Initial VAKEY

S060 (Model Structure for Info Structures with Initial VAKEY) 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 S060 to other SAP tables.

S060 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SSOUR Statistic(s) origin SSOUR CHAR 4 0
VRSIO Version number in the information structure VRSIO CHAR 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
SPMON Period to analyze - month SPMON NUMC 6 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
SPWOC Period to analyze - week SPWOC NUMC 6 0
SPBUP Period to analyze - posting period SPBUP NUMC 6 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
VWDAT Pointer to administrative data VWDAT NUMC 10 0
STWAE Local Currency HWAER CUKY 5 0
KMEIN Condition unit in the document KVMEI T006 UNIT 3 0
AUWRT Rebate: Rebate payments in local currency MC_AUWRT CURR 19 2
RUWRT Rebate: Accrued value in local currency MC_RUWRT CURR 19 2
RRWRT Rebate: Accruals reversed on the basis of local currency MC_RRWRT CURR 19 2
KWERT_K Cumulative condition value (Cond.curr.) MC_KWERT_K CURR 19 2
KAWRT_K Cumulative condition base value (cond.curr.) MC_KAWRT_K CURR 19 2
KSTBS Cumulative scale base value MC_KSTBS CURR 19 2
KWAEH Condition currency (for cumulation fields) KWAEH CUKY 5 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
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)
AUWRT_K Rebate: Value of payments in condition currency MC_AUWRT_K CURR 19 2
RUWRT_K Rebate: Accruals value in condition currency MC_RUWRT_K CURR 19 2
RRWRT_K Rebate: Accruals reversed in condition currency MC_RRWRT_K CURR 19 2

S060 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S060 KMEIN MCKOMV MANDT T006 Units of Measurement MANDT
S060 KMEIN S060 KMEIN T006 Units of Measurement MSEHI
S060 KONMS S060 MANDT T006 Units of Measurement MANDT
S060 KONMS S060 KONMS T006 Units of Measurement MSEHI
S060 KONWS S060 KONWS TCURC Currency Codes WAERS
S060 KONWS S060 MANDT TCURC Currency Codes MANDT
S060 MANDT S060 MANDT T000 Clients MANDT
S060 PERIV S060 MANDT T009 Fiscal Year Variants MANDT
S060 PERIV S060 PERIV T009 Fiscal Year Variants PERIV