Adding tcode to query

[Former Member]

Hello Gurus,

I want to add my Query to a tcode. My Query is a Global one i.e cross client. I have used the tcode START_REPORT in SE93 AND assigned D_SREPOVARI-REPORTTYPE = AQ, D_SREPOVARI-REPORT = "User Group ", D_SREPOVARI-EXTDREPORT = "Query Name". But when i run the tcode i get a message that the user group is not created. I also tried this method : D_SREPOVARI-REPORT = "User Group" space G.

But i still get the same error.

Any idea ?

Regards,

Abhishek.

[Former Member]

Hi,

First try to assign the User group for the query in SQ01..

and below code will help in checking the background program name generated for Query

      IF p_rb4 = 'X'.
*       Fetching Query names avaialable for Standard Area
*       Validating Query Group
        SELECT SINGLE * FROM aqltq  WHERE num = p_qname.
        IF sy-subrc NE 0.
   
        ENDIF.
*       Validating Query Group & Query Name
        SELECT SINGLE * FROM aqltq  WHERE num  = p_qname
                                    AND   qnum = p_pname.
        IF sy-subrc NE 0.
     
        ENDIF.
      ELSE.
*       Validating Query Group for Global Area
        SELECT SINGLE * FROM aqgtq  WHERE num = p_qname.
        IF sy-subrc NE 0.

        ENDIF.
*       Validating Query Group & Query Name
        SELECT SINGLE * FROM aqgtq  WHERE num  = p_qname
                                    AND   qnum = p_pname.
        IF sy-subrc NE 0.
          
        ENDIF.
      ENDIF.

*     Validating Variant name for Query Name
      CONCATENATE '%' p_qname '%' p_pname '%' INTO w_rname.
      SELECT SINGLE * FROM varid WHERE report LIKE w_rname
                                 AND   variant EQ p_variant.
      IF sy-subrc NE 0.
     ENDIF.

or

"try to fetch the background report generated for the query name by using above query..

"then create a transaction for above query same as report 

Prabhudas