SAP ESH_HDB_FTX ESH Fulltext Index Maintenance Table data and field list

ESH_HDB_FTX is a standard SAP Table which is used to store ESH Fulltext Index Maintenance data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_HDB_FTX table consists of various fields, each holding specific information or linking keys about ESH Fulltext Index Maintenance data available in SAP. These include LOGSYS (Logical system), OBJECT_TYPE (Object Type), NODE_NAME (Node Name), FIELD_NAME (Node Field)... 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_HDB_FTX table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ESH_HDB_FTX 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_HDB_FTX 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
LOGSYS	Logical system	LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
OBJECT_TYPE	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
FIELD_NAME	Node Field	ESH_E_OM_NODE_FIELD	CHAR	30	Assigned to domain		FDNAME
HDB_DBSCHEMA	Database Schema	ESH_E_HDB_DBSCHEMA	CHAR	64			ESH_D_HDB_DBSCHEMA
HDB_APPTABLE	Database table name	ESH_E_HDB_DBTABNAME	CHAR	64			ESH_D_HDB_DBTABNAME
FULLTEXT_INDEX	Fulltext Index	ESH_E_HDB_FULLTEXT_INDEX	CHAR	64			ESH_D_HDB_FULLTEXT_INDEX
OWNER	Fulltext Index Owner	ESH_E_HDB_FTX_OWNER	CHAR	4			ESH_D_HDB_FTX_OWNER
STATUS	Fulltext Index Status	ESH_E_HDB_FTX_STATUS	CHAR	1			ESH_D_HDB_FTX_STATUS
MOD_USER	Last Modification User	ESH_E_ADM_BIN_LAST_MOD_USER	CHAR	12			SYCHAR12
MOD_TIMESTAMP	ESH: Timestamp	ESH_E_ADM_TIMESTAMP	DEC	15			TZNTSTMPS

Key field

Non-key field

< ESH_HDB_DBSCHEMA - Schema Mapping for ESH on Application Tables Scenario ESH_HDB_MAP - Mapping table for ESHAUTH <-> MANDT >

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

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

SELECT SINGLE *
FROM ESH_HDB_FTX
INTO CORRESPONDING FIELDS OF WA_ESH_HDB_FTX
WHERE...

How to access SAP table ESH_HDB_FTX

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

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