SAPListOfMessages

This function includes messages into the sheet. You can select which messages , according to their level of severity, and details should be displayed in the sheet.

The formula consists of 2 parameters and is made up of the following arguments:

Severity
You can enter the following severities: INFORMATION, WARNING, ERROR and CRITICAL.

INFORMATION is the least severe category, CRITICAL the most severe. If you select a severity, all messages are shown which have this severity or higher. If you select WARNING, for example, all messages with severity WARNING, ERROR and CRITICAL are displayed.
Show Details
If you enter FALSE, the messages are listed with severity and short text.
If you enter TRUE, the messages are listed with additional information. The details are listed in the following sequence:
1. Message ID
  
  The message ID is a unique identifier for a message that is valid for the current messages dialog. If the same message is displayed again at a later time, it has a different message ID.
  
  The message ID can be used as identifier in the API methods SAPAddMessage and SAPSuppressMessage.
2. Short Text
  
  The message short text is displayed.
3. Message Class
  
  If the message comes from a BW back-end system, the message class is displayed.
4. ID
  
  For Analysis messages, the notification ID is displayed. For messages from a BW back-end, a concatenation of the message class and the message number is displayed.
5. Severity
  
  The message severity is displayed.
6. Variables: VARIABLE1-VARIABLE4
  
  If the message comes from a BW back-end system, the message can comprise up to four variables to support dynamic message texts.
7. System ID
  
  If the message comes from a BW back-end system, the system ID is displayed.

Example

Cell H11: =SAPListOfMessages("ERROR";FALSE)

In cell H11, all messages with severity ERROR and CRITICAL are displayed with severity and text.