select statement

[Former Member]

Hi frnds,

I m upgrading and i m having a unicode error. My problem i m facing is select statement...

SELECT * FROM Z_ABC INTO TABLE IT_ABC WHERE......

So frnds the problem is z_abc is table which contains some fields... and it_abc contains fields but more than z_abc...

so frnds.. can u plzz help me how to rectify this issue...

thanking u all..

regards,

satya

[Former Member]

Write the logic like :

data it_abc like z_abc occurs 0 with header line.

SELECT * FROM Z_ABC INTO TABLE IT_ABC WHERE......

now see the output

[Former Member]

HI,

SELECT * FROM Z_ABC INTO <b>CORRESPONDING FIELDS OF</b> TABLE IT_ABC WHERE......

Regards

SAB

[pradeep_nellore]

Hi,

use the following code.

select * from Z_abc into corresponding fields of table it_abc where ....

Bye

Hi frnds,

I m upgrading and i m having a unicode error. My problem i m facing is select statement...

SELECT * FROM Z_ABC INTO TABLE IT_ABC WHERE......

So frnds the problem is z_abc is table which contains some fields... and it_abc contains fields but more than z_abc...

so frnds.. can u plzz help me how to rectify this issue...

thanking u all..

regards,

satya

[Former Member]

Thank u frnds....

Is this a solution to eliminate the unicode problem...

plzz help...

thnks

satya

[Former Member]

if you get same problem ,then declare internal table as like database table ,so you will not get any more problem

[Former Member]

ou cans solve this problem doind the following:

1- Change the declaration of the Itab as a type table of Dbtab.

Ex: data: t_xxx type table of xxx (with header line).

2- If the the fields of both tables have the same you can use

Ex: select * INTO CORRESPONDING FIELDS....

3- Use the statement:

Select a b c into ( a b c ) from xxx into table t_xx where...

Hope this can help you.

Regards.

[former_member182346]

Satya,

I think

Select * from z_abc into corresponding field of table it_tab where....

ll work for you.

Note: Check the field name of both table shuld be same.

Thank-You.

Reward points if helpful

Regards

vinsee

[Former Member]

hi,

SELECT * FROM Z_ABC INTO corresponding fields of TABLE IT_ABC

WHERE <condition>

Reward with points if helpful.

[S0025444845]

Hi,

u can solve it by two ways,

data: it_abc like z_abc.

\and now

select * from z_zbc into it_abc where <condition>

or

if u want it_abc with more fields than

select * from z_abc into corresponding fields of it_abc where <condition>

regards,

sudha