SAP table CKMLW (Material Ledger Currencies in Valuation Area)

SAP table CKMLW has 3 primary key fields being MANDT,BWKEY,MATLED.

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 T000 MANDT
BWKEY Valuation area CHAR 4 0 T001K BWKEY
MATLED Material Ledger Type CHAR 4 0 TCKM1 CK_MATLED
CURTP1 Currency type and valuation view CHAR 2 0 CURTP
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURTP2 Currency type and valuation view CHAR 2 0 CURTP
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURTP3 Currency type and valuation view CHAR 2 0 CURTP
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
WAERS_1 Currency Key CUKY 5 0 * WAERS
WAERS_2 Currency Key CUKY 5 0 * WAERS
WAERS_3 Currency Key CUKY 5 0 * WAERS
ADJUST_FLAG_1 Currency Type Reconciled with FI CHAR 1 0 CK_ADJUSTFLAG
ADJUST_FLAG_2 Currency Type Reconciled with FI CHAR 1 0 CK_ADJUSTFLAG
ADJUST_FLAG_3 Currency Type Reconciled with FI CHAR 1 0 CK_ADJUSTFLAG
ADJUST_VERS Release of SAP System CHAR 4 0 SYSAPRL
ADJUST_DATE Date on Which the Reconciliation Was Performed DATS 8 0 CK_ADJUSTDAT
ADJUST_USER User Who Performed the Reconciliation CHAR 12 0 CK_ADJUSTUSR

CKMLW foreign key relationships

Table Field Check Table Check Field
0 CKMLW MANDT T000 Clients MANDT
1 CKMLW MATLED TCKM1 Material Ledger Table MANDT