The CHARACTERTEXT table in SAP ERP or S/4HANA stores DML Text Object data. There are total 23 fields in CHARACTERTEXT table. The DML Text Object table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CHARACTERTEXT table. It is in Characteristic: Definition/Runtime (CME_CHAR) ABAP package and is part of the Classification System (New) (AP-CME) module.
SAP CHARACTERTEXT Table Fields
Following is the list of fields that are available in SAP CHARACTERTEXT table. The primary key fields of the table are CLIENT (Client), FRG_GUID (Set GUID), ELEMENT (MDF Text Element, like Set Type), SUBELEM (Subelement (Attribute of Set Type)), SUBOBJECT (Subobject, for example, row key of a set), TEXT_TYPE (MDF Text Type), LANGUAGE (Language), COUNTRY (Country Key), COUNTER (Counter for Multiline Text Types).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| FRG_GUID | Set GUID | COMT_FRG_GUID | RAW (16) | |
| ELEMENT | MDF Text Element, like Set Type | DML_TEXT_ELEMENT | CHAR (30) | |
| SUBELEM | Subelement (Attribute of Set Type) | DML_TEXT_SUBELEMENT | CHAR (30) | |
| SUBOBJECT | Subobject, for example, row key of a set | DML_TEXT_SUBOBJECT | NUMC (5) | |
| TEXT_TYPE | MDF Text Type | DML_TEXT_TYPE | CHAR (10) | |
| LANGUAGE | Language | DML_TEXT_LANGU | CHAR (2) | |
| COUNTRY | Country Key | DML_TEXT_COUNTRY | CHAR (2) | |
| COUNTER | Counter for Multiline Text Types | DML_TEXT_COUNTER | NUMC (5) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | * | CHAR (10) |
| POS_COUNT | Sort Order | DML_TEXT_POSITION | NUMC (5) | |
| SHORT | Description | DML_TEXT_SHORT | SSTR (255) | |
| SHORT_CAP | Description, Uppercase | DML_TEXT_SHORT_CAPS | SSTR (255) | |
| LONG_ID | Long Text Key | DML_TEXT_LONG | RAW (16) | |
| OBJECT_ID | Object GUID | DML_OBJECT | RAW (16) | |
| DOCUMENTS | Document Key | DML_DOCKEY | RAW (16) | |
| ECM_COUNT | Change Management Counter | DML_ECM_COUNT | NUMC (5) | |
| ECM_DEL | Deletion Indicator | DML_ECM_DEL | CHAR (1) | |
| LINE_ID | Row Key | DML_LINE_ID | NUMC (5) |
