Question:
Hello all,
I know that with the where-used function in the AWB or within the metadata repository we have the possibility to get all the queries in which a particular infoobject is used.
Is it possible to have the reverse possibility : get all the infoojects used in a particular query ? (quicker than opening the query in the query designer and looking at the rows columns etc. )
Thank you in advance,
Aude
Answer:
Hi Aude,
I know no easy way to do it, but you can create an ABAP yourself. Call function RSZ_X_COMPONENT_GET, and you'll get InfoObjects in the result tables:
- c_t_select
- c_t_range
- c_t_calc
- c_t_var
Be aware that InfoObjects can be in fields that are non-straightforward (like in the LOW field in c_t_range or the OPER1 and OPER2 fields in c_t_calc). Furthermore, the query can use Restricted/Calculated Key Figures that use InfoObjects that are not included in the query. If you want these, you'll need to do your ABAP recursive on those reusable objects.
_________________
Leandro,
Tuly Idiots Shadow Supporter
Answer:
Hi Leandro,
I see this is not simple to get.
Thanks however for your suggestion with this function.
Regards,
Aude
Answer:
here's the table way:
RSZCOMDIR
-> COMPID = <technical name of your query>
<- COMPUID
RSZCOMPIC
-> COMPUID = RSZCOMPDIR-COMPUID
<- INFOCUBE
RSDDIME
-> INFOCUBE = RSZCOMPIC-INFOCUBE
<- DIMENSION (gives you the dimension name)
<- TABLNM (gives you the dimension table)
Answer:
Thanks El Belgio for your answer!
However I think this is going to give me all the characteristics of the infocube classified by dimension and not only the ones effectively used in the query.
We need this to figure out wich infoobjects are really used in our users' queries...