Help On Select Query

[Former Member]

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?

[ThomasZloch]

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

Thomas

[BH2408]

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

[Former Member]

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

[Former Member]

use the concept of DYNAMIC INTERNAL TABLE

[Former Member]

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

[Former Member]

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.