Table name/FM that give query definition details

[Former Member]

Technical Gurus,

Can anyone help me in finding out the table name/FM that holds the query definition? I have found RSRREPDIR that holds the query header information, but I am mainly after the table that holds Characteristics details.

Any help is highly appreciated.

_RJA

[edwin_harpino · Accepted solution]

hi,

see this thread

[edwin_harpino · Accepted solution]

try FM RSZ_P_WHERE_USED_COMPLIST_GET

check following program :

REPORT Z_QUERY_IO .

tables: RSZELTTXT,

rszeltdir,

rszeltxref,

rszrange,

RSZSELECT.

data : begin of it_result occurs 0,

iobjnm like rszselect-iobjnm,

end of it_result,

lv_iobjnm like rszselect-iobjnm.

select-options:

s_query for rszeltdir-mapname.

start-of-selection.

----

---

select * from rszeltdir where mapname in s_query

and objvers = 'A'.

select single * from RSZELTTXT where eltuid = rszeltdir-eltuid

and objvers = 'A' and langu = 'N'.

write: / rszeltdir-mapname, rszelttxt-txtlg.

refresh it_result.

select * from rszeltxref where seltuid = rszeltdir-eltuid

and objvers = 'A'.

*characteristics

select iobjnm into lv_iobjnm

from RSZSELECT where eltuid = rszeltxref-teltuid and objvers = 'A'

and iobjnm <> '1KYFNM'.

it_result-iobjnm = lv_iobjnm.

append it_result.

endselect.

*keyfigures

select low into lv_iobjnm

from rszrange where eltuid = rszeltxref-teltuid and objvers = 'A'

and iobjnm = '1KYFNM'.

it_result-iobjnm = lv_iobjnm.

append it_result.

endselect.

endselect.

sort it_result by IOBJNM.

• delete adjacent duplicates from it_result comparing mapname IOBJNM.

loop at it_result.

write: / it_result-IOBJNM.

endloop.

uline.

endselect.

Message was edited by: A.H.P

[Former Member · Accepted solution]

Just a quick thankyou AHP.