topic Re: Queries and Tcode in Application Development and Automation Discussions

Queries and Tcode

Former Member — Mon, 14 Feb 2011 05:20:32 GMT

Hi ,

Query 'X' uses an infoset 'Y' .The report program generated by the query has two Tcodes. I am doing an sy-tcode authorization check in INITIALIZATION of the infoset. How can I cpature the actual Sy-tcode of the report program in the debugging mode? Plz help me with some FM or process which will do this task for me.

Thanks and Regards,

Sinu Mathew.

Re: Queries and Tcode

GauthamV — Mon, 14 Feb 2011 05:27:11 GMT

Use this FM.

RSAQ_DECODE_REPORT_NAME.

Re: Queries and Tcode

matt — Mon, 14 Feb 2011 06:01:45 GMT

What value does sy-tcode have in the debugger and why isn't it useful for your purposes?

matt

Re: Queries and Tcode

Former Member — Mon, 14 Feb 2011 06:36:42 GMT

Sy-tcode is displaying the Infoset transaction code 'SQ02' and not the report tcode.

Regards,

Sinu.

Re: Queries and Tcode

Former Member — Mon, 14 Feb 2011 06:48:09 GMT

This is to get the generated report name. I already have this in hand. I need to find the TCODE which is running this query.

Re: Queries and Tcode

Former Member — Mon, 14 Feb 2011 06:50:12 GMT

I want to perform authorization check on the Tcode.

If the sy-tcode eq 'X1'

perform auth-check for tcode X1.

elseif sy-tcode eq 'X2'

perform auth-check for tcode X2.

endif.

Hope you understood my requirement.

Regards,

Sinu.

Re: Queries and Tcode

brad_bohn — Mon, 14 Feb 2011 15:37:51 GMT

Hmmmm...if the transaction were defined like a query transaction should be, you should get 'START_REPORT' as the SY-TCODE value, not SQ02. Why does that need to be checked in the infoset? Wouldn't you already have an S_TCODE check performed against the user profile when the user executes the transaction?

Re: Queries and Tcode

Former Member — Tue, 15 Feb 2011 05:38:28 GMT

Report program has two tcodes associated with it, So I need to verify which Tcode is actually executing the query transaction in the infoset.This is how my coding will go in the infoset's Initialization.

*If tcode1 then perform auth_check1.*

*else perform auth_check2.*

Kindly help if you are familiar with these concepts.

Regards,

Sinu.

Re: Queries and Tcode

matt — Tue, 15 Feb 2011 09:09:52 GMT

Yes, we understand what you are trying to achieve and we are well aware of the concepts involved, but your question doesn't make sense to us. The transaction for running queries is based on START_REPORT not SQ02.

I've a suspicion I've got the solution to your problem, but I'm not going to suggest it until I fully understand why you're talking about SQ02. Sometimes a question needs clarification - simply repeating what you've already posted isn't helping.