SAP Table TCK05

Valuation Variants in Costing

TCK05 (Valuation Variants in Costing) 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 TCK05 to other SAP tables.

TCK05 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BWVAR Valuation Variant in Costing CK_BWVAR CHAR 3 0
BWSM1 Valuation Strategy for Material Component CK_BWSMA CHAR 1 0
1 Standard Price in Previous Period
2 Standard Price
3 Moving Average Price
4 Planned Price 1
5 Planned Price 2
6 Planned Price 3
7 Valuation Price According to Price Control in Mat. Master
8 Valuation with Additive Cost Component Split
9 Future Standard Price
A Valuation Price 1 Based On Tax Law
B Valuation Price 1 Based On Commercial Law
C Valuation Price 2 Based On Tax Law
D Valuation Price 2 Based On Commercial Law
E Valuation Price 3 Based On Tax Law (Reserved)
F Valuation Price 3 Based On Commercial Law (Reserved)
G Future Price from Accounting
H Planned Price Whose Date Is Closest to the Valuation Date
I Current Planned Price
J Time-Based Valuation Price According to Price Control
K Price from Preliminary Order Cost Est (Goods Receipts Only)
L Price from Purchasing Info Record
U Valuation Price with User Exit
Z Price from Last Valid Alternative Valuation Run
Q Price from Price Table
BWSM2 Valuation Strategy for Material Component CK_BWSMA CHAR 1 0
1 Standard Price in Previous Period
2 Standard Price
3 Moving Average Price
4 Planned Price 1
5 Planned Price 2
6 Planned Price 3
7 Valuation Price According to Price Control in Mat. Master
8 Valuation with Additive Cost Component Split
9 Future Standard Price
A Valuation Price 1 Based On Tax Law
B Valuation Price 1 Based On Commercial Law
C Valuation Price 2 Based On Tax Law
D Valuation Price 2 Based On Commercial Law
E Valuation Price 3 Based On Tax Law (Reserved)
F Valuation Price 3 Based On Commercial Law (Reserved)
G Future Price from Accounting
H Planned Price Whose Date Is Closest to the Valuation Date
I Current Planned Price
J Time-Based Valuation Price According to Price Control
K Price from Preliminary Order Cost Est (Goods Receipts Only)
L Price from Purchasing Info Record
U Valuation Price with User Exit
Z Price from Last Valid Alternative Valuation Run
Q Price from Price Table
BWSM3 Valuation Strategy for Material Component CK_BWSMA CHAR 1 0
1 Standard Price in Previous Period
2 Standard Price
3 Moving Average Price
4 Planned Price 1
5 Planned Price 2
6 Planned Price 3
7 Valuation Price According to Price Control in Mat. Master
8 Valuation with Additive Cost Component Split
9 Future Standard Price
A Valuation Price 1 Based On Tax Law
B Valuation Price 1 Based On Commercial Law
C Valuation Price 2 Based On Tax Law
D Valuation Price 2 Based On Commercial Law
E Valuation Price 3 Based On Tax Law (Reserved)
F Valuation Price 3 Based On Commercial Law (Reserved)
G Future Price from Accounting
H Planned Price Whose Date Is Closest to the Valuation Date
I Current Planned Price
J Time-Based Valuation Price According to Price Control
K Price from Preliminary Order Cost Est (Goods Receipts Only)
L Price from Purchasing Info Record
U Valuation Price with User Exit
Z Price from Last Valid Alternative Valuation Run
Q Price from Price Table
BWSM4 Valuation Strategy for Material Component CK_BWSMA CHAR 1 0
1 Standard Price in Previous Period
2 Standard Price
3 Moving Average Price
4 Planned Price 1
5 Planned Price 2
6 Planned Price 3
7 Valuation Price According to Price Control in Mat. Master
8 Valuation with Additive Cost Component Split
9 Future Standard Price
A Valuation Price 1 Based On Tax Law
B Valuation Price 1 Based On Commercial Law
C Valuation Price 2 Based On Tax Law
D Valuation Price 2 Based On Commercial Law
E Valuation Price 3 Based On Tax Law (Reserved)
F Valuation Price 3 Based On Commercial Law (Reserved)
G Future Price from Accounting
H Planned Price Whose Date Is Closest to the Valuation Date
I Current Planned Price
J Time-Based Valuation Price According to Price Control
K Price from Preliminary Order Cost Est (Goods Receipts Only)
L Price from Purchasing Info Record
U Valuation Price with User Exit
Z Price from Last Valid Alternative Valuation Run
Q Price from Price Table
BWSM5 Valuation Strategy for Material Component CK_BWSMA CHAR 1 0
1 Standard Price in Previous Period
2 Standard Price
3 Moving Average Price
4 Planned Price 1
5 Planned Price 2
6 Planned Price 3
7 Valuation Price According to Price Control in Mat. Master
8 Valuation with Additive Cost Component Split
9 Future Standard Price
A Valuation Price 1 Based On Tax Law
B Valuation Price 1 Based On Commercial Law
C Valuation Price 2 Based On Tax Law
D Valuation Price 2 Based On Commercial Law
E Valuation Price 3 Based On Tax Law (Reserved)
F Valuation Price 3 Based On Commercial Law (Reserved)
G Future Price from Accounting
H Planned Price Whose Date Is Closest to the Valuation Date
I Current Planned Price
J Time-Based Valuation Price According to Price Control
K Price from Preliminary Order Cost Est (Goods Receipts Only)
L Price from Purchasing Info Record
U Valuation Price with User Exit
Z Price from Last Valid Alternative Valuation Run
Q Price from Price Table
BWSE1 Valuation Strategy for Internal Activities and Processes CK_BWSEL CHAR 1 0
1 Plan Price for the Period
2 Plan Price as Average of All Fiscal Year Periods
3 Plan Price as Average of Remaining Periods of Fiscal Year
4 Actual Price of Previous Period
5 Most Up-to-Date Actual Price in the Past
6 Most Up-to-Date Plan Price
7 Actual Price for the Period
BWSE2 Valuation Strategy for Internal Activities and Processes CK_BWSEL CHAR 1 0
1 Plan Price for the Period
2 Plan Price as Average of All Fiscal Year Periods
3 Plan Price as Average of Remaining Periods of Fiscal Year
4 Actual Price of Previous Period
5 Most Up-to-Date Actual Price in the Past
6 Most Up-to-Date Plan Price
7 Actual Price for the Period
BWSE3 Valuation Strategy for Internal Activities and Processes CK_BWSEL CHAR 1 0
1 Plan Price for the Period
2 Plan Price as Average of All Fiscal Year Periods
3 Plan Price as Average of Remaining Periods of Fiscal Year
4 Actual Price of Previous Period
5 Most Up-to-Date Actual Price in the Past
6 Most Up-to-Date Plan Price
7 Actual Price for the Period
MATSUBSTRAT1 Substrategy for Material Valuat. with Purchasing Info Record CK_SUBSTRAT CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
A Quotation Price via Condition Table
B Purchase Order Price via Condition Table
MATSUBSTRAT2 Substrategy for Material Valuat. with Purchasing Info Record CK_SUBSTRAT CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
A Quotation Price via Condition Table
B Purchase Order Price via Condition Table
MATSUBSTRAT3 Substrategy for Material Valuat. with Purchasing Info Record CK_SUBSTRAT CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
A Quotation Price via Condition Table
B Purchase Order Price via Condition Table
BWMA1 Material Valuation Including Additive Costs CK_BWMAN CHAR 1 0
X Manual Cost Component Splits Are Added Together
BWMA2 Material Valuation Including Additive Costs CK_BWMAN CHAR 1 0
X Manual Cost Component Splits Are Added Together
BWMA3 Material Valuation Including Additive Costs CK_BWMAN CHAR 1 0
X Manual Cost Component Splits Are Added Together
BWMA4 Material Valuation Including Additive Costs CK_BWMAN CHAR 1 0
X Manual Cost Component Splits Are Added Together
BWMA5 Material Valuation Including Additive Costs CK_BWMAN CHAR 1 0
X Manual Cost Component Splits Are Added Together
BWSF1 Valuation Strategy for Subcontracting CK_BWSFL CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSF2 Valuation Strategy for Subcontracting CK_BWSFL CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSF3 Valuation Strategy for Subcontracting CK_BWSFL CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSV1 Valuation Strategy for External Processing in Operation CK_BWSVW CHAR 1 0
1 Price from Operation
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSV2 Valuation Strategy for External Processing in Operation CK_BWSVW CHAR 1 0
1 Price from Operation
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSV3 Valuation Strategy for External Processing in Operation CK_BWSVW CHAR 1 0
1 Price from Operation
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
BWSFH Valuation Strategy for Production Resources and Tools CK_BWSFH CHAR 1 0
1 Current Cost Rate for Production Resources and Tools
KALSM Costing Sheet for Calculating Overhead CK_KALSM T683 CHAR 6 0
KALSM_RAW Costing Sheet for Applying Overhead to Raw Materials CK_KALSM_RAW T683 CHAR 6 0
ZUART Overhead type AUFZA CHAR 1 0
1 Actual overhead rate
2 Planned overhead rate
3 Commitment overhead rate
PLISQUT Plan/Actual Quota Arrangement for Subcontracting CK_PLISQUT CHAR 1 0
NULL Actual Quota Arrangement
X Planned Quota Arrangement
LOBEZUS Overhead on Subcontracted Materials CK_LOBEZUS CHAR 1 0
X Yes
NULL No
PERTARIF Scheduled Activity Price Calculation CK_PERTARI CHAR 1 0
X Yes
NULL No
VERSN Version VERSN TKA09 CHAR 3 0
CON_FIN_MPL1 Price Type CK_PRICELABEL CHAR 3 0
CON_FIN_MPL2 Price Type CK_PRICELABEL CHAR 3 0
CON_FIN_MPL3 Price Type CK_PRICELABEL CHAR 3 0
CON_FIN_MPL4 Price Type CK_PRICELABEL CHAR 3 0
CON_FIN_MPL5 Price Type CK_PRICELABEL CHAR 3 0

TCK05 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCK05 KALSM TCK05 KALSM T683 Pricing procedures KALSM
TCK05 KALSM SY MANDT T683 Pricing procedures MANDT
TCK05 KALSM 'A' T683 Pricing procedures KVEWE
TCK05 KALSM 'KA' T683 Pricing procedures KAPPL
TCK05 KALSM_RAW SY MANDT T683 Pricing procedures MANDT
TCK05 KALSM_RAW 'A' T683 Pricing procedures KVEWE
TCK05 KALSM_RAW 'KA' T683 Pricing procedures KAPPL
TCK05 KALSM_RAW TCK05 KALSM_RAW T683 Pricing procedures KALSM
TCK05 VERSN TCK05 MANDT TKA09 Basic Settings for Versions MANDT
TCK05 VERSN * TKA09 Basic Settings for Versions KOKRS
TCK05 VERSN TCK05 VERSN TKA09 Basic Settings for Versions VERSN