Regarding table name for SOST Transaction data

[Former Member]

Hi SAP Gurus,

Can I please know the table where the data in Transaction SOST are stored.

Please Help,

Tahnks & Regards ,

Pavan.

[former_member480923]

Hi Use the following Function Module

call function 'SX_SNDREC_SELECT'
    exporting
      snd_art       = g_adrtp
      snd_date      = g_date[]
      snd_time      = g_time[]
      status        = soststatus
      notifications = g_stanot
      sender        = g_sel_sender[]
      maxsel        = g_maxsel
      all_waiting   = all_waiting
    importing
      sndrecs       = gt_send_processes
    exceptions
      others        = 0.

u can put a breakpoint in this FM to get the Input parameters whihc will be filled in when u execute SOST Transaction

Hope That Helps

Anirban M.

[Former Member]

hi,

Thanks all for your valuable suggestions.

Can you please tell me in which table I can get the status field. (ie the message is sent or not )

Thanks & Regards,

Pavan.

[mukundkansara]

Hi,

Go through the code i hv given. In that code i hv use tablle 'SOES' where u can get status.

Edited by: Mukund Kansara on Jan 12, 2010 10:34 AM

[former_member480923]

The field is

STATUS	SO_REC_STA	CHAR	12	0	SAPcomm: status of the sent object

Hope That Helps

Anirban M.

[mukundkansara]

If it is 1) ERROR then STATUS range between 601 to 699 and 801 to 899

2) WAITING then STATUS = '751'.

3) IN TRANSIT then STATUS range between '701' to '749'

4) DELIVER then STATUS = '73'.

[Former Member]

Hi Pavan,

check following tables:

SOOS - SAPoffice: send process

SOSC - SAPoffice: Connection table to SAPcomm and SAPconnect

If You need something more, try to look at other tables from package SO.

Regards,

Adrian

[Former Member]

Thanks to all

By the table i am getting all the sendt requests.

My requirement is to get the error requests which are shown in the sost transaction.

Please help,

Pavan.

[Former Member]

Put a break-point into a subroutine send_rec_sel in include LSX11F02 (and also send_rec_sel_wait) and run transaction SOST again. You will see, how the selection is done and also a values of variables going to WHERE condition. Than You can construct some similar select in your program. In this subroutines it looks like this:

select rectp recyr recno from sosc into table lt_sosc
       where sndart in sndart
         and ( wait_date le wait_date or
               ( wait_date =  wait_date and
                 wait_time le wait_time ) )
              and immediatly in l_immediatly.

       select (sel_fields) appending table sndrecs

         from soos as f join soes as g
           on f~rectp = g~rectp
          and f~recyr = g~recyr
          and f~recno = g~recno
              join sood as h
           on f~objtp = h~objtp
          and f~objyr = h~objyr
          and f~objno = h~objno

          for all entries in lt_sost
        where g~rectp = lt_sost-rectp
          and g~recyr = lt_sost-recyr
          and g~recno = lt_sost-recno

          and g~status    in status_ranges
          and g~snddat    in snd_date
          and g~sndtim    in snd_time
          and f~sndtp     ne 'BCS'
          and ( ( f~sndnam in sender and f~fornam = space )
                  or f~fornam in sender )
          and ( f~sndreq = empty_guid
           or  exists ( select * from bcst_sr
                         where os_guid = f~sndreq
                          and to_delete = space ) )
                             .

Regards,

Adrian

[mukundkansara]

Hi

For that try following code , may be it will help you

TYPE-POOLS sosx.

TYPES: BEGIN OF ty_itab,

objtp TYPE soos-objtp,

objyr TYPE soos-objyr,

objno TYPE soos-objno,

fortp TYPE soos-fortp,

foryr TYPE soos-foryr,

forno TYPE soos-forno,

rectp TYPE soos-rectp,

recyr TYPE soos-recyr,

recno TYPE soos-recno,

sndart TYPE soos-sndart,

sndtp TYPE soos-sndtp,

sndyr TYPE soos-sndyr,

sndno TYPE soos-sndno,

sndnam TYPE soos-sndnam,

sndreq TYPE soos-sndreq,

snddat TYPE soes-snddat,

sndtim TYPE soes-sndtim,

msgid TYPE soes-msgid,

msgty TYPE soes-msgty,

msgv1 TYPE soes-msgv1,

msgv2 TYPE soes-msgv2,

msgv3 TYPE soes-msgv3,

msgv4 TYPE soes-msgv4,

scomtp TYPE soes-scomtp,

scomyr TYPE soes-scomyr,

scomno TYPE soes-scomno,

status TYPE soes-status,

adrnr TYPE soes-adrnr,

node TYPE soes-node,

objdes TYPE sood-objdes,

objsns TYPE sood-objsns,

objlen TYPE sood-objlen,

attlen TYPE sood-attlen,

END OF ty_itab.

DATA: itab TYPE STANDARD TABLE OF ty_itab INITIAL SIZE 0.

DATA: status_ranges TYPE sosx_status_range,

snd_date TYPE sxdatrngt,

sender TYPE sxsenderrngt.

DATA: stat LIKE LINE OF status_ranges,

date TYPE sxdatrngl,

send TYPE sxsenderrngl.

stat-sign = 'I'.

stat-option ='BT'.

stat-low = '601'.

stat-high = '699'.

APPEND stat TO status_ranges.

stat-low = '801'.

stat-high = '899'.

APPEND stat TO status_ranges.

date-sign = 'I'.

date-option ='BT'.

date-low = sy-datum - 5.

date-high = sy-datum.

APPEND date TO snd_date.

SELECT f_{objtp f}objyr f_{objno f}fortp

f_{foryr f}forno f_{rectp f}recyr

f_{recno f}sndart f_{sndtp f}sndyr

f_{sndno f}sndnam f_{sndreq g}snddat

g_{sndtim g}msgid g_{msgty g}msgv1

g_{msgv2 g}msgv3 g_{msgv4 g}scomtp

g_{scomyr g}scomno g_{status g}adrnr

g_{node h}objdes h_{objsns h}objlen h~attlen

FROM soos AS f JOIN soes AS g

ON f_{rectp = g}rectp

AND f_{recyr = g}recyr

AND f_{recno = g}recno

JOIN sood AS h

ON f_{objtp = h}objtp

AND f_{objyr = h}objyr

AND f_{objno = h}objno

INTO TABLE itab

WHERE g~status IN status_ranges

AND g~snddat IN snd_date

AND ( ( f_{sndnam IN sender AND f}fornam = space ) OR f~fornam IN sender )

AND g~msgty NE 'X'.

[Former Member]

Find below the tables related to SOST transaction. Are you looking for a specific data?

Tables:- SOST, SOOS, SOPR, SOSTSTATUS.

Thanks,

Ajeet

[Former Member]

Hi All,

I also have a query related to SOST transaction :

1) Please let me the table (or internal table) which will contain the content of the mail.

2)I am working on solution in which i am going to to foward all the triggered mail ( which are visible in SOST) to a particular mail id (lts say support@xyz.com ) by developing a cutom report. I will be great if sombody throw a light as how to prceed.

Thanks & Regards,

Ramesh Kumar Singh

[Former Member]

Hi Ramesh,

By any chance did your issue got resolved.Please let me know if you have solved it

Regards

swathi

[GauthamV]

Check tables SOOD,SOST,SOOS

[Former Member]

Hello,

Check the table SOOD and SO* tables as per your requirement

Vikranth

[Former Member]

Hi,

tables -

---

sost, soos, sopr, sxaddrtype, soststatus.

Hope this helps you,

Regards,

Abhijit G. Borkar

[former_member184703]

The report for SOST is RSSOSOSTSTAT. You can find the details in the report.