Skip to Content

find table relationship in sost tcodes

Aug 08, 2017 at 06:01 PM


avatar image

Is there a way to find out the table relationships used by tcode sost

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Santhosh Hanumanthappa Aug 08, 2017 at 06:03 PM

we found that truncating tables SOSC(containing waiting status entries) and SOES(containing error/sent entries) cleared all the queues in the SOST tcode. There are other tables related to this tcode which we are not sure makes any sense to truncate those such as DDLOG – Log table SOST – Log table USR05 – Contains user list. SPERS_OBJ - SAP Personalization object repository Table.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Santhosh,

You should be extremely careful with truncating tables if you are not absolutely certain of how they relate to each other. For instance, DDLOG and USR05 are used by many applications and transaction codes, for numerous functions. There are times when it makes sense to clear DDLOG -- on the target system after a system copy, for instance -- but otherwise you would be best served by leaving it alone.

So was your question really about how to clear old queue entries in SOST, rather than how to find what tables the tcode referenced?