Query-InfoObject - Tables

[Former Member]

Hi All,

I am looking for a table which shows the list of infoobjects (Technical Names) and the corresponding queries they are embedded in.

George

[Former Member · Accepted solution]

Take a look at the Function Module RSZ_I_BASIC_CHA_WHERE_USED.

Thanks,

Jeff

[Former Member]

Hi Guys,

Thanks to all. I used the where-used list already. That didnt help me.I was actually wanting to see a list of the queries in which the infoobject is actually being used (not just available).

Thanks for your time though.

Regards

[former_member188975]

Hi George,

The Where used list will list out the queries where the InfoObject is being used...not just the cubes where it is available. Or did I misunderstand the requirement..?

[Former Member]

Hi Bhanu,

By saying 'being used' i meant being referenced. I am sorry if that confused you.

Regards

[edwin_harpino]

hi George,

tables may useful : RSZCOMPDIR RSZELTXREF RSZELTDIR

RSZCOMPIC RSZELTPRIO RSZELTPROP RSZELTATTR RSZELTTXT

RSZRANGE RSZCALC RSZCEL RSZGLOBV

code :

report zio_query.

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.

[Former Member]

Hi George,

My 2 cents to what Bhanu and Roberto already suggested..

In RSA1 --> Info Objects --> Highlight the info object and press F1.

A web page with all the details abt that Info object opens which will give you the information you are looking for..

Hope this helps..

Ashish..

[edwin_harpino]

hi George,

take a look other programs

[former_member188975]

Hi George,

Not exactly what you are looking for but an alternative: In RSD1, you can type in the name of the InfoObject and from the menu Edit > Where used list will also give you the queries in which it is used.

Hope this helps...

[Former Member]

Did you try with metadata repository in RSA1, or with the where-used list in IO definition ?

Or do you need a DDIC table ?

PS.

Bhanu, check your mail...