Querying table for content in ST22.

[former_member199653]

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

[Former Member]

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

[former_member199653]

Hey Raj,

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

[Former Member]

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

[former_member199653]

WOW great help! thanks and full points awarded!

[Former Member]

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

Thanks,

Rahul

[former_member199653]

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?