Get sender email using SOOD table

Question

I am trying to get the sender email adress of the entries saved in the table SOOD in SAP. I need to get this info via tables. I have seen that there might be some FM, like so_object_read, that can achieve so, but I need to relate those two fields via tables.

This table stores the info that appears in SCOT trx (SOIN - received messages and SOST sent messages).

Any suggestion?

Thank you so much!

Answer 1

Here is how you can reach message sender if you have SOOD record:

SELECT sost~objtp, sost~objno, sost~objyr, sost~msgv2 
  FROM sood 
  LEFT JOIN sost 
    ON sood~objtp = sost~objtp 
   AND sood~objno = sost~objno 
   AND sood~objyr = sost~objyr 
  INTO TABLE it_sost.

Sender is contained in MSGV2 and recipient in MSGV1 of SOST table.

The same logic should be used with SOIN table.