topic Re: table insert in Application Development and Automation Discussions

table insert

Former Member — Mon, 06 Oct 2008 07:26:18 GMT

hi experts

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

thanks

Amit

Former Member — Mon, 06 Oct 2008 07:28:51 GMT

You can try

MODIFY ZTABLE FROM ITAB.

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

Regards

Former Member — Mon, 06 Oct 2008 07:28:54 GMT

Hi,

Please explain more.

Regards

Jana

Former Member — Mon, 06 Oct 2008 07:32:02 GMT

loop at itab into wa.

INSERT INTO dbtab VALUES wa.

endloop.

loop at itab into wa.

INSERT dbtab FROM wa.

endloop.

INSERT dbtab FROM TABLE itab.

Regards,

Aparna

Former Member — Mon, 06 Oct 2008 07:36:36 GMT

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.

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