insert statement problem

[Former Member]

hi experts,

insert zqm_tb_is1786n FROM final2 ACCEPTING DUPLICATE KEYS.

system is throwing error for this message as

'.' has to be inserted after final2

what is the reason .

i am inserting values from final2 internal table to my ztable .

regards,

mani

[Former Member]

hi

good

go through this link,this will give you clear idea abou the insert statement,

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

thanks

mrutyun^

[Former Member]

INSERT dbtab FROM TABLE itab. oder

INSERT (dbtabname) FROM TABLE itab.

Extras:

1. ... CLIENT SPECIFIED

2. ... ACCEPTING DUPLICATE KEYS

3. ... CONNECTION con

Hi change your code as below and check

insert zqm_tb_is1786n FROM TABLE final2 ACCEPTING DUPLICATE KEYS.

[Former Member]

Hi,

the exact form of statement required for u is

insert (u r DB table name) FROM TABLE <internal table> ACCEPTING DUPLICATE KEYS.

[Former Member]

hi,

i have an internal table final2 with 3 line items like

delivno item material

800001 10 500000

800001 20 500001

800001 30 500002

i am using the code.

loop at final2.

insert zqm_tb_is1786n FROM table final2 ACCEPTING DUPLICATE keys.

endloop.

but only the first line item is inserted into my table .what may be the reason?