Skip to Content
author's profile photo
Former Member

Regarding INSERT keyword

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 12:59 PM

    Hi,

    sorry...

    INSERT DBTAB FROM TABLE ITAB

    regards,

    Omkar.

    Message was edited by:

    Omkaram Yanamala

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 01:00 PM

    Hi,

    U can data from internal table to DB table.

    INSERT DTAB FROM TABLE ITAB.

    Regards,

    Sankar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 01:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2007 at 01:00 PM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 03:14 PM

    hi

    good

    go through this link

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

    thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded