topic Re: insert data from itab to database table in Application Development and Automation Discussions

insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:54:28 GMT

hallow

what isthe best way to insert the data from itab to database table with same structre.

Regards

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:55:34 GMT

make use of keyworkds

Modify/Insert/Update.

Regards

Peram

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:56:55 GMT

hi antonio,

Try this,

 INSERT/MODIFY ZTABLE FROM TABLE ITAB.

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:57:49 GMT

hi Prabhu Peram

i try with

loop at itab.

insert zdatatab

endloop.

but its not working?

Regards

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:58:02 GMT

Hi,

Use Modify it is the best one insted of using INSERT or UPDATE.

MODIFY will do both the functions of INSERT and UPDATE.

Reward if helpful.

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:58:14 GMT

Hi Antonio,

Make use of the following statement in a similar way as shown below,

INSERT <DATABASE TABLE NAME> FROM TABLE <INTERNAL TABLE>.

Note that the internal table has the same structure as the database table.

No need of looping at the internal table.

Reward points if this helps,

Kiran

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:59:27 GMT

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/c4/93d942f7ca45b69dfdfd424c38332e/content.htm">refer this link</a>

regards,

srinivas

*reward for useful answers*

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 12:59:29 GMT

Hi,

Change the code

loop at itab.

insert into zdatatab values itab.

endloop.

Reward if helpful.

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 13:04:37 GMT

hi kiran

i try like that but i have eroorr

INSERT ZINTAB_A1 FROM TABLE intab_a1.

The work area "INTAB_A132" is not long enough. long enough.

but intab its not work area.

DATA : intab_a1 TYPE TABLE OF t_a1 WITH HEADER LINE .

TYPES: BEGIN OF t_konp,

knumh LIKE konp-knumh,

kstbm LIKE konp-kstbm,

kbetr LIKE konp-kbetr,

konwa TYPE konp-konwa,

END OF t_konp.

Regards

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 13:13:21 GMT

good

ATA: WA_ZSAMPTAB1 TYPE ZSAMPTAB1.

DATA: T_DATA TYPE STANDARD TABLE OF ZSAMPTAB1.

WA_ZSAMPTAB1-CUSTNO = 'TEST'.

WA_ZSAMPTAB1-CUSTNAME = 'TEST CUSTOMER'.

WA_ZSAMPTAB1-CUSTADD = '44 TEST'.

APPEND WA_ZSAMPTAB1 TO T_DATA.

WA_ZSAMPTAB1-CUSTNO = 'TEST2'.

WA_ZSAMPTAB1-CUSTNAME = 'TEST CUSTOMER 2'.

WA_ZSAMPTAB1-CUSTADD = '44 TEST 2'.

APPEND WA_ZSAMPTAB1 TO T_DATA.

INsert the records.

INSERT ZSAMPTAB1 FROM TABLE T_DATA.

Commit.

COMMIT WORK.

thanks

mrutyun^

Re: insert data from itab to database table

Former Member — Mon, 27 Aug 2007 14:00:53 GMT

hi Mrutyunjaya Tripathy

itry like u tell but i always get i database table first line empty end the second line data but just one row way?

i also try like below and i have the same results

i declare the table like

data calss APPL0

size 1

dlivery class A

LOOP AT intab_a13 INTO wa_intab_a13.

INSERT zintab_a13 FROM wa_intab_a13.

COMMIT WORK.

ENDLOOP.

Regards

Re: insert data from itab to database table

abapdeveloper20 — Tue, 28 Aug 2007 11:23:06 GMT

Hi..

DATA : ITAB TYPE STANDARD TABLE OF ZMATL

INITIAL SIZE 0 WITH HEADER LINE.

INSERT ZMATL FROM TABLE ITAB.

Regards,

Lakshmiraj

Reward points if helpful