MDM_GX_CATEGORY SAP (Category Structure with texts) Structure details

Dictionary Type: Structure
Description: Category Structure with texts




ABAP Code to SELECT data from MDM_GX_CATEGORY
Related tables to MDM_GX_CATEGORY
Access table MDM_GX_CATEGORY




Structure field list including key, data, relationships and ABAP select examples

MDM_GX_CATEGORY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Category Structure with texts" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MDM_GX_CATEGORY TYPE MDM_GX_CATEGORY.

The MDM_GX_CATEGORY table consists of various fields, each holding specific information or linking keys about Category Structure with texts data available in SAP. These include CATEGORY_GUID (Category GUID), CATEGORY_ID (Category ID), HIERARCHY_GUID (Category Hierarchy GUID), PARENT_GUID (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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MDM_GX_CATEGORY structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
HIERARCHY_GUIDCategory Hierarchy GUID COMT_HIERARCHY_GUIDRAW16SYSUUID
PARENT_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
NON_ASSIGNABLEProducts Cannot Be Assigned to the Category COMT_NON_ASSIGNABLE_CATEGORYCHAR1COM_NON_ASSIGNABLE_CATEGORY
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
CATEGORY_TEXTCategory Description COMT_CATEGORY_TEXTCHAR80TEXT80
TEXT_UPPER_CASECategory Description in Uppercase COMT_CATEGORY_TEXT_UPPER_CASECHAR80COM_CATEGORY_TEXT_UPPER_CASE
VALID_FROMValid From (Time Stamp) COMT_VALID_FROMDEC15TSTPSBCOS_TSTMP
VALID_TOValid To (Time Stamp) COMT_VALID_TODEC15TSTPSBCOS_TSTMP
UPNAMEName of the User Who Last Changed the Set COMT_UPNAMECHAR12UNAME
HISTEXHistory Exists COMT_HISTEXCHAR1COM_BOOLEAN
LOGSYSOriginal System COMT_LOGSYSCHAR10Assigned to domainALPHALOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYS

Key field Non-key field



How do I retrieve data from SAP structure MDM_GX_CATEGORY using ABAP code?

As MDM_GX_CATEGORY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDM_GX_CATEGORY as there is no data to select.

How to access SAP table MDM_GX_CATEGORY

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!