topic Regarding INSERT keyword in Application Development and Automation Discussions

Regarding INSERT keyword

Former Member — Wed, 22 Aug 2007 12:56:23 GMT

Dear all,

could u please help me out from the below.

1. Can we insert data from internal table to DB view ?

2. Can we insert data from internal table to DB table ?

2. If so what is the syntax ?

Regards

Venkat

Re: Regarding INSERT keyword

Former Member — Wed, 22 Aug 2007 12:59:42 GMT

Hi,

sorry...

INSERT DBTAB FROM TABLE ITAB

regards,

Omkar.

Message was edited by:

Omkaram Yanamala

Re: Regarding INSERT keyword

Former Member — Wed, 22 Aug 2007 13:00:02 GMT

Hi,

U can data from internal table to DB table.

INSERT DTAB FROM TABLE ITAB.

Regards,

Sankar

Re: Regarding INSERT keyword

RichHeilman — Wed, 22 Aug 2007 13:00:15 GMT

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/frameset.htm

Regards,

Rich Heilman

Re: Regarding INSERT keyword

Former Member — Wed, 22 Aug 2007 13:08:07 GMT

Hi Prasad,

you can insert data data from internal table to DB table.

The syntax is

INSERT DBTAB FROM TABLE ITAB.

And you can also insert data in to a view depending on the maintenance status of the view.

The syntax is same as above(For a table).

The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

The maintenance status can be defined as follows:

Read only: Data can only be read through the view.

Read, change, delete, insert: Data of the tables contained in the view can be changed, deleted, and inserted through the view.

see the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec91446011d189700000e8322d00/frameset.htm

Regards,

Suresh Linga.

Re: Regarding INSERT keyword

Former Member — Wed, 22 Aug 2007 15:14:42 GMT

good

go through this link

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/insert_d.htm

thanks

mrutyun^