IUUC_DELETE_SENDER_TRIGGERS SAP ABAP Report - IUUC: delete DB triggers in sender system
IUUC_DELETE_SENDER_TRIGGERS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for In the context of incremental upgrades, database triggers are used to log changes of database tables during the time frame of the monitored production...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_DELETE_SENDER_TRIGGERS 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_DEL_SND_TRIG - delete DB triggers in sender system
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_DELETE_SENDER_TRIGGERS. "Basic submit
SUBMIT IUUC_DELETE_SENDER_TRIGGERS AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_DELETE_SENDER_TRIGGERS 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_ACT_ID = D Activity ID
Selection Text: P_BATCH = Number of batch jobs
Selection Text: P_LOGSUC = log success also
Selection Text: P_LTMOUT = MS SQL only: Lock Timeout Val.
Selection Text: P_MT_ID = D Mass Transfer ID
Selection Text: P_PACK = D Package
Selection Text: P_PHASE = D Phase
Selection Text: S_PROCOP = D process option
Selection Text: S_TABN = D Table Name
Title: IUUC: delete DB triggers in sender system
Text Symbol: 001 = Triggers successfully deleted for
Text Symbol: 002 = Trigger deletion failed for
Text Symbol: 003 = Tables
Text Symbol: 004 = Trigger can't be deleted - Table should be replicated!!!
Text Symbol: 005 = Table
Text Symbol: 006 = No mass transfer ID assigned to this package
Text Symbol: FUN = delete DB triggers in sender
INCLUDES used within this REPORT IUUC_DELETE_SENDER_TRIGGERS
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'.
DTL_GET_IDS_FROM_PACKAGE CALL FUNCTION 'DTL_GET_IDS_FROM_PACKAGE' EXPORTING i_packid = p_pack IMPORTING e_mt_id = p_mt_id EXCEPTIONS no_pcl_destination = 1 invalid_package = 2 OTHERS = 3.
GET_JOB_RUNTIME_INFO CALL FUNCTION 'GET_JOB_RUNTIME_INFO' IMPORTING jobcount = gs_substate-jobcount jobname = gs_substate-jobname 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 = 1.
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.
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.
IUUC_DELETE_ADBC_TRIGGER CALL FUNCTION 'IUUC_DELETE_ADBC_TRIGGER' EXPORTING i_tabname = g_logged_table i_shadowtab = gs_tables-shadowtab_name i_connection_name = g_dbcon_name i_process_option = gs_tables-process_option i_pool_handling = g_pool_handling i_lock_timeout = p_ltmout IMPORTING e_error_message = g_error_message.
IUUC_DELETE_DB_TRIGGER CALL FUNCTION 'IUUC_DELETE_DB_TRIGGER' DESTINATION g_sndrfc EXPORTING i_tabname = g_logged_table i_shadowtab = gs_tables-shadowtab_name i_process_option = gs_tables-process_option i_pool_handling = g_pool_handling 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_sndrfc EXPORTING i_tabname = g_logged_table i_shadowtab = gs_tables-shadowtab_name i_connection_name = g_dbcon_name i_process_option = gs_tables-process_option i_pool_handling = g_pool_handling i_lock_timeout = p_ltmout IMPORTING e_error_message = g_error_message EXCEPTIONS communication_failure = 1 MESSAGE l_errtext system_failure = 2 MESSAGE l_errtext.
RFC_CONNECTION_CLOSE CALL FUNCTION 'RFC_CONNECTION_CLOSE' EXPORTING destination = g_sndrfc * TASKNAME = EXCEPTIONS OTHERS = 0.
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_DELETE_SENDER_TRIGGERS or its description.
IUUC_DELETE_SENDER_TRIGGERS - IUUC: delete DB triggers in sender system IUUC_DELETE_SENDER_TRIGGERS - IUUC: delete DB triggers in sender system IUUC_DELETE_REPOSITORY_OBJECTS - Delete IUUC Objects (Reports, Tables) IUUC_DELETE_REPOSITORY_OBJECTS - Delete IUUC Objects (Reports, Tables) IUUC_DELETE_RECEIVER_TRIGGERS - IUUC: delete DB triggers in Receiver System IUUC_DELETE_RECEIVER_TRIGGERS - IUUC: delete DB triggers in Receiver System