SAP Reports / Programs
IUUC_CRE_ACT_DB_TRIGGER SAP ABAP Report - IUUC: create and activate DB triggers in old productive system
IUUC_CRE_ACT_DB_TRIGGER is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report is used to create and activate DB triggers in the sender system (the old productive system of an IUUC scenario)...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_CRE_ACT_DB_TRIGGER into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
IUUC_CRE_DB_TRIGGER - Create DB triggers
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_CRE_ACT_DB_TRIGGER. "Basic submit
SUBMIT IUUC_CRE_ACT_DB_TRIGGER AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_CRE_ACT_DB_TRIGGER 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 = select for table names
Selection Text: S_PROCOP = D process option
Selection Text: P_PHASE = D Phase
Selection Text: P_PACK = D Package
Selection Text: P_OPERAT = trigger only Ins/Upd/Del
Selection Text: P_MT_ID = D Mass Transfer ID
Selection Text: P_LTMOUT = MS SQL only: Lock Timeout Val.
Selection Text: P_LOGSUC = log success also
Selection Text: P_BATCH = number of jobs to be scheduled
Selection Text: P_ACT_ID = D Activity ID
Title: IUUC: create and activate DB triggers in old productive system
Text Symbol: UPD = update
Text Symbol: UP2 = update 2
Text Symbol: TST = These selections are only meant for testing purposes!
Text Symbol: TRG = trigger creation
Text Symbol: INS = insert
Text Symbol: FUN = create DB triggers
Text Symbol: DEL = delete
Text Symbol: 010 = No logging table exists for table pool
Text Symbol: 009 = Automatic Retry in error case
Text Symbol: 008 = Time
Text Symbol: 007 = Last Start
Text Symbol: 006 = Minutes
Text Symbol: 005 = Hour(s)
Text Symbol: 004 = Start periodically every
Text Symbol: 003 = Date
Text Symbol: 002 = delta
Text Symbol: 001 = freeze
INCLUDES used within this REPORT IUUC_CRE_ACT_DB_TRIGGER
INCLUDE CNV_MBT_SM_PARAMS.
INCLUDE CNV_MBT_SUB_SM_MACROS.
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_sndrfc IMPORTING e_dbsys = g_dbsys EXCEPTIONS communication_failure = 1 MESSAGE g_errtext system_failure = 2 MESSAGE g_errtext.
GET_JOB_RUNTIME_INFO CALL FUNCTION 'GET_JOB_RUNTIME_INFO' IMPORTING jobcount = gs_substate-jobcount jobname = gs_substate-jobname EXCEPTIONS OTHERS = 0.
IUUC_CRE_ACT_ADBC_TRIGGER CALL FUNCTION 'IUUC_CRE_ACT_ADBC_TRIGGER' EXPORTING i_tabname = g_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = gs_tables-process_option i_scenario = g_scenario i_data_in_logtab = gs_mt_header-data_in_logtab i_connection_name = g_dbcon_name i_trigger_state = gs_tables-trigger_state i_lock_timeout = p_ltmout it_specific_conditions = gt_specific_conditions i_phase = gs_tables-phase i_sequence_cache_size = g_sequence_cache_size i_exec_condition = g_exec_condition i_active_mt_id = g_trig_act_mt_id i_add_client_cond = gs_mt_header-client_specific i_db_operat = p_operat IMPORTING et_statements = gt_statements et_error = gt_error e_error_message = g_error_message e_rc = g_subrc.
IUUC_CRE_ACT_DB_TRIGGER CALL FUNCTION 'IUUC_CRE_ACT_DB_TRIGGER' DESTINATION g_sndrfc EXPORTING i_tabname = g_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = gs_tables-process_option i_scenario = g_scenario i_trigger_state = gs_tables-trigger_state i_data_in_logtab = gs_mt_header-data_in_logtab it_specific_conditions = gt_specific_conditions i_phase = gs_tables-phase i_sequence_cache_size = g_sequence_cache_size i_exec_condition = g_exec_condition i_active_mt_id = g_trig_act_mt_id i_add_client_cond = gs_mt_header-client_specific i_db_operat = p_operat i_logtab_multiuse = gs_mt_header-multi_logtab_use IMPORTING et_statements = gt_statements et_error = gt_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_sndrfc EXPORTING i_tabname = g_passed_tabname i_shadowtab = gs_tables-shadowtab_name i_tabclass = gs_tables-tabclass i_process_option = gs_tables-process_option i_scenario = g_scenario i_data_in_logtab = gs_mt_header-data_in_logtab i_connection_name = g_dbcon_name i_trigger_state = gs_tables-trigger_state i_lock_timeout = p_ltmout it_specific_conditions = gt_specific_conditions i_phase = gs_tables-phase i_sequence_cache_size = g_sequence_cache_size i_exec_condition = g_exec_condition i_active_mt_id = g_trig_act_mt_id i_add_client_cond = gs_mt_header-client_specific i_db_operat = p_operat i_logtab_multiuse = gs_mt_header-multi_logtab_use IMPORTING et_statements = gt_statements et_error = gt_error e_error_message = g_error_message e_rc = g_subrc EXCEPTIONS communication_failure = 1 MESSAGE g_errtext system_failure = 2 MESSAGE g_errtext.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
RFC_CONNECTION_CLOSE CALL FUNCTION 'RFC_CONNECTION_CLOSE' EXPORTING destination = g_sndrfc EXCEPTIONS OTHERS = 0.
CNV_MBT_L_SUBSTATE_WRITE CALL FUNCTION 'CNV_MBT_L_SUBSTATE_WRITE' EXPORTING packid = p_pack TABLES im_cnvmbtsubstate = gt_substate EXCEPTIONS OTHERS = 0.
GUID_CREATE CALL FUNCTION 'GUID_CREATE' IMPORTING ev_guid_22 = l_guid.
JOB_OPEN CALL FUNCTION 'JOB_OPEN' EXPORTING jobname = l_jobname IMPORTING jobcount = l_jobcount EXCEPTIONS cant_create_job = 1 invalid_job_data = 2 jobname_missing = 3 OTHERS = 4.
CNV_MBT_SUBSTATE_WRITE CALL FUNCTION 'CNV_MBT_SUBSTATE_WRITE' TABLES im_cnvmbtsubstate = gt_substate EXCEPTIONS OTHERS = 0.
END_TIME_DETERMINE CALL FUNCTION 'END_TIME_DETERMINE' EXPORTING duration = l_duration unit = 'MIN' IMPORTING end_date = l_nxtstrtdate end_time = l_nxtstrttime EXCEPTIONS OTHERS = 0.
JOB_CLOSE CALL FUNCTION 'JOB_CLOSE' EXPORTING jobcount = l_jobcount jobname = l_jobname sdlstrtdt = l_nxtstrtdate sdlstrttm = l_nxtstrttime EXCEPTIONS cant_start_immediate = 1 invalid_startdate = 2 jobname_missing = 3 job_close_failed = 4 job_nosteps = 5 job_notex = 6 lock_failed = 7 invalid_target = 8 OTHERS = 9.
JOB_CLOSE CALL FUNCTION 'JOB_CLOSE' EXPORTING jobcount = l_jobcount jobname = l_jobname strtimmed = 'X' EXCEPTIONS cant_start_immediate = 1 invalid_startdate = 2 jobname_missing = 3 job_close_failed = 4 job_nosteps = 5 job_notex = 6 lock_failed = 7 invalid_target = 8 OTHERS = 9.
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_CRE_ACT_DB_TRIGGER or its description.
IUUC_CRE_ACT_DB_TRIGGER - IUUC: create and activate DB triggers in old productive system IUUC_CRE_ACT_DB_TRIGGER - IUUC: create and activate DB triggers in old productive system IUUC_CREATE_TRIGGER_NONSAP - Create DB Triggers in a non-SAP system IUUC_CREATE_TRIGGER_NONSAP - Create DB Triggers in a non-SAP system IUUC_CREATE_TABLES_VERSION - create new Version of Exception Table IUUC_CREATE_TABLES_VERSION - create new Version of Exception Table