01-05-2007 1:16 PM
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
01-05-2007 1:37 PM
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,
01-05-2007 2:12 PM
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
01-05-2007 2:23 PM
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'.
A.
01-08-2007 11:47 AM
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