topic Re: Problem in Abap query in Application Development and Automation Discussions

Problem in Abap query

Former Member — Wed, 15 Feb 2006 03:59:11 GMT

hello friends ,

thnanks for ur reply...

iam doing a small prog to assign a tcode for abap query as looking to the answer in sdn by callling function moduel

rsaq_report_name. i got answer that create small program and call this function and submit it ..i did it but what ever the query name iam passing either it shows dumop by saying "report not found" or there is no output ..the following is the code of mine..pls is something wriong it correct it or pls give me a example to do it.. i wnat to assign tcode to this progam and run the abap query .............

DATA: FUN(45) TYPE C.

DATA:QUERYREPORT LIKE AQADEF-PGNAME.

get name of queryreport

CALL FUNCTION 'RSAQ_REPORT_NAME'

EXPORTING

WORKSPACE = 'G'

USERGROUP = 'ZSKNFGRP1234'

QUERY = 'QUE_SHAMEEK_01'

IMPORTING

REPORTNAME = QUERYREPORT

EXCEPTIONS

OTHERS = 0.

SUBMIT (QUERYREPORT)

VIA SELECTION-SCREEN

USING SELECTION-SET 'ZNPIL_SUBMIT'

USING SELECTION-SETS OF PROGRAM 'REPORT00'

AND RETURN.

Re: Problem in Abap query

Former Member — Wed, 15 Feb 2006 04:03:37 GMT

Go to se38 and create a report program.

REPORT ztest.
DATA: FUN(45) TYPE C.
DATA:QUERYREPORT LIKE AQADEF-PGNAME.


* get name of queryreport
CALL FUNCTION 'RSAQ_REPORT_NAME'
EXPORTING
WORKSPACE = 'G'
USERGROUP = 'ZSKNFGRP1234'
QUERY = 'QUE_SHAMEEK_01'
IMPORTING
REPORTNAME = QUERYREPORT
EXCEPTIONS
OTHERS = 0.

SUBMIT (QUERYREPORT)
VIA SELECTION-SCREEN
USING SELECTION-SET 'ZNPIL_SUBMIT'
* USING SELECTION-SETS OF PROGRAM 'REPORT00'
AND RETURN.

Now go to se93 and assign tcode to this program.

Re: Problem in Abap query

Former Member — Wed, 15 Feb 2006 04:39:20 GMT

Hi Farukh,

Your code looks Ok. But you have to make one small change to avoid short dump.

Please pass import parameter WORKSPACE = ' ' (Blank) inplave of 'G'. This will avoid you the short dump.