SAP ABAP Table SXMSMSGLST_SORTED (Sorted Message List)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-XI-IS-IEN (Application Component) Integration Engine
     ⤷ SXMSPERSIST (Package) XI: Integration Engine Persistence Layer

Basic Data

Table Category	INTTAB	Structure
Structure	SXMSMSGLST_SORTED	Table Relationship Diagram
Short Description	Sorted Message List

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SORTINDEX	☐	SXMXINDEX	SXMXINDEX	INT4	10	0	Sort Index
2	.INCLUDE	☐				0	0	XML Message Broker: Message
3	.INCLUDE	☐				0	0	Integration Engine: Message Queue (Master)
4	MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
5	MSGGUID	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
6	PID	☐	SXMSPID	SXMSPID	CHAR	40	0	Integration Engine: Pipeline ID	*
7	MSGTYPE	☐	SXMSPMTYPE	SXMSPMTYPE	CHAR	1	0	Integration Engine: Message Type
8	MSGSTATE	☐	SXMSPMSTAT	SXMSPMSTAT	NUMC	3	0	Integration Engine: Message Status	*
9	QOSMODE	☐	SXMSQOS	SXMSQOS	CHAR	4	0	Integration Engine: Quality of Service
10	EXETIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
11	INITTIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
12	SENDTIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
13	SNDRGUID	☐	SXMSSNDRID	SYSUUID	RAW	16	0	Sender ID
14	QUEUEGUID	☐	SXMSQID	SXMSQID	CHAR	32	0	ID for Message Queue
15	EO_REFID	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
16	EO_REFVAL	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
17	ADAPT_TYP	☐	SXMSPSTYPE	SXMSPSTYPE	CHAR	10	0	Pipeline Service Type
18	ADAPT_STAT	☐	SXMSPASTAT	SXMSPASTAT	NUMC	3	0	Integration Engine: Adapter Status
19	PARENTMSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
20	CHILDCOUNT	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
21	CLIENT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
22	ADMINUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
23	GEN_ENTRY	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
24	MANUALSTAT	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
25	RETRYCOUNT	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
26	ITFACTION	☐	SXMSITFACT	SXMSITFACT	CHAR	4	0	Integration Engine: Action for Interface
27	COMMITACT	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
28	EO_REFID_I	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
29	EO_REFVL_I	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
30	ADAPT_TP_I	☐	SXMSPSTYPE	SXMSPSTYPE	CHAR	10	0	Pipeline Service Type
31	REST_VERS	☐	SXMSLSQNBR		NUMC	3	0	Sequence Number for a Message Log ID
32	EO_REFID_O	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
33	EO_REFVL_O	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
34	QUEUEINT	☐	TRFCQNAM	TRFCQNAM	CHAR	24	0	Name of tRFC Queue
35	REF_TO_MSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
36	REF_TO_REC_MSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
37	ACK_STATE	☐	SXMSPACKSTAT	SXMSPACKSTAT	NUMC	3	0	XI: Acknowledgment Status
38	REORG	☐	SXMSREORG	SXMSREORG	CHAR	3	0	Reorganization Status
39	RND_NUMBER	☐	SXMSRNDNUM	SXMSRNDNUM	NUMC	2	0	Random Number for Integration Engine Messages
40	VERS	☐	SXMSLSQNBR		NUMC	3	0	Sequence Number for a Message Log ID
41	SECURITY	☐	SXMSSECURITY	SXMSSECURITY	NUMC	1	0	Security Flag
42	WS_HASH_CODE	☐	WS_MSGID_HASH_CODE	WS_MSGID_HASH_CODE	INT4	10	0	Message ID Hash Code
43	RETRYCOUNT_MAN	☐	SXMS_MAN_RETRYCO	SXMS_MAN_RETRYCO	INT4	10	0	Manual Retry Counter
44	USERINFOSTORAGE	☐	USERINFO_GUID	SYSUUID	RAW	16	0	Unique Identifier for Saving USERINFO Metadata
45	USERINFODATA	☐	SXMS_ENGINE_KEY	SYSUUID	RAW	16	0	Key for Engine Look Up Table
46	MSG_SIZE	☐	SXMS_SIZE_MSG	SXMS_SIZE_MSG	DEC	20	0	Message Size
47	BULK_ERROR	☐	SXMS_BULK_ERROR	SXMS_BULK_ERROR	CHAR	1	0	Error in Bulk
48	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
49	.INCLUDE	☐				0	0	Integration Engine: Extended Message Queue (Data)
50	.INCLUDE	☐				0	0	Integration Engine: Sender/Receiver
51	OB_SYSTEM	☐	AIT_SNDR	AIT_SYSTEM	CHAR	60	0	Sending System
52	OB_NS	☐	RM_OIFNS	SAI_NSPCE	CHAR	255	0	Outbound Interface Namespace
53	OB_NAME	☐	RM_OIFNAME	AIT_INTF	CHAR	120	0	Outbound Interface Name
54	OB_PARTY	☐	SXI_PARTY	SXI_PARTY	CHAR	60	0	XI: Communication Party
55	OB_PARTY_TYPE	☐	SXI_PARTY_TYPE	SXI_PARTY_TYPE	CHAR	120	0	XI Partner: Identification Schema
56	OB_PARTY_AGENCY	☐	SXI_PARTY_AGENCY	SXI_PARTY_AGENCY	CHAR	120	0	XI Partner: Agency
57	OB_OPERATION	☐	SXI_OPERATION	SXI_OPERATION	CHAR	120	0	Operation of Service Interface
58	IB_SYSTEM	☐	AIT_RCVR	AIT_SYSTEM	CHAR	60	0	Receiving System
59	IB_NS	☐	RM_IIFNS	SAI_NSPCE	CHAR	255	0	Inbound Interface Namespace
60	IB_NAME	☐	RM_IIFNAME	AIT_INTF	CHAR	120	0	Inbound Interface Name
61	IB_PARTY	☐	SXI_PARTY	SXI_PARTY	CHAR	60	0	XI: Communication Party
62	IB_PARTY_TYPE	☐	SXI_PARTY_TYPE	SXI_PARTY_TYPE	CHAR	120	0	XI Partner: Identification Schema
63	IB_PARTY_AGENCY	☐	SXI_PARTY_AGENCY	SXI_PARTY_AGENCY	CHAR	120	0	XI Partner: Agency
64	IB_OPERATION	☐	SXI_OPERATION	SXI_OPERATION	CHAR	120	0	Operation of Service Interface
65	.INCLUDE	☐				0	0	Integration Engine: Message Reference to Job System
66	JOB_ID	☐	SXMSJOB		CHAR	32	0	Job ID
67	STATUS	☐	SXMSMSGREFSTATUS	SXMSMSGREFSTATUS	CHAR	1	0	Job Processing Status
68	.INCLUDE	☐				0	0	XML Message Broker: Message Queue (Incorrect Entries)
69	ERRCAT	☐	SXMSERRCAT	TEXT20	CHAR	20	0	XI: Error Category
70	ERRCODE	☐	SXMSERRID		CHAR	30	0	XI: Error ID
71	ERRLABEL	☐	SXMSERRLABELTXT	SXMSERRLABELTXT	CHAR	255	0	XI: Status Detail: Description

History

Last changed by/on	SAP	20141013
SAP Release Created in	200_620