SAP ESH_OM_SOTYPNRR Object Types: Nodes: Related Requests Table data and field list

ESH_OM_SOTYPNRR is a standard SAP Table which is used to store Object Types: Nodes: Related Requests data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_OM_SOTYPNRR table consists of various fields, each holding specific information or linking keys about Object Types: Nodes: Related Requests data available in SAP. These include MODEL_GUID (Model GUID), OTYPNRR_GUID (GUID in 'CHAR' Format in Uppercase), NODE_GUID (Node GUID), REL_REQU_GUID (Related Request 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_SOTYPNRR 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_SOTYPNRR 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_SOTYPNRR 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
OTYPNRR_GUIDGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
NODE_GUIDNode GUID ESH_E_OM_NODE_GUIDCHAR32SYSUUID_C
REL_REQU_GUIDRelated Request GUID ESH_E_OM_RELATED_REQUEST_GUIDCHAR32SYSUUID_C
MAPPING_NUMBERMapping Number ESH_E_OM_MAPPING_NUMBERCHAR32SYSUUID_C
STATUSStatus of Related Request ESH_E_OM_STATUS_OTYPNRRCHAR1ESH_D_OM_STATUS_OTYPNRR
POSICount parameters NUMC4NUMC4NUMC4
TARGET_NAV_IDID of Target Navigation ESH_E_OM_TARGET_NAVIGATION_IDCHAR32
DETAIL_UIFlag: Shown in Detail UI ESH_E_OM_DETAIL_UICHAR1XFELD
SINGLETONFlag: Related Request yields singleton result ESH_E_OM_SINGLETONCHAR1XFELD
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_SOTYPNRR using ABAP code

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

SELECT SINGLE *
FROM ESH_OM_SOTYPNRR
INTO CORRESPONDING FIELDS OF WA_ESH_OM_SOTYPNRR
WHERE...

How to access SAP table ESH_OM_SOTYPNRR

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

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