SAP ESH_OM_CRELATFV Relations: Fixed Values Table data and field list

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

The ESH_OM_CRELATFV table consists of various fields, each holding specific information or linking keys about Relations: Fixed Values data available in SAP. These include MODEL_GUID (Model GUID), RELATFV_GUID (GUID in 'CHAR' Format in Uppercase), RELATION_GUID (Relation GUID), NODE_FIELD_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_CRELATFV 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

SAP ESH_OM_CRELATFV 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_CRELATFV 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
MODEL_GUID	Model GUID	ESH_E_OM_MODEL_GUID	CHAR	32			SYSUUID_C
RELATFV_GUID	GUID in 'CHAR' Format in Uppercase	GUID_32	CHAR	32			SYSUUID_C
RELATION_GUID	Relation GUID	ESH_E_OM_RELATION_GUID	CHAR	32			SYSUUID_C
NODE_FIELD_MUID	Model GUID	ESH_E_OM_MODEL_GUID	CHAR	32			SYSUUID_C
NODE_FIELD_GUID	Node Field GUID	ESH_E_OM_NODE_FIELD_GUID	CHAR	32			SYSUUID_C
LOW	Low	ESH_E_OM_LOW_STRING	STRG	0
HIGH	High	ESH_E_OM_HIGH_STRING	STRG	0
SIGN	Sign	ESH_E_OM_SIGN	CHAR	1			ESH_D_OM_SIGN
OPT	Option	ESH_E_OM_OPTION	CHAR	2			ESH_D_OM_OPTION
MODNAM_SEG	Name of Person Who Changed the Segment	ESH_E_OM_MODNAM_SEG	CHAR	12			USNAM
TIMESTMP_MOD_SEG	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
AREA_MOD_SEG	Area	ESH_E_OM_AREA	CHAR	1			ESH_D_OM_AREA
CRENAM_SEG	Name of Person Who Created the Segment	ESH_E_OM_CRENAM_SEG	CHAR	12			USNAM
TIMESTMP_CRE_SEG	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
AREA_CRE_SEG	Area	ESH_E_OM_AREA	CHAR	1			ESH_D_OM_AREA
AENAM_SEG	Name of Person Who Changed the Segment	ESH_E_OM_AENAM_SEG	CHAR	12			USNAM
TIMESTMP_AEN_SEG	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
ORG_SYSREL_GUID	Software Component GUID	ESH_E_OM_SYSREL_GUID	CHAR	32			SYSUUID_C

Key field

Non-key field

< ESH_OM_CRELATF - Relations: Field Assignments ESH_OM_CSWASGN - Switch Assignments >

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

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

SELECT SINGLE *
FROM ESH_OM_CRELATFV
INTO CORRESPONDING FIELDS OF WA_ESH_OM_CRELATFV
WHERE...

How to access SAP table ESH_OM_CRELATFV

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

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