topic Re: Finding tables in a program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/finding-tables-in-a-program/m-p/3004830#M710027 <HTML><HEAD></HEAD><BODY><P>Hi jacob,</P><P></P><P>Try this code</P><P>you can choose the application component in the popup that comes</P><P>then all the tables / views will be stored in the pt_cust_obj internal table</P><P></P><PRE><CODE>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.</CODE></PRE><P></P></BODY></HTML> Tue, 30 Oct 2007 08:12:37 GMT former_member189059 2007-10-30T08:12:37Z Finding tables in a program https://community.sap.com/t5/application-development-and-automation-discussions/finding-tables-in-a-program/m-p/3004829#M710026 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P> 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?</P></BODY></HTML> Tue, 30 Oct 2007 05:24:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/finding-tables-in-a-program/m-p/3004829#M710026 Former Member 2007-10-30T05:24:28Z Re: Finding tables in a program https://community.sap.com/t5/application-development-and-automation-discussions/finding-tables-in-a-program/m-p/3004830#M710027 <HTML><HEAD></HEAD><BODY><P>Hi jacob,</P><P></P><P>Try this code</P><P>you can choose the application component in the popup that comes</P><P>then all the tables / views will be stored in the pt_cust_obj internal table</P><P></P><PRE><CODE>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.</CODE></PRE><P></P></BODY></HTML> Tue, 30 Oct 2007 08:12:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/finding-tables-in-a-program/m-p/3004830#M710027 former_member189059 2007-10-30T08:12:37Z