topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Thu, 22 May 2008 08:25:38 GMT

Dear All,

I have to trigger one transaction from SAP Query. When clicking one column in an SAP Query - Output, I have to call a new transaction .Where can I write the Code?

How? Please help me..

Regards,

Lijo

Re: SAP Query

kiran_k8 — Thu, 22 May 2008 08:31:36 GMT

Lijo,

I guess it is not possible with SQ01/SQVI.

K.Kiran.

Re: SAP Query

Former Member — Thu, 22 May 2008 08:31:38 GMT

Hi,

I think in SQL it is not possible

but in normal repotds do like this.

Under the At line-selection

call the transaction.

See the example...

select kunnr name1 land1

from kna1

into table it_cust

where kunnr in s_kunnr.

loop at it_cust into wa_cust.

write:/ wa_cust-kunnr hotspot on,

wa_cust-name1 hotspot on,

wa_cust-land1 hotspot on.

endloop.

At line-selection.

if sy-lsind = 1.

Call transaction 'TCODE'.

Reward if Helpful

Re: SAP Query

Former Member — Thu, 22 May 2008 08:35:06 GMT

Hello Jagadish,

Where can I write the code for At-Line Selection in SAP Query. Could you please help me?

Regards,

Lijo

Re: SAP Query

Former Member — Thu, 22 May 2008 08:41:19 GMT

Hi,

The following is the way to change queries,

If u r able to change it u can write the code there.

Changing Queries

Use

Provided that you have the appropriate authorizations, you are able to process a query that has been created already.

Procedure

Proceed as follows to change an existing query:

On the initial screen, choose a user group and type the query name. The query you specify must already exist in the user group.

Choose the Change function.

You are taken to the Title, Format screen.

In the Field Selection, Basic List, Statistics, and Ranked List series of screens, you make the changes that you require.

Additional Functions

Status info

Choose the Extras ® Status Info function, to find out who created the query or who last made changes to the query.

For more information see this link,

http://help.sap.com/saphelp_nw04/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm

Hope ur problem will get solve.

Regards,

Jagadish

Re: SAP Query

Former Member — Thu, 22 May 2008 08:43:06 GMT

Hi John,

After fetching all the data, you can write the AT line selection event for the action to take place when you select a line in the output list.

reward points if useful.

Thanks,

Khan.