Using SQVI To Generate Program in DEV

[Former Member]

I have read a lot about the merits of using SQVI for simple queries and then generating the code and assigning to a transaction code so that others can run the query/report. I have found posts in this forum that suggest using SE93 to create a transaction code and assign the SQVI generated program is the only way that an SQVI query can be shared. I certainly hope they were not assuming that users have SE93 in a production environment??

My question is, if I create this query and generate the program in our DEV environment and then assign it to a transaction code, can this be transported from DEV to TST to PRD intact? Will this work?

One other question, when the program is generated does it also create the required authorization checks? I am using USR* tables for this report, nothing considered sensitive, would any additional authorizations be required to allow just about any user to run the transaction?

Disclosure, I am a power user and not an ABAP specialist.

I appreciate a speedy reply if that is possible.

Thanks

Mark

[Former Member]

Hi Mark,

I have faced same requirement. I am not sure about transporting to TST and PROD. I done by this way.

After generating SQVI program in DEV , I assigned that program to a transaction and tested in DEV. Later i have regenarated SQVI in Production. then I assigned the generated Program to same transaction in DEV. And transported the Tcode assignment of program to Production..

About authorization , if its not sensitive report, BASIS can restrict at transaction level.

Regards,

Ravi.