SAP Reports / Programs

SBAL_DELETE SAP ABAP Report - Application Log: Delete Expired Logs







SBAL_DELETE 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 SBAL_DELETE into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

LLDEL - Delete application logs
SLG2 - Application Log: Delete logs


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 SBAL_DELETE. "Basic submit
SUBMIT SBAL_DELETE AND RETURN. "Return to original report after report execution complete
SUBMIT SBAL_DELETE 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: S_USR = D .
Selection Text: S_TRC = D .
Selection Text: S_SUB = D .
Selection Text: S_OBJ = D .
Selection Text: S_EXT = D .
Selection Text: S_PCL = Problem class
Selection Text: S_LOG_NM = Log number
Selection Text: P_SIM = Only calculate how many
Selection Text: P_LIST = Generate list
Selection Text: P_ENDTIM = Creation Time: to
Selection Text: P_ENDDAT = Creation Date: to
Selection Text: P_DIRECT = Delete immediately
Selection Text: P_COMM = COMMIT Counter
Selection Text: P_BEGTIM = Creation Time: from
Selection Text: P_BEGDAT = Creation Date: from
Selection Text: P_BEF_OK = and others
Selection Text: P_BEF_NO = Only expired logs
Title: Application Log: Delete Expired Logs
Text Symbol: SEL = Selection conditions
Text Symbol: PAC = Delete by Number of Logs
Text Symbol: OPT = Options
Text Symbol: LID = Interval Proposals for
Text Symbol: LDP = Deletable Logs
Text Symbol: LCK = No. of Logs - Cumulative
Text Symbol: LCI = Logs per Interval
Text Symbol: IVE = Interval End
Text Symbol: IVB = Interval Start
Text Symbol: END = to (date/time)
Text Symbol: DOK = and logs which can be deleted before the expiry date
Text Symbol: DNO = Only logs which have reached their expiry date
Text Symbol: DL2 = Delete logs?
Text Symbol: DL1 = Delete logs
Text Symbol: DEL = Expiry date
Text Symbol: COM = Delete logs
Text Symbol: CN2 = Number of deleted logs:
Text Symbol: CN1 = Number of deletable logs:
Text Symbol: BEG = from (date/time)
Text Symbol: 004 = - the expiry date is not defined





Text Symbol: 003 = - the expiry date is reached or passed
Text Symbol: 002 = selection conditions, and for which:
Text Symbol: 001 = All logs are deleted which satisfy the following


INCLUDES used within this REPORT SBAL_DELETE

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:

HELP_OBJECT_SHOW_FOR_FIELD CALL FUNCTION 'HELP_OBJECT_SHOW_FOR_FIELD' EXPORTING called_by_tcode = sy-tcode called_by_program = l_repid called_by_dynp = sy-dynnr "#EC DOM_EQUAL called_for_tab = 'BALHDR' called_for_field = 'LOGNUMBER' EXCEPTIONS OTHERS = 0.

REUSE_ALV_GRID_DISPLAY CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_grid_title = l_s_grid_title i_callback_program = l_callback_report is_layout = l_s_layout_alv it_fieldcat = l_t_fieldcat * i_default = true * i_save = 'A' * is_variant = l_s_disvariant TABLES t_outtab = l_tint_list EXCEPTIONS OTHERS = 0.

BAL_DB_DELETE CALL FUNCTION 'BAL_DB_DELETE' EXPORTING i_t_logs_to_delete = l_log_hdr i_package_size = p_comm EXCEPTIONS OTHERS = 0.

BAL_DB_LOAD CALL FUNCTION 'BAL_DB_LOAD' EXPORTING i_t_lognumber = l_t_lognumber EXCEPTIONS OTHERS = 0.

BAL_DSP_PROFILE_SINGLE_LOG_GET CALL FUNCTION 'BAL_DSP_PROFILE_SINGLE_LOG_GET' IMPORTING e_s_display_profile = l_s_display_profile.

BAL_DSP_PROFILE_STANDARD_GET CALL FUNCTION 'BAL_DSP_PROFILE_STANDARD_GET' IMPORTING e_s_display_profile = l_s_display_profile.

BAL_DSP_LOG_DISPLAY CALL FUNCTION 'BAL_DSP_LOG_DISPLAY' EXPORTING i_s_display_profile = l_s_display_profile EXCEPTIONS OTHERS = 0.

BAL_GLB_MEMORY_REFRESH CALL FUNCTION 'BAL_GLB_MEMORY_REFRESH' EXCEPTIONS OTHERS = 0.

POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING textline1 = 'Protokoll(e) wirklich löschen ?'(dl2) titel = 'Protokolle löschen'(dl1) cancel_display = false IMPORTING answer = l_answer EXCEPTIONS OTHERS = 0.

BAL_DB_DELETE CALL FUNCTION 'BAL_DB_DELETE' EXPORTING i_t_logs_to_delete = l_t_logs_to_delete i_package_size = p_comm EXCEPTIONS OTHERS = 0.

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.

BAL_DSP_TXT_OBJECT_READ CALL FUNCTION 'BAL_DSP_TXT_OBJECT_READ' EXPORTING i_object = -object IMPORTING e_text = -t_object.

BAL_DSP_TXT_SUBOBJECT_READ CALL FUNCTION 'BAL_DSP_TXT_SUBOBJECT_READ' EXPORTING i_object = -object i_subobject = -subobject IMPORTING e_text = -t_subobj.

BAL_DSP_TXT_PROBCLASS_READ CALL FUNCTION 'BAL_DSP_TXT_PROBCLASS_READ' EXPORTING i_probclass = -probclass IMPORTING e_text = -t_probclsh.

BAL_DSP_TXT_DEL_BEFORE_READ CALL FUNCTION 'BAL_DSP_TXT_DEL_BEFORE_READ' EXPORTING i_del_before = -del_before IMPORTING e_text = -t_del_bef.

BAL_DSP_TXT_ALSTATE_READ CALL FUNCTION 'BAL_DSP_TXT_ALSTATE_READ' EXPORTING i_alstate = -alstate IMPORTING e_text = -t_alstate.

BAL_DSP_TXT_ALTCODE_READ





CALL FUNCTION 'BAL_DSP_TXT_ALTCODE_READ' EXPORTING i_tcode = -altcode IMPORTING e_text = -t_altcode.

BAL_DSP_TXT_ALMODE_READ CALL FUNCTION 'BAL_DSP_TXT_ALMODE_READ' EXPORTING i_almode = -almode IMPORTING e_text = -t_almode.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = 'BALHDR_ALV' CHANGING ct_fieldcat = l_t_fieldcat EXCEPTIONS OTHERS = 0.

REUSE_ALV_LIST_DISPLAY

REUSE_ALV_GRID_DISPLAY * CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_buffer_active = true i_callback_program = l_callback_report i_callback_pf_status_set = 'LIST_PBO' i_callback_user_command = 'LIST_PAI' is_layout = l_s_layout_alv it_fieldcat = l_t_fieldcat i_default = true i_save = 'A' is_variant = l_s_disvariant TABLES t_outtab = g_t_balhdr_alv EXCEPTIONS OTHERS = 0.

F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'ALUSER' dynpprog = 'SBAL_DELETE' dynpnr = '1000' dynprofield = 'BALHDR-ALUSER' value_org = 'S' display = display TABLES value_tab = lt_values_user EXCEPTIONS OTHERS = 0.

F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'ALUSER' dynpprog = 'SBAL_DELETE' dynpnr = '1000' dynprofield = 'BALHDR-ALUSER' value_org = 'S' display = display TABLES value_tab = lt_values_user EXCEPTIONS OTHERS = 0.



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