Dynamic program SOST

[amine_lamkaissi]

Hi experts,

I would like to create a dynamic program wich recovers the sending status of mails from t-code SOST.

I found the program RSSOSOSTSTAT which corresponds to SOST, but how can i use it in my program to launch a particular date and an hour and then get the status?

Thanks.

Amine

[Former Member]

Hi Amine,

The data you are looking for are mostly available in table SOOS and SOEC.

Run an SQL trace ( ST05 ) on SOST transaction . You will get to know exactly how the data is fetched.

R

[amine_lamkaissi]

Hi Rudra,

Thanks for your answer.

I tried the SQL trace, i had too many lines and i couldn't found the information you talking about.

I was trough table SOST, buut i can't find the statuts (yoh know the green or red sign that we get in SOST)

By the way, i can't find in my system table SOEC either.

Thanks.

Amine

[Former Member]

Sorry my bad. It was typo. Table SOES contains the status. Field STATUS.

[amine_lamkaissi]

Thanks Rudra,

Can you send me the screenshot of the SQL trace that you got please?

Thank you.

Amine

[Former Member]

Hi Amine,

Please find attached. (ST05.xls)

Also the "Explain" part which should help to to build the query. There is a JOIN between table SOOS and SOES

[amine_lamkaissi]

Thank Rudra,

I have just a question, normally all the mails that are sent from SAP have to be displayed in SOST right?

Amine

[Former Member]

Yes Amine.