select statement

[Former Member]

hi All,

i want to know what will this statement do

select * from *<dbtabname> where.......

thanks

Sundeep

[Former Member]

This will select all fields from database table into internal table u have specified, which should be of the table type.

Never use select * unless u need more than 75% of the fields. this will create performance problems

[Former Member]

Here data is populated from a <DB table name> which is assigned during runtime. So this is a Dynamic SELECT.

Check the program. There must be some code which assigns value to field symbol <dbtabname>.

ashish

[Former Member]

it gets the data from the databasetable depending upon the

where condition.

suppose i have one table zone.

in this table 3 records will be there.the fields in the recores are

f1 f2 f3 f4.

one boss big a

two boss1 big1 a

theree boss2 big2 b.

if u write select statement like this

select * from zone where f4 = 'a'.

u get the fallowing records

one boss big a

two boss1 big1 a

[Former Member]

hi

good

i dont think select statement works like this,

if you give the statement as select * from * mara, it ll give you a compile time error.

thanks

mrutyun^

[former_member387317]

Hi Sundeep,

As per my thinking it should give you <b>ERROR</b>...

Thanks & Regards

ilesh 24x7

[Former Member]

Hello all,

i have seen this codeing in a standard progrmam and its working

select * from *mara where(some condition)

[Former Member]

Hi

If you are specifying the field names then you will have to use into clause , since you dont want to use into clause then you select all the fields from the table using select *.

here is an sample

select single * from ekpo where ebeln = v_ebeln.

[Former Member]

hi Naresh,

u did not get my question..

select * from <b>*mara</b>

what is is the use of the *before mara.

i want to know that.

thanks

sundeep

[Former Member]

not answered

[gopi_narendra]

Generally *MARA when declared is treated as the Work Area for that program.

Suppose we declare

tables : mara, *mara.

MARA and * MARA are treatead as workareas and at the same time you can even retrieve data.

Regards

Gopi

[Former Member]

Hi,

select * statement will select all the fields of the database table based on the condition given in the where clause.

Please reward points.

Thank you,

Gangula Vikram.