SAP TIPS & TRICKS - SQ01

Have you ever run into a situation like this?

Note: I think this tip is a bit "techy", but I think it's good to have exposure to this as well.  SQ01 can provide the Super User the ability to write queries to get reports without going to a developer and asking for a development effort.  Some organizations do not provide this access to the business.  I believe it's really about education, training, and governance to make sure it is properly used. This question was posted in SCN (SAP Community Network) by an anonymous user.  Have you encountered something similar? "Hi all - I want to assign a transaction code to sap query that was created using SQ01. I can do it by SE93. My question is does the program name change when the query is transported? Is there any other way to do it? In my previous project they did it from PFCG." The correct answer was posted by Shiva Tirumalasetty: "Hi,   The above solution will work if you assign the transaction in one server, If you want this will not work in quality/production boxes when transported the query..the program name will not be the same in all the servers...   For this. Do the below:   In SE93, Create a Paramter Transaction -> Transaction = Start_report -> In default values, give the below details:      D_SREPOVARI-REPORTTYPE = AQ      D_SREPOVARI-EXTDREPORT = Name of the Query      D_SREPOVARI-REPORT = User Group   Save the transaction..Now if the program is generated with different names in the quality/proudction, this will still work.." Source: SAP Tips & Tricks - SQ01 Source: Assign transaction code to SAP Query (created via SQ01)