cancel
Showing results for 
Search instead for 
Did you mean: 

Table Name

Former Member
0 Kudos

Hi Gurus,

In which table we can see all the Query Detailes I.e.., which user created,changed and time stamp.

Regards

Rams.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Rams,

You can check details in table RSZCOMPDIR.

Hope this helps...

Former Member
0 Kudos

Hi Bhanu,

Thank u, It shows each and every query but i want to know only what we are given to Customers i.e.., standard and Created queries.Now i am trying with user names but this one shows only Z Queries.

Let me help this one.

regards

rams.

Answers (1)

Answers (1)

edwin_harpino
Active Contributor
0 Kudos

hi Rams,

table RSRREPDIR, RSZCOMPDIR

sample report you may modified

threads

hope this helps.

REPORT ZZZ_QUERY_ELEM.

Tables: rszeltdir, "query element table

rszelttxt, "query element texts

rszcompdir, "global query elements

rszeltxref.

*itab to hold related info

data: begin of i_query_desc occurs 0,

local, "Local to Query

eltuid like rszeltdir-eltuid, "25 char generated ID

compid like rszcompdir-compid, "technical name

deftp like rszeltdir-deftp, "element type

el_txt(16), "element type text

  • txtsh like rszelttxt-txtsh, "short text

txtlg like rszelttxt-txtlg, "long text

owner like rszcompdir-owner, "owner

end of i_query_desc.

data: xlocal.

clear: i_query_desc,

rszeltdir,

rszelttxt,

rszcompdir,

rszeltxref,

xlocal.

select-options:

  • query technical name.

s_qtn for rszeltdir-mapname.

select * from rszeltdir where mapname in s_qtn

and objvers = 'A'.

select * from rszeltxref where seltuid = rszeltdir-eltuid

and objvers = 'A'.

if sy-subrc <> 0.

write: / rszeltdir-eltuid, ' Query element not found.'.

write: / .

else.

select single * from rszelttxt where eltuid = rszeltxref-teltuid and

objvers = 'A'.

endif.

select single * from rszcompdir where compuid = rszeltxref-teltuid and

objvers = 'A'.

if sy-subrc <> 0.

  • write: / long_ID-low, ' not found in table RSZCOMPDIR.'.

xlocal = 'X'.

endif.

  • fill itab for list

i_query_desc-local = xlocal.

i_query_desc-eltuid = rszeltxref-teltuid. "25 char generated ID

i_query_desc-compid = rszcompdir-compid. "technical name

i_query_desc-deftp = rszeltdir-deftp. "element type

case i_query_desc-deftp.

when 'SEL'.

if xlocal = 'X'.

i_query_desc-el_txt = 'Selection'.

else.

i_query_desc-el_txt = 'Restricted K/Fig'.

endif.

when 'REP'.

i_query_desc-el_txt = 'Query'.

when 'VAR'.

i_query_desc-el_txt = 'Variable'.

when 'STR'.

i_query_desc-el_txt = 'Structure'.

when 'CKF'.

i_query_desc-el_txt = 'Calculated K/Fig'.

when 'FML'.

i_query_desc-el_txt = 'Formula'.

endcase.

  • i_query_desc-txtsh = rszelttxt-txtsh. "short text

i_query_desc-txtlg = rszelttxt-txtlg. "long text

i_query_desc-owner = rszcompdir-owner. "owner

append i_query_desc.

clear i_query_desc.

endselect.

endselect.

  • list results

sort i_query_desc by local deftp owner.

loop at i_query_desc.

write: / sy-vline,

i_query_desc-eltuid, sy-vline, "25 char generated ID

i_query_desc-compid , sy-vline, "technical name

i_query_desc-deftp , sy-vline, "element type

i_query_desc-el_txt, sy-vline, "element text

*write: / i_query_desc-txtsh , "short text

i_query_desc-txtlg(40) , sy-vline, "long text

i_query_desc-owner , sy-vline.

write: sy-uline .

endloop. "@ i_query_desc