/MRSS/D_ALERTS SAP (Alerts) Table details

Dictionary Type: Table
Description: Alerts




ABAP Code to SELECT data from /MRSS/D_ALERTS
Related tables to /MRSS/D_ALERTS
Access table /MRSS/D_ALERTS




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

/MRSS/D_ALERTS is a standard SAP Table which is used to store Alerts data and is available within R/3 SAP systems depending on the version and release level.

The /MRSS/D_ALERTS table consists of various fields, each holding specific information or linking keys about Alerts data available in SAP. These include ALERT_GUID (GUID), MSGID (Message Class), MSGNR (Message Number), MSGTYPE (Message Type).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP /MRSS/D_ALERTS 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
ALERT_GUIDGUID /MRSS/T_GUIDRAW16SYSUUID
MSGIDMessage Class SYMSGIDCHAR20Assigned to domainARBGB
MSGNRMessage Number SYMSGNONUMC3SYMSGNO
MSGTYPEMessage Type SYMSGTYCHAR1SYCHAR01
VALID_FROMUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
MSGVAR1Message Variable SYMSGVCHAR50SYCHAR50
MSGVAR1_IS_TSTMPCheckbox XFELDCHAR1XFELD
MSGVAR2Message Variable SYMSGVCHAR50SYCHAR50
MSGVAR2_IS_TSTMPCheckbox XFELDCHAR1XFELD
MSGVAR3Message Variable SYMSGVCHAR50SYCHAR50
MSGVAR3_IS_TSTMPCheckbox XFELDCHAR1XFELD
MSGVAR4Message Variable SYMSGVCHAR50SYCHAR50
MSGVAR4_IS_TSTMPCheckbox XFELDCHAR1XFELD
CREATED_ATUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
CREATED_BYUser Name SYUNAMECHAR12SYCHAR12
CHANGED_ATUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
CHANGED_BYUser Name SYUNAMECHAR12SYCHAR12
CONFIRMDConfirmation /MRSS/T_ALERT_CONFRIMDCHAR1/MRSS/_CONFIRMD
ALERT_TYPEAlert Type /MRSS/T_ALERTTYPENUMC3Assigned to domain/MRSS/_ALERTTYPE
DEL_FLGBoolean Variable /MRSS/T_BOOLEANCHAR1/MRSS/_BOOLEAN

Key field Non-key field



How do I retrieve data from SAP table /MRSS/D_ALERTS using ABAP code

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

SELECT SINGLE *
FROM /MRSS/D_ALERTS
INTO CORRESPONDING FIELDS OF WA_/MRSS/D_ALERTS
WHERE...

How to access SAP table /MRSS/D_ALERTS

Within an ECC or HANA version of SAP you can also view further information about /MRSS/D_ALERTS 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!