Question regarding select and corresponding

[Former Member]

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.

[RichHeilman]

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

[Former Member]

hi,

Select erdat

from databasetable

into corresponding fields of table itab

where......

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

Regards,

Manohar.

[Former Member]

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

[Former Member]

hi nuren,

as u have into corresponding fields of itab

it will fill erdat.

[Former Member]

hi Nuren,

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

[LucianoBentiveg]

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......

[Former Member]

HI

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