/MRSS/D_ALERTS SAP table for – Alerts

Here we would like to draw your attention to /MRSS/D_ALERTS table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). /MRSS/D_ALERTS is a SAP standard transparent table used for storing Alerts related data in SAP. It comes under the package /MRSS/SGA.

SAP /MRSS/D_ALERTS table

Table /MRSS/D_ALERTS technical data

Table/MRSS/D_ALERTS
Data storingAlerts
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_ALERTS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /MRSS/D_ALERTS table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • MSGVAR1_IS_TSTMP
    Its data type is C (Character String) with field length 2
  • MSGVAR2
    Its data type is C (Character String) with field length 100
  • MSGVAR2_IS_TSTMP
    Its data type is C (Character String) with field length 2
  • MSGVAR3
    Its data type is C (Character String) with field length 100
  • MSGVAR3_IS_TSTMP
    Its data type is C (Character String) with field length 2
  • MSGVAR4
    Its data type is C (Character String) with field length 100
  • MSGVAR4_IS_TSTMP
    Its data type is C (Character String) with field length 2
  • CREATED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CREATED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • ALERT_GUID
    Its a key field. Its data type is X (Byte string) with field length 16
  • CHANGED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • CONFIRMD
    Its data type is C (Character String) with field length 2
  • ALERT_TYPE : Char 20
    Its data type is N (Character String with Digits Only) with field length 6
  • DEL_FLG
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /MRSS/T_ALERT_EXT
  • MSGID : Application Area
    Its data type is C (Character String) with field length 40
  • MSGNR
    Its data type is N (Character String with Digits Only) with field length 6
  • MSGTYPE
    Its data type is C (Character String) with field length 2
  • VALID_FROM : Valid From (Time Stamp)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VALID_TO : Valid To (Time Stamp)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MSGVAR1
    Its data type is C (Character String) with field length 100