SAP ESH_OM_AOTYPUF Object Type Usage: Fields Relevant for Usage Table data and field list

ESH_OM_AOTYPUF is a standard SAP Table which is used to store Object Type Usage: Fields Relevant for Usage data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_OM_AOTYPUF table consists of various fields, each holding specific information or linking keys about Object Type Usage: Fields Relevant for Usage data available in SAP. These include MODEL_GUID (Model GUID), USAGE_FIELD_GUID (Usage Field GUID), USAGE_GUID (Object Type Usage: GUID), USAGE_FIELD (TbO Usage Field)... 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_AOTYPUF 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


SAP ESH_OM_AOTYPUF 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_AOTYPUF 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
USAGE_FIELD_GUIDUsage Field GUID ESH_E_OM_USAGE_FIELD_GUIDCHAR32SYSUUID_C
USAGE_GUIDObject Type Usage: GUID ESH_E_OM_USAGE_GUIDCHAR32SYSUUID_C
USAGE_FIELDTbO Usage Field ESH_E_OM_USAGE_FIELDCHAR30
RNODE_FIELD_MUIDModel GUID ESH_E_OM_MODEL_GUIDCHAR32SYSUUID_C
RNODE_FIELD_GUIDNode Field GUID ESH_E_OM_NODE_FIELD_GUIDCHAR32SYSUUID_C
NAVPATH_GUIDObject Types: Navigation Path GUID ESH_E_OM_NAVIGATION_PATH_GUIDCHAR32SYSUUID_C
T_DATA_TYPE_GUIDData Type GUID ESH_E_OM_DATA_TYPE_GUIDCHAR32SYSUUID_C
INTERACTIVE_NAVInteractive Navigation ESH_E_OM_INTERACTIVE_NAVCHAR1XFELD
RANKING_WEIGHTRanking Weight ESH_E_OM_RANKING_WEIGHTINT13ESH_D_OM_RANKING_WEIGHT
POSICount parameters NUMC4NUMC4NUMC4
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
ORG_MODEL_GUIDModel GUID ESH_E_OM_MODEL_GUIDCHAR32SYSUUID_C

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_OM_AOTYPUF
INTO CORRESPONDING FIELDS OF WA_ESH_OM_AOTYPUF
WHERE...

How to access SAP table ESH_OM_AOTYPUF

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

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