topic Help On Select Query in Application Development and Automation Discussions

Help On Select Query

Former Member — Thu, 25 Sep 2008 14:56:52 GMT

Hello

Please help me out.

I have a SELECT statement wherein a data type is

specified as the from statement.

Data f1 type char4.

SELECT * from ( f1 )

Where is this used? What is the need?

Re: Help On Select Query

ThomasZloch — Thu, 25 Sep 2008 14:59:39 GMT

Dynamic SQL, allows you to determine the database table name only at runtime.

Thomas

Re: Help On Select Query

BH2408 — Thu, 25 Sep 2008 17:27:50 GMT

Hi ,

Here it is called Dynamica calling ...they can be called during the runtime only.This type of select query are called different table based on table

Re: Help On Select Query

Former Member — Fri, 26 Sep 2008 04:19:55 GMT

Hi Yogesh,

Here we are specifying the table name dynamically. That means that we can give any table name we want at the run time and select the data from that table.

Regards,

Chandra Sekhar

Re: Help On Select Query

Former Member — Fri, 26 Sep 2008 12:26:16 GMT

use the concept of DYNAMIC INTERNAL TABLE

Re: Help On Select Query

Former Member — Fri, 26 Sep 2008 12:31:31 GMT

Hi,

The F1 Value i.e Table name will be allocated at the run time u can not see any where this definition. F1 difinition u can see it in global definition of your main program.

Regards,

Nandha

Re: Help On Select Query

Former Member — Fri, 26 Sep 2008 12:32:41 GMT

As also told by others you are passing the database table name at runtime.

refer to the link below:

http://www.sap-img.com/abap/how-can-we-give-dynamic-table-name-in-select-statement.htm

With luck,

Pritam.