SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | MaxDB(BC-DB-SDB) SAP BC
RSSDBDEL SAP ABAP Report - Deletion of DBA History and DBA Action Logs
RSSDBDEL 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 RSSDBDEL 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 RSSDBDEL. "Basic submit
SUBMIT RSSDBDEL AND RETURN. "Return to original report after report execution complete
SUBMIT RSSDBDEL 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: P_CON = Name of Database Connection
Selection Text: P_DATE = Delete Older Than: (Date)
Selection Text: P_DAYS = Delete Older Than: (Days)
Selection Text: P_NOPOP = W/out Request for Confirmation
Title: Deletion of DBA History and DBA Action Logs
Text Symbol: 001 = Specify a Database Connection Name
Text Symbol: 002 = No Deletion to Be Made (Integration Data)
Text Symbol: 003 = Could not read DBA history
Text Symbol: 004 = Delete File:
Text Symbol: 005 = Error when deleting the log from:
Text Symbol: 006 = Delete from DBAHIST File
Text Symbol: 007 = Error when deleting actions from the DBA history
Text Symbol: 008 = Delete from DBA Action Logs (&)
Text Symbol: 009 = DBA action logs from before & will be deleted
Text Symbol: 010 = These actions can then no longer be displayed.
Text Symbol: 011 = Are you sure that you want to delete the DBA action logs?
INCLUDES used within this REPORT RSSDBDEL
INCLUDE SDB_CLIENT_SEPARATION.
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:
POPUP_TO_CONFIRM_WITH_MESSAGE CALL FUNCTION 'POPUP_TO_CONFIRM_WITH_MESSAGE' "#EC FB_OLDED EXPORTING defaultoption = 'N' diagnosetext1 = lv_text2 diagnosetext2 = text-010 * DIAGNOSETEXT3 = textline1 = text-011 * TEXTLINE2 = ' ' titel = lv_text1 * START_COLUMN = 25 * START_ROW = 6 cancel_display = ' ' IMPORTING answer = lv_answer.
GET_DBAHIST_SDB CALL FUNCTION 'GET_DBAHIST_SDB' EXPORTING con_name = gv_con_name use_dbmrfc = 'C' TABLES dbahist = lt_dbahist RESULT = lt_result EXCEPTIONS offset_error = 1 no_dbcon_entry = 2 no_dbconusr_entry = 3 get_connect_info_error = 4 dbm_getf_error = 5 no_dbahist_found = 6 OTHERS = 7.
TH_SERVER_LIST CALL FUNCTION 'TH_SERVER_LIST' EXPORTING services = '25' TABLES list = lt_servertab EXCEPTIONS OTHERS = 0.
DEL_DBA_FILE_SDB CALL FUNCTION 'DEL_DBA_FILE_SDB' DESTINATION lt_servertab-name EXPORTING protname = lv_command comm_txt = lv_comm_txt EXCEPTIONS del_dataset_error = 1 not_a_dba_log_file = 2 OTHERS = 3.
FIND_DB_APPLICATION_SERVER CALL FUNCTION 'FIND_DB_APPLICATION_SERVER' IMPORTING servername = lv_appserver EXCEPTIONS no_application_server = 1 OTHERS = 2.
DEL_DBA_FILE_SDB CALL FUNCTION 'DEL_DBA_FILE_SDB' DESTINATION lv_appserver EXPORTING protname = lv_command comm_txt = lv_comm_txt EXCEPTIONS del_dataset_error = 1 not_a_dba_log_file = 2 OTHERS = 3.
FIND_DB_APPLICATION_SERVER CALL FUNCTION 'FIND_DB_APPLICATION_SERVER' IMPORTING servername = lv_appserver EXCEPTIONS no_application_server = 1 OTHERS = 2.
DEL_DBA_FILE_SDB CALL FUNCTION 'DEL_DBA_FILE_SDB' DESTINATION lv_appserver EXPORTING protname = lv_command comm_txt = lv_comm_txt EXCEPTIONS del_dataset_error = 1 not_a_dba_log_file = 2 OTHERS = 3.
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 RSSDBDEL or its description.