topic Re: Execute Query in Application Development and Automation Discussions

Execute Query

Former Member — Fri, 04 May 2007 09:11:03 GMT

Hi,

Is there a transaction that will execute a query directly?

Re: Execute Query

Former Member — Fri, 04 May 2007 09:12:22 GMT

Hi Joseph,

Could be a bit specific?

Ravi

Re: Execute Query

Former Member — Fri, 04 May 2007 09:18:02 GMT

I BELIEVE NO

Re: Execute Query

Former Member — Fri, 04 May 2007 09:19:26 GMT

Hi,

For example, I have a query 'ZQUERY'. Is there a transaction that will run this directly by just going to that transaction and entering the Query name (ZQUERY).

Re: Execute Query

Former Member — Fri, 04 May 2007 09:21:18 GMT

Yo can create a transaction with parameters to execute directly your query.

Inside you must write in default values for: transaction START_REPORT and mark flag of skip initial screen. Then in default values you must complete strcuture d_srepovari with diferent fields values:

Example:

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = (user group)

D_SREPOVARI-EXTDREPORT = (query name)

Re: Execute Query

Former Member — Fri, 04 May 2007 09:23:33 GMT

What do you mean exactly by this?

If you execute a Transaction attached to a program, it will give selection screen and execute gives the results.

Generally we design a program in SE38 with all the querries and attach a Tcode in SE93 and gave some Tcode (custom).

when you execute that Tcode, the results will be displayed.

Reward points if useful

Regards

Anji