topic Re: hi all--reg insert statement in Application Development and Automation Discussions

hi all--reg insert statement

Former Member — Tue, 11 Sep 2007 12:28:19 GMT

hi all ,

i have a z table which consisits of 13 fields. i have to insert field from 4 internal tables. but the fields in z table is is not in order as that of internal tables.

when i try insert , it is showing error,,,, is there any option to insert into corresponding fields,,,,,,,

regards

karthi

Re: hi all--reg insert statement

Former Member — Tue, 11 Sep 2007 12:32:27 GMT

Used corresponsing.

i.e. move corresponding

with modify or append

Re: hi all--reg insert statement

Former Member — Tue, 11 Sep 2007 12:34:19 GMT

Hi,

Declare one more int table with structure same as DB table and fill the table from existing 4 tables.

Use insert command now using this new int table as it should be same as DB table.

Regards,

Amit

Re: hi all--reg insert statement

Former Member — Tue, 11 Sep 2007 12:34:50 GMT

Use Modify statment

select *

from std table

into corresponding fields of itab.

modify ztab from table itab.

REgards,

Re: hi all--reg insert statement

Former Member — Tue, 11 Sep 2007 12:36:51 GMT

Hi,

if the field names are same you can use the MOVE-CORRESPONDING, but instead of MOVE-CORRESPONDING, you can use the MOVE statment ..

Here is the example:

Read First table

ZTABLE-FIELD3 = ITAB1-field3 .

ZTABLE-FIELD4 = ITAB1-field4 .

Read second internal table

ZTABLE-FIELD2 = ITAB2-field2 .

ZTABLE-FIELD5 = ITAB2-field5 .

Read Third internal table

ZTABLE-FIELD1 = ITAB3-field1 .

ZTABLE-FIELD6 = ITAB3-field6 .

INSERT ZTABLE.

Regards

Sudheer