Question regarding: select * into corresponding fields

[Former Member]

Hi,

My question is about this select statement "select * from A into CORRESPONDING FIELDS of Table B". When ABAP executes this statement, would abap select all fields from table A and assign value to table B or would it select only some fields in table A which is existed in table B ?

Thanks,

Pavin

[former_member156446]

select all fields from table A and assign corresponding value to table B

[former_member305388]

Hi,

In this whether A and B have same fields, i mean... both are of same structure..?

If yes, select query will select all the fields and assign to the table B with the same field name..

If no, means, if A and B are of different structures, then you should not use INTO CORRESPONDING.. though u use it, it will fetch nothing... For this kind of examples you must give the exact field names..like:

SELECT fld1 fld2

FROM tab_a

INTO CORRESPONDIONG FIELDS OF TABLE tab_b.

Hope this explains..