How to find the queryid of a query

[Former Member]

Hi,

Can someone suggest how to find the queryid of a query?

Many thanks,

Xibi

[Former Member]

Dear all,

I have one transaction code zsdldc.my requirement is to find query name? How can I get it?

please help me.

With Regards,

Jaheer

[Former Member]

hi xibi

please follow my simple way to find the queryid of the query.

Go to open qeury from BEx, select the query for which you wish to see the queryid, copy the query using CtrlC and paste the same to notepad CtrlP.

There you can see the queryid with all the other details also.

The result you find with this method is the easiest i hope.

hope this helps

regards

vijaykumar

[former_member188325]

Hi,

After Executing the Query,From the context menu (right click on Result area)>Properties>information Tab.

ThankS

[victor_yang2]

Hi,

You can find it from BEX query property.

[Former Member]

Thanks Bhanu.

I found the queryid as per your hint, however i don't seem to find that id in rsddstat.

I enabled statiscts for that cube.

Any reasons why?

Regards,

Xibi

PS: It seems like the socring system is down so i will assign points later.

[Former Member]

That's now OK.

I used table RSRREPDIR and locate the queyid in field genuid in that table.

Regards,

Xibi

[athavanraja]

you can also use FM

DATA: p_genuniid TYPE rsgenuniid .

CALL FUNCTION 'CONVERSION_EXIT_GENID_INPUT'

EXPORTING

input = query_name

IMPORTING

output = p_genuniid.

Regards

Raja

[former_member188975]

Hi Xibi,

You can look up table RSZCOMPDIR. Put the techincal name of the query as input and you can see the Query ID along with other info.

Hope this helps...