SXMSBLKAGG SAP (XMB: Aggregated Data for Package Statistics) Table details

Dictionary Type: Table
Description: XMB: Aggregated Data for Package Statistics




ABAP Code to SELECT data from SXMSBLKAGG
Related tables to SXMSBLKAGG
Access table SXMSBLKAGG




Table field list including key, data, relationships and ABAP select examples

SXMSBLKAGG is a standard SAP Table which is used to store XMB: Aggregated Data for Package Statistics data and is available within R/3 SAP systems depending on the version and release level.

The SXMSBLKAGG table consists of various fields, each holding specific information or linking keys about XMB: Aggregated Data for Package Statistics data available in SAP. These include FROMTIME (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), TOTIME (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), QUEUE (Name of tRFC Queue), BCFG_KEY (Character field, length 32).. 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 empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SXMSBLKAGG 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
MANDTClient ID SYMANDTCLNT3Assigned to domainMANDT
FROMTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
TOTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
QUEUEName of tRFC Queue TRFCQNAMCHAR24TRFCQNAM
BCFG_KEYCharacter field, length 32 CHAR32CHAR32CHAR32
INTERVLENGTHNatural Number INT4INT410INT4
BULKCNTNatural Number INT4INT410INT4
AVGPACKSIZEXMB: Decimal Number 15 digits, 1 decimal point SXMSAVGCNTDEC15(1)
SUMPACKSIZENatural Number INT4INT410INT4
AVGMSGSIZEMessage Size SXMS_SIZE_MSGDEC20SXMS_SIZE_MSG
SUMMSGSIZEMessage Size SXMS_SIZE_MSGDEC20SXMS_SIZE_MSG
AVGMSGSIZEMAPMessage Size SXMS_SIZE_MSGDEC20SXMS_SIZE_MSG
SUMMSGSIZEMAPMessage Size SXMS_SIZE_MSGDEC20SXMS_SIZE_MSG
AVGEXECTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
SUMEXECTIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
TIMEOUTNatural Number INT4INT410INT4
EMPTYNatural Number INT4INT410INT4
ERRORNatural Number INT4INT410INT4
AVGPACKSIZEINIXMB: Decimal Number 15 digits, 1 decimal point SXMSAVGCNTDEC15(1)
SUMPACKSIZEININatural Number INT4INT410INT4
DELSUMNatural Number INT4INT410INT4
EVENT00Natural Number INT4INT410INT4
EVENT01Natural Number INT4INT410INT4
EVENT02Natural Number INT4INT410INT4
EVENT03Natural Number INT4INT410INT4
EVENT04Natural Number INT4INT410INT4
EVENT05Natural Number INT4INT410INT4
EVENT06Natural Number INT4INT410INT4
EVENT07Natural Number INT4INT410INT4
EVENT08Natural Number INT4INT410INT4
EVENT09Natural Number INT4INT410INT4
EVENT10Natural Number INT4INT410INT4
EVENT11Natural Number INT4INT410INT4
EVENT12Natural Number INT4INT410INT4
EVENT13Natural Number INT4INT410INT4
EVENT14Natural Number INT4INT410INT4
EVENT15Natural Number INT4INT410INT4
EVENT16Natural Number INT4INT410INT4
EVENT17Natural Number INT4INT410INT4
EVENT18Natural Number INT4INT410INT4
EVENT19Natural Number INT4INT410INT4
EVENT20Natural Number INT4INT410INT4
EVENT21Natural Number INT4INT410INT4
EVENT22Natural Number INT4INT410INT4
EVENT23Natural Number INT4INT410INT4
EVENT24Natural Number INT4INT410INT4
EVENT25Natural Number INT4INT410INT4
EVENT26Natural Number INT4INT410INT4
EVENT27Natural Number INT4INT410INT4
EVENT28Natural Number INT4INT410INT4
EVENT29Natural Number INT4INT410INT4
EVENT30Natural Number INT4INT410INT4
AGG_LEVELNatural Number INT4INT410INT4

Key field Non-key field



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

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

SELECT SINGLE *
FROM SXMSBLKAGG
INTO CORRESPONDING FIELDS OF WA_SXMSBLKAGG
WHERE...

How to access SAP table SXMSBLKAGG

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!