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
RUTDBCHK SAP ABAP Report - DD: ABAP Dictionary/Database Consistency Check
RUTDBCHK 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 RUTDBCHK 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 RUTDBCHK. "Basic submit
SUBMIT RUTDBCHK AND RETURN. "Return to original report after report execution complete
SUBMIT RUTDBCHK 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: TYPE = Check Type and Length
Selection Text: TABNAME = Table Name
Selection Text: SHOWONLY = Display Only
Selection Text: SHOWLIST = Display as List
Selection Text: SECIND = Check Secondary Indexes
Selection Text: REFKIND = Source for Reference
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: DBDIFFP = Take DBDIFF into Consideration
Selection Text: CMPKIND = Source for Comparison
Title: DD: ABAP Dictionary/Database Consistency Check
Text Symbol: 102 = Fld Name
Text Symbol: 103 = Position
Text Symbol: 104 = Runtime Object
Text Symbol: 105 = Decimals
Text Symbol: 109 = Indexes for
Text Symbol: 110 = does not exist
Text Symbol: 111 = Index
Text Symbol: 112 = Database object for
Text Symbol: 113 = is consistent
Text Symbol: 114 = is inconsistent:
Text Symbol: A02 = Field Name
Text Symbol: A03 = (not for DB)
Text Symbol: A04 = Single Checks
Text Symbol: A05 = Triggers for
Text Symbol: A06 = Trigger
Text Symbol: 101 = Fields of
Text Symbol: 001 = Runtime Object
Text Symbol: 002 = Database
Text Symbol: 003 = Position
Text Symbol: 005 = Data Type
Text Symbol: 006 = Length
Text Symbol: 007 = Deci.
Text Symbol: 008 = Not null
Text Symbol: 009 = Default
Text Symbol: 010 = Database
Text Symbol: 011 = ABAP Dictionary
Text Symbol: 012 = Unique Index
Text Symbol: 013 = Index
Text Symbol: 014 = Index does not exist
Text Symbol: 015 = Table is not created in the database
Text Symbol: 016 = Tabale is not active in Dictionary
Text Symbol: 017 = The database object is not consistent:
Text Symbol: 018 = Fields
Text Symbol: 019 = Primary Index
Text Symbol: 020 = Secondary Indexes
Text Symbol: 021 = The database object is consistent
Text Symbol: 022 = Fields: Inconsistent with the runtime object
Text Symbol: 023 = Fields: Consistent with the 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
Text Symbol: 029 = Partitioning
Text Symbol: 040 = Client-Specific
Text Symbol: 044 = Storage Type
INCLUDES used within this REPORT RUTDBCHK
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 check_only = 'X' tables ddfields = ddfields x031l_tab = x031l_tab changing dbpos = dbpos.
DB_EXISTS_TENANTTYPE * CALL FUNCTION 'DB_EXISTS_TENANTTYPE' * IMPORTING ** NAME = * SUBRC = rc * EXCEPTIONS * SQL_ERROR = 1 * MAXDB_VERSION_TOO_OLD = 2 * OTHERS = 3.
DB_PARTITION_TABLE
* CALL FUNCTION 'DB_PARTITION_TABLE' * EXPORTING * TABNAME = tabname * IMPORTING * SUBRC = rc * EXCEPTIONS * MAXDB_VERSION_TOO_OLD = 1 * SQL_ERROR = 2 * TABLE_DOES_NOT_EXIST = 3 * DBMS_NOT_SUPPORTED = 4 * OTHERS = 5.
SHDB_GET_TABLE_TYPE call function 'SHDB_GET_TABLE_TYPE' exporting i_table_name = hdb_tabname * I_SCHEMA_NAME = * I_DB_NAME = IMPORTING E_TABLE_TYPE = header-roworcolst EXCEPTIONS SQL_ERROR = 1 INTERNAL_ERROR = 2 OTHERS = 3.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = tabname STATE = get_state IMPORTING GOTSTATE = got_state DD02V_WA = dd02v_wa DD09L_WA = dd09v_wa EXCEPTIONS ILLEGAL_INPUT = 1 OTHERS = 2.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = tabname STATE = get_state IMPORTING GOTSTATE = got_state DD02V_WA = dd02v_wa DD09L_WA = dd09v_wa TABLES DD03P_TAB = dd03p_tab EXCEPTIONS ILLEGAL_INPUT = 1 OTHERS = 2.
DD_GET_NAMETAB_HEADER call function 'DD_GET_NAMETAB_HEADER' exporting * STATUS = 'A' tabname = tabname IMPORTING R_STATUS = read_state X030L_WA = x030l_wa EXCEPTIONS NOT_FOUND = 1 OTHERS = 2.
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.
DB_GET_TRIGGERS call function 'DB_GET_TRIGGERS' EXPORTING TABNAME = tabname IMPORTING SUBRC = lrc tables triggers = triggers .
DB_GET_TRIGGERTEXT call function 'DB_GET_TRIGGERTEXT' exporting tabname = tabname triggername = triggers-objname tables triggertext = triggertext EXCEPTIONS NOT_FOUND = 1 OTHERS = 2 .
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 RUTDBCHK or its description.
RUTDBCHK - DD: ABAP Dictionary/Database Consistency Check RUTDBCHK - DD: ABAP Dictionary/Database Consistency Check RUTCSADAPT - DD: Changes log cluster to transparent RUTCSADAPT - DD: Changes log cluster to transparent RUTCNVSK - Analysis of terminated conversions RUTCNVSK - Analysis of terminated conversions