2006 Oct 19 9:38 AM
Hi,
Whenever we create a Query system will automatically generate a program.
Now my situation is , I know the name of the program that is generated whjile creating ABAP Query. I am supposed to find the Query name using that program.
Thanks in Advance..
-Mohan.
2006 Oct 19 10:16 AM
Hi,
look at the FM RSAQ_REPORT_NAME there you find the
definition:
<b>* Namenskonventionen
*
AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
*
ww - 00..99 Mandant 000 bis 099 im Standardbereich
A0..YZ Mandant 100 bis 999 im Standardbereich
ZZ im globalen Standardbereich
bbbbbbbbbbbb - Benutzergruppe
qqqqqqqqqqqqqq - Query
*
in den ersten 30 Stellen werden Leerzeichen durch = ersetzt</b>
Sorry that i send it in german,
Regards, Dieter
Hi,
look at the FM RSAQ_REPORT_NAME there you find the
definition:
<b>* Namenskonventionen
*
AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
*
ww - 00..99 Mandant 000 bis 099 im Standardbereich
A0..YZ Mandant 100 bis 999 im Standardbereich
ZZ im globalen Standardbereich
bbbbbbbbbbbb - Benutzergruppe
qqqqqqqqqqqqqq - Query
*
in den ersten 30 Stellen werden Leerzeichen durch = ersetzt</b>
Sorry that i send it in german,
Regards, Dieter
2006 Oct 19 9:57 AM
if you go thru the created program, in the documentation part at the header level in program you will be getting INFOSET QUERY NAME , BY USING THIS IF YOU GO TO SQ02 you will get query name
2006 Oct 19 10:14 AM
hi,
query = report_name+16(14)
e.g.
05-16user-group 17-30 query-name
AQCSAM01========ZZ01==========A.
2006 Oct 19 10:16 AM
Hi,
Please check Table <b>AQBWCAT</b> with your query program name . it should then give you the query name
Also please try <b>AQBWCAT_SAP</b>
Thanks
Dominic
Message was edited by: Dominic Pappaly
2006 Oct 19 10:16 AM
Hi,
look at the FM RSAQ_REPORT_NAME there you find the
definition:
<b>* Namenskonventionen
*
AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
*
ww - 00..99 Mandant 000 bis 099 im Standardbereich
A0..YZ Mandant 100 bis 999 im Standardbereich
ZZ im globalen Standardbereich
bbbbbbbbbbbb - Benutzergruppe
qqqqqqqqqqqqqq - Query
*
in den ersten 30 Stellen werden Leerzeichen durch = ersetzt</b>
Sorry that i send it in german,
Regards, Dieter
2006 Oct 19 10:20 AM
Check this function mdoule,
RSAQ_DECODE_REPORT_NAME.
Look at the program name, it should look something like this. Here USER_LOGIN is the name of the query.
AQFKBASIS=======USER_LOGIN====
Regards
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |