Alter Ego

I was asked by a person from one of our functional team on how to attach a transaction code to an SAP query. After a little bit of research and asking around, there is a way to do it (though this might not be the best practice, really). You are going to have to trick the system a little bit.


1. Instead of creating your queries in SQ01, use SQVI. Create a query in your production system.
2. Now execute the query. When you have reached the selection screen, go to System > Status.
3. Copy the program name.
4. Now create a Z executable program in your development client. Put this one line of code in it:

submit program_name_copied_fr_production via selection-screen and return.

5. Create a TCode and assign the Z program to the TCode.
6. Transport the Z program and TCode over to Production system.

That's it. If you have any other solution, do drop me a comment :)

p/s: I'm still considered a n00b in SAP, really.