SAP Reports / Programs

RUTCNVSC SAP ABAP Report - Analysis tool for terminated conversions







RUTCNVSC 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 RUTCNVSC 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 RUTCNVSC. "Basic submit
SUBMIT RUTCNVSC AND RETURN. "Return to original report after report execution complete
SUBMIT RUTCNVSC 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: TBLNAME = Table Name
Selection Text: PUSER = User
Selection Text: PTIME = Start Time
Selection Text: PDATE = Start Date
Title: Analysis tool for terminated conversions
Text Symbol: 117 = Table 2
Text Symbol: 116 = Table 1
Text Symbol: 115 = Function
Text Symbol: 114 = Old nametab for scan no longer accessible
Text Symbol: 113 = Table information
Text Symbol: 112 = Scan for P/C->P/C only possible for termin. in steps 2 or 5
Text Symbol: 111 = Scan for P/C->T only possible for termin. in step 2
Text Symbol: 110 = Scan for T->T/P/C only possible for termin. in step 5
Text Symbol: 109 = Cancel not possible for this type of conversion
Text Symbol: 108 = Cancel after step 5 is not supported for T -> T
Text Symbol: 107 = QCM table does not exist - cannot cancel
Text Symbol: 106 = QCM table is renamed to original table
Text Symbol: 105 = Original table still exists; indexes are possibly missing
Text Symbol: 104 = Original and QCM table exist
Text Symbol: 103 = Restart logs: Terminated table conversions
Text Symbol: 102 = Insert in DDPROF failed
Text Symbol: 101 = QCM table does not exist in the database
Text Symbol: 100 = Nametab compare not possible: old nametab missing
Text Symbol: 083 = Steps 1 - 6
Text Symbol: 082 = Time
Text Symbol: 081 = Date
Text Symbol: 080 = User
Text Symbol: 079 = Function
Text Symbol: 065 = Date, time of conversion
Text Symbol: 229 = Nametab QCM table missing
Text Symbol: 228 = Nametab orig. table missing
Text Symbol: 227 = Wrong table type
Text Symbol: 226 = Projection view
Text Symbol: 225 = Transparent table/view
Text Symbol: 224 = Pool table
Text Symbol: 223 = Cluster Table
Text Symbol: 222 = View
Text Symbol: 221 = Pool, cluster, transp. table





Text Symbol: 220 = Physical Pool Table
Text Symbol: 219 = Table/view without DB repr.
Text Symbol: 218 = Physical cluster table
Text Symbol: 217 = Table form
Text Symbol: 216 = Table type
Text Symbol: 215 = Nametab does not exist
Text Symbol: 214 = Cannot be determined
Text Symbol: 213 = Both tables do not exist
Text Symbol: 212 = New table does not exist
Text Symbol: 211 = QCM table does not exist
Text Symbol: 210 = Original table does not exist
Text Symbol: 205 = Changes must also be removed in the Dictionary
Text Symbol: 203 = Secondary indexes of original table are deleted
Text Symbol: 119 = Activation type
Text Symbol: 118 = Nametab compare
Text Symbol: 027 = Cluster -> Pool
Text Symbol: 026 = Cluster -> Transparent
Text Symbol: 025 = Pool -> Cluster
Text Symbol: 024 = Pool -> Pool
Text Symbol: 023 = Pool -> Transparent
Text Symbol: 022 = Transparent -> Cluster
Text Symbol: 021 = Transparent -> Pool
Text Symbol: 020 = Transparent -> Transparent
Text Symbol: 019 = Key
Text Symbol: 018 = Fld Name
Text Symbol: 017 = Fields of table $tabname$
Text Symbol: 016 = Y
Text Symbol: 015 = No
Text Symbol: 014 = QCM->:
Text Symbol: 013 = ->QCM:
Text Symbol: 011 = Selection conds. for syslog/short dumps
Text Symbol: 010 = Table name selection
Text Symbol: 009 = DBspace
Text Symbol: 008 = Number of sec. indexes
Text Symbol: 007 = Number of tupels in orig. table
Text Symbol: 006 = Number of tupels in QCM table
Text Symbol: 005 = QCM table exists?
Text Symbol: 004 = Tupel already converted
Text Symbol: 003 = Table





Text Symbol: 002 = Terminated after step
Text Symbol: 001 = Conversion type
Text Symbol: 028 = Cluster -> Cluster
Text Symbol: 064 = Select count(*) from table
Text Symbol: 063 = Determine
Text Symbol: 062 = First ext.
Text Symbol: 061 = background or online operation?
Text Symbol: 060 = Should conversion scan be started in
Text Symbol: 059 = Should conversion clear be started in
Text Symbol: 058 = Online
Text Symbol: 057 = Background
Text Symbol: 056 = IndexName
Text Symbol: 055 = Next ext.
Text Symbol: 054 = Init. ext.
Text Symbol: 053 = Max ext.
Text Symbol: 052 = Extents
Text Symbol: 051 = Size (KB)
Text Symbol: 050 = Tablespace
Text Symbol: 049 = Table Name
Text Symbol: 046 = With Informix, the table sizes usually contain the indexes!
Text Symbol: 038 = Tablespace QCM table
Text Symbol: 037 = Free (KB)
Text Symbol: 035 = Tablespace table
Text Symbol: 034 = Tablespace information
Text Symbol: 033 = No tablespace/size information exists
Text Symbol: 032 = Database system
Text Symbol: 031 = Fragmented
Text Symbol: 030 = Cat
Text Symbol: 029 = Lngth


INCLUDES used within this REPORT RUTCNVSC

INCLUDE RADBTOUM.
INCLUDE RADBTLOM.
INCLUDE RADBTMAC.


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:

DD_ABORT_REQUESTS_GET CALL FUNCTION 'DD_ABORT_REQUESTS_GET' TABLES ITCNV = ITCNV EXCEPTIONS UNEXPECTED_ERROR = 1 OTHERS = 2.

DB_EXISTS_TABLE CALL FUNCTION 'DB_EXISTS_TABLE' EXPORTING TABNAME = TABNAME IMPORTING SUBRC = RC.

DD_OBJECT_EXISTS



CALL FUNCTION 'DD_OBJECT_EXISTS' EXPORTING CLASS = 'TABL' NAME = TEMPNAME STATE = 'A' IMPORTING EXISTS = RESULT * PRODUCED = EXCEPTIONS ILLEGAL_INPUT = 1.

DD_DICTIONARY_TO_NAMETAB CALL FUNCTION 'DD_DICTIONARY_TO_NAMETAB' EXPORTING FOREIGN_KEY = 'X' * PRID = 0 STATUS = 'M' TABNAME = NAME TECHNICAL_INFO = 'X' IMPORTING X030L_WA = X030L_WA TABLES X031L_TAB = X031L_TAB EXCEPTIONS MAPPING_ERROR = 1 OTHERS = 2.

POPUP_TO_DECIDE_LIST CALL FUNCTION 'POPUP_TO_DECIDE_LIST' EXPORTING CURSORLINE = 1 MARK_FLAG = ' ' MARK_MAX = 1 START_COL = 0 START_ROW = 0 TEXTLINE1 = TEXT1 TEXTLINE2 = TEXT2 TITEL = TITLE IMPORTING ANSWER = ANSWER TABLES T_SPOPLI = DECIDELIST EXCEPTIONS NOT_ENOUGH_ANSWERS = 1 TOO_MUCH_ANSWERS = 2 TOO_MUCH_MARKS = 3 OTHERS = 4.

DD_DB_OPERATION CALL FUNCTION 'DD_DB_OPERATION' EXPORTING FCT = 'CNV' FORCED = ' ' ID_NAME = ' ' OBJ_NAME = TMPNAME OBJ_TYPE = 'TABL' PRID = PRID STATUS = 'D' USER = ' ' * importing * subrc = subrc * DATA_COPY = EXCEPTIONS UNEXPECTED_ERROR = 1 UNSUPPORTED_FUNCTION = 2 UNSUPPORTED_OBJ_TYPE = 3 UNSUPPORTED_STATUS = 4 OBJECT_LOCKED = 5 OP_FAILURE = 6 OTHERS = 7.

BP_START_DATE_EDITOR CALL FUNCTION 'BP_START_DATE_EDITOR' EXPORTING STDT_DIALOG = 'N' STDT_INPUT = STARTCOND STDT_OPCODE = 0 IMPORTING STDT_OUTPUT = STARTCOND EXCEPTIONS OTHERS = 28.

JOB_OPEN CALL FUNCTION 'JOB_OPEN' EXPORTING JOBNAME = JOBNAME IMPORTING JOBCOUNT = JOBNR EXCEPTIONS CANT_CREATE_JOB = 1 INVALID_JOB_DATA = 2 JOBNAME_MISSING = 3 OTHERS = 4.

DD_JOB_CLOSE CALL FUNCTION 'DD_JOB_CLOSE' EXPORTING JOBNAME = JOBNAME JOBCOUNT = JOBNR STARTCOND = STARTCOND EXCEPTIONS UNEXPECTED_ERROR = 1 OTHERS = 2.

DD_DBUT_REQUEST_DELETE CALL FUNCTION 'DD_DBUT_REQUEST_DELETE' EXPORTING OBJNAME = TEMPNAME * IDNAME = ' ' OBJTYPE = 'TABL' * WITH_UPDATE = ' ' INCL_ABORT_REQUESTS = 'X' IMPORTING SUBRC = SUBRC EXCEPTIONS NOTHING_TO_DELETE = 1 ABORT_FUNCTION = 2 DELETE_FAILED = 3 DELETE_NOT_PROVIDE = 4 OTHERS = 5.

DB_DROP_TABLE CALL FUNCTION 'DB_DROP_TABLE' EXPORTING DBSYS = SY-DBSYS NO_EXEC = ' ' PRID = PRID PROGNAME = ' ' TABNAME = NAME DB_CHECK_FLAG = 'X' IMPORTING * GENPROG = SUBRC = SUBRC EXCEPTIONS PROGRAM_NOT_GENERATED = 1 PROGRAM_NOT_WRITTEN = 2 TABLE_NOT_DROPPED = 3 OTHERS = 4.

DB_RENAME_TABLE CALL FUNCTION 'DB_RENAME_TABLE' EXPORTING DBSYS = SY-DBSYS NO_EXEC = ' ' PRID = PRID * TOLERANT = ' ' PROGNAME = ' ' TABNAME_NEW = NEW_NAME TABNAME_OLD = OLD_NAME LINK_ALLOWED = ' ' * IMPORTING * GENPROG = EXCEPTIONS NEW_TABLE_EXISTS = 1 OLD_TABLE_DOES_NOT_EXIST = 2 PROGRAM_NOT_GENERATED = 3 PROGRAM_NOT_WRITTEN = 4 OTHERS = 5.

DD_CREATE_INDEX_S CALL FUNCTION 'DD_CREATE_INDEX_S' EXPORTING DBSYS = SY-DBSYS INDEXNAME = '0' NO_EXEC = ' ' PRID = PRID * PROGNAME = ' ' TABNAME = NAME TABLES STATEMENTS = STMT_TAB_DUMMY EXCEPTIONS BASETAB_ERROR = 1 DB_ERROR = 2 DD_ERROR = 3 INDEX_EXISTS = 4 OTHERS = 5.

DD_TABL_ACTM CALL FUNCTION 'DD_TABL_ACTM' EXPORTING MODE = 12 GETSTATE = 'A' * NTAB_PUTSTATE = 'A' PRID = PRID * SETTMST = ' ' TABNAME = NAME * AUTH_CHK = 'X' * EXCOMMIT = 'X' * TIMER_ON = ' ' * UPGRMODE = ' ' EXCEPTIONS DBCHANGE_FAILURE = 1 NTAB_GEN_FAILURE = 2 PUT_FAILURE = 3 READ_FAILURE = 4 ACCESS_FAILURE = 5 OTHERS = 6.

DB_STORAGE_GET CALL FUNCTION 'DB_STORAGE_GET' EXPORTING DBSYS = SY-DBSYS TABNAME = TABNAME SOURCE_HIERARCHY = SRC_HIERARCHY FORMAT = ' ' TABLES STORPAR = STORPAR EXCEPTIONS MAPPING_ERROR = 1 DB_ERROR = 2 UNCOMPLETE_PARAMETER = 3 OTHERS = 4.

DB_STORAGE_GET CALL FUNCTION 'DB_STORAGE_GET' EXPORTING DBSYS = SY-DBSYS TABNAME = TABNAME SOURCE_HIERARCHY = SRC_HIERARCHY FORMAT = ' ' TABLES STORPAR = STORPAR EXCEPTIONS MAPPING_ERROR = 1 DB_ERROR = 2 UNCOMPLETE_PARAMETER = 3 OTHERS = 4.

DB_INF_TBL_EXTENTS CALL FUNCTION 'DB_INF_TBL_EXTENTS' EXPORTING DBSPACE1 = DBSPACENAMELOW VERSION = VERSION TFLAG = 1 TABLES DBA_SEG_TAB = DBTABLES_TAB FRAGTAB = FRAGTAB_TAB DBA_TMP_TAB = DBA_TMP_TAB EXCEPTIONS WRONG_DATABASE = 1 OTHERS = 2.

DB_INF_TBL_EXTENTS CALL FUNCTION 'DB_INF_TBL_EXTENTS' EXPORTING DBSPACE1 = DBSPACENAMELOWQCM VERSION = VERSION TFLAG = 1 TABLES DBA_SEG_TAB = DBTABLES_TAB FRAGTAB = FRAGTAB_TAB DBA_TMP_TAB = DBA_TMP_TAB EXCEPTIONS WRONG_DATABASE = 1 OTHERS = 2.

DB_INF_DB_SPACE_ALL_DETAIL CALL FUNCTION 'DB_INF_DB_SPACE_ALL_DETAIL' TABLES DBSPACES_TAB = DBSPACES_TAB EXCEPTIONS WRONG_DATABASE = 1 OTHERS = 2.

DB02_ORA_SELECT_DBA_SEGMENTS CALL FUNCTION 'DB02_ORA_SELECT_DBA_SEGMENTS' EXPORTING SEG_NAME = TABNAME TB_SPACE = TABSPACENAME SEG_TYPE = '%' KBYTES = 0 NR_EXTENTS = 0 TABLES DBA_SEGMENTS = ORADBA_SEGMENTS EXCEPTIONS OTHERS = 1.

DB02_ORA_SELECT_DBA_SEGMENTS CALL FUNCTION 'DB02_ORA_SELECT_DBA_SEGMENTS' EXPORTING SEG_NAME = TABNAME TB_SPACE = TABSPACENAMEQCM SEG_TYPE = '%' KBYTES = 0 NR_EXTENTS = 0 TABLES DBA_SEGMENTS = ORADBA_SEGMENTS EXCEPTIONS OTHERS = 1.

DB02_ORA_TABLE_INDEX_ANALYSIS CALL FUNCTION 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = ORADBA_SEGMENTS-SN ANALYSIS = 'S' SEG_TYPE = 'TABLE' partition = oradba_segments-sn TABLES DBA_SEGMENTS = DBA_SEGMENTSI2 EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.

DB02_ORA_FILL_TS CALL FUNCTION 'DB02_ORA_FILL_TS' * EXPORTING * FLAG_REFRESH = ' ' * IMPORTING * CURR_TIME = * CURR_DATE = * DATETIME = TABLES TS = TABSPACES_TAB.

DB_GET_RELEASE CALL FUNCTION 'DB_GET_RELEASE' IMPORTING RELEASE = DB_RELEASE.

S_DB_INFORMIX_VERSION_GET CALL FUNCTION 'S_DB_INFORMIX_VERSION_GET' EXPORTING FULL_VERSION = ' ' IMPORTING VERSION = INFORMIX_VERSION EXCEPTIONS COMMUNICATION_FAILURE = 01 SYSTEM_FAILURE = 02 WRONG_DATABASE = 03 X_ERROR = 04.

DDIF_TABL_GET CALL FUNCTION 'DDIF_TABL_GET' "alle Tabellenindizes lesen EXPORTING NAME = OBJNAME STATE = 'M' LANGU = SY-LANGU TABLES DD12V_TAB = DD12V_ALL EXCEPTIONS OTHERS = 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 RUTCNVSC or its description.