topic Re: Dynamic 'from' Clause in Native SQL in Application Development and Automation Discussions

Dynamic 'from' Clause in Native SQL

Former Member — Wed, 03 Nov 2004 15:36:41 GMT

Hi All,

While running a select query in ORACLE, we can put the table name in 'from' clause at the runtime-Seletion Screen Parameter .

But I am not able to do so in SAP using Native Sql. Does SAP has any restrictions regarding this?

It might be possible that ,by using Embedded SQL (C/C++ precompiler ),we may be able to achive this.

Can any body please throw light on this.

Its Urgent.

Thanks in Advance.

Regards,

Gaurav

Re: Dynamic 'from' Clause in Native SQL

Former Member — Wed, 03 Nov 2004 16:11:16 GMT

Hello Gaurav,

I don't know much about native SQL, but with open SQL this is possible with a statement like "select * from (p_table)" where p_table is the parameter which takes table name on the selection screen.

Thank you,

Aravind.

Re: Dynamic 'from' Clause in Native SQL

VXLozano — Wed, 03 Nov 2004 16:27:27 GMT

Have you tried macroes?

DEFINE ....

SELECT * FROM &1

....

(I will become a macroes' fan)

Re: Dynamic 'from' Clause in Native SQL

ssimsekler — Wed, 03 Nov 2004 19:10:12 GMT

Assuming you can also use Open SQL.

Macroman's suggestion is OK. in Open SQL (this is SQL of ABAP platform) but a query statement can be constituted using some dynamic clauses. Although macro coding has some restrictions it will be less time consuming using it than a dynamic query.

An example SELECT statement with dynamic clauses:

SELECT (fields) FROM (table_name_variable)
INTO <target_fields>
WHERE (conditions_tab) .

For more information:

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3983358411d1829f0000e829fbfe/frameset.htm">Open SQL -Reading Data</a>

*--Serdar