topic Re: Question regarding select and corresponding in Application Development and Automation Discussions

Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:14:25 GMT

Select erdat

from databasetable

into corresponding fields of table itab

where......

Now if itab has two fields erdat and edatu which are both of same type (both erdat and edatu are of sy-datum type) , now which field of itab will be filled because of the above select statement. erdat or edatu?

Thanks.

Re: Question regarding select and corresponding

RichHeilman — Wed, 05 Jul 2006 15:15:37 GMT

The corresponding means, that it will move the values from the same field names, not types. So if you specify ERDAT it will try to move the value into the ERDAT field.

To answer your question, ERDAT will be filled.

Regards,

Rich Heilman

Re: Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:16:46 GMT

hi,

Select erdat

from databasetable

into corresponding fields of table itab

where......

<b>For this erdat field will get field up.</b>

Regards,

Manohar.

Re: Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:16:50 GMT

The one with the same name as in DB table will be filled

Re: Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:18:55 GMT

hi nuren,

as u have into corresponding fields of itab

it will fill erdat.

Re: Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:29:59 GMT

hi Nuren,

Since you are selecting erdat field in your select statement it will fill <b>ERDAT</b> field only

Re: Question regarding select and corresponding

LucianoBentiveg — Wed, 05 Jul 2006 15:35:47 GMT

You fill only field with same name in internal table. To fill the other you need to do something like this:

Select erdat AS edatu

from databasetable

into corresponding fields of table itab

where......

Re: Question regarding select and corresponding

Former Member — Wed, 05 Jul 2006 15:57:48 GMT

GOOD

IT WILL FILLED YOUR INTERNAL TABLE WITH DATA FROM BOTH THE FIELDS, MOVE CORRESPONDING DOES NOT MAKES ANY DIFFERENCE IN YOUR CASE.

THANKS

MRUTYUN