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

Transaction SOST performance issue

Hi,

The execution of SOST tcode raises performance issue as it takes up too long time to generate the report.

I guess deletion of unwanted records from SOST tabel will help to improve.

Before deleting it I need to know what are the data that populates this table.Is it system generated messages,mails,faxes or any other types.

If it is SAP mails, then there are few standard Inbox reorg programs which can be used to delete data from relevant tables including SOST table.But even this does not helping.As there are still records left out in SOST table.

If user were to distinguish the types of data and then delete ,it how it can be done?

Please come up with your valuable suggestion

Thanks,

Priya

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on May 11, 2005 at 03:38 PM

    If you look at the code, SOST is nothing but a big select statement with a bunch of joins accross the tables SOOS, SOES, SOOD, SOST and SOSC.

    The data that is there in these tables pertain to messages that need to go out of the SAP environment to external systems/applications. Communication method tells you all the different types of data that it selects.

    SAP mails per se doesn't have to be here unless it involves sending mails out to internet(ie outside of SAP). So even if the users delete it from their inboxes it is not going to help.

    I would imagine you don't need to keep the successfully sent ones in the system anymore. Similarly you may not want to keep any messages that are say a year or more older. The best way to deal with it is to archive the data. You can schedule a job to do that for the program RSSOSOOS.

    Hope this helps,

    Srinivas

    PS; I think you accidentally created two posts with the same title. Please close the other one.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2005 at 01:15 AM

    Hi

    This is a similar question to above....in our QA system there are alot of email generated and in status waiting. We don't want all these emails to be sent. Is there away to schedule a job that will delete the mails with waiting status older than a certain date.

    Thanks

    Jim

    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.