SXMSTRANS_HEADER SAP (Lookup Table for Message Transfer) Table details
Description: Lookup Table for Message Transfer
Related tables to SXMSTRANS_HEADER
Access table SXMSTRANS_HEADER
Table field list including key, data, relationships and ABAP select examples
SXMSTRANS_HEADER is a standard SAP Table which is used to store Lookup Table for Message Transfer data and is available within R/3 SAP systems depending on the version and release level.
The SXMSTRANS_HEADER table consists of various fields, each holding specific information or linking keys about Lookup Table for Message Transfer data available in SAP. These include GROUP_TYPE (Group Type for Message Transfer), GROUP_GUID (Generated Group GUID for Message Transfer), GROUP_ID (Group ID for Message Transfer), MSG_TRANS_STATE (Status for Message Transfer).. 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 SXMSTRANS_HEADER 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 |
| MANDT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| GROUP_TYPE | Group Type for Message Transfer | SXMSGROUP_TYPE | CHAR | 10 | SXMSGROUP_TYPE | ||||
| GROUP_GUID | Generated Group GUID for Message Transfer | SXMSGROUP_GUID | RAW | 16 | SYSUUID | ||||
| GROUP_ID | Group ID for Message Transfer | SXMSGROUP_ID | CHAR | 64 | SXMSGROUP_ID | ||||
| MSG_TRANS_STATE | Status for Message Transfer | SXMS_MSG_TRANS_STATE | NUMC | 3 | SXMS_MSG_TRANS_STATE | ||||
| TASK_STATE | Task Status for Message Transfer | SXMS_TASK_STATE | NUMC | 3 | SXMS_TASK_STATE | ||||
| TRANS_QUEUE_NAME | Name of tRFC Queue | TRFCQNAM | CHAR | 24 | TRFCQNAM | ||||
| TID | Unique Transaction ID (LUW -> COMMIT WORK) | ARFCTID_D | CHAR | 24 | CHAR24 | ||||
| DELETION_STATE | Delete Status for Message Transfer | SXMS_DELETION_STATE | NUMC | 3 | SXMS_DELETION_STATE |
| Key field | Non-key field |
How do I retrieve data from SAP table SXMSTRANS_HEADER using ABAP code
The following ABAP code Example will allow you to do a basic selection on SXMSTRANS_HEADER to SELECT all data from the tableDATA: WA_SXMSTRANS_HEADER TYPE SXMSTRANS_HEADER.
SELECT SINGLE *
FROM SXMSTRANS_HEADER
INTO CORRESPONDING FIELDS OF WA_SXMSTRANS_HEADER
WHERE...
How to access SAP table SXMSTRANS_HEADER
Within an ECC or HANA version of SAP you can also view further information about SXMSTRANS_HEADER 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