topic Re: Regarding Insert command in Application Development and Automation Discussions

Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:17:54 GMT

Dear guys,

I have internaltable with 10 fields with different data types. and i have addontable with 8 fields(with differnt data type)

Now i want to insert records from internal table to addontable.which will be the best way.

I have done as below..pls confirm this is best way or not.

<b>Created internal table xtab same as addontable 8 fields.</b>

loop at mytab into ltab.

move-corresponding ltab into xtab.

append xtab.

endloop.

<b>now insert internal table valus to addontable.</b>

loop at xtab into ytab.

insert table zlottab values ytab.

endloop.

and

Commit work.

is there any alternative way or any wrong in my code..

ambichan.

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:20:01 GMT

Hello Ambi,

Can you please close you all old threads and reward points accordingly.

regards

....................

Message was edited by: Surpreet Singh Bal

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:21:06 GMT

loop at mytab into ltab.

move-corresponding ltab into xtab.

*check the data are transferring correctly..else move field by field..

append xtab.

endloop.

insert table zlottab from table xtab.

commit work.

regds

Message was edited by: Venkat

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:27:17 GMT

one thing you can take care while inserting is that whether data already exist and still you want to overwrite it then use update. else insert it.

for this you can use 'popup_to_confirm' FM.

regards

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:29:18 GMT

yeah, I agree with venkat

'INSERT dbtab FROM TABLE itab'

this is better in performance, as its select statements runned by DB is less than insert every entry one by one.

Thanks

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:32:39 GMT

Instead of this loop at, if the table mytab and xtab are of the same structrue,

loop at mytab into ltab.

move-corresponding ltab into xtab.

append xtab.

endloop.

Can do as below mytab[] = xtab[].

INSERT  zlottab FROM TABLE xtab

This two line code is enough if all r of teh same structure.

mytab[] = xtab[].
LOOP AT xtab into ytab.
 INSERT INTO zlottab VALUES ytab.
CLEAR ytab.
ENDLOOP.

Hope this helps.

Kindly reward points and close the thread.

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:33:35 GMT

hey guys,

why i could not see points ooption button displaying at left side of post?

looks strange..

is something prob with portal?..

ambichan

Re: Regarding Insert command

Former Member — Wed, 31 Aug 2005 04:35:22 GMT

yes i am also facing same problem

regards