SAP table TCK05 (Valuation Variants in Costing)

SAP table TCK05 has 2 primary key fields being MANDT,BWVAR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BWVAR Valuation Variant in Costing CHAR 3 0 CK_BWVAR
BWSM1 Valuation Strategy for Material Component CHAR 1 0 CK_BWSMA
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
BWSM2 Valuation Strategy for Material Component CHAR 1 0 CK_BWSMA
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
BWSM3 Valuation Strategy for Material Component CHAR 1 0 CK_BWSMA
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
BWSM4 Valuation Strategy for Material Component CHAR 1 0 CK_BWSMA
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
BWSM5 Valuation Strategy for Material Component CHAR 1 0 CK_BWSMA
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
BWSE1 Valuation Strategy for Internal Activities and Processes CHAR 1 0 CK_BWSEL
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 CHAR 1 0 CK_BWSEL
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 CHAR 1 0 CK_BWSEL
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 CHAR 1 0 CK_SUBSTRAT
MATSUBSTRAT2 Substrategy for Material Valuat. with Purchasing Info Record CHAR 1 0 CK_SUBSTRAT
MATSUBSTRAT3 Substrategy for Material Valuat. with Purchasing Info Record CHAR 1 0 CK_SUBSTRAT
BWMA1 Material Valuation Including Additive Costs CHAR 1 0 CK_BWMAN
X Manual Cost Component Splits Are Added Together
BWMA2 Material Valuation Including Additive Costs CHAR 1 0 CK_BWMAN
X Manual Cost Component Splits Are Added Together
BWMA3 Material Valuation Including Additive Costs CHAR 1 0 CK_BWMAN
X Manual Cost Component Splits Are Added Together
BWMA4 Material Valuation Including Additive Costs CHAR 1 0 CK_BWMAN
X Manual Cost Component Splits Are Added Together
BWMA5 Material Valuation Including Additive Costs CHAR 1 0 CK_BWMAN
X Manual Cost Component Splits Are Added Together
BWSF1 Valuation Strategy for Subcontracting CHAR 1 0 CK_BWSFL
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 CHAR 1 0 CK_BWSFL
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 CHAR 1 0 CK_BWSFL
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 CHAR 1 0 CK_BWSVW
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 CHAR 1 0 CK_BWSVW
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 CHAR 1 0 CK_BWSVW
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 CHAR 1 0 CK_BWSFH
1 Current Cost Rate for Production Resources and Tools
KALSM Costing Sheet for Calculating Overhead CHAR 6 0 T683 CK_KALSM
KALSM_RAW Costing Sheet for Applying Overhead to Raw Materials CHAR 6 0 T683 CK_KALSM_RAW
ZUART Overhead Type CHAR 1 0 AUFZA
1 Actual overhead rate
2 Planned overhead rate
3 Commitment overhead rate
PLISQUT Plan/Actual Quota Arrangement for Subcontracting CHAR 1 0 CK_PLISQUT
Actual Quota Arrangement
X Planned Quota Arrangement
LOBEZUS Overhead on Subcontracted Materials CHAR 1 0 CK_LOBEZUS
PERTARIF Scheduled Activity Price Calculation CHAR 1 0 CK_PERTARI
VERSN Version CHAR 3 0 TKA09 VERSN
CON_FIN_MPL1 Price Type CHAR 3 0 CK_PRICELABEL
CON_FIN_MPL2 Price Type CHAR 3 0 CK_PRICELABEL
CON_FIN_MPL3 Price Type CHAR 3 0 CK_PRICELABEL
CON_FIN_MPL4 Price Type CHAR 3 0 CK_PRICELABEL
CON_FIN_MPL5 Price Type CHAR 3 0 CK_PRICELABEL

TCK05 foreign key relationships

Table Field Check Table Check Field
0 TCK05 KALSM T683 Pricing procedures KAPPL
0 TCK05 KALSM T683 Pricing procedures KALSM
1 TCK05 KALSM_RAW T683 Pricing procedures KAPPL
1 TCK05 KALSM_RAW T683 Pricing procedures KALSM
0 TCK05 VERSN TKA09 Basic Settings for Versions MANDT
0 TCK05 VERSN TKA09 Basic Settings for Versions KOKRS
0 TCK05 VERSN TKA09 Basic Settings for Versions VERSN