Skip to Content
author's profile photo Former Member
Former Member

Where to see SOST contents

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2009 at 11:23 AM

    Hi,

    Use Table SOOD.

    Regards,

    Sachin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2009 at 11:28 AM

    Check if you can find anything in the following

    SOOS, SOOD, SOES, SOST and SOSC tables.

    Regards,

    PR.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2016 at 04:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.