topic Re: Dynamic program SOST in Application Development and Automation Discussions

Dynamic program SOST

Former Member — Fri, 10 Jul 2015 13:52:59 GMT

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

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 14:09:34 GMT

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.

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 14:19:57 GMT

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

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 14:27:09 GMT

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

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 14:34:40 GMT

Thanks Rudra,

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

Thank you.

Amine

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 14:53:48 GMT

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

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 15:22:19 GMT

Thank Rudra,

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

Amine

Re: Dynamic program SOST

Former Member — Fri, 10 Jul 2015 15:42:52 GMT

Yes Amine.