Insert database from 2 tables

[former_member582701]

Hi!

I have field-symbol table with some components. And i have another internal table with other fields. Example:

itab (field1, field2, field3)

fs (component1, component2) " like zstruct

I have a table with

field1

field2

field3

struct (zstrcut with 2 fields)

How i can insert into database table?

Regards

pd: really it is not 2 internal tables. It is 2 work areas.

Message was edited by:

Manel Casadesus

[suresh_datti]

loop at itab into wa.

insert into dbtab values wa.

endloop.

~Suresh

[Former Member]

First copy the values of itab & fs into workarea whcih is type of database table.

To move from itab- Use MOVE

To move from fs - Use ASSIGN COMPONENT

then using INSERT statement u insert the record into DB table.

Regards,

Sail

Message was edited by:

Aarun Sailyendran Murugesan

[Former Member]

Create one more work area which has the same structure as the Z table.

And move values from those 2 work areas to the new work area.

wa_ztable-field1 = itab-field1.

..

and insert this work area into z table.

INSERT INTO ztable VALUES wa_ztable.