SOST filter configuration

1. For API, you need to populate the filter with following.

Basically, this will extract messages with status history either 701, 702, 073 or 723 which mean that the message has been transmitted successfully.

The format of the field is <field name>_<table name>.

SOST Field NameCounterInclude / ExcludeOptionLowHigh
MSGNO_SOST1IEQ701
MSGNO_SOST2IEQ702
MSGNO_SOST3IEQ073
MSGNO_SOST4IEQ723
OBJDES_SOOD1ICPAPI Alphapharm Daily Sales – *

I think size of the attachment should be checked in Splunk. Use field ATTLEN_SOOD and the field unit is in byte.

SOST filter configuration

2. If you want to extract only the TRANSMITTED messages

SOST filter configuration

3. If you want to extract only messages WITH ERRORS

SOST Field NameCounterInclude / ExcludeOptionLowHigh
MSGNO_SOST1IBT801899
MSGNO_SOST2IBT601698

4. How do I know the numbers?

Unfortunately, I had to look at SOST source code.

SOST filter configuration

5. CAUTION: Not all fields that you can see in transaction SOST can be used as a filter directly.

5.1. Sender field is not a field in the database but the sender is derived from field SNDTP, SNDYR, SNDNO of table SOOS.

SOST filter configuration

So you can use the above fields in SOST filter to filter by specific sender.

In N71, if you want to filter by me, create the following.

SOST filter configuration

5.2. Recipient field is not a field in the database but the recipient email address is derived from field RECTP, RECYR and RECNO in table SOOS.

However, you cannot filter by recipient because the RECNO changes all the time although the same recipient is used.

SOST filter configuration

Download PDF version here