08-23-2010 3:58 PM
Dear All,
We have 3 queries which are linked to service management, now, user wants to consolidated one ABAP report with feilds of 3 queries, which consist of total 100 feilds. he want provision of downloading each single query (in ABAP report).
Is ther anyway whee we can pass all the 3 quries values in internal tables and pass to ABAP report?? is there any better way so that we will reduce the writing of big logic for 100 feilds??
Thanks in advance.
Regards
Ramki
08-23-2010 4:24 PM
Hi ,
you can do this way..
for every query there is a
* Validating Variant name for Query Name
CONCATENATE '%' <query group> '%' <Query name > '%' INTO w_rname.
SELECT SINGLE * FROM varid WHERE report LIKE w_rname
AND variant EQ p_variant.
IF sy-subrc NE 0.
ENDIF.
* Submit report in background and creating spool
SUBMIT (w_rname) USING SELECTION-SET p_variant
TO SAP-SPOOL WITHOUT SPOOL DYNPRO
SPOOL PARAMETERS wa_pri_params AND RETURN.
COMMIT WORK AND WAIT.
"create spool like above for three query and and capture in Spool and format the three spools
"into one internal table and form one report.
Prabhudas