SAP ESH_OM_CCATEG Categories Table data and field list

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

The ESH_OM_CCATEG table consists of various fields, each holding specific information or linking keys about Categories data available in SAP. These include MODEL_GUID (Model GUID), CATEGORY_GUID (Category GUID), CATEGORY (Category), P_CATEGORY_GUID (Parent Category 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_CCATEG 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_CCATEGT

SAP ESH_OM_CCATEG 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_CCATEG 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
CATEGORY_GUID	Category GUID	ESH_E_OM_CATEGORY_GUID	CHAR	32			SYSUUID_C
CATEGORY	Category	ESH_E_OM_CATEGORY	CHAR	30			ESH_D_OM_CATEGORY		ESH_H_OM_CATEGORY
P_CATEGORY_GUID	Parent Category GUID	ESH_E_OM_PARENT_CATEGORY_GUID	CHAR	32			SYSUUID_C
NON_CROSS_MODEL	Flag: Category Is Valid For All Models	ESH_E_OM_CAT_NON_CROSS_MODEL	CHAR	1			XFELD
POSI	Count parameters	NUMC4	NUMC	4			NUMC4
BACKEND_NAME	Backend Name	ESH_E_OM_BACKEND_NAME	CHAR	255			ESH_D_OM_BACKEND_NAME
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_CAUTHONWT - SAP_NW Authorizations: Authorization Objects: Descriptions ESH_OM_CCATEGT - Categories: Descriptions >

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

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

SELECT SINGLE *
FROM ESH_OM_CCATEG
INTO CORRESPONDING FIELDS OF WA_ESH_OM_CCATEG
WHERE...

How to access SAP table ESH_OM_CCATEG

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

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