SAP CKMLCT Currency Types and Valuation Types in a Valuation Area Table data and field list

CKMLCT is a standard SAP Table which is used to store Currency Types and Valuation Types in a Valuation Area data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CKMLCT table consists of various fields, each holding specific information or linking keys about Currency Types and Valuation Types in a Valuation Area data available in SAP. These include BWKEY (Valuation Area), CURTP (Currency Type and Valuation View), WAERS (Currency Key), ADJUST_FLAG (Currency Type Reconciled with FI)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CKMLCT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CKMLCT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CKMLCT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BWKEYValuation Area BWKEYCHAR4T001KBWKEYBWK
CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
ADJUST_FLAGCurrency Type Reconciled with FI CK_ADJUSTFLAGCHAR1XFELD
ADJUST_VERSRelease of SAP System SYSAPRLCHAR4SYCHAR04
ADJUST_DATEDate on Which the Reconciliation Was Performed CK_ADJUSTDATDATS8SYDATS
ADJUST_USERUser Who Performed the Reconciliation CK_ADJUSTUSRCHAR12SYCHAR12

Key field Non-key field



How do I retrieve data from SAP table CKMLCT using ABAP code

The following ABAP code Example will allow you to do a basic selection on CKMLCT to SELECT all data from the table
DATA: WA_CKMLCT TYPE CKMLCT.

SELECT SINGLE *
FROM CKMLCT
INTO CORRESPONDING FIELDS OF WA_CKMLCT
WHERE...

How to access SAP table CKMLCT

Within an ECC or HANA version of SAP you can also view further information about CKMLCT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).