SAP Reports / Programs

comments icon Comments

IUUC_CHECK_UNIQUE_INDEX SAP ABAP Report - Check if Tables have a unique Index (primary or secondary)







IUUC_CHECK_UNIQUE_INDEX 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 tables to be processed in a near zero downtime project for two criteria: Does the table have a primary index or otherwise, at least a unique secondary index? Tables not fulfillng this criterion are listed...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_CHECK_UNIQUE_INDEX 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_CHECK_UNIQUE_INDEX. "Basic submit
SUBMIT IUUC_CHECK_UNIQUE_INDEX AND RETURN. "Return to original report after report execution complete
SUBMIT IUUC_CHECK_UNIQUE_INDEX 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_MTID = D Mass Transfer ID
Selection Text: P_PACK = D Pack ID
Selection Text: P_PHASE = D Phase
Selection Text: SO_TAB = D Table Name
Title: Check if Tables have a unique Index (primary or secondary)
Text Symbol: 001 = Number of analyzed tables:
Text Symbol: 002 = All tables have a unique index
Text Symbol: 003 = Tables which have no primary nor unique secondary index:
Text Symbol: 004 = Tables missing in the sender system:
Text Symbol: 005 = No tables with additional unique secondary index found
Text Symbol: 006 = Tables which have both a primary and a unique secondary index:
Text Symbol: 007 = Tables which have both a primary and a unique secondary index,
Text Symbol: 008 = the secondary index being part of the primary index:
Text Symbol: FUN = CHECK_UNIQUE_INDEX
Text Symbol: NTF = No relevant tables found for mass transfer


INCLUDES used within this REPORT IUUC_CHECK_UNIQUE_INDEX

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_CHECK_UNIQUE_INDEX
    CALL FUNCTION 'IUUC_CHECK_UNIQUE_INDEX'
      DESTINATION gv_rfcdest_snd
      EXPORTING
        iv_tabname            = gv_tabname
      IMPORTING
        e_has_unique_index    = g_has_unique_index
        e_also_unique_sec     = g_also_unique_sec_ind
      EXCEPTIONS
        communication_failure = 1  MESSAGE g_message
        system_failure        = 2  MESSAGE g_message
        table_missing         = 3
        OTHERS                = 4.


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


   
 

IUUC_CHECK_UNIQUE_INDEX - Check if Tables have a unique Index (primary or secondary)
IUUC_CHECK_UNIQUE_INDEX - Check if Tables have a unique Index (primary or secondary)
IUUC_CHECK_TABLE_CLASS_EXIST - IUUC Save Table Classification
IUUC_CHECK_TABLE_CLASS_EXIST - IUUC Save Table Classification
IUUC_CHECK_SEQUENCE_TIMESTAMP - check sequence / timestamp order
IUUC_CHECK_SEQUENCE_TIMESTAMP - check sequence / timestamp order