SAP CKI_TCKM2E Currencies of the Material Ledger Table data and field list

CKI_TCKM2E is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Currencies of the Material Ledger" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CKI_TCKM2E TYPE CKI_TCKM2E.

The CKI_TCKM2E table consists of various fields, each holding specific information or linking keys about Currencies of the Material Ledger data available in SAP. These include MANDTE (Client), BWKEYE (Valuation Area), LFDNRE (Consecutive number for additional ML types - no longer used), MATLEDE (Material Ledger Type)... 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. .

CKI_TCKM2E structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP CKI_TCKM2E structure 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 CKI_TCKM2E 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
.INCLU-E				0
MANDTE	Client	MANDT	CLNT	3	T000		MANDT
BWKEYE	Valuation Area	BWKEY	CHAR	4	T001K		BWKEY	BWK
LFDNRE	Consecutive number for additional ML types - no longer used	CK_LFDNR	NUMC	5			CK_LFDNR
MATLEDE	Material Ledger Type	CKML_MATLED	CHAR	4	TCKMHD		CKML_MATLED
MANDT	Client	MANDT	CLNT	3	T000		MANDT
MATLED	Material ledger type	CK_MATLED	CHAR	4	Assigned to domain		CK_MATLED
CURTP1	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
CURTP2	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
CURTP3	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
MLFICT	Use currency types from financial accounting	CK_ML_FICT	CHAR	1			XFELD
MLCOCT	Use currency types from Controlling	CK_ML_COCT	CHAR	1			XFELD
WAERS_1	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
WAERS_2	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
WAERS_3	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
TEXT_1	Explanatory short text	DDTEXT	CHAR	60			DDTEXT
TEXT_2	Explanatory short text	DDTEXT	CHAR	60			DDTEXT
TEXT_3	Explanatory short text	DDTEXT	CHAR	60			DDTEXT
KURST_1	Exchange Rate Type	KURST	CHAR	4	Assigned to domain		KURST	KUT
KURST_2	Exchange Rate Type	KURST	CHAR	4	Assigned to domain		KURST	KUT
KURST_3	Exchange Rate Type	KURST	CHAR	4	Assigned to domain		KURST	KUT
BASW_1	Source Currency for Currency Translation	CURSR	CHAR	1			CURSR
BASW_2	Source Currency for Currency Translation	CURSR	CHAR	1			CURSR
BASW_3	Source Currency for Currency Translation	CURSR	CHAR	1			CURSR
UMRD_1	Translation Date Type for Second Local Currency	UMRD2	CHAR	1			CURDT
UMRD_2	Translation Date Type for Second Local Currency	UMRD2	CHAR	1			CURDT
UMRD_3	Translation Date Type for Second Local Currency	UMRD2	CHAR	1			CURDT
CURRTYP_1	Currency Type	CURRTYP	CHAR	2			CURRTYP
CURRTYP_2	Currency Type	CURRTYP	CHAR	2			CURRTYP
CURRTYP_3	Currency Type	CURRTYP	CHAR	2			CURRTYP
VALUTYP_1	Valuation View	VALUTYP	NUMC	1			VALUTYP	VTP
VALUTYP_2	Valuation View	VALUTYP	NUMC	1			VALUTYP	VTP
VALUTYP_3	Valuation View	VALUTYP	NUMC	1			VALUTYP	VTP

Key field

Non-key field

< CKI_TCK05 - Extended Structure of TCK05 CKI_UEW_ML - Subsequent debit amounts neutral -ZUUMB- >

How do I retrieve data from SAP structure CKI_TCKM2E using ABAP code?

As CKI_TCKM2E is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CKI_TCKM2E as there is no data to select.

How to access SAP table CKI_TCKM2E

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

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