SAP table TCK05 has 2 primary key fields being MANDT,BWVAR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCK05 columns.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
KeyMANDT
Client
CLNT
3
0
MANDT
KeyBWVAR
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