Where to see SOST contents

[Former Member]

Hello,

Does anyone know the table where the email content of emails going out from SOST is stored?

The problem is, the document title field has the same value for all outgoing emails(document number is not mentioned) and we have thousands of emails to scan through. It is not any attachment or anything, just a simple email to outlook.

I am trying to find one particular document in thousands of emails sent and I can't do it through SOST.

So, if I have the table name for it, I can directly put document number and search for it.

Any ideas?

Regards,

Snehal

[dharmenda_kumar]

hi ,

I know its a very old post..

Recently i found one such requirement and prepared a solution for it..

here is the code approach:

call this FM :  SX_SNDREC_SELECT with relevant filter criteria to select the list of mail request with all relevant key under the exporting parameter :  sndrecs.

Under  sndrecs : there are there fields objtp, objyr and objno. create a table of unique fields of these fields from the table sndrecs as  object_id table.

Using the each key of object_id call the perform :

PERFORM data_select(sapfsso1) TABLES objhead

                                          objcont

                                          objpara

                                          objparb

                                    USING object_id

                                          rcode.

the objcont table will contain the content of the mail body.

>> here is the sample code for the function module prepared for the same:

FUNCTION zdk_sost_content.

*"----------------------------------------------------------------------

*"*"Local Interface:

*"  EXPORTING

*"     REFERENCE(ET_MAIL_CONTENT) TYPE  ZDKT_MAIL_CONTENT

*"     REFERENCE(SNDRECS) TYPE  SOXSP2TAB

*"----------------------------------------------------------------------

*DATA SND_ART       TYPE SX_ADDRTYP.

   DATA snd_date      TYPE sxdatrngt.

*DATA SND_TIME      TYPE SXTIMRNGT.

*DATA DEL_DATE      TYPE SXDATRNGT.

*DATA DEL_TIME      TYPE SXTIMRNGT.

   DATA status        TYPE soststatus.

   DATA notifications TYPE sx_boolean VALUE 'X'.

*DATA SENDER        TYPE SXSENDERRNGT.

   DATA maxsel        TYPE tbmaxsel VALUE 1000.

*DATA ALL_WAITING   TYPE SX_BOOLEAN.

*DATA DESCRIPTION   TYPE SO_OBJ_DES.

*  DATA sndrecs       TYPE soxsp2tab.

   APPEND INITIAL LINE TO snd_date ASSIGNING FIELD-SYMBOL(<lfs_snd_date>).

   <lfs_snd_date>-sign = 'I'.

   <lfs_snd_date>-option = 'BT'.

   <lfs_snd_date>-low = sy-datum - 1 .

   <lfs_snd_date>-high = sy-datum .

   status = 'XXXXXXXX'.

   CALL FUNCTION 'SX_SNDREC_SELECT'

     EXPORTING

*     SND_ART       = SND_ART

       snd_date      = snd_date

       status        = status

       notifications = notifications

*     SENDER        = SENDER

       maxsel        = maxsel

*     ALL_WAITING   = 'X'

*     DESCRIPTION   = DESCRIPTION

     IMPORTING

       sndrecs       = sndrecs.

   DATA sndrecsl       TYPE soxsp2tab.

   sndrecsl = sndrecs.

   SORT sndrecsl BY objtp objyr objno.

   DELETE ADJACENT DUPLICATES FROM sndrecsl COMPARING objtp objyr objno.

   DATA : objcont TYPE STANDARD TABLE OF   soli .

   DATA : objhead TYPE STANDARD TABLE OF  soli .

   DATA : objpara TYPE STANDARD TABLE OF  selc .

   DATA : objparb TYPE STANDARD TABLE OF soop1 .

   DATA : object_id TYPE soodk.

   DATA : rcode TYPE sysubrc.

*  DATA : lt_mail_content TYPE ZDKT_MAIL_CONTENT.

   LOOP AT sndrecsl ASSIGNING FIELD-SYMBOL(<lfs_sndrecsl>).

     CLEAR : object_id, objhead, objcont,objpara, objparb.

     object_id-objtp = <lfs_sndrecsl>-objtp.

     object_id-objyr = <lfs_sndrecsl>-objyr.

     object_id-objno = <lfs_sndrecsl>-objno.

     PERFORM data_select(sapfsso1) TABLES objhead

                                          objcont

                                          objpara

                                          objparb

                                    USING object_id

                                          rcode.

     APPEND INITIAL LINE TO et_mail_content ASSIGNING FIELD-SYMBOL(<lfs_mail>).

     <lfs_mail>-object_id = object_id.

     <lfs_mail>-objcont = objcont.

   ENDLOOP.

*  et_mail_content = lt_mail_content.

ENDFUNCTION.

.....................

ZDKT_MAIL_CONTENT: table type of ZDKS_MAIL_CONTENT,

ZDKS_MAIL_CONTENT:

OBJECT_ID	SAPoffice: Definition of an Object (Key Part)	SOODK
OBJCONT	Objcont and Objhead as Table Type	SOLI_TAB

This is one of the possible approach. to resolve such requirement.

[Former Member]

Check if you can find anything in the following

SOOS, SOOD, SOES, SOST and SOSC tables.

Regards,

PR.

[Former Member]

Nope, none of the tables have the detailed content which you see, when you open any message in SOST!

Is it not stored in tables? Is there any other way of storing them in system?

Regards,

Snehal

[Former Member]

Any ideas?

[Former Member]

Hi,

You can check the trace of all these messages in TCode SCOT.

Goto Utilities Menu--> Trace selection.

Regards,

Sachin

[Former Member]

Thanks Sachin. But, I dont' think I get you. In SCOT, I do not have messages which were sent a week back?

Please clarify.

Regards,

Snehal

[Former Member]

Any suggestions?

Regards,

Snehal

[former_member183819]

Hi Snehal,

Sachin already answered your query.

for more detail Note 567975 - Hidden folder: Reorganization

regards

Muthu

[Former Member]

Hello Everyone, Thank you for your replies.

When I try to see the trace through SCOT - Utilities -> Trace -> Internal Trace I get nothing at all!

The trace is blank!

Also, I went through the notes suggested but all i could find that the details of hte content of SOST are in hidden folders and not in any tables.

All of the report names mentioned in the Note suggested like RSSODFRE are reports for deleting the contents from SOST, which I absolutely do not want.

Let me again explain my situation again - I go in SOST, see several outgoing send requests there, through the "Document Title" filed, I can't make out, which is the exact document I am looking for, so I have to click on each send request and then click on "Display Document" . Rather than doing this for thousands of document I would prefer to see it through some table/report etc.

Please let me know, if anyone can give me the exact details of how to see the entire content without going into SOST.

Regards,

Snehal

[Former Member]

I found out, there is no way this can be done.

Thank you everyone for your help,

Snehal

[Former Member]

Hi,

Use Table SOOD.

Regards,

Sachin