SAP Reports / Programs | Cross-Application Components | European Monetary Union: Euro(CA-EUR) SAP CA

IUUC_RENAME_DB_TABLE SAP ABAP Report - copy table A to table B, move data to table B, optionally delete A







IUUC_RENAME_DB_TABLE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report can be used to first copy an existing table, along with the table content, and then optionally delete the original table...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter IUUC_RENAME_DB_TABLE 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 IUUC_RENAME_DB_TABLE. "Basic submit
SUBMIT IUUC_RENAME_DB_TABLE AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_RENAME_DB_TABLE 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: P_BACK = rename back (remove prefix)
Selection Text: P_DELORG = delete prefix tables after ren
Selection Text: P_PREFIX = prefix for table name
Selection Text: S_TABN = table names
Title: copy table A to table B, move data to table B, optionally delete A
Text Symbol: 001 = successfully renamed to
Text Symbol: 002 = does not yet exist
Text Symbol: 003 = could not be created
Text Symbol: 004 = could not be activated
Text Symbol: 005 = Table
Text Symbol: 006 = could not be dropped
Text Symbol: 007 = could not be renamed
Text Symbol: 008 = Table rename failed


INCLUDES used within this REPORT IUUC_RENAME_DB_TABLE

No INCLUDES are used within this REPORT code!


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:

CNV_MBT_AUTHORITY_CHECK CALL FUNCTION 'CNV_MBT_AUTHORITY_CHECK' EXPORTING im_area = 'SLOP' im_level = 'PACKAGE' im_activity = '02'.

IUUC_RENAME_DB_TABLE CALL FUNCTION 'IUUC_RENAME_DB_TABLE' EXPORTING i_name_source = g_orignm i_name_target = g_newnam i_del_source_table = p_delorg tables et_messages = gt_messages EXCEPTIONS orig_table_not_exist = 1 table_creation_failed = 2 table_activation_failed = 3 table_drop_failed = 4 table_rename_failed = 5 OTHERS = 6.



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