1. Home
  2. Resources
  3. SAP Tables
  4. CKMLW - Material Ledger Currencies in Valuation Area

SAP Table CKMLW

Material Ledger Currencies in Valuation Area

CKMLW (Material Ledger Currencies in Valuation Area) 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 CKMLW to other SAP tables.

CKMLW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
MATLED Material ledger type CK_MATLED TCKM1 CHAR 4 0
CURTP1 Currency Type and Valuation View CURTP CHAR 2 0
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 CURTP CHAR 2 0
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 CURTP CHAR 2 0
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 WAERS CUKY 5 0
WAERS_2 Currency Key WAERS CUKY 5 0
WAERS_3 Currency Key WAERS CUKY 5 0
ADJUST_FLAG_1 Currency Type Reconciled with FI CK_ADJUSTFLAG CHAR 1 0
X Yes
NULL No
ADJUST_FLAG_2 Currency Type Reconciled with FI CK_ADJUSTFLAG CHAR 1 0
X Yes
NULL No
ADJUST_FLAG_3 Currency Type Reconciled with FI CK_ADJUSTFLAG CHAR 1 0
X Yes
NULL No
ADJUST_VERS Release of SAP System SYSAPRL CHAR 4 0
ADJUST_DATE Date on Which the Reconciliation Was Performed CK_ADJUSTDAT DATS 8 0
ADJUST_USER User Who Performed the Reconciliation CK_ADJUSTUSR CHAR 12 0

CKMLW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLW BWKEY CKMLW MANDT T001K Valuation area MANDT
CKMLW BWKEY CKMLW BWKEY T001K Valuation area BWKEY
CKMLW MANDT CKMLW MANDT T000 Clients MANDT
CKMLW MATLED CKMLW MATLED TCKM1 Material Ledger Table MATLED
CKMLW MATLED CKMLW MANDT TCKM1 Material Ledger Table MANDT