SAP CHARACTERTEXT_MR_DATA Structure for Maintaining Set Type CHARACTERTEXT Table data and field list

CHARACTERTEXT_MR_DATA 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 "Structure for Maintaining Set Type CHARACTERTEXT" 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_CHARACTERTEXT_MR_DATA TYPE CHARACTERTEXT_MR_DATA.

The CHARACTERTEXT_MR_DATA table consists of various fields, each holding specific information or linking keys about Structure for Maintaining Set Type CHARACTERTEXT data available in SAP. These include CLIENT (Client), FRG_GUID (Set GUID), ELEMENT (MDF Text Element, like Set Type), SUBELEM (Subelement (Attribute of Set Type))... 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. .

CHARACTERTEXT_MR_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP CHARACTERTEXT_MR_DATA structure 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 CHARACTERTEXT_MR_DATA 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
DATA 0
CLIENTClient MANDTCLNT3MANDT
FRG_GUIDSet GUID COMT_FRG_GUIDRAW16SYSUUID
ELEMENTMDF Text Element, like Set Type DML_TEXT_ELEMENTCHAR30DML_TEXT_ELEMENT
SUBELEMSubelement (Attribute of Set Type) DML_TEXT_SUBELEMENTCHAR30DML_TEXT_SUBELEMENT
SUBOBJECTSubobject, for example, row key of a set DML_TEXT_SUBOBJECTNUMC5DML_TEXT_SUBOBJECT
TEXT_TYPEMDF Text Type DML_TEXT_TYPECHAR10DML_TEXT_TYPE
LANGUAGELanguage DML_TEXT_LANGUCHAR2DML_TEXT_LANGU
COUNTRYCountry Key DML_TEXT_COUNTRYCHAR2DML_TEXT_COUNTRY
COUNTERCounter for Multiline Text Types DML_TEXT_COUNTERNUMC5DML_TEXT_COUNTER
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_LOGSYSCHAR10ALPHALOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYS
POS_COUNTSort Order DML_TEXT_POSITIONNUMC5DML_TEXT_POSITION
SHORTDescription DML_TEXT_SHORTSSTR255DML_TEXT_SHORT
SHORT_CAPDescription, Uppercase DML_TEXT_SHORT_CAPSSSTR255DML_TEXT_SHORT_CAPS
LONG_IDLong Text Key DML_TEXT_LONGRAW16DML_TEXT_LONG
OBJECT_IDObject GUID DML_OBJECTRAW16DML_OBJECT
DOCUMENTSDocument Key DML_DOCKEYRAW16DML_DOCKEY
ECM_COUNTChange Management Counter DML_ECM_COUNTNUMC5DML_ECM_COUNT
ECM_DELDeletion Indicator DML_ECM_DELCHAR1DML_ECM_DEL
LINE_IDRow Key DML_LINE_IDNUMC5DML_LINE_ID
DATA_X 0
POS_COUNTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SHORTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SHORT_CAPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LONG_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
OBJECT_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DOCUMENTSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ECM_COUNTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ECM_DELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LINE_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UPDATE_TYPEType of Change UPDATE_TYPECHAR1UPDATE_TYPE

Key field Non-key field



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

As CHARACTERTEXT_MR_DATA 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 CHARACTERTEXT_MR_DATA as there is no data to select.

How to access SAP table CHARACTERTEXT_MR_DATA

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

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