how use TCODE to find SAP QUERY NAME

[Former Member]

hi

i use TCODE and find the report use sap query made(SQ01).

but i don't what name about SQ01.

how use TCODE to find the name about SQ01.

thank you very much!

[Former Member]

Hi,

Go to SE93 -> give the t-code name.

There you can find which query is used in this t-code.

Regards,

Atish

[Former Member]

Hi

In the program of the query, you will find the INFOSET, QUERY and USERGROUP names.

Also, in SE93, for this transaction, if it is created using START_REPORT, then you will see at the bottom of the page, a report type of I AQ and

report name is your QUERY NAME.

OR

IF Pgm Name is

AQRIZHRALL======PP_REPORT

Then PP_REPORT is Query Name

Thanks.

Praveen

Message was edited by:

praveen parasiya

[Former Member]

i know to use SE93 to get report name :

AQVWSYSTQV000009ZINFO-1=======

but how to get SQ01 info record name!

best Regard!

[former_member223537]

Hi,

In SE93 , scroll down to view the details.

Dont check the program name. Scroll down.

Best regards,

Prashant

[Former Member]

report AQVWSYSTQV000009ZINFO-1=======.

include /1BCDWB/IQ000000000006DAT.

data %dtab type standard table of /1BCDWB/IQ000000000006 with header line.

data %subrc type sy-subrc.

include /1BCDWB/IQ000000000006SSCR.

include /1BCDWB/IQ000000000006SSCRAT.

start-of-selection.

if %runmode-extr_on <> space.

call function '/1BCDWB/IQ000000000006EXTR'

tables %selopt = %seloptions

%dtab = %dtab

changing %rtmode = %runmode

exceptions no_data = 1

others = 2.

%subrc = sy-subrc.

call function 'RSAQRT_CHECK_EXTR'

exporting extr_subrc = %subrc

tables dtab = %dtab

changing rtmode = %runmode.

endif.

end-of-selection.

if %runmode-show_on <> space.

call function '/1BCDWB/IQ000000000006SHOW'

tables %dtab = %dtab

changing %rtmode = %runmode.

endif.

*----

---

• special code for old API and BW extractor calls

*----

---

form %set_data changing p_lines type i.

import ldata to %dtab from memory id 'AQLISTDATA'.

describe table %dtab lines p_lines.

free memory id 'AQLISTDATA'.

endform.

form %get_data tables p_dtab structure %dtab

using p_first type i

p_last type i.

append lines of %dtab from p_first to p_last to p_dtab.

endform.

form %get_ref_to_table using p_lid type aql_lid

p_ref type ref to data

p_subrc type i.

if p_lid = %iqid-lid.

create data p_ref like %dtab[].

p_subrc = 0.

else.

p_subrc = 4.

endif.

endform.

the report code !

how to find! thank you!

[Former Member]

Hi,

Do not scroll down in SE38. Prashant was telling to scroll down in SE93.

Go to SE93 -> Display transaction -> Scroll Down. You will find query name.

Regards,

Atish

[Former Member]

just for report name not SAP QUERY name in SE93, i can't find in SQ01 OR SQ02!

[naimesh_patel]

To find out the query in SQ01 from your SAP Query name

AQVWSYSTQV000009ZINFO-1=======

AQ stands for the query

VWSYST is the user group

ZINFO-1 is the query name

Regards,

Naimesh Patel

[Former Member]

thank you!