topic Re: How to use INSERT query ? in Application Development and Automation Discussions

How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:39:05 GMT

Frenz,

I have created one internal table and i am doing loop on it like...


Loop at it_data into wa_data.
-----
-----
-----
Endloop.

I want to insert some data into table zdata.

How to use INSERT records on this data base table?

Give me one example.

Regards,

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:43:01 GMT

Hi,

Use the following statement for inserting the records

however the data is there in the internal table it_data.

modify zdata from table it_data.

it_data must consists of all the fields of the table zdata and importantly primary keys of the table zdata.

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:44:09 GMT

Hello

INSERT zdata FROM TABLE it_data.

Loop/endloop - here not it is necessary.

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:45:00 GMT

Hi,

explain better what you want....

Do you want to change data in an existing raw?

Loop at tb_data into wa_data.

wa_data-field1 = 'jsahdu'.

modify tb_data from wa_data.

endloop.

If you want to add raws you use APPEND statement.

In the end you'll modify your table zdata from the internal table tb_data:

MODIFY zdata FROM TABLE tb_data.

Using modify you change raws basing on primary keys. If a raw doesn't exist it will be inserted.

Regards

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:45:40 GMT

Hi Dude,

INSERT INTO ZDATA VALUES wa_data.

Insert FROM TABLE itab .

Regards,

Ramki

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:45:51 GMT

Hi ronny,

Checkl these links;-

http://www.sapdb.org/7.4/htmhelp/34/ee7fb7293911d3a97d00a0c9449261/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c4/93d942f7ca45b69dfdfd424c38332e/content.htm

Best of luck,

Bhumika

Re: How to use INSERT query ?

asik_shameem — Thu, 04 Sep 2008 10:46:13 GMT

Do in this way.

Loop at it_data into wa_data.
-----
-----
-----
INSERT INTO ZDATA VALUES WA_DATA.
Endloop.

Re: How to use INSERT query ?

former_member282823 — Thu, 04 Sep 2008 10:46:34 GMT

This message was moderated.

Re: How to use INSERT query ?

GauthamV — Thu, 04 Sep 2008 10:46:40 GMT

hi,

check this sample code.

Loop at it_data into wa_data.

insert zgm_table from table it_data.

Endloop.

IF sy-subrc = 0.

MESSAGE 'records created succesfully' TYPE 'S'.

ENDIF.

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:46:50 GMT

Hi,

Use your code like this.

Loop at it_data into wa_data.

ztable-field1 = wa_data-field1.

ztable-field2 = wa_data-field2.

modify ztable.

Endloop.

Otherwise you can also use the Update statement.

Regards,

Amit Kumar Singh

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:46:58 GMT

use:

Loop at it_data into wa_data.
INSERT INTO zdata VALUES wa_data.
Endloop.

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:51:47 GMT

Hi,

Plz try this way :

loop at it_data into wa_data.

INSERT INTO databasetable VALUES wa_data.

endloop.

but it always good to use MODIFY statement as it handles a new row insert as well as update existing row.

thanx.

Re: How to use INSERT query ?

Former Member — Thu, 04 Sep 2008 10:56:47 GMT

hi,

write Insert in ur abap editor, place the cursor on it and press F1.

U will get all the details.

Anyhow, in this case-

Insert into <tablename> values <workarea name>.

Hope this helps u.

Regards,

Aleem.

Re: How to use INSERT query ?

Former Member — Wed, 10 Sep 2008 14:31:34 GMT

Thanks