Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Checking FAX/Email (SOST) via ABAP or Function Module

Former Member
0 Kudos


I'm wanting to check email/fax send status for a given date using Perl SAP::RFC module.

The only way I've found so far of checking is with SAPs own SOST/SOSV but the reports behind these can only be run in dialoq mode i.e. attached to a GUI.

If I try and run via SAP::RFC I get errors to say 'GUI not attached'.

How can I check the status, similar to what SOST would show, without having to actually run the commands?


Former Member
0 Kudos

Um, I may have found the answer in table SOST with field MSGTY.

0 Kudos

Well, nearly there.

If I select recs from SOST with MSGTY=E for a specific date I can get the failed Faxes/emails.

However I then need to determine who the sender was and who the recipient should be, and that info isn't in SOST.

Anyone know which table I should link into?

0 Kudos


You can see the sender and recipient details in SOOS table.

0 Kudos


U can alos use T-Code : SCOT....................

0 Kudos

Wanting to do it all without a logon i.e. via RFC, so trx like SCON/SCOT not viable.

I'll try and use tables SOOS etc, but finding out where everything is stored is proving difficult.

Former Member
0 Kudos

Solved with:

select a.snddat, a.msgv4, c.objdes, c.ownnam, b.rectel, f.name_last, f.name_first

from sapr3.usr21 e, sapr3.adrp f, sapr3.soos b join sapr3.soes a

on b.rectp = a.rectp

and b.recyr = a.recyr

and b.recno = a.recno

join sapr3.sood c

on b.objtp = c.objtp

and b.objyr = c.objyr

and b.objno = c.objno

join sapr3.sost d

on b.rectp = d.rectp

and b.recyr = d.recyr

and b.recno = d.recno

where a.msgty='E'

and a.sndart = 'FAX'

and d.counter = ( select max( counter ) from sapr3.sost

where rectp = b.rectp

and recyr = b.recyr

and recno = b.recno )

and a.snddat >= '$date1'

and a.snddat <= '$date2'

and c.ownnam=e.bname

and e.persnumber=f.persnumber

order by a.snddat