SAP Reports / Programs

comments icon Comments

RSDB4DLT SAP ABAP Report - Report for displaying tables with deleted records.







RSDB4DLT is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program displays all tables that contain deleted records...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 RSDB4DLT 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 RSDB4DLT. "Basic submit
SUBMIT RSDB4DLT AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB4DLT VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Report for displaying tables with deleted records.
Text Symbol: D30 = Perform Reset Operation
Text Symbol: D31 = Database monitor is currently inactive!
Text Symbol: D32 = Database monitor has been inactive since
Text Symbol: D33 = Do you want to
Text Symbol: D34 = reset the monitor anyway?
Text Symbol: D35 = DB monitor successfully stopped!
Text Symbol: D36 = DB monitor successfully started!
Text Symbol: D37 = Information was deleted manually.
Text Symbol: D38 = Start or end the DB monitor to get
Text Symbol: D39 = the correct information for ST04
Text Symbol: D40 = If you choose EXIT, this transaction
Text Symbol: D41 = will be aborted.
Text Symbol: D42 = Start database monitor
Text Symbol: D43 = End database monitor
Text Symbol: D44 = No information about DBMON activities found!
Text Symbol: D45 = No information about DBMON activities found!
Text Symbol: D46 = Information was deleted manually.
Text Symbol: D47 = The DBMON button in ST04 may be corrupt!
Text Symbol: D48 = Transaction will be aborted
Text Symbol: D49 = No information about DBMON activities found!
Text Symbol: D50 = Start database monitor
Text Symbol: D51 = End database monitor
Text Symbol: 001 = Table Name
Text Symbol: 002 = Rows
Text Symbol: 003 = Deleted Rows
Text Symbol: 004 = % Deleted
Text Symbol: 005 = Row Length
Text Symbol: 006 = Waisted Space (KB)
Text Symbol: 010 = Tables by deleted space
Text Symbol: 011 = Tables with Deleted Rows at
Text Symbol: 012 = The control could not be created
Text Symbol: 013 = Name of Dictionary Table
Text Symbol: 014 = Number of Table Rows
Text Symbol: 015 = Number of Deleted Table Rows
Text Symbol: 016 = Percentage of Deleted Rows
Text Symbol: 017 = Row Length of Dictionary Table
Text Symbol: 018 = Size Deleted Rows in Kilobytes





Text Symbol: 020 = Error in Flush
Text Symbol: C25 =
Text Symbol: C26 = Inactive since
Text Symbol: C27 =
Text Symbol: C28 =
Text Symbol: C29 =
Text Symbol: C30 =
Text Symbol: D01 = Performance monitor data as of


INCLUDES used within this REPORT RSDB4DLT

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:

GET_DB4_DELETED_RECORDS
CALL FUNCTION 'GET_DB4_DELETED_RECORDS'
     EXPORTING
          DBHOST = dbhost
          SCHEMANAME = schemaname
     TABLES
          del_recs           = gt_del_recs
          analysis_timestamp = analysis_timestamp
     EXCEPTIONS
          NO_RECORDS_FOUND   = 1
          OTHERS             = 0.

LVC_FIELDCATALOG_MERGE
  call function 'LVC_FIELDCATALOG_MERGE'
    EXPORTING
      i_structure_name       = p_structure_name
      I_INTERNAL_TABNAME     = P_INTERNAL_TABNAME
    CHANGING
      ct_fieldcat            = p_tablename
    EXCEPTIONS
      INCONSISTENT_INTERFACE = 1
      PROGRAM_ERROR          = 2
      OTHERS                 = 3.

POPUP_TO_INFORM
    call function 'POPUP_TO_INFORM'
      EXPORTING
        titel = g_repid
        txt2  = sy-subrc
        txt1  = 'Error in Flush'(020).

POPUP_TO_INFORM
      call function 'POPUP_TO_INFORM'
        EXPORTING
          titel = g_repid
          txt2  = sy-subrc
          txt1  = 'The control could not be created'(012).


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


   
 

RSDB4DLT - Report for displaying tables with deleted records.
RSDB4DLT - Report for displaying tables with deleted records.
RSDB4DDC - iSeries: Display Data Dictionary Information (Overview) within ST04
RSDB4DDC - iSeries: Display Data Dictionary Information (Overview) within ST04
RSDB4DBH - iSeries: Display History of DBMonitor Overview from MONI
RSDB4DBH - iSeries: Display History of DBMonitor Overview from MONI