SAP Reports / Programs

IUUC_CHANGE_PROCESS_OPTION SAP ABAP Report - Change the Process Option for one or multiple Tables







IUUC_CHANGE_PROCESS_OPTION is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report allows to change the process option of selected tables...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_CHANGE_PROCESS_OPTION 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_CHANGE_PROCESS_OPTION. "Basic submit
SUBMIT IUUC_CHANGE_PROCESS_OPTION AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_CHANGE_PROCESS_OPTION 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: S_TABN = D Table Name
Selection Text: P_TRIGG = also delete / create triggers?
Selection Text: P_REASON = Reason for change
Selection Text: P_PROCOP = new process option
Selection Text: P_MT_ID = D Mass Transfer ID
Selection Text: P_LTMOUT = MS SQL only: Lock Timeout Val.
Selection Text: P_LOGTAB = also create logging tables?
Selection Text: P_DATCL3 = data class 3
Selection Text: P_DATCL2 = data class 2
Selection Text: P_DATCL1 = data class 1
Selection Text: P_CLONE = logging tables also in clone
Title: Change the Process Option for one or multiple Tables
Text Symbol: YES = yes
Text Symbol: UPD = update
Text Symbol: TBS = Tablespace Assignment
Text Symbol: SND = Attention:These data classes must be defined in the SENDER system!
Text Symbol: NON = no
Text Symbol: MDB = Process option change not possible for MAX DB !
Text Symbol: INS = insert
Text Symbol: FUN = change process option
Text Symbol: DEL = delete
Text Symbol: CRT = Really change process option of table
Text Symbol: CLN = activate only if clone system rfc is set to clone!!!
Text Symbol: CCL = create logging tables also in clone
Text Symbol: ASS = up to 3 data classes for the tablespace assignment
Text Symbol: ART = For Oracle and IBM DB systems, you can optionally specify
Text Symbol: 008 = Triggers can't be created without logging tables!
Text Symbol: 007 = record only
Text Symbol: 006 = delta final
Text Symbol: 005 = delayed
Text Symbol: 004 = complete
Text Symbol: 003 = ignore
Text Symbol: 002 = delta
Text Symbol: 001 = freeze


INCLUDES used within this REPORT IUUC_CHANGE_PROCESS_OPTION

INCLUDE CNV_MBT_SM_PARAMS_NODISPLAY.


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_GET_DBSYS CALL FUNCTION 'IUUC_GET_DBSYS' DESTINATION g_rfcdest IMPORTING e_dbsys = g_dbsys EXCEPTIONS communication_failure = 1 MESSAGE g_errtext system_failure = 2 MESSAGE g_errtext.

POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING * TITLEBAR = ' ' diagnose_object = 'IUUC_CRITICAL_PROCOPT_CHANGE' text_question = g_question text_button_1 = text-yes text_button_2 = text-non IMPORTING answer = g_answer EXCEPTIONS OTHERS = 0.

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.

IUUC_CRE_ACT_ADBC_TRIGGER CALL FUNCTION 'IUUC_CRE_ACT_ADBC_TRIGGER' EXPORTING i_tabname = l_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = p_procop i_scenario = g_scenario i_data_in_logtab = gs_mt_header-data_in_logtab i_connection_name = g_dbcon_name i_create_temp_trig = i_create_temp_trigger i_lock_timeout = p_ltmout it_specific_conditions = lt_specific_conditions i_phase = gs_tables-phase i_exec_condition = l_exec_condition i_active_mt_id = g_act_mt_id i_rfc_dest = g_rfcdest i_add_client_cond = gs_mt_header-client_specific IMPORTING et_statements = gt_statements et_error = lt_error e_error_message = l_error_message e_rc = e_subrc.

IUUC_CRE_ACT_DB_TRIGGER CALL FUNCTION 'IUUC_CRE_ACT_DB_TRIGGER' DESTINATION g_rfcdest EXPORTING i_tabname = l_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = p_procop i_scenario = g_scenario i_data_in_logtab = gs_mt_header-data_in_logtab i_create_temp_trig = i_create_temp_trigger it_specific_conditions = lt_specific_conditions i_phase = gs_tables-phase i_active_mt_id = g_act_mt_id i_add_client_cont = gs_mt_header-client_specific IMPORTING et_statements = gt_statements et_error = lt_error EXCEPTIONS communication_failure = 1 MESSAGE g_errtext system_failure = 2 MESSAGE g_errtext table_not_exist = 3 shadowtab_not_exist = 4 insert_trigger_failed = 5 update_trigger_failed = 6 delete_trigger_failed = 7 table_not_on_db = 8 OTHERS = 9.

IUUC_CRE_ACT_ADBC_TRIGGER CALL FUNCTION 'IUUC_CRE_ACT_ADBC_TRIGGER' DESTINATION g_rfcdest EXPORTING i_tabname = l_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = p_procop i_scenario = g_scenario i_data_in_logtab = gs_mt_header-data_in_logtab i_connection_name = g_dbcon_name i_create_temp_trig = i_create_temp_trigger i_lock_timeout = p_ltmout it_specific_conditions = lt_specific_conditions i_phase = gs_tables-phase i_active_mt_id = g_act_mt_id i_add_client_cont = gs_mt_header-client_specific IMPORTING et_statements = gt_statements et_error = lt_error e_error_message = l_error_message e_rc = e_subrc EXCEPTIONS communication_failure = 1 MESSAGE g_errtext system_failure = 2 MESSAGE g_errtext.

IUUC_DELETE_ADBC_TRIGGER CALL FUNCTION 'IUUC_DELETE_ADBC_TRIGGER' EXPORTING i_tabname = l_logged_table i_shadowtab = gs_tables-shadowtab_name i_connection_name = g_dbcon_name i_process_option = i_old_process_option i_pool_handling = i_pool_handling i_delete_temp_trig = i_delete_temp_trig i_lock_timeout = p_ltmout IMPORTING e_error_message = l_error_message.

IUUC_DELETE_DB_TRIGGER CALL FUNCTION 'IUUC_DELETE_DB_TRIGGER' DESTINATION g_rfcdest EXPORTING i_tabname = l_logged_table i_shadowtab = gs_tables-shadowtab_name i_process_option = i_old_process_option i_pool_handling = i_pool_handling i_delete_temp_trig = i_delete_temp_trig EXCEPTIONS communication_failure = 1 MESSAGE l_errtext system_failure = 2 MESSAGE l_errtext trigger_deletion_failed = 3 OTHERS = 0.

IUUC_DELETE_ADBC_TRIGGER CALL FUNCTION 'IUUC_DELETE_ADBC_TRIGGER' DESTINATION g_rfcdest EXPORTING i_tabname = l_logged_table i_shadowtab = gs_tables-shadowtab_name i_connection_name = g_dbcon_name i_process_option = i_old_process_option i_pool_handling = i_pool_handling i_delete_temp_trig = i_delete_temp_trig i_lock_timeout = p_ltmout IMPORTING e_error_message = l_error_message EXCEPTIONS communication_failure = 1 MESSAGE l_errtext system_failure = 2 MESSAGE l_errtext.



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