SAP ESH_TREX_PARAM Enables using TREX features Table data and field list

ESH_TREX_PARAM is a standard SAP Table which is used to store Enables using TREX features data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_TREX_PARAM table consists of various fields, each holding specific information or linking keys about Enables using TREX features data available in SAP. These include FEATURE (TREX Feature), ACTIVE (Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')), DETAILS (Config Parameter Value), MOD_USER (Last Modification User)... 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_TREX_PARAM 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_TREX_PARAM 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_TREX_PARAM 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 MANDTCLNT3Assigned to domainMANDT
FEATURETREX Feature ESH_E_TREX_FEATURECHAR10ESH_D_TREX_FEATURE
ACTIVEData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
DETAILSConfig Parameter Value ESH_E_ADM_VALUESSTR250
MOD_USERLast Modification User ESH_E_ADM_BIN_LAST_MOD_USERCHAR12SYCHAR12
MOD_TIMESTAMPESH: Timestamp ESH_E_ADM_TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_TREX_PARAM
INTO CORRESPONDING FIELDS OF WA_ESH_TREX_PARAM
WHERE...

How to access SAP table ESH_TREX_PARAM

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

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