SAP ESH_OM_AOTYPNQ Object Types: Nodes: Requests Table data and field list

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

The ESH_OM_AOTYPNQ table consists of various fields, each holding specific information or linking keys about Object Types: Nodes: Requests data available in SAP. These include MODEL_GUID (Model GUID), REQUEST_GUID (Request GUID), NODE_GUID (Node GUID), REQUEST (Request)... 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_AOTYPNQ table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = ESH_OM_AOTYPNQT


SAP ESH_OM_AOTYPNQ 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_AOTYPNQ 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
REQUEST_GUIDRequest GUID ESH_E_OM_REQUEST_GUIDCHAR32SYSUUID_C
NODE_GUIDNode GUID ESH_E_OM_NODE_GUIDCHAR32SYSUUID_C
REQUESTRequest ESH_E_OM_REQUESTCHAR20
DEFAULT_REQUESTFlag: Default Request ESH_E_OM_DEFAULT_REQUESTCHAR1XFELD
STATUSStatus of Request ESH_E_OM_STATUS_OTYPNQCHAR1ESH_D_OM_STATUS_OTYPNQ
MOD_STATUSModification Status of Requests ESH_E_OM_MOD_STATUS_OTYPNQCHAR1ESH_D_OM_MOD_STATUS_OTYPNQ
BACKEND_NAMEBackend Name ESH_E_OM_BACKEND_NAMECHAR255ESH_D_OM_BACKEND_NAME
REQ_RELV_INTFlag: Request Relevant Internally ESH_E_OM_REQ_RELV_INTERNALCHAR1XFELD
REQ_RELV_ATTRFlag: Request Relevant for Attribute Search ESH_E_OM_REQ_RELV_ATTRSEARCHCHAR1XFELD
REQ_RELV_VALHELPFlag: Request Relevant for Value Help ESH_E_OM_REQ_RELV_VALHELPCHAR1XFELD
REQ_RELV_RELREQFlag: Request Relevant for Related Requests ESH_E_OM_REQ_RELV_RELREQCHAR1XFELD
REQ_RELV_ODPFlag: Request Relevant for ODP (Navigation Request) ESH_E_OM_REQ_RELV_ODPCHAR1XFELD
REQ_DEF_ODPFlag: Default ODP-Request (Navigation Request) ESH_E_OM_DEFAULT_REQUEST_ODPCHAR1XFELD
REQ_AUTOTAG_TYPEAutotagging Request Type (Source=Taggee, Target=Tagger) ESH_E_OM_REQ_AUTOTAG_TYPECHAR1ESH_D_OM_REQ_AUTOTAG_TYPE
GEN_INFO_GUIDGeneration Info GUID ESH_E_OM_GEN_INFO_GUIDCHAR32SYSUUID_C
SWO_IND_AUTH_CHECKSSwitch off indirect authorization checks ESH_E_OM_SWO_IND_AUTH_CHECKSCHAR1XFELD
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_AOTYPNQ using ABAP code

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

SELECT SINGLE *
FROM ESH_OM_AOTYPNQ
INTO CORRESPONDING FIELDS OF WA_ESH_OM_AOTYPNQ
WHERE...

How to access SAP table ESH_OM_AOTYPNQ

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

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