SAP EMS_UDF_KEY User-Defined Fields - Key Table data and field list

EMS_UDF_KEY 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 "User-Defined Fields - Key" 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_EMS_UDF_KEY TYPE EMS_UDF_KEY.

The EMS_UDF_KEY table consists of various fields, each holding specific information or linking keys about User-Defined Fields - Key data available in SAP. These include DOM_TYPE_KEY (Key for Domain Type), DATA_TYPE (Actual/Target Data), KV_TECHNICAL_ID (Key-Value: Technical ID), KV_STRING_VALUE (Key-Value: Value)... 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. .

EMS_UDF_KEY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP EMS_UDF_KEY 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 EMS_UDF_KEY 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
FAC_ID	Asset ID	EMEFAC_ID	INT4	10			INT4
DOM_TYPE_KEY	Key for Domain Type	EMEDOM_TYPE_KEY	INT4	10			INT4
DATA_TYPE	Actual/Target Data	EMEDATA_TYPE	INT4	10			INT4
KV_TECHNICAL_ID	Key-Value: Technical ID	EMEKV_TECHNICAL_ID	INT4	10			INT4
KV_STRING_VALUE	Key-Value: Value	EMEKV_STRING_VALUE	CHAR	255			CHAR255
KV_LANGU	2-Character SAP Language Code	LAISO	CHAR	2			LAISO
KV_UNIT	Unit	UNIT	UNIT	3		CUNIT	EINHEIT
KV_UNIT_CODE	Key-Value: Unit Code	EMEKV_UNIT_CODE	CHAR	10			CHAR10
KV_ELEMENT_NAME	Key-Value: Element Name	EMEKV_ELEMENT_NAME	CHAR	128			CHAR128
VISIBLE	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
VAL_AREA_ID	Validity Area ID	EMEVAL_AREA_ID	CHAR	30			CHAR30

Key field

Non-key field

< EMS_UDF_DISP - User-Defined Fields for the Display EMS_UDF_PDF - User-Defined Fields - Form Context >

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

As EMS_UDF_KEY 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 EMS_UDF_KEY as there is no data to select.

How to access SAP table EMS_UDF_KEY

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

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