SAP Reports / Programs

RUTTABSC SAP ABAP Report - Scan over all tables







RUTTABSC 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 RUTTABSC 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 RUTTABSC. "Basic submit
SUBMIT RUTTABSC AND RETURN. "Return to original report after report execution complete
SUBMIT RUTTABSC 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: TABNAME = Table Name
Selection Text: RESPONS = Author
Selection Text: PROTTABL = Log empty tables individually
Selection Text: PROTFIEL = Log empty fields individually
Selection Text: PROTAPP = Append Log
Selection Text: PRNAME = Log Name
Selection Text: NOTEST = Without Test Packages
Selection Text: DEVCLASS = Package
Selection Text: CHKFIELD = Table empty/empty fields?
Selection Text: CHKEMPTY = Table empty?
Title: Scan over all tables
Text Symbol: 030 = Number of empty sec. index fields .......:
Text Symbol: 031 = Table width (bytes) .....................:
Text Symbol: 032 = Of these are initial (bytes) ............:
Text Symbol: 040 = Log options
Text Symbol: 060 = Table fields cannot be read from the DB
Text Symbol: 070 = Table does not exist on the DB
Text Symbol: 080 = Object is not a table
Text Symbol: 090 = Table has no nametab
Text Symbol: 100 = Table does not contain data
Text Symbol: 200 = Report could not be saved
Text Symbol: 201 = Report could not be generated
Text Symbol: 202 = Statements cannot be generated
Text Symbol: 300 = Field is a key field
Text Symbol: 301 = Field contained in a secondary index
Text Symbol: 029 = Number of empty key fields ..............:
Text Symbol: 001 = =================================================
Text Symbol: 002 = Total number of tables...................:
Text Symbol: 003 = Number of empty tables...................:
Text Symbol: 004 = Number of tables without nametab.........:
Text Symbol: 005 = Number of objects that are not table.....:
Text Symbol: 006 = Number of tables not existing on DB......:
Text Symbol: 008 = Field is empty name/type/lngth...........:
Text Symbol: 009 = Table is inconsistent (nametab <-> DB)
Text Symbol: 010 = Attributes to be checked
Text Symbol: 011 = Number of inconsistent tables............:
Text Symbol: 012 = Number of tables with empty fields.......:
Text Symbol: 013 = Total number of empty fields ............:





Text Symbol: 014 = *************************************************
Text Symbol: 015 = Number of table records..................:
Text Symbol: 016 = Table....................................:
Text Symbol: 017 = Field length * no. of records (bytes)....:
Text Symbol: 019 = Field length * record no. (bytes)........:
Text Symbol: 020 = Selection by Table Name/Package
Text Symbol: 022 = Table name.................Bytes........Bytes ORA
Text Symbol: 023 = Field length * no. of recs. (bytes) ORA..:
Text Symbol: 024 = Field length * rec. no. (bytes) ORA......:
Text Symbol: 025 = Length of key field * no. of records ....:
Text Symbol: 026 = Length of key field * no. of records ORA.:
Text Symbol: 027 = Index field length * no. of records .....:
Text Symbol: 028 = Index field length * no. of records ORA..:


INCLUDES used within this REPORT RUTTABSC

INCLUDE RADBTOUM.
INCLUDE RADBTLOM.
INCLUDE RADBTSC0.
INCLUDE RADPROPV.


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:

DB_GET_TABLE_FIELDS CALL FUNCTION 'DB_GET_TABLE_FIELDS' EXPORTING FIELD_INFO = 'A' TABNAME = TABLENAME IMPORTING SUBRC = DBRC TABLES DBFIELDS = DBFIELD_TAB EXCEPTIONS OTHERS = 1.

DB_GET_INDEXES CALL FUNCTION 'DB_GET_INDEXES' EXPORTING TABNAME = TABLENAME TABLES DBINDEXES = DBINDEX_TAB DBINDFLDS = DBINDFLD_TAB.

DB_EXISTS_TABLE CALL FUNCTION 'DB_EXISTS_TABLE' EXPORTING TABNAME = TABLENAME IMPORTING SUBRC = RETURNCODE EXCEPTIONS OTHERS = 1.

ENQUEUE_ESRDIRE CALL FUNCTION 'ENQUEUE_ESRDIRE' EXPORTING NAME = PROGNAME EXCEPTIONS FOREIGN_LOCK = 1.

ENQUEUE_ESRDIRE CALL FUNCTION 'ENQUEUE_ESRDIRE' EXPORTING NAME = PROGNAME EXCEPTIONS FOREIGN_LOCK = 1.



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