topic Re: Checking FAX/Email (SOST) via ABAP or Function Module in Application Development and Automation Discussions

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

Former Member — Thu, 18 Jan 2007 13:04:30 GMT

Hi.

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?

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

Former Member — Thu, 18 Jan 2007 13:22:22 GMT

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

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

Former Member — Thu, 18 Jan 2007 13:29:18 GMT

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?

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

Former Member — Thu, 18 Jan 2007 13:51:17 GMT

Hi,

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

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

Former Member — Thu, 18 Jan 2007 13:52:05 GMT

Hi,

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

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

Former Member — Thu, 18 Jan 2007 15:30:00 GMT

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.

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

Former Member — Thu, 12 Apr 2007 10:10:25 GMT

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