SAP ST22 SNAP – The SAP Tables for Dumb Message

SAP ST22 SNAP Table: SAP Dumb Table for Error. This post will explain the SAP Table behind the the SAPRuntime Errors Tcode ST22.
It will help your to answer the following question: how to get the errors from snap database table in sap abap.


The SAP Table behind the ST22 the SAP Tcode for Runtime Errors is SNAP

If you want to Query the ST22 table, use rather the SAP Projection view SNAP_BEG.

SNAPT Table is an other important table containing the ABAP Runtime Error Texts.

SAP ST22 SNAP Query Table

source: Querying table for content in ST22

Delete Short Dumps from the SNAP Table

Up to SAP Note 11838 , there is  3 different methods how to clean up the ST22 or SNAP tables in SAP.

Check also   SAP FSCM Overview

Method 1 : Dump analysis: Reorganization

• Go to transaction code ST22. Choose ‘Reorganize‘. You can now select all short dumps older than n days for deletion.
CAUTION: If a large amount of records are deleted simultaneously during the reorganization, ORACLE error ora1562 ‘failed to extend rollback segment …’ may occur. In this case, refer to error Note 6328.

Method 2 : Drop and recreate the SNAP table

• With the database utility transaction code SE14, you can drop and recreate the SNAP table.
CAUTION: When you do this, ALL short dumps are deleted.

Method 3 : Reorganization program RSSNAPDL

• To avoid database problems, this program deletes old short dumps gradually from the SNAP table unless they are selected for retention. With standard setting all short dumps that are older than 7 days and that are not flagged are deleted. Since this program occupies the database when large datasets are processed, it should be scheduled to run overnight. Execute RSSNAPDL in transaction SE38

Check also   Different Types of SAP BW Extractors Explained: Content Vs Generic Extractors

the source: Delete dumb for SNAP Table


Leave a Reply

Your email address will not be published. Required fields are marked *