SAP ESH_KEYMAP_RULES Longtext Extraction - Key Mapping Rules Table data and field list

ESH_KEYMAP_RULES is a standard SAP Table which is used to store Longtext Extraction - Key Mapping Rules data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_KEYMAP_RULES table consists of various fields, each holding specific information or linking keys about Longtext Extraction - Key Mapping Rules data available in SAP. These include SWCV (Software Component), SYS_GROUP (Model), BO_NAME (Object Type), NODE_NAME (Node Name)... 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. .

ESH_KEYMAP_RULES table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ESH_KEYMAP_RULES 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 ESH_KEYMAP_RULES 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
SWCV	Software Component	ESH_E_OM_SYSREL	CHAR	32
SYS_GROUP	Model	ESH_E_OM_MODEL	CHAR	32
BO_NAME	Object Type	ESH_E_OM_OBJECT_TYPE	CHAR	20			ESH_D_OM_OBJECT_TYPE
NODE_NAME	Node Name	ESH_E_OM_NODE_NAME	CHAR	20			ESH_D_OM_NODE_NAME
RULE_ORDER	Key Mapping Rule - Rule Part	ESH_E_LTXT_RULE_ORDER_NUMBER	INT4	10
RULE_TERM	Key Mapping Rule Term (Node Field/ Terminal)	ESH_E_LTXT_RULE_TERM	CHAR	64
IS_NODE_FIELD	Key Mapping Rule - Is Node Field Flag	ESH_E_LTXT_IS_NODE_FIELD	CHAR	1			ESH_LTXT_IS_NODE_FIELD

Key field

Non-key field

< ESH_HDB_MAP - Mapping table for ESHAUTH <-> MANDT ESH_LOGSYS - Dummy-Table for Lock object for source system >

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

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

SELECT SINGLE *
FROM ESH_KEYMAP_RULES
INTO CORRESPONDING FIELDS OF WA_ESH_KEYMAP_RULES
WHERE...

How to access SAP table ESH_KEYMAP_RULES

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

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