SXMSMSGDEF SAP (Message Definition) Table details
Dictionary Type: Table
Description: Message Definition
Description: Message Definition
Table field list including key, data, relationships and ABAP select examples
SXMSMSGDEF is a standard SAP Table which is used to store Message Definition data and is available within R/3 SAP systems depending on the version and release level.
The SXMSMSGDEF table consists of various fields, each holding specific information or linking keys about Message Definition data available in SAP. These include GUID (Filter ID), LOCATION (Filter Location), SENDER (Sender/Receiver ID), RECEIVER (Receiver ID).. 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SXMSMSGDEF table 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 |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | Filter ID | SXMSFILTERGUID | RAW | 16 | SYSUUID | ||||
LOCATION | Filter Location | SXMSLOCATION | CHAR | 1 | SXMSLOCATION | ||||
SENDER | Sender/Receiver ID | SXMSSENDER_ID | CHAR | 30 | Assigned to domain | SXMSSITE | |||
RECEIVER | Receiver ID | SXMSRECEIVER_ID | CHAR | 30 | Assigned to domain | SXMSSITE | |||
QUEUE | ID for Message Queue | SXMSQUEUE_ID | CHAR | 16 | SXMSQIDAPP | ||||
JOB_ID | Job ID | SXMSJOB | CHAR | 32 | SXMS_PRG_JOB_ID_ALL | ||||
PREFIX | Queue Prefix | SXMS_QUEUE_PREFIX | CHAR | 4 | SXMS_QUEUE_PREFIX | ||||
MSGTYPE | Message Type | SXMS_ACKNOWLEDGE | CHAR | 1 | SXMS_ACKNOWLEDGE | ||||
SIZECAT | Smaller/Larger Operator | SXMSMSGSIZECAT | CHAR | 1 | SXMSMSGSIZECAT | ||||
MSGSIZE | Size of Message Payload in KB | SXMSMSGSIZE | NUMC | 7 | |||||
SEQUENCE | Sequence of Message Filters | SXMSMSGSEQU | NUMC | 6 | |||||
STATUS | Message Filter Status | SXMSMSGDEFSTATUS | CHAR | 1 | SXMSMSGDEFSTATUS | ||||
MAXPACKSIZE | Maximum Size of Message Package | SXMSMAXPACKSIZE | INT4 | 10 | |||||
STARTATONCE | Flag ('' space) to indicate start mode of packaged messages | SXMSSTARTATONCE | CHAR | 1 | SXMSSTARTATONCE | ||||
EO_QUEUE | Data Type for Generated EO tcmp Queue | SXMS_EO_QUEUE | CHAR | 24 | TRFCQNAM | ||||
DESCR | Description | SXMSDESCR | CHAR | 60 | TEXT60 | ||||
CREATEDBY | Created by User | SXMSCREATEDBY | CHAR | 12 | UNAME | ||||
CREATEDDATE | Created On | SXMSCREATEDDATE | DATS | 8 | SYDATS | ||||
CREATEDTIME | Created At | SXMSCREATEDTIME | TIMS | 6 | SYTIME | ||||
MODIFIEDBY | Last Changed By | SXMSMODIFIEDBY | CHAR | 12 | UNAME | ||||
MODIFYDATE | Changed On | SXMSMODIFYDATE | DATS | 8 | SYDATS | ||||
MODIFYTIME | Last Changed At | SXMSMODIFYTIME | TIMS | 6 | SYTIME |
Key field | Non-key field |
How do I retrieve data from SAP table SXMSMSGDEF using ABAP code
The following ABAP code Example will allow you to do a basic selection on SXMSMSGDEF to SELECT all data from the tableDATA: WA_SXMSMSGDEF TYPE SXMSMSGDEF.
SELECT SINGLE *
FROM SXMSMSGDEF
INTO CORRESPONDING FIELDS OF WA_SXMSMSGDEF
WHERE...
How to access SAP table SXMSMSGDEF
Within an ECC or HANA version of SAP you can also view further information about SXMSMSGDEF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects