SAP ESH_OM_SDATATY Data Types Table data and field list

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

The ESH_OM_SDATATY table consists of various fields, each holding specific information or linking keys about Data Types data available in SAP. These include MODEL_GUID (Model GUID), DATA_TYPE_GUID (Data Type GUID), DATA_TYPE (Data Type), DOMNAME (Domain 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_OM_SDATATY 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


SAP ESH_OM_SDATATY 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_SDATATY 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
MODEL_GUIDModel GUID ESH_E_OM_MODEL_GUIDCHAR32SYSUUID_C
DATA_TYPE_GUIDData Type GUID ESH_E_OM_DATA_TYPE_GUIDCHAR32SYSUUID_C
DATA_TYPEData Type ESH_E_OM_DATA_TYPECHAR30
DOMNAMEDomain name DOMNAMECHAR30Assigned to domainDOMNAMEDD_DOMA
DATATYPEABAP/4 Dictionary: Screen data type for Screen Painter DYNPTYPECHAR4DATATYPE
INTTYPEABAP data type (C,D,N,...) INTTYPECHAR1INTTYPE
LENGLength (No. of Characters) DDLENGNUMC6DDLENG
INTLENInternal Length in Bytes INTLENNUMC6DDLENG
DECIMALSNumber of Decimal Places DECIMALSNUMC6DDLENG
LOWERCASELowercase letters allowed/not allowed LOWERCASECHAR1AS4FLAG
CONVEXITConversion Exit ESH_E_OM_CONVEXITCHAR5ESH_D_OM_CONVEXIT
OUTPUTLENOutput Length OUTPUTLENNUMC6DDLENG
SIGNFLAGFlag for sign in numerical fields SIGNFLAGCHAR1AS4FLAG
FIXED_UOMUnit of Measurement ESH_E_OM_UOMCHAR3
TEXT_REPOSITORYTText Repository ESH_E_OM_TEXT_REPOSITORYCHAR1ESH_D_OM_TEXT_REPOSITORY
TEXT_REPOSITORYFText Repository ESH_E_OM_TEXT_REPOSITORYCHAR1ESH_D_OM_TEXT_REPOSITORY
DATA_ELEMENTDDIC Data Element ESH_E_OM_DATA_ELEMENTCHAR30
DGEN_INFO_GUIDGeneration Info GUID ESH_E_OM_GEN_INFO_GUIDCHAR32SYSUUID_C
DMODNAM_SEGName of Person Who Changed the Segment ESH_E_OM_MODNAM_SEGCHAR12USNAM
DTMESTMP_MOD_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DAREA_MOD_SEGArea ESH_E_OM_AREACHAR1ESH_D_OM_AREA
DCRENAM_SEGName of Person Who Created the Segment ESH_E_OM_CRENAM_SEGCHAR12USNAM
DTMESTMP_CRE_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DAREA_CRE_SEGArea ESH_E_OM_AREACHAR1ESH_D_OM_AREA
DAENAM_SEGName of Person Who Changed the Segment ESH_E_OM_AENAM_SEGCHAR12USNAM
DTMESTMP_AEN_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_OM_SDATATY
INTO CORRESPONDING FIELDS OF WA_ESH_OM_SDATATY
WHERE...

How to access SAP table ESH_OM_SDATATY

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

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