topic Regarding SQ01 T-code(high priority) in Application Development and Automation Discussions

Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 10:52:07 GMT

Hi All,

Need a help in SAP Query...

Endusers want to use the SQ01 t-code in the production environment for reporting purpose..(security issues)

Now i want to build SQ01 as Ztcode...if I do that will be there any limitations ..

and to my knowlegde inorder to build a query with sq01 we need infoset and user grp...so do i need to make ztcode for sq02 and sq03 or...if infoset and user grp are already maintained in the production then the new ztcode (sq01) will work as like the standard t-code...

so could you guys show me the way to solve this issue

points will be rewarded.....

regards,

Ravi Ganji

Re: Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 10:56:37 GMT

Hi ,

Why do you require to build a ZSQ01 .First question .

Second you don't require to create ZSQ02 and zSQ03 because if you create infoset n usergroup thru standard transaction when you create query through ZSQ01 you will able to select infoset n usergroup thru ZSQ01 also.

So you don't require to create ZSQ02 and ZSQ03.

Please reward if useful.

Re: Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 11:03:18 GMT

Hi,

create a infoset and assign it to a group.

there is no need to create the Z tr code.

once the query is generated then it will create a system generated report and you can create tr code for this report

Regards

SHiva

Re: Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 11:15:22 GMT

Hi,

Currently they use transaction SQ01 to generate their daily sales report...and have now requested for permanent access to transaction SQ01....which is not normally provided to site users so for this reason they want custom build t-code for sq01.

Regards

Ravi Ganji

Re: Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 11:18:57 GMT

Hi,

you get the nname of the infoset and goto system and there you get the name of the report generated by sap.

then assign a tr code for this report.

regards

Shiva

Re: Regarding SQ01 T-code(high priority)

Former Member — Wed, 07 Feb 2007 12:14:55 GMT

Create the query in your development system, then in SQ01 goto Query->More Functions-> Generate Program

In SE93 create a transaction to reference this psuedo-program. The program will be created with the query name and user group embedded into it, do (Query Name) in SE38 to find its name.

Transport the query and the transaction into your production environment.