SAP Reports / Programs | Basis Components | ABAP Workbench, Java IDE and Infrastructure | Activation Program, Conversion Program, DB Utility, MC, SPDD(BC-DWB-DIC-AC) SAP BC
MSRUTDBCHK1 SAP ABAP Report - DD: ABAP Dictionary/Database Consistency Check
MSRUTDBCHK1 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 MSRUTDBCHK1 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 MSRUTDBCHK1. "Basic submit
SUBMIT MSRUTDBCHK1 AND RETURN. "Return to original report after report execution complete
SUBMIT MSRUTDBCHK1 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: PRIMIND = Check primary key
Selection Text: POS = Check DB position
Selection Text: NOTNULL = Check not null
Selection Text: DELTAOPT = Delta option
Selection Text: DEFAULT = Check default
Selection Text: TYPE = Check type and length
Selection Text: TABNAME = Table Name
Selection Text: SHOWONLY = Display Only
Selection Text: SECIND = Check secondary indexes
Selection Text: REFKIND = Source for reference
Selection Text: DBDIFFP = Take DBDIFF into consideration
Selection Text: CMPKIND = Source for comparison
Title: DD: ABAP Dictionary/Database Consistency Check
Text Symbol: 017 = The database object is not consistent:
Text Symbol: 016 = Tabale is not active in Dictionary
Text Symbol: 015 = Table is not created in the database
Text Symbol: 014 = Index does not exist
Text Symbol: 013 = Index
Text Symbol: 022 = Fields: Inconsistent with runtime object
Text Symbol: 021 = The database object is consistent
Text Symbol: 020 = Secondary Index
Text Symbol: 019 = Prim. Index
Text Symbol: 018 = Fields
Text Symbol: 012 = Unique index
Text Symbol: 006 = Lngth
Text Symbol: 005 = DataType
Text Symbol: 003 = Position
Text Symbol: 002 = Database
Text Symbol: 001 = Runtime Obj
Text Symbol: 011 = ABAP Dictionary
Text Symbol: 010 = Database
Text Symbol: 009 = Default
Text Symbol: 008 = Not null
Text Symbol: 007 = Deci.
Text Symbol: A02 = Fld name
Text Symbol: A03 = (not for DB)
Text Symbol: A04 = Single checks
Text Symbol: 023 = Fields: Consistent with runtime object
Text Symbol: 024 = Indexes:Inconsistent with DDIC Source
Text Symbol: 025 = Indexes:Consistent with DDIC
Text Symbol: 026 = Deviation entered in DBDIFF:
Text Symbol: 027 = Indexes
INCLUDES used within this REPORT MSRUTDBCHK1
INCLUDE RADBTMAC.
INCLUDE RADBTOUM.
INCLUDE SDB2PDBS.
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 = tabname importing subrc = lrc tables dbfields = dbfields.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting status = 'A' tabname = tabname importing x030l_wa = x030l_wa tables x031l_tab = x031l_tab exceptions not_found = 1 no_fields = 2 others = 3.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting status = 'N' tabname = tabname importing x030l_wa = x030l_wa tables x031l_tab = x031l_tab exceptions others = 1.
DD_RTOBJ_GET call function 'DD_RTOBJ_GET' exporting name = tabname rtobj = rtobj importing x030l_wa = x030l_wa tables x031l_tab = x031l_tab exceptions others = 2.
DD_MAP_NAMETAB_TO_DDFIELDS call function 'DD_MAP_NAMETAB_TO_DDFIELDS' exporting authentic = 'X' x030l_wa = x030l_wa tables ddfields = ddfields x031l_tab = x031l_tab changing dbpos = dbpos.
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.
DB_GET_INDEXES call function 'DB_GET_INDEXES' exporting tabname = itabname tables dbindexes = dbindexes dbindflds = dbindflds.
DD_DD07V_GET call function 'DD_DD07V_GET' exporting domain_name = 'DBDIFFKIND' langu = sy-langu withtext = 'X' tables dd07v_tab = dbdiffkind_text exceptions access_failure = 01.
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 MSRUTDBCHK1 or its description.
MSRUTDBCHK1 - DD: ABAP Dictionary/Database Consistency Check MSRUTDBCHK1 - DD: ABAP Dictionary/Database Consistency Check MSRT0TOP - documentation and ABAP source code MSRT0O01 - documentation and ABAP source code MSRT0I01 - documentation and ABAP source code MSRT0F01 - documentation and ABAP source code