topic Re: Querying table for content in ST22. in Application Development and Automation Discussions

Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 03:29:56 GMT

Dear all,

I have a requirement to gather certain abap short dump e.g. like only Error Id is TIME_OUT into an xls sheet. System throws out nearly 100+ TIME_OUT error each day and we want to put that into an xls sheet. So I?m thinking to write an abap but I need help with getting started with it. Can someone out there show me the way? thanks

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 04:37:24 GMT

This is the query which will help you pull up the report.

select * from snap_beg into wa_snap_beg
            where seqno = '000'
            and   datum in s_datum
            and   uzeit in s_uzeit
            and   ahost in s_ahost
            and   modno in s_wpid
            and   uname in s_uname
            and   mandt in s_mandt
            and   xhold in s_xhold
            order by datum descending uzeit descending.

Please reward points,

Thanks,

Rahul

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 05:42:15 GMT

Hey Raj,

Helpful answer, thanks. Another question though, how do i know if its a time_out error?

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 06:15:50 GMT

Hi,

The field in ST22 pointed me to the table SNAPT. If you check snapt table for Language = EN and ABAP Runtime Error = 'TIME_OUT', you will get the answer. This table should be linked to the previous table in some way.

I hope that was helpful.

Kindly reward me points,

Rahul

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 06:21:06 GMT

WOW great help! thanks and full points awarded!

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 06:26:55 GMT

Are you sure you have awarded points? It still hasn't reflected for me..

Thanks,

Rahul

Re: Querying table for content in ST22.

Former Member — Tue, 22 Apr 2008 06:32:45 GMT

there you go...

btw, since i'm writing to you again, table SNAP_BEG doesnt really provide alot details does it?

i need additional info from section User, transaction like Transaction, program and user Id and also details from Information on where termination occurred

any help on this?