SAP Reports / Programs

comments icon Comments

IUUC_TRIGGER_RECONCILIATION SAP ABAP Report - Reconcile number of expected and existing triggers







IUUC_TRIGGER_RECONCILIATION is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report checks if the number of DB triggers that should exist in the productive system in an IUUC project matches the number of really existing database triggers...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_TRIGGER_RECONCILIATION 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_TRIGGER_RECONCILIATION. "Basic submit
SUBMIT IUUC_TRIGGER_RECONCILIATION AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_TRIGGER_RECONCILIATION 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_MT_ID = D Mass Transfer ID
Title: Reconcile number of expected and existing triggers
Text Symbol: 001 = Tables with freeze triggers
Text Symbol: 002 = Physical pool tables with both freeze and delta
Text Symbol: 003 = expected number of triggers
Text Symbol: 004 = actual number of triggers
Text Symbol: 005 = For the following tables, triggers are missing (existing ones are specified):
Text Symbol: 006 = Tables with delta-like triggers
Text Symbol: 007 = Among these: cluster tables
Text Symbol: 008 = Among these: pool tables
Text Symbol: 009 = Among these: physical cluster tables
Text Symbol: 010 = Among these: physical pool tables
Text Symbol: 011 = For the following tables, unexpected triggers exist:
Text Symbol: 012 = Unknown database system
Text Symbol: FUN = Check number of DB triggers


INCLUDES used within this REPORT IUUC_TRIGGER_RECONCILIATION

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_TRIGGERS
  CALL FUNCTION 'IUUC_GET_TRIGGERS'
    DESTINATION g_sndrfc
    IMPORTING
      e_dbsys               = g_dbsys
      et_triggers           = gt_triggers
    EXCEPTIONS
      communication_failure = 1  MESSAGE g_errtext
      system_failure        = 2  MESSAGE g_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_TRIGGER_RECONCILIATION or its description.


   
 

IUUC_TRIGGER_RECONCILIATION - Reconcile number of expected and existing triggers
IUUC_TRIGGER_RECONCILIATION - Reconcile number of expected and existing triggers
IUUC_TCODES_LOCK_UNLOCK - Lock Transaction Codes
IUUC_TCODES_LOCK_UNLOCK - Lock Transaction Codes
IUUC_TABLE_UPLOAD - Define the Set of Tables to be considered in the Delta Replay
IUUC_TABLE_UPLOAD - Define the Set of Tables to be considered in the Delta Replay