RSTEXTA3 SAP ABAP Report - Delete Superfluous Text Table Entries
RSTEXTA3 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Tables that statisfy the following conditions are cleaned up: Table name is not DD...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter RSTEXTA3 into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RSTEXTA3. "Basic submit
SUBMIT RSTEXTA3 AND RETURN. "Return to original report after report execution complete
SUBMIT RSTEXTA3 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: PRELS = Analysis of all Relationships
Selection Text: PSYSTABS = Include System Tables
Selection Text: P_APPEND = Append to File
Selection Text: P_AUTHOR = User Responsible for Table
Selection Text: P_CLEAN = Perform Cleanup
Selection Text: P_CLIENT = Cleanup in all Clients
Selection Text: P_DEVCL = Packages
Selection Text: P_FILE = File Name
Selection Text: P_FILE_R = File Name
Selection Text: P_GET = Read Saved Entries
Selection Text: P_LANG = Languages
Selection Text: P_NOVRWR = Protect from Overwriting
Selection Text: P_TEST = Test Mode (No Deletion!)
Selection Text: P_TXTTAB = Text Tables
Selection Text: P_WRIFI = Data Backup
Title: Delete Superfluous Text Table Entries
Text Symbol: 040 = Deleted Entries
Text Symbol: 041 = Text Tables: Cleaned Up
Text Symbol: 042 = Text Tables: Analyzed
Text Symbol: 043 = Text Tables: Total
Text Symbol: 044 = Cleanup Statistics
Text Symbol: 045 = Which texts are deleted?
Text Symbol: 046 = Entries in Translation-Relevant Text Tables
Text Symbol: 047 = - with at least one text table relationship
Text Symbol: 048 = - for which no entry exists in primary table
Text Symbol: 049 = Input Parameter
Text Symbol: 050 = Error while saving the table entries to be deleted
Text Symbol: 051 = Number of Text Tables
Text Symbol: 052 = File could not be closed
Text Symbol: 053 = File could not be opened for writing
Text Symbol: 054 = File already exists, choose another file
Text Symbol: 055 = File could not be opened for reading
Text Symbol: 059 = Specify a language
Text Symbol: 060 = (Object S_CTS_LANG, Field CTS_LANFKT, Value SUPL)
Text Symbol: 061 = You do not have the authorization for this action
Text Symbol: 062 = Insufficient Authorization:
Text Symbol: 063 = Analysis of all Relationships
Text Symbol: 064 = Included System Text Tables
Text Symbol: 039 = Language Statistics
Text Symbol: 001 = Text Table
Text Symbol: 002 = Primary Table
Text Symbol: 003 = What should be cleaned up?
Text Symbol: 004 = Save Table Entries To Be Deleted
Text Symbol: 005 = Which data should be read?
Text Symbol: 006 = How should the cleanup take place?
Text Symbol: 007 = Not Cleaned Up Text Tables
Text Symbol: 008 = Clean Text Tables
Text Symbol: 009 = Cleaned Up Text Tables
Text Symbol: 010 = Test Mode (No Deletion)
Text Symbol: 011 = Data Backup
Text Symbol: 012 = Protect Overwriting
Text Symbol: 013 = Append to File
Text Symbol: 014 = From
Text Symbol: 015 = No
Text Symbol: 016 = Yes
Text Symbol: 017 = Cleanup in all Clients
Text Symbol: 018 = Logon Language
Text Symbol: 019 = Language
Text Symbol: 020 = All Text Tables
Text Symbol: 021 = Text Tables
Text Symbol: 022 = Data Record
Text Symbol: 023 = Display only possible using file
Text Symbol: 024 = Error accessing file
Text Symbol: 025 = Unknown
Text Symbol: 026 = File Name
Text Symbol: 027 = New Analysis of Text Tables
Text Symbol: 028 = Data Source
Text Symbol: 029 = Tables
Text Symbol: 030 = Table
Text Symbol: 031 = Total
Text Symbol: 032 = Start
Text Symbol: 033 = End
Text Symbol: 034 = Entries
Text Symbol: 035 = Deletions
Text Symbol: 036 = Position
Text Symbol: 037 = System
Text Symbol: 038 = Comment
INCLUDES used within this REPORT RSTEXTA3
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
TOCX_GET_SYSTEM_TYPE CALL FUNCTION 'TOCX_GET_SYSTEM_TYPE' IMPORTING sap_system = gv_sap_system EXCEPTIONS OTHERS = 1.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = c_logsubdir_name including_dir = 'X' IMPORTING file_name = p_file_r EXCEPTIONS OTHERS = 1.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = c_logsubdir_name CHANGING physical_filename = gv_file_name EXCEPTIONS OTHERS = 1.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = c_logsubdir_name CHANGING physical_filename = gv_file_name_hdr EXCEPTIONS OTHERS = 1.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING percentage = gv_percentage text = gs_info EXCEPTIONS OTHERS = 0.
DDIF_TABL_GET CALL FUNCTION 'DDIF_TABL_GET' EXPORTING name = pv_table_name TABLES dd03p_tab = lt_field EXCEPTIONS illegal_input = 1 OTHERS = 2.
SYSTAB_CHECK CALL FUNCTION 'SYSTAB_CHECK' EXPORTING tabname = pv_tabname IMPORTING protection_flag = lv_protection_flag.
DDIF_TABL_GET CALL FUNCTION 'DDIF_TABL_GET' EXPORTING name = pv_tabname IMPORTING dd02v_wa = ls_dd02v TABLES dd03p_tab = lt_field dd05m_tab = lt_rel_field dd08v_tab = lt_rel EXCEPTIONS illegal_input = 1 OTHERS = 2.
FREE_SELECTIONS_RANGE_2_WHERE CALL FUNCTION 'FREE_SELECTIONS_RANGE_2_WHERE' EXPORTING field_ranges = lt_range IMPORTING where_clauses = lt_where.
DDIF_TABL_GET CALL FUNCTION 'DDIF_TABL_GET' EXPORTING name = ps_request-primary_table_name IMPORTING dd02v_wa = ls_dd02v_prim TABLES dd03p_tab = lt_field_prim EXCEPTIONS illegal_input = 1 OTHERS = 2.
FREE_SELECTIONS_RANGE_2_WHERE CALL FUNCTION 'FREE_SELECTIONS_RANGE_2_WHERE' EXPORTING field_ranges = lt_range IMPORTING where_clauses = lt_where.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RSTEXTA3 or its description.
RSTEXTA3 - Delete Superfluous Text Table Entries RSTEXTA3 - Delete Superfluous Text Table Entries RSTEST_CL_RSSH_HIERARCHY_FUNC - Test cl_rssh_hierarchy_func Class RSTEST_CL_RSSH_HIERARCHY_FUNC - Test cl_rssh_hierarchy_func Class RSTEST_CL_RSSH_HIERARCHY_BASE - HierTest RSTEST_CL_RSSH_HIERARCHY_BASE - HierTest