SAP ESH_OM_FLDTYPE Field Types Table data and field list

ESH_OM_FLDTYPE is a standard SAP Table which is used to store Field Types data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_OM_FLDTYPE table consists of various fields, each holding specific information or linking keys about Field Types data available in SAP. These include FIELD_TYPE (Type of Field), FIELD_TYPE_EXT (Field Type: External Representation), CONSTRAINT_USE (Field Type: Usable as Constraint), RANGE_USE (Field Type: Usable as Range)... 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_OM_FLDTYPE table Technical Details:

Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = ESH_OM_FLDTYPET


SAP ESH_OM_FLDTYPE 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_OM_FLDTYPE 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
FIELD_TYPEType of Field ESH_E_OM_FIELD_TYPECHAR2ESH_D_OM_FIELD_TYPE
FIELD_TYPE_EXTField Type: External Representation ESH_E_OM_FIELD_TYPE_EXTCHAR255ESH_D_OM_FIELD_TYPE_EXT
CONSTRAINT_USEField Type: Usable as Constraint ESH_E_OM_FLDTYPE_CONSTRCHAR1ESH_D_OM_FLDTYPE_CONSTR
RANGE_USEField Type: Usable as Range ESH_E_OM_FLDTYPE_RANGECHAR1ESH_D_OM_FLDTYPE_RANGE
CONSTRAINT_NAMEConstraint Name ESH_E_OM_CONSTR_NAMECHAR64ESH_D_OM_CONSTR_NAME
CONSTRAINT_OPConstraint Operator ESH_E_OM_CONSTR_OPERATORCHAR2ESH_D_OM_CONSTR_OPERATOR

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_OM_FLDTYPE
INTO CORRESPONDING FIELDS OF WA_ESH_OM_FLDTYPE
WHERE...

How to access SAP table ESH_OM_FLDTYPE

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

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