topic calling data dictionary table dynamically into select query in Application Development and Automation Discussions

calling data dictionary table dynamically into select query

Former Member — Fri, 05 Jan 2007 13:16:46 GMT

i am having all the SD related data dictionary table into one of the internal table( it consist of views , clusters , tables, individual transaction object and logical transport object).

now my query is that, i want to get each/individual dictionary table from the internal table , that may be view,cluster etc, and get the detailed information of that particular table using select query and show it into excel sheet.

i also want all my views to be in one excel sheet, cluster into one sheet and remaining other table with the proper header. while displaying the information there should not be any duplicate and each field should be properly assign to the header.

and similarly i also want each table to be displayed in separate spread sheet

Re: calling data dictionary table dynamically into select query

Former Member — Fri, 05 Jan 2007 13:37:24 GMT

Hello ,

Actually it is possible to generate a select statement dynamically,

select single abc

from (iv_tabname)

into ev_tstrid

where (lt_cond).

In the code above the iv_tabname is table name and it_cond is the internal table containing the conditions for selection....

Regards,

Re: calling data dictionary table dynamically into select query

Former Member — Fri, 05 Jan 2007 14:12:20 GMT

i am not having table name, i have to get it from the internal table.

tell me where the table will be retrieved from internal table and from the retrieve table get the detail list of that table

Re: calling data dictionary table dynamically into select query

andreas_mann3 — Fri, 05 Jan 2007 14:23:40 GMT

hi,

select table info_tabl (view from dd02l and tadir)

with coressponding packages of SD

 SELECT TABNAME devclass FROM  INFO_TABL INTO TABLE itab
         WHERE  TABNAME IN TABN
         AND    DEVCLASS = DEVC
         AND    tabclass = 'TRANSP'.

Re: calling data dictionary table dynamically into select query

Former Member — Mon, 08 Jan 2007 11:47:19 GMT

can u send me clearly how to write,

for ex, in my internal table i am having 4 tables

VVC_T682_CC ,

V_T134_V ,

TVSHP ,

VVC_T682_VB ,

all these r views, now how will we write the code

send me in with proper steps