SAP Reports / Programs | SAP Business Information Warehouse | Business Explorer | End User Technology(BW-BEX-ET) SAP BW

comments icon Comments

COMPONENT_REORG SAP ABAP Report - Deletion of queries with selection conditions







COMPONENT_REORG is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter COMPONENT_REORG 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

RSZDELETE - Deletion of query objects


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 COMPONENT_REORG. "Basic submit
SUBMIT COMPONENT_REORG AND RETURN. "Return to original report after report execution complete
SUBMIT COMPONENT_REORG 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: G_P_CTS = With Transport Connection
Selection Text: G_P_LOC = Only Local Objects ($TMP)
Selection Text: G_P_NCTS = Without Transport Connection
Selection Text: G_P_OBV = Object Version
Selection Text: G_P_QVIW = Query Views
Selection Text: G_P_RRQA = BBS Sender/Recipient
Selection Text: G_P_V = All Query Elements
Selection Text: G_P_V3 = Only 3.x Query Elements
Selection Text: G_P_V7 = Only 7.x Query Elements
Selection Text: G_P_XLWB = Workbooks
Selection Text: G_SO_DAT = Last Changed
Selection Text: G_SO_DEF = Type
Selection Text: G_SO_IC = InfoProvider
Selection Text: G_SO_ID = Technical Name
Selection Text: G_SO_LUS = Last Used
Selection Text: G_SO_OWN = Owner
Selection Text: G_SO_UID = Element UID
Selection Text: G_SO_USR = Last Changed by
Title: Deletion of queries with selection conditions
Text Symbol: 028 = RRI Sender/Recipient
Text Symbol: 027 = Quantity Conversion Type
Text Symbol: 026 = Currency Translation Type
Text Symbol: 025 = InfoPackage
Text Symbol: 024 = Enterprise Report
Text Symbol: 001 = Selection of Query Components to Delete
Text Symbol: 002 = Query Components
Text Symbol: 003 = Version
Text Symbol: 004 = Result of Deletion
Text Symbol: 005 = Transport System
Text Symbol: 006 = Dependent Objects
Text Symbol: 007 = The selected components will be deleted from the database
Text Symbol: 008 = This process is irreversible. Are you sure you want to continue?
Text Symbol: 009 = Delete?
Text Symbol: 010 = Yes
Text Symbol: 011 = No
Text Symbol: 012 = Workbook
Text Symbol: 013 = Query
Text Symbol: 014 = Filters





Text Symbol: 015 = Structure
Text Symbol: 016 = Restricted Key Figure
Text Symbol: 017 = Calculated Key Figure
Text Symbol: 018 = Variable
Text Symbol: 019 = Reporting Agent Setting
Text Symbol: 020 = Crystal Report
Text Symbol: 021 = Query View
Text Symbol: 022 = Web Template (Format SAP BW 3.x)
Text Symbol: 023 = Web Template (Format SAP BW 7.x)


INCLUDES used within this REPORT COMPONENT_REORG

No INCLUDES are used within this REPORT code!


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:

ENQUEUE_E_COMPDIR
  CALL FUNCTION 'ENQUEUE_E_COMPDIR'
    EXPORTING
      mode_rszcompdir = 'O'
      compuid         = 'QUERY_DELETION_IN_PROCESS'
    EXCEPTIONS
      foreign_lock    = 1
      system_failure  = 2.

ENQUEUE_E_COMPDIR
    CALL FUNCTION 'ENQUEUE_E_COMPDIR'
      EXPORTING
        mode_rszcompdir = 'O'                               "#EC NOTEXT
        compuid         = -compuid
      EXCEPTIONS
        foreign_lock    = 1
        system_failure  = 2.

DEQUEUE_E_COMPDIR
    CALL FUNCTION 'DEQUEUE_E_COMPDIR'
      EXPORTING
        mode_rszcompdir = 'O'
        compuid         = -compuid.

POPUP_TO_CONFIRM
      CALL FUNCTION 'POPUP_TO_CONFIRM'
        EXPORTING
          titlebar              = 'Delete?'(009)            "#EC TEXT_DIFF
          text_question         = l_string
          text_button_1         = 'Yes'(010)                "#EC TEXT_DIFF
          icon_button_1         = 'ICON_DELETE'             "#EC NOTEXT
          text_button_2         = 'No'(011)                 "#EC TEXT_DIFF
          icon_button_2         = 'ICON_CANCEL '            "#EC NOTEXT
          default_button        = 1
          display_cancel_button = rs_c_false
          start_column          = 25
          start_row             = 6
        IMPORTING
          answer                = l_answer
        EXCEPTIONS
          OTHERS                = 0.

RSSB_AUTHORITY_COMP_CHECK
    CALL FUNCTION 'RSSB_AUTHORITY_COMP_CHECK'               "#EC *
      EXPORTING
        i_infoarea          = space
        i_infocube          = space
        i_comptype          = i_component-deftp
        i_compid            = i_component-compid
        i_owner             = i_component-owner
        i_actvt             = i_activity
      EXCEPTIONS
        user_not_authorized = 1
        OTHERS              = 2.

RSSB_AUTHORITY_COMP_CHECK
      CALL FUNCTION 'RSSB_AUTHORITY_COMP_CHECK'             "#EC *
        EXPORTING
          i_infoarea          = space
          i_infocube          = space
          i_comptype          = i_component-deftp
          i_compid            = i_component-compid
          i_owner             = i_component-owner
          i_actvt             = i_activity
        EXCEPTIONS
          user_not_authorized = 1
          OTHERS              = 2.

RSSB_AUTHORITY_COMP_CHECK
      CALL FUNCTION 'RSSB_AUTHORITY_COMP_CHECK'             "#EC *
        EXPORTING
          i_infoarea          = l_s_dta-infoarea
          i_infocube          = i_component-infocube
          i_comptype          = i_component-deftp
          i_compid            = i_component-compid
          i_owner             = i_component-owner
          i_actvt             = i_activity
        EXCEPTIONS
          user_not_authorized = 1
          OTHERS              = 2.

ENQUEUE_E_COMPDIR
  CALL FUNCTION 'ENQUEUE_E_COMPDIR'
    EXPORTING
      mode_rszcompdir = 'E'
      compuid         = 'QUERY_DELETION_IN_PROCESS'         "#EC NOTEXT
    EXCEPTIONS
      foreign_lock    = 1
      system_failure  = 2.

RRMS_MESSAGE_OFF
      CALL FUNCTION 'RRMS_MESSAGE_OFF'.                     "#EC

RSZ_DB_ELT_DELETE
      CALL FUNCTION 'RSZ_DB_ELT_DELETE'
        EXPORTING
          i_compuid             = -compuid
          i_enqmode             = rs_c_enqmode-extended
          i_objvers             = rs_c_objvers-modified
          i_tr_check            = rs_c_false
          i_tr_insert           = rs_c_false
          i_th_deletion_pending = l_th_eltuid
          i_delete_variables    = rs_c_true
          i_delete_immediately  = rs_c_true
        EXCEPTIONS
          OTHERS                = 0.

RSZ_DB_ELT_DELETE
      CALL FUNCTION 'RSZ_DB_ELT_DELETE'
        EXPORTING
          i_compuid             = -compuid  "Component itself
          i_enqmode             = rs_c_enqmode-extended
          i_objvers             = g_p_obv
          i_tr_check            = l_cts
          i_tr_insert           = l_cts
          i_th_deletion_pending = l_th_eltuid                "Filled with local ELEMs
          i_delete_variables    = rs_c_true
          i_delete_immediately  = rs_c_true                  "Avoid further processing
        EXCEPTIONS
          component_not_found   = 1
          component_locked      = 2
          canceled              = 3
          inherited_error       = 4
          element_locked        = 5
          multiple_tasks        = 6.

RSZ_DB_ELT_DELETE
        CALL FUNCTION 'RSZ_DB_ELT_DELETE'
          EXPORTING
            i_compuid             = -compuid
            i_enqmode             = rs_c_enqmode-extended
            i_objvers             = rs_c_objvers-backup
            i_tr_check            = rs_c_false
            i_tr_insert           = rs_c_false
            i_th_deletion_pending = l_th_eltuid
            i_delete_variables    = rs_c_true
            i_delete_immediately  = rs_c_true
          EXCEPTIONS
            OTHERS                = 0.

DEQUEUE_E_COMPDIR
  CALL FUNCTION 'DEQUEUE_E_COMPDIR'
    EXPORTING
      mode_rszcompdir = 'E'
      compuid         = 'QUERY_DELETION_IN_PROCESS'.        "#EC NOTEXT

RSDG_WRITE_PROTOCOL
















  CALL FUNCTION 'RSDG_WRITE_PROTOCOL'
    EXPORTING
      i_object        = 'RSZ'             "#EC NOTEXT "MP70025 N1505534
      i_subobject     = 'DELETE'                            "#EC NOTEXT
      i_extnum        = 'Deletion of queries and query components' "#EC NOTEXT
      i_t_msg         = l_t_msg
      i_show_protocol = rs_c_true
      i_show_as_popup = rs_c_true
    EXCEPTIONS
      OTHERS          = 0.

RRMX_WORKBOOKS_DELETE
        CALL FUNCTION 'RRMX_WORKBOOKS_DELETE'               "#EC *
          EXPORTING
            i_workbookid    = i_s_where_used-id
            i_objvers       = g_p_obv
            i_no_transport  = l_no_cts                     "MP N1883269
          EXCEPTIONS
            transport_error = 1
            OTHERS          = 2.

RSBBS_REPORT_READ
          CALL FUNCTION 'RSBBS_REPORT_READ'                 "#EC *
            EXPORTING
              i_appl      = rsbbs_c_appl-query
              i_s_onam    = l_s_onam
            IMPORTING
              e_t_def     = l_t_def
              e_t_text    = l_t_text
              e_t_mapping = l_t_mapping
            EXCEPTIONS
              not_found   = 1.

RSBBS_REPORT_DELETE
            CALL FUNCTION 'RSBBS_REPORT_DELETE'             "#EC *
              EXPORTING
                i_appl              = rsbbs_c_appl-query
                i_s_onam            = l_s_onam
              EXCEPTIONS
                delete_not_possible = 1
                cancel              = 2
                OTHERS              = 3.

RSBBS_REPORT_SAVE
            CALL FUNCTION 'RSBBS_REPORT_SAVE'
              EXPORTING
                i_appl                    = rsbbs_c_appl-query
                i_s_onam                  = l_s_onam
              IMPORTING
                e_t_msg                   = l_t_msg
              CHANGING
                c_t_def                   = l_t_def
                c_t_text                  = l_t_text
                c_t_mapping               = l_t_mapping
              EXCEPTIONS
                insert_not_possible       = 1
                trsti_insert_not_possible = 2
                cancel                    = 3
                OTHERS                    = 4.

RSZ_DB_FULL_XREF_GET
  CALL FUNCTION 'RSZ_DB_FULL_XREF_GET'
    EXPORTING
      i_objvers    = g_p_obv
    IMPORTING
      e_ts_eltxref = g_ts_eltxref.

RSZ_DB_COMP_LIST_GET
  CALL FUNCTION 'RSZ_DB_COMP_LIST_GET'
    EXPORTING
      i_deftp       = rzd1_c_deftp-all
      i_objvers     = g_p_obv
    IMPORTING
      e_th_complist = g_th_components
    EXCEPTIONS
      OTHERS        = 0.

RSZ_DB_COMP_WHERE_USED
  CALL FUNCTION 'RSZ_DB_COMP_WHERE_USED'
    EXPORTING
      i_compuid           = i_compuid
      i_objvers           = g_p_obv
      i_ts_eltxref        = g_ts_eltxref
    IMPORTING
      e_t_where_used_info = l_t_where_used_info.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rsra_setting
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rserheader
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rszwbtmphead
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rszwbitmhead
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rsddaggrdir
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rsldpio
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_rsant_process
            IMPORTING
              subrc   = l_subrc.

DB_EXISTS_TABLE
          CALL FUNCTION 'DB_EXISTS_TABLE'
            EXPORTING
              tabname = lc_xclsdash
            IMPORTING
              subrc   = l_subrc.


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


   
 

COMPONENT_REORG - Deletion of queries with selection conditions
COMPONENT_REORG - Deletion of queries with selection conditions
COMPONENT_PRINT - Prepares Query Definition for Printing
COMPONENT_PRINT - Prepares Query Definition for Printing
COMPONENT_NODE_DISPLAY========FT - COMPONENTNODEDISPLAY========FT
COMPONENT_EXPORT_XML - Exports a component to a file