SAP CHARACTERTEXT DML Text Object Table data and field list

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

The CHARACTERTEXT table consists of various fields, each holding specific information or linking keys about DML Text Object 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 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP CHARACTERTEXT 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 CHARACTERTEXT 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
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
FRG_GUID	Set GUID	COMT_FRG_GUID	RAW	16			SYSUUID
ELEMENT	MDF Text Element, like Set Type	DML_TEXT_ELEMENT	CHAR	30			DML_TEXT_ELEMENT
SUBELEM	Subelement (Attribute of Set Type)	DML_TEXT_SUBELEMENT	CHAR	30			DML_TEXT_SUBELEMENT
SUBOBJECT	Subobject, for example, row key of a set	DML_TEXT_SUBOBJECT	NUMC	5			DML_TEXT_SUBOBJECT
TEXT_TYPE	MDF Text Type	DML_TEXT_TYPE	CHAR	10			DML_TEXT_TYPE
LANGUAGE	Language	DML_TEXT_LANGU	CHAR	2			DML_TEXT_LANGU
COUNTRY	Country Key	DML_TEXT_COUNTRY	CHAR	2			DML_TEXT_COUNTRY
COUNTER	Counter for Multiline Text Types	DML_TEXT_COUNTER	NUMC	5			DML_TEXT_COUNTER
VALID_FROM	Valid From (Time Stamp)	COMT_VALID_FROM	DEC	15		TSTPS	BCOS_TSTMP
VALID_TO	Valid To (Time Stamp)	COMT_VALID_TO	DEC	15		TSTPS	BCOS_TSTMP
UPNAME	Name of the User Who Last Changed the Set	COMT_UPNAME	CHAR	12			UNAME
HISTEX	History Exists	COMT_HISTEX	CHAR	1			COM_BOOLEAN
LOGSYS	Original System	COMT_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS	COM_LOGSYS	COM_PRODUCT_LOGSYS
POS_COUNT	Sort Order	DML_TEXT_POSITION	NUMC	5			DML_TEXT_POSITION
SHORT	Description	DML_TEXT_SHORT	SSTR	255			DML_TEXT_SHORT
SHORT_CAP	Description, Uppercase	DML_TEXT_SHORT_CAPS	SSTR	255			DML_TEXT_SHORT_CAPS
LONG_ID	Long Text Key	DML_TEXT_LONG	RAW	16			DML_TEXT_LONG
OBJECT_ID	Object GUID	DML_OBJECT	RAW	16			DML_OBJECT
DOCUMENTS	Document Key	DML_DOCKEY	RAW	16			DML_DOCKEY
ECM_COUNT	Change Management Counter	DML_ECM_COUNT	NUMC	5			DML_ECM_COUNT
ECM_DEL	Deletion Indicator	DML_ECM_DEL	CHAR	1			DML_ECM_DEL
LINE_ID	Row Key	DML_LINE_ID	NUMC	5			DML_LINE_ID

Key field

Non-key field

< CHARACTERS - Internal characteristics number and name CHARACTERTEXTH - DML Text Object >

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

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

SELECT SINGLE *
FROM CHARACTERTEXT
INTO CORRESPONDING FIELDS OF WA_CHARACTERTEXT
WHERE...

How to access SAP table CHARACTERTEXT

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

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