Query elements by technical name

[Former Member]

Hello experts,

I need a report which displays all queries containing a specific object by its technical name. I already know that table RSZELTXREF helps me finding objects which are used in a specific query, but I miss the connection between the fields TELTUID (SYSUUID_25-field) and the technical name I gave a component.

Any help is appreciated.

Greetings,

Daniel

[edwin_harpino · Accepted solution]

hi Daniel,

- table RSZELTDIR

MAPNAME - query technical name

get ELTUID - query ID

- table RSZELTXREF

SELTUID = RSZELTDIR-ELTUID

get TELTUID

hope this helps.

[edwin_harpino · Accepted solution]

hi Daniel,

and some sample codes

hope this helps.

[Former Member]

Hi A.H.P.,

thank you very much for the links, the function module RSZ_I_BASIC_CHA_WHERE_USED is exactly what I was searching for.

That solved the problem, points rewarded.

Greetings,

Daniel

[Former Member]

Hi A.H.P.,

thanks for the quick answer. That's the right way and I have found the same connection. But now I need the technical name (e.g. 0DATE) for TELTUID. Is it stored somewhere?

Thanks in advance.

Daniel

[edwin_harpino]

hi Daniel,

table RSZSELECT, IOBJNM = 0date -> get ELTUID,

rszeltxref, SELTUID = RSZSELECT-ELTUID -> get TELTUID

hope this helps.

you are welcome,

i'm very glad, that fm should save your time

Message was edited by: A.H.P