topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 17 May 2007 18:05:44 GMT

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

Re: select statement

Former Member — Thu, 17 May 2007 18:07:24 GMT

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

Re: select statement

Former Member — Thu, 17 May 2007 18:08:09 GMT

HI,

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

Regards

SAB

Re: select statement

pradeep_nellore — Thu, 17 May 2007 18:11:30 GMT

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

Re: select statement

Former Member — Thu, 17 May 2007 18:15:20 GMT

Thank u frnds....

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

plzz help...

thnks

satya

Re: select statement

Former Member — Thu, 17 May 2007 18:18:57 GMT

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.

Re: select statement

Former Member — Thu, 17 May 2007 18:20:21 GMT

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

Re: select statement

Former Member — Thu, 17 May 2007 19:40:46 GMT

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

Re: select statement

Former Member — Fri, 18 May 2007 06:27:54 GMT

hi,

SELECT * FROM Z_ABC INTO corresponding fields of TABLE IT_ABC

WHERE <condition>

Reward with points if helpful.

Re: select statement

S0025444845 — Fri, 18 May 2007 06:35:41 GMT

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>

if u want it_abc with more fields than

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

regards,

sudha