topic Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 21 Sep 2006 20:43:00 GMT

Hi friends when we write

select single *

is it necessary to have a data base and the internal table of the same structure.

I am writing,

Select Single *

From ZZSD0010

into it_zzsd0010

Where

princ_customer = it_zzsd0010-princ_customer

default_sold_2 = 'X'.

the internal table and the data base table are of different structure.

Any suggestions,

Shejal Shetty.

Re: Select statement

Former Member — Thu, 21 Sep 2006 20:44:53 GMT

Hi,

IF the internal table and database structure are of different structure you can use INTO CORRESPONDING FIELDS OF..to move the common field values..

You cannot use INTO alone if the database table and internal table structure are different..

The values may not move to the correct fields..

THanks,

Naren

Re: Select statement

Former Member — Thu, 21 Sep 2006 20:49:53 GMT

Hi Shejal,

In case the db table and internal table are of different structure, then u need to write the fields you want to populate explicitly using corresponding fiels addition in select statement.

Select Single *

From ZZSD0010

into <b>CORRESPONDING FIELDS OF TABLE</b> it_zzsd0010

Where

princ_customer = it_zzsd0010-princ_customer and

default_sold_2 = 'X'.

Else if the structure is same then your statement will also work.

Cheers,

Vikram

Pls reward for helpful replies!!

Re: Select statement

Former Member — Thu, 21 Sep 2006 20:53:17 GMT

thansk for the suggestions,

Shejal Shetty.