SAP4TECH

SAP and ABAP Free Tutorials
Menu
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
  • SAP Functional
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP HANA
  • SAP BW
  • SAP CRM
  • SAP SRM
  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy and Cookie Policy

SAP4TECH » SAP ST22 SNAP – The SAP Tables for Dumb Message

ABAP Snippets

SAP ST22 SNAP – The SAP Tables for Dumb Message

June 30, 2016 John

SAP ST22 SNAP Table: SAP Dumb Table for Error. This post will explain the SAP Table behind the SAP Runtime Errors Tcode ST22.

It will help you to answer the following question: how to get the errors from snap database table in sap ABAP.

Table of Contents

  • SAP ST22 SNAP Table
  • SAP ST22 SNAP Query Table
  • Delete Short Dumps from the SNAP Table
    • Method 1 : Dump analysis: Reorganization
    • Method 2 : Drop and recreate the SNAP table
    • Method 3 : Reorganization program RSSNAPDL

SAP ST22 SNAP Table

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 another important table containing the ABAP Runtime Error Texts.

SAP ST22 SNAP Query Table

ABAP
1
2
3
4
5
6
7
8
9
10
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.

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.

Method 1 : Dump analysis: Reorganization

Go to transaction code ST22. Choose to reorganize. You can now select all short dumps older than n days for deletion.

CAUTION: If a large amount of records is 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

The source: Delete dumb for SNAP Table

Prev Article
Next Article
Tags:SAP Tables SAP Transaction Codes

Related Articles

JSON and ABAP
JSON (JavaScript Object Notation) is a lightweight data-interchange format. It …

List of The most important JSON ABAP Classes in SAP

ABAP Workbench
SAP BADI: Enhancement of a SAP Standard Program/Class/function are a …

How To find SAP BADI and User exit for any SAP transaction

Search on SAP4TECH

The Most Populars

  • The Most Important SAP ISU Tables
    The Most Important SAP ISU Tables
  • SAP Users Tables
    SAP Users Tables (for Personal, Logon, and Address Data)
  • List of SAP Purchase Order Tables in SAP MM SAP PO Tables
    SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • Full list of SAP Movement Types
    SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP GL Account Tcodes SAP GL Account Tables
    The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables
    SAP BOM Tables for BOM Header, Items and components and Category

Related Posts

  • domino 163522 1280 e1442441105680
    Full ABAP Program How to Delete Customer Address in SAP
  • SAP CRM e1459022344657
    Sample ABAP Program to Update Customer with CMD_EI_API
  • SAP GUI for HTML e1495658219900
    SAP GUI for HTML: Menu and Toolbar Parameters
  • Online Text Repository OTR Tcodes Tables Function and Translation
    SAP Online Text Repository (OTR): SAP OTR Tcodes, Tables, Function and Translation
  • Mime Type in SAP
    How to retrieve Mime Type of File in ABAP ? ( SAP Mime Types Tables)

SAP4TECH

SAP and ABAP Free Tutorials

Trending Posts

  • The Most Important SAP ISU Tables
  • SAP Users Tables (for Personal, Logon, and Address Data)
  • SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables for BOM Header, Items and components and Category

The Most Recents

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)

Search

SAP Tutorials by Topics

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books
Copyright © 2021 SAP4TECH

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy