table insert

[Former Member]

hi experts

how can i insert table into database table not line by line.

thanks

Amit

[Former Member]

hi experts

how can i insert table into database table not line by line.

thanks

Amit

[Former Member]

Hi

You can try

MODIFY ZTABLE FROM ITAB.

if the record already exists, it will modify, else it will insert

Regards

MD

[Former Member]

Hi,

Please explain more.

Regards

Jana

[Former Member]

1)

loop at itab into wa.

INSERT INTO dbtab VALUES wa.

endloop.

2)

loop at itab into wa.

INSERT dbtab FROM wa.

endloop.

3)

INSERT dbtab FROM TABLE itab.

Regards,

Aparna

[Former Member]

Hi,

Try like this...

insert ztable from table <internal table>.

It will insert the values to database table. if the internal table value already existing in database table means dump will come.

OR

Use modify statment

modify ztable from table <internal table>.

if internal table value already existing in database table means it will modify the values, else it will insert the values

Hope it will helps