SAP ESH_OM_SRELAT Relations Table data and field list

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

The ESH_OM_SRELAT table consists of various fields, each holding specific information or linking keys about Relations data available in SAP. These include MODEL_GUID (Model GUID), RELATION_GUID (Relation GUID), RELATION_ID (Relation ID), SOURCE_NODE_MUID (Model GUID)... 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_SRELAT 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_SRELAT 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_SRELAT 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
RELATION_GUIDRelation GUID ESH_E_OM_RELATION_GUIDCHAR32SYSUUID_C
RELATION_IDRelation ID ESH_E_OM_RELATION_IDCHAR32ESH_D_OM_RELATION_ID
SOURCE_NODE_MUIDModel GUID ESH_E_OM_MODEL_GUIDCHAR32SYSUUID_C
SOURCE_NODE_GUIDSource Node GUID ESH_E_OM_SOURCE_NODE_GUIDCHAR32SYSUUID_C
TARGET_NODE_MUIDModel GUID ESH_E_OM_MODEL_GUIDCHAR32SYSUUID_C
TARGET_NODE_GUIDTarget Node GUID ESH_E_OM_TARGET_NODE_GUIDCHAR32SYSUUID_C
CARD_SOURCECardinality Source ESH_E_OM_CARDSOURCECHAR2ESH_D_OM_CARDSOURCE
CARD_TARGETCardinality Target ESH_E_OM_CARDTARGETCHAR2ESH_D_OM_CARDTARGET
CONTAINMENTFlag: Containment ESH_E_OM_CONTAINMENTCHAR1XFELD
ASSOCIATION_TYPEAssociation Type ESH_E_OM_ASSO_TYPECHAR1ESH_D_OM_ASSO_TYPE
BACKEND_NAMEBack-End Name ESH_E_OM_BACKEND_NAME_RELATCHAR32ESH_D_OM_BACKEND_NAME_RELAT
BACKEND_NAME_LBackend Name ESH_E_OM_BACKEND_NAMECHAR255ESH_D_OM_BACKEND_NAME
MAPPING_ROLEMapping Role ESH_E_OM_MAPPING_ROLECHAR1ESH_D_OM_MAPPING_ROLE
MOD_STATUSModification Status of Relations ESH_E_OM_MOD_STATUS_RELATCHAR1ESH_D_OM_MOD_STATUS_RELAT
MODNAM_SEGName of Person Who Changed the Segment ESH_E_OM_MODNAM_SEGCHAR12USNAM
TIMESTMP_MOD_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
AREA_MOD_SEGArea ESH_E_OM_AREACHAR1ESH_D_OM_AREA
CRENAM_SEGName of Person Who Created the Segment ESH_E_OM_CRENAM_SEGCHAR12USNAM
TIMESTMP_CRE_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
AREA_CRE_SEGArea ESH_E_OM_AREACHAR1ESH_D_OM_AREA
AENAM_SEGName of Person Who Changed the Segment ESH_E_OM_AENAM_SEGCHAR12USNAM
TIMESTMP_AEN_SEGUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
ORG_SYSREL_GUIDSoftware Component GUID ESH_E_OM_SYSREL_GUIDCHAR32SYSUUID_C

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_OM_SRELAT
INTO CORRESPONDING FIELDS OF WA_ESH_OM_SRELAT
WHERE...

How to access SAP table ESH_OM_SRELAT

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

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