topic Re: variable has SELECT query how to execute it in Application Development and Automation Discussions

variable has SELECT query how to execute it

Former Member — Wed, 30 Jul 2008 06:39:48 GMT

hi all

question may be odd one but guide me on that.

requirement is as , i have a BAPI which have a STRING type INPUT parameter let P1, P1 contain a SELECT query as its value.

now i want to execute the select query which P1 contain in my BAPI , how i can do it.

e.g.

P1 = 'Select single * from MARA .'

now either i have extract the P1 OR have to do something to get this query executed .

please guide me.

Former Member — Wed, 30 Jul 2008 06:43:45 GMT

We can use the FM

Earlier WS_QUERY was there but it is obsolete. we need to check for the new one.

Or try to use the FM

GUI_EXEC to run it.

Thanks & Regards,

Chandralekha.

Former Member — Wed, 30 Jul 2008 06:51:43 GMT

hi,

GUI_EXEC --- Executes a command on the presentation Server.

But if you Are using ECC 6.0 then

you can use

CL_GUI_FRONTEND_SERVICES -

> EXECUTE

Regards

Sumit Agarwal