topic Re: Regarding select statement in Application Development and Automation Discussions

Regarding select statement

Former Member — Thu, 13 Dec 2007 12:50:11 GMT

I have to get only three fields form a Ztable and pass them to an internal table(which is of type another Ztable)

Field names are different in the Ztable and the internal table

Please give me the SELECT statement

The dataelements and lengths are same

Thanks in advance

Re: Regarding select statement

Former Member — Thu, 13 Dec 2007 12:51:48 GMT

how can u pass if they are of different types

Re: Regarding select statement

Former Member — Thu, 13 Dec 2007 12:52:06 GMT

hi,

i think its not possible...

If fieldname is different u will not get data from table.

Re: Regarding select statement

former_member386202 — Thu, 13 Dec 2007 12:52:54 GMT

Hi,

declare internal tabl etype ztable

data : itab1 like ztable occurs 0 with header line

select f1 f2 f3 from ztable into itab1 .

loop at itab1.

itab2-f1 = itab1-f1.

itab2-f2 = itab1-f2.

itab2-f3 = itab1-f3.

Append itab2.

Endloop.

Regards,

Prashant

Re: Regarding select statement

Former Member — Thu, 13 Dec 2007 12:55:11 GMT

hi,

i have no clue about your issue,but you could declare your internal table like

data: Begin of itab,

field1 like ztable1-fieldname,

field2 like ztable2-fieldname,

endof itab.

and you can use select * from zable1 into corresponding fields of table itab.

which i think would be easier way ...i any issue in this let me know

regards,

karthik

Re: Regarding select statement

Former Member — Thu, 13 Dec 2007 12:55:34 GMT

Hi ,

Try this select statement:

select single from Ztable-field name1 into itab-fieldname1.

select single from Ztable-field name2 into itab-fieldname2.

select single from Ztable-field name3 into itab-fieldname3.

May be helpful...

Reward points if found helpful……

Cheers,

Chandra Sekhar.

Re: Regarding select statement

Former Member — Thu, 13 Dec 2007 12:55:41 GMT

select f1 f2 f3 into itab-a1 itab-a2 itab-a3 from ztable1.

regards,

pavan

Re: Regarding select statement

JozsefSzikszai — Thu, 13 Dec 2007 13:00:58 GMT

hi Ajay,

fields in ztable: z1, z2, z3

fields in internal table: i1, i2, i3.

SELECT z1 AS i1
              z2 AS i2
              z3 AS i3
              FROM ztable
              INTO CORRESPONDING FIELDS OF TABLE itab
              WHERE ...

hope this helps