topic Re: data updation into table in Application Development and Automation Discussions

data updation into table

Former Member — Wed, 24 Oct 2007 08:32:49 GMT

Hi abapers,

Here iam facing an interesting situation in one of my object.am putting my words abt that object .

THANKS IN ADVANCE

i have more than 10,000 records in one internal table. i need to update that internal table with all the records. but i need to update in a frequency of 1000 records at a time...i.e., from that 10,000 records i need to update that itab in 10 loops. Please help me out.

Will give points.

Re: data updation into table

Former Member — Wed, 24 Oct 2007 08:38:08 GMT

hI,

It is very easy

Just use PACKAGE SIZE in your select query.

Do F1 on PACKAGE SIZE you will get details.

Regards,

Atish

Re: data updation into table

varma_narayana — Wed, 24 Oct 2007 08:39:13 GMT

Hi..

You can do this by declaring another Itab like ITab2 .

Eg:

DATA V_START TYPE I VALUE 1.

DATA V_END TYPE I VALUE 1000.

DO 10 TIMES .

APPEND LINES OF ITAB1 FROM V_START TO V_END TO ITAB2.

INSERT ZDBTABLE FROM TABLE ITAB2 ACCEPTING DUPLICATE KEYS.

V_START = V_END + 1.

V_END = V_END + 1000.

REFRESH ITAB2.

ENDDO.

<b>reward if Helpful.</b>

Re: data updation into table

rainer_hbenthal — Wed, 24 Oct 2007 08:39:59 GMT

the most performant way is to use fieldsymbols.

having 10 points where the whole table is updated is bad programming style. You have to recode that. Loop over the table, then deliver the fieldsymbol to formroutines which are doing the changes, e.g:


DATA:
  itab type standard table of t_something.

FIELD-SYMBOLS:
  <p> type t_something.

loop at itab assigning <p>.
  perform first_change using <p>,
  perform second_change using <p>.
  perform third_test using <p>.
....
endloop.

Re: data updation into table

Former Member — Wed, 24 Oct 2007 08:41:16 GMT

Hi Govardhan,

do like this

select <f1> <f2> from <dbtable> into table itab

package size 1000 where <clause>.

update records.

endselect.

Let me know if you are not clear.....

<b>Reward for helpful answers</b>

Satish

Re: data updation into table

rainer_hbenthal — Wed, 24 Oct 2007 08:42:08 GMT

How should that work on an internal table? Please read postings more carefully.

Re: data updation into table

Former Member — Wed, 24 Oct 2007 08:45:10 GMT

Hi Rainer,

I am not telling about doing process after getting the data into internal table.. Before getting the data to the internal table...

Cheers,

Satish

Re: data updation into table

Former Member — Wed, 24 Oct 2007 08:46:19 GMT

is it better to make sy-index to 1 after 1000 records

Re: data updation into table

Former Member — Wed, 24 Oct 2007 09:43:23 GMT

Hi Varma,

Thanx alot. really this hint worked in my case. am giving you points.

Re: data updation into table

Former Member — Wed, 24 Oct 2007 09:45:30 GMT

Thanx for giving your valuable solutions