SAP Reports / Programs
RUTCHKDB SAP ABAP Report - DD: ABAP Dictionary/Database Consistency Check
RUTCHKDB 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 RUTCHKDB 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 RUTCHKDB. "Basic submit
SUBMIT RUTCHKDB AND RETURN. "Return to original report after report execution complete
SUBMIT RUTCHKDB VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: DD: ABAP Dictionary/Database Consistency Check
Text Symbol: 108 = Length DD/DB:
Text Symbol: 109 = Decimal places DD/DB:
Text Symbol: 115 = Not NULL forced in DD, but nullable in DB
Text Symbol: 116 = Default value DD/DB:
Text Symbol: 117 = Not defined as NOT NULL in DB
Text Symbol: 118 = (Installed system)
Text Symbol: 120 = Not defined as Not Null in DD
Text Symbol: 216 = Database position DD/DB:
Text Symbol: 082 = Entered in DBDIFF:
Text Symbol: 087 = Defined in TADIR as type &
Text Symbol: 089 = Incorrect type in Dictionary: DD type &, class &
Text Symbol: 102 = Nametab does not exist
Text Symbol: 103 = NT fields cannot be mapped in DB
Text Symbol: 104 = Table has not been created in the database
Text Symbol: 105 = Field is not in Dictionary, type/length:
Text Symbol: 106 = Field is not in database
Text Symbol: 107 = Type DD/DB:
INCLUDES used within this REPORT RUTCHKDB
INCLUDE RADBTMAC.
INCLUDE RADBTOUM.
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:
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING TABNAME = 'DBDIFFKIND' * FIELDNAME = ' ' * LANGU = SY-LANGU * LFIELDNAME = ' ' ALL_TYPES = 'X' * IMPORTING * X030L_WA = * DDOBJTYPE = * DFIES_WA = TABLES * DFIES_TAB = FIXED_VALUES = dbdiff_values EXCEPTIONS NOT_FOUND = 1 INTERNAL_ERROR = 2 OTHERS = 3.
DD_MSCHK_DB_REPAIR call function 'DD_MSCHK_DB_REPAIR' exporting objtype = tbatg_table-object objname = tbatg_table-tabname indname = tbatg_table-indname fct = tbatg_table-fct prid = prid.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting * STATUS = 'A' tabname = tabname * GET_ALL = ' ' "no includes_as extensions ! importing x030l_wa = x030l_wa tables x031l_tab = x031l_tab exceptions not_found = 1 others = 8.
DD_MAP_NAMETAB_TO_DDFIELDS call function 'DD_MAP_NAMETAB_TO_DDFIELDS' exporting authentic = 'X' x030l_wa = x030l_wa tables ddfields = ddfield_tab x031l_tab = x031l_tab.
DB_MAP_DDFIELDS call function 'DB_MAP_DDFIELDS' exporting * DBSYS = SY-DBSYS * WITH_CHECK = ' ' * Um die Defaults zu erzeugen, muß With_string gesetzt sein und * ebenso nullable = space. Letzteres wirkt sich nicht auf die
DB_GET_TABLE_FIELDS call function 'DB_GET_TABLE_FIELDS' exporting field_info = 'A' tabname = tabname importing subrc = rc tables dbfields = dbfield_tab.
DD_TBIX_GET call function 'DD_TBIX_GET' exporting get_state = 'A' indexname = '*' langu = sy-langu prid = prid tabl_name = tabname withtext = ' ' tracelevel = 0 importing got_state = got_state tables dd12v_tab_a = dd12v_tab dd17v_tab_a = dd17v_tab exceptions * illegal_value = 1 others = 8.
DD_TBIX_GET call function 'DD_TBIX_GET' exporting get_state = 'A' indexname = '*' langu = sy-langu prid = prid tabl_name = tabname withtext = ' ' tracelevel = 0 importing got_state = got_state tables dd12v_tab_a = dd12v_tab dd12v_tab_n = dd12v_tab_dummy dd17v_tab_a = dd17v_tab dd17v_tab_n = dd17v_tab_dummy exceptions * illegal_value = 01 others = 08.
DB_GET_ALL_TABLES call function 'DB_GET_ALL_TABLES' importing subrc = rc tables all_tables = dbobj_tab.
DB_GET_ALL_VIEWS call function 'DB_GET_ALL_VIEWS' importing subrc = rc tables all_views = dbobj_tab.
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 RUTCHKDB or its description.