SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




Install SAP Free


Delete Entries in NAST Table using RSCLNAST ABAP Program

To delete NAST entries in SAP system, developers can run RSCLNAST ABAP program. RSCLNAST enables to delete data from NAST table where output message status records are stored. ABAP report RSCLNAST provides a selection screen which enables SAP developer to choose the NAST entries to delete using output application, object key, output type (output message type), transmission medium of output message, etc. These selection criteria makes deleting output status records in NAST table easier.

Recently, I had to delete incorrectly processed output messages from productive SAP system. I experienced that using RSCLNAST ABAP report is very handy for the deletion of NAST entries that cause problems. Later on I had to trigger output determination procedure for creation of deleted NAST entries for billing documents (invoices) in our SD system. Now in this SAP tutorial, I want to show you how you can use RSCLNAST ABAP program in case you need to delete output messages in SAP.

Please note that this ABAP program is deletes entries in NAST table, so take care of consistency of your application before executing on your productive systems. RSCLNAST will delete output messages in NAST table without checking if they're processed correctly, or processed incorrectly or waiting in unprocessed status if they match the criteria you provide in selection screen.

Call transaction SE38 to activate ABAP Editor initial screen. Type the RSCLNAST ABAP report.

RSCLNAST ABAP program to delete NAST output messages

RSCLNAST is a standard ABAP report in SAP systems. We are now ready to execute and run ABAP program titled "Report for Deleting Output Status Records (Note Consistency)" by pressing F8

delete data from NAST ABAP table in SAP

Provide the required information to filter ABAP NAST table entries. This will enable us to delete NAST entries we want to remove from NAST table.

RSCLNAST select screen to delete NAST entries

As ABAP developers will realize, there are 3 options for the execution of RSCLNAST program. Normal deletion process,
Simulation only, no deletion,
Confirm each deletion options

Normal deletion process can be selected if you want to delete NAST entries or output messages matching with your filter criterias at once.
Confirm each deletion selection will request the executing SAP user's approval for each NAST record one by one before removing it from ABAP NAST table.
If you just want to test the report, choose the Simulation only option for a test run.

SAP SD output message deletion from NAST ABAP table

When DELETE process is approved the ABAP codes in CLEANSWEEP form routine is executed. I think is is useful to see the ABAP codes in this form routine

FORM CLEANSWEEP USING INAST STRUCTURE NAST.

DATA: TDNAME LIKE THEAD-TDNAME,
 L_MESSAGE TYPE SWC_OBJECT.
SWC_CONTAINER LT_CONTAINER.
* CLEAR PROTOCOL
IF NOT INAST-CMFPNR IS INITIAL.
 CALL FUNCTION 'NAST_PROTOCOL_DELETE'
  EXPORTING
   NR = INAST-CMFPNR
  EXCEPTIONS
   CALLED_WITHOUT_VALUES = 01.
ENDIF.
* clear mailtexts
TDNAME = INAST(66).
IF INAST-NACHA = '7'.
* delete object (where applicable)
 IF INAST-TDNAME NE SPACE.
  SWC_CREATE_OBJECT L_MESSAGE 'MESSAGE' INAST-TDNAME.
  SWC_CALL_METHOD L_MESSAGE 'Delete' LT_CONTAINER.
 ENDIF.
* delete mailtext
 CALL FUNCTION 'DELETE_TEXT'
  EXPORTING
* CLIENT = " SY-MANDT
   ID = 'BEWG'
   LANGUAGE = SY-LANGU
   NAME = TDNAME
   OBJECT = 'OCS'
   SAVEMODE_DIRECT = 'X'
* TEXTMEMORY_ONLY = " ' '
  EXCEPTIONS
   NOT_FOUND = 01.
ENDIF.
* CLEAR TABLE NAST
MOVE-CORRESPONDING INAST TO NAST.
DELETE NAST.

ENDFORM.

If ABAP developers want to see all codes of the ABAP program RSCLNAST, they can display source codes in ABAP Editor using SAP transactions SE80 or SE38

delete output message NAST entries using ABAP program






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table






Related Articles and Tutorials(http://www.kodyaz.com/sap-abap/delete-entries-in-nast-table-using-abap-program.aspx)
Convert Smartform to PDF in Print Preview Mode
SAPScript Transaction Codes
Free Adobe LiveCycle Designer Download
Change Output Condition Records
Check Existence using ABAP SELECT
Create Business Object in SAP
Delete All Data from SAP Database Table
How to Debug Popup Screen in ABAP
ABAP LOOP Statement with At New and At End
How to Upload Data to SAP from Excel File using alsm_excel_to_internal_table Function Module
ABAP - Create Hierarchy Tree List using rs_tree_construct, rs_tree_list_display and snodetext
ABAP Tutorial - ABAP String Split Example Code
Upload Data from Excel File in ABAP using TEXT_CONVERT_XLS_TO_SAP
Create CL_GUI_ALV_GRID ALV Grid Column Header using ABAP Data Element
Email Spool Request using SAPOffice - Spool to PDF
How to Create SAPScript Text using SO10 Transaction Code
ALV Grid Color - Table Row Background Color in ALV List
SAP ABAP Tutorial - ALV Grid Example with cl_gui_alv_grid and Screen Painter
SAP Invoice Output Determination Analysis for Not Created Output Message
SAP Smartforms - How to Call Smartform within ABAP Program
SAP Smartforms Table for Sales Order and Invoice Outputs
SAP Smartforms Tutorial - How to Create Smartform
SAP Smartforms Tutorial - Table Calculations using Count
SAP Smartforms Tutorial - Table Calculations using Sum Total
ABAP Tutorial - SAP Split and ABAP Split String Function
SAP Tutorial - Convert Spool Request to PDF File using RSTXPDFT4 ABAP Report
Set Default Single Values List for SAP Selection Screen Parameter
ABAP Debugging using Log Point and Break Point
ABAP RegEx for ABAP Regular Expression to fetch Date from String
ABAP Runtime Error ST22 Transaction using Short Dump Analysis
ABAP Shared Memory Objects Tutorial with Sample ABAP Code
ABAP Try Catch for exception is neither caught Code Inspector Error
Add Year, Month or Day to Date Variable in ABAP using RP_CALC_DATE_IN_INTERVAL
Read Address Data using FM ADDR_GET instead of Querying ADRC Table
Adobe Forms Table Header is Missing After Second Page
ABAP Authority-Check Object For User Other Than Current
SAP Code Inspector for ABAP Break-Point Statement
Call Function Module using RFC Destination in ABAP
CALL_FUNCTION_NOT_FOUND ABAP Run Time Error
Message no XS826: Cannot process message; no node determined for 76550052
Complex Conditions in SAP Smartform with AND/OR
How to Spell Numbers using ABAP Spell_Amount Function Module
Convert the table using the Database Utility (SE14)
Convert Sales Unit into Text using Function Module in Target Language
Create SAP Dynamic Variant using Date Calculation
Create SAP Transaction to Maintain ABAP Table using SM30
Database Hint Pseudo-Comment for SAP Code Inspector
Delete Entries in NAST Table using RSCLNAST ABAP Program
Dynamic Programming using Field Symbols in ABAP Reports
Prevent DYNPRO_SEND_IN_BACKGROUND Error in Background Process
Execute ABAP Program Automatically After Transport Request Import
How to Execute SAP Program in Background Task
How to Export IDOC as Excel and Save as Local File from WE02 Transaction
Export SAP Spool Requests as PDF using SP01 Transaction
How to Find Internal Table Row Count in ABAP
How to Find Output Determination Procedure for a Billing Document
Export SAP Data to Fixed Length Text File
Get Fullname of SAP user using Function Module in ABAP Program
How to Disable Word Editor in SAP Smartform Text
How to Find User Exits in ABAP Codes of SAP Transaction
Read Integer and Decimals of a Numeric Value in ABAP Programming
Import and Export SO10 Standard Text using RSTXSCRP ABAP Program
Move Minus Sign from Right to Left of Negative Number in SAP Smartform
Primary key change not permitted for value table
Print SAP Outputs From Two Printers at the Same Time
Get Proforma Invoice from Commercial Invoice in ABAP
Read Pricing Condition Text using ABAP in SAP Sales Document Output
Read Text Symbols in Specific Language using ABAP RS_TEXTPOOL_READ
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
SAP Invoice Output ZZZZ is not Defined
SAP Output Management - Create New SAP Output Type
SAP Purchase Order Tables, Transaction Codes and Output
Graphics White Background Displayed Grey on SAP Smartform Output
Export Table Contents into Text File and Download File
SE63 Smartform Translation and Export using SLXT Program
Search and Find SAP Transaction Code using SE93 or SEARCH_SAP_MENU
SAP Code Inspector Error: Select For Cluster Table Without Order By
ABAP Select Statement using Space instead of Null or Initial
SAP Code Inspector: Select-Statement can be Transformed
ABAP Tutorial for SET and GET PARAMETER ID Command
SAP Smartform Runtime Error CX_SY_CONVERSION_NO_NUMBER
Window MAIN does not fit onto page PAGE (height)
SAP Smartforms Table Parameter in Form Routine
ABAP CONVT_NO_NUMBER Error on SP01 due SP01_WARN Parameter
How to find string length using STRLEN ABAP string function
ABAP Submit Report to Run Another ABAP Program within Code
Transport Variants of an ABAP Program into Workbench Request
Trigger Output Re-Determination for Billing Documents
TVAP Item Category and SAP Table TVAPT for Text Translations
Code Inspector: Unsecure use of FOR ALL ENTRIES
Update Multiple Variables in ABAP Select Single Statement
VF31 SAP Transaction to Reprocess Billing Output Messages
Web DynPro Tutorial - Display Spool Requests using Web DynPro Table
Function module is not released for the Internet
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement


Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems