Finding tables in a program

[Former Member]

Dear All,

I want to write a report program which returns all transparent database tables and views which belong to a specific application component.How can that be done?

[former_member189059]

Hi jacob,

Try this code

you can choose the application component in the popup that comes

then all the tables / views will be stored in the pt_cust_obj internal table

type-pools scust.
type-pools spro.
type-pools cmpwl.

data: ps_objlist_statistic type slcov_s_statistic_type.

data: pt_cust_obj type slcov_s_cust_obj_type occurs 0 with header line.

data:et_devclasses type slcov_devclass_s_type
  occurs 0 with header line,

    call function 'SCT1_DEVCLASS_GET_BY_APP_TREE'
      exporting
        iv_start_x    = 5
        iv_start_y    = 5
      importing
        ev_canceled   = lv_canceled
      tables
        et_devclasses = et_devclasses
      exceptions
        canceled      = 1
        others        = 2.



*get objects according to what is selected
    call function 'SCOV_GET_CUST_OBJECTS'
      exporting
        iv_clidep                   = 'X'
        iv_cliindep                 = 'X'
        iv_obj_type_sel             = 'CLSTV'
        iv_img_relation             = 'X'
        iv_no_img_relation          = ' '
        iv_tabs_of_vc_items         = 'X'
        iv_vc_items_as_object       = 'X'
        iv_get_statistic            = 'X'
        iv_get_item_ddtext          = 'X'
        iv_get_object_ddtext        = 'X'
        iv_get_item_clidep          = 'X'
        iv_select_via_devclass_list = 'X'
        iv_select_via_object_list   = ' '
        iv_get_devclass             = 'X'
        iv_get_table_delivery_class = 'X'
        iv_get_app_comp             = 'X'
      importing
        es_statistic                = ps_objlist_statistic
      tables
        et_cust_obj                 = pt_cust_obj
        it_devclass_list            = et_devclasses.