SAP ESH_OM_SYSREL Product Versions Table data and field list

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

The ESH_OM_SYSREL table consists of various fields, each holding specific information or linking keys about Product Versions data available in SAP. These include SYSREL_GUID (Software Component GUID), SYSREL (Software Component), COMPONENT (Software Component), COMPONENT_REL (SAP Release)... 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_SYSREL table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = ESH_OM_SYSRELT


SAP ESH_OM_SYSREL 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_SYSREL 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
SYSREL_GUIDSoftware Component GUID ESH_E_OM_SYSREL_GUIDCHAR32SYSUUID_C
SYSRELSoftware Component ESH_E_OM_SYSRELCHAR32
COMPONENTSoftware Component DLVUNITCHAR30Assigned to domainDLVUNITH_CVERS
COMPONENT_RELSAP Release SAPRELEASECHAR10CHAR10
SP_LEVELSupport Package Level of a Software Component SAPPATCHLVCHAR10CHAR10
TEMPLATE_TYPETemplate Type ESH_E_OM_TEMPLATE_TYPECHAR10ESH_D_OM_TEMPLATE_TYPE
BACKEND_NAMEBackend Name ESH_E_OM_BACKEND_NAMECHAR255ESH_D_OM_BACKEND_NAME
VERSION_IDUnique Model Version ID ESH_E_OM_VERSION_IDCHAR40ESH_D_OM_VERSION_ID
MOD_STATUSModification Status of Software Components ESH_E_OM_MOD_STATUS_SYSRELCHAR1ESH_D_OM_MOD_STATUS_SYSREL
AENAM_MODELName of Person Who changed the Model ESH_E_OM_AENAM_MODELCHAR12USNAM
TIMESTMP_MODELUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
AENAM_MODEL_CName of Person Who changed the Categories related to a Model ESH_E_OM_AENAM_MODEL_CATEGCHAR12USNAM
TIMESTMP_MODEL_CUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
NO_EXTRACTIONNo Extraction ESH_E_OM_NO_EXTRCHAR1XFELD
SYSREL_TYPEType of Software Component ESH_E_OM_SYSREL_TYPECHAR1ESH_D_OM_SYSREL_TYPE
BASIS_SWCBasis Software Component Type ESH_E_OM_BASIS_SWCCHAR1ESH_D_OM_BASIS_SWC
DEVCLASSPackage DEVCLASSCHAR30Assigned to domainDEVCLASSDVCDEVCLASS
APPL_COMPApplication component ID UFPS_POSIDCHAR24UFPS_POSID
SW_COMPSoftware Component DLVUNITCHAR30Assigned to domainDLVUNITH_CVERS
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_SYSREL using ABAP code

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

SELECT SINGLE *
FROM ESH_OM_SYSREL
INTO CORRESPONDING FIELDS OF WA_ESH_OM_SYSREL
WHERE...

How to access SAP table ESH_OM_SYSREL

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

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