SAP Reports / Programs

S_AUT_ARCH_DEL SAP ABAP Report - Audit Trail (ILM): Deletion Program for Long Text Logs







S_AUT_ARCH_DEL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter S_AUT_ARCH_DEL 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 S_AUT_ARCH_DEL. "Basic submit
SUBMIT S_AUT_ARCH_DEL AND RETURN. "Return to original report after report execution complete
SUBMIT S_AUT_ARCH_DEL 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: PARAL = Parallel Processing
Selection Text: P_DELPRD = D .
Selection Text: P_DELTST = D .
Selection Text: RFCGROUP = D .
Title: Audit Trail (ILM): Deletion Program for Long Text Logs
Text Symbol: 002 = Delete Program
Text Symbol: 003 = Options
Text Symbol: 004 = With this option, note the maximum runtime
Text Symbol: 005 = Current Value in Seconds:
Text Symbol: DEL = &1% (&2 of &3) of long text logs processed


INCLUDES used within this REPORT S_AUT_ARCH_DEL

INCLUDE ARCH_DELETE_PRG_STANDARD1. "#EC INCL_OK


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:

ENQUEUE_E_TABLE CALL FUNCTION 'ENQUEUE_E_TABLE' EXPORTING mode_rstable = 'S' tabname = cl_s_aut_arc=>gc_arch_hist EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3.

ARCHIVE_OPEN_FOR_DELETE CALL FUNCTION 'ARCHIVE_OPEN_FOR_DELETE' EXPORTING object = cl_s_aut_arc=>gc_arc_obj_ltxtlogs test_mode = p_deltst IMPORTING archive_handle = gv_handle EXCEPTIONS file_already_open = 1 file_io_error = 2 internal_error = 3 no_files_available = 4 object_not_found = 5 open_error = 6 not_authorized = 7 OTHERS = 8.

ARCHIVE_GET_INFORMATION CALL FUNCTION 'ARCHIVE_GET_INFORMATION' EXPORTING archive_handle = gv_handle IMPORTING archive_document = gv_document object_number_in_file = gv_objects_to_delete EXCEPTIONS internal_error = 1 wrong_access_to_archive = 2 OTHERS = 3.

ARCHIVE_GET_CUSTOMIZING_DATA CALL FUNCTION 'ARCHIVE_GET_CUSTOMIZING_DATA' EXPORTING object = cl_s_aut_arc=>gc_arc_obj_ltxtlogs IMPORTING commit_count_for_delete_prg = gv_commit_counter EXCEPTIONS object_not_found = 1 OTHERS = 2.

S_AUT_STXH_STXL_DELETE CALL FUNCTION 'S_AUT_STXH_STXL_DELETE' STARTING NEW TASK 'STXH' DESTINATION IN GROUP rfcgroup PERFORMING receiver ON END OF TASK EXPORTING iv_tabname = cl_s_aut_arc=>gc_stxh_arch iv_cmt_cnt = gv_commit_counter EXCEPTIONS communication_failure = 1 system_failure = 2 resource_failure = 3 OTHERS = 4.

S_AUT_STXH_STXL_DELETE CALL FUNCTION 'S_AUT_STXH_STXL_DELETE' STARTING NEW TASK 'STXL' DESTINATION IN GROUP rfcgroup PERFORMING receiver ON END OF TASK EXPORTING iv_tabname = cl_s_aut_arc=>gc_stxl_arch iv_cmt_cnt = gv_commit_counter EXCEPTIONS communication_failure = 1 system_failure = 2 resource_failure = 3 OTHERS = 4.

S_AUT_STXH_STXL_DELETE CALL FUNCTION 'S_AUT_STXH_STXL_DELETE' EXPORTING iv_tabname = cl_s_aut_arc=>gc_stxh_arch iv_cmt_cnt = gv_commit_counter EXCEPTIONS not_authorized = 1 database_locked = 2 OTHERS = 3.

S_AUT_STXH_STXL_DELETE CALL FUNCTION 'S_AUT_STXH_STXL_DELETE' EXPORTING iv_tabname = cl_s_aut_arc=>gc_stxl_arch iv_cmt_cnt = gv_commit_counter EXCEPTIONS not_authorized = 1 database_locked = 2 OTHERS = 3.

ARCHIVE_GET_NEXT_OBJECT CALL FUNCTION 'ARCHIVE_GET_NEXT_OBJECT' EXPORTING archive_handle = gv_handle EXCEPTIONS end_of_file = 1 file_io_error = 2 internal_error = 3 open_error = 4 wrong_access_to_archive = 5 OTHERS = 6.

ARCHIVE_GET_TABLE CALL FUNCTION 'ARCHIVE_GET_TABLE' EXPORTING archive_handle = gv_handle record_structure = cl_s_aut_arc=>gc_dbtablog_stxl_a all_records_of_object = 'X' TABLES table = gt_stxl_a EXCEPTIONS end_of_object = 1 internal_error = 2 wrong_access_to_archive = 3 OTHERS = 4.

ARCHIVE_GET_TABLE CALL FUNCTION 'ARCHIVE_GET_TABLE' EXPORTING archive_handle = gv_handle record_structure = cl_s_aut_arc=>gc_extend_a all_records_of_object = 'X' TABLES table = gt_stxl_a EXCEPTIONS end_of_object = 1 internal_error = 2 wrong_access_to_archive = 3 OTHERS = 4.

ARCHIVE_GET_TABLE CALL FUNCTION 'ARCHIVE_GET_TABLE' EXPORTING archive_handle = gv_handle record_structure = cl_s_aut_arc=>gc_head all_records_of_object = 'X' TABLES table = gt_stxh EXCEPTIONS end_of_object = 1 internal_error = 2 wrong_access_to_archive = 3 OTHERS = 4.

PROGRESS_INDICATOR CALL FUNCTION 'PROGRESS_INDICATOR' EXPORTING i_text = text-del i_processed = gv_objects_deleted i_total = gv_objects_to_delete.

PROGRESS_INDICATOR CALL FUNCTION 'PROGRESS_INDICATOR' EXPORTING i_text = text-del i_processed = gv_objects_deleted i_total = gv_objects_to_delete i_output_immediately = abap_true.

ARCHIVE_WRITE_STATISTICS CALL FUNCTION 'ARCHIVE_WRITE_STATISTICS' EXPORTING archive_handle = gv_handle statistics_only_per_file = abap_true EXCEPTIONS internal_error = 1 OTHERS = 2.

ARCHIVE_CLOSE_FILE CALL FUNCTION 'ARCHIVE_CLOSE_FILE' EXPORTING archive_handle = gv_handle EXCEPTIONS internal_error = 1 wrong_access_to_archive = 2 OTHERS = 3.

DEQUEUE_E_TABLE CALL FUNCTION 'DEQUEUE_E_TABLE' EXPORTING mode_rstable = 'S' tabname = cl_s_aut_arc=>gc_arch_hist.

ARCHIVE_GIVE_STATISTICS CALL FUNCTION 'ARCHIVE_GIVE_STATISTICS' EXPORTING archive_handle = gv_handle TABLES table = lt_stat EXCEPTIONS internal_error = 1 OTHERS = 2.



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 S_AUT_ARCH_DEL or its description.